- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Etl Architect Resume Samples
No results found
Candidate Info
years in workforce
months at this job
Economics
Electrical Engineering
Engineering And Policy
Senior ETL Architect
Restatement Project: Undertaken to restate company's earnings, this $1 Billion project employed over 2000 workers.
- Spearheaded the automation of restatement operations which was instrumental in completing restatement within a short period of 7 months against projections of 3 years.
- Managed a team of 18 AbInitio developers, Autosys schedulers and Business Analysts. Created BOXI/WEBI reports for senior management.
- Played a leading role in the setup of the Restatement Operations Center.
Candidate Info
years in workforce
months at this job
Computer Science
Be
ETL Architect/etl Lead
Deployed a robust business intelligence solution that increased the ability to monitor Meter to Bill process on a daily basis and provided the ability to reconcile source system Meter Determinants
- Designed and implemented generic Visio Mapping template that facilitated automatic generation of Informatica ETL mappings which reduced significant time and effort.
- Lead development initiative to adhere Informatica best practices and standards outlined in Informatica's Velocity Methodology.
- Worked extensively on Informatica partitioning when dealing with large volumes of Meter Reads data and also partitioned the tables in Oracle for optimal performance.
- Led a group of technical on-shore and off-shore developers and support team.
- Managed software design and technical architecture of large complex system, using project management and planning skills to minimize development time and maximize client acceptance.
Candidate Info
years in workforce
year at this job
Computer Applications
Enterprise Business Management
ETL Architect - Risk Management/compliance
The scope of this project is the remediation of the pre-Helix OFAC/OSFI (Office of Foreign Asset Control/Office of the Superintendent of Financial Institutions) system process. This process resides in the CSA as of January of 2006. This system is designed to source personal data about customers to a downstream process that is designed to compare our entire customer base to a list provided by an external source.
- Led a team of Onsite and Offshore Designers, as of the new Data Movement architecture.
- Designed and mentored multiple custom and generic processes, which were used by many other applications outside the platform.
- Led a team in Developing new and modifying existing UNIX shell scripts to automate routine tasks as of the new ETL architecture directions.
- Ensured data is clean, consistent and synchronized across source platforms.
Candidate Info
years in workforce
months at this job
Computer Engineering
Computer Science
ETL Architect
- Designed and developed Informatica objects to support the company's needs, this includes Unit testing and QA
- Upgraded from Informatica 7.x to 8.1, then to 8.5
- Analyzed and implemented different projects for different clients. Started by gathering the requirements, writing the design documents and conducting all required development, including the UNIT testing and QA
- Supported development, production and business groups by providing technical tips
- Identified some bottlenecks with the mapping and improve the performance by using Pushdown optimization.
Candidate Info
years in workforce
months at this job
ETL Architect
Application developed to forecast the demand for various products. The system captures data along the way. It looks at 20 different parameters and estimates the demand for the product, calculates projected and targeted days of supply and host of other numbers that helps the company to schedule manufacturing, stocking and release of products at various locations around the country.
- Analyzed and documented the requirements.
- Participated in Data Model design.
- Wrote detailed technical design
- Planned and managed the tool development
- Participated in the User Acceptance Testing and tool release
Candidate Info
years in workforce
months at this job
Electronics And Communications Engineering
Electrical And Computer Engineering
Computer Engineering
ETL Architect/ ETL Lead
Architected new ETL solution for [company name] EDW using Windows, Sql Server and IBM Information Server(Datastage 8.1)
- Developed, Tested, Implemented and Supported SSIS/DataStage jobs as part of Data Warehouse Migration Project.
- Designed and developed star schema solution for [company name] Financial reporting.
- Documented ETL Designs, ETL Standards and Source to Target mapping.
- Supported Database migration project.
- Supported Admin tasks like DataStage Installation, Configuration and ETL Tuning on Windows
- Supported day to day DataStage admin tasks like lock management, User Management, Database configurations and User defined Parameters.
Candidate Info
years in workforce
years at this job
Computer Science
Sr.sql Server/etl Architect
Actively involved as part of a team for gathering and analyzing needs of end user requirements to build BI architecture.
- Actively responsible for leading warehouse development team.
- Working with SSIS to load data files to SQL Server and the other way. Maintaining data, database backups, backup strategies, scheduling backups.
- Designed database models including creation of tables, referential integrity, keys and constraints.
- Scheduled jobs weekly/monthly basis to import data from various data sources like Netezza, Oracle, excel & delimited files.
- Managed multiple projects to ensure data load dependencies used by different business users.
- SDLC cycle was completed on time for almost all projects to meet deadlines with team effort.
Candidate Info
years in workforce
years at this job
Computer Engineering
Ab Initio Systems Administrator/technical Lead/etl Architect
Responsible for the design, and administration of the Ab Initio infrastructure within Marketing Services
- Assisted in the creation of enterprise ETL development standards and best practices
- Designed and created several common utilities used to integrate ETL services with external systems
- Architected and delivered several ETL batch applications centered on application modernization
- Mentored client team members in the design and development of several batch applications
Candidate Info
years in workforce
months at this job
Computer Science
Microstrategy Architect and ETL Architect
Defined the process between [company name] IMD and Cognizant in terms of roles & responsibilities, deliverables and SLA.
- Analyzed the [company name] business, BA team requirements and communicating offshore team effectively.
- Designed and developed ETL mappings, high level design document, Source to Target Mapping document and test cases.
- Designed and developed MicroStrategy projects by creating attributes, facts, hierarchies, metrics, prompts, filters, transformations, logical tables and canned reports.
- Managed and reviewed offshore deliverables, prepared test cases, and logs and assisted the [company name] IMD business team for User Acceptance Testing and getting sign off for production.
Candidate Info
years in workforce
years at this job
Computer Science
ETL Architect/manager (consultant)
Managed and oversaw the entire ETL solution for [company name]'s new Operational Data Store(ODS). This is about a three terabyte database and supports the on-line customer service application. There are over four hundred incoming source feeds. The load schedule is automated through Autosys.
- Managed and oversaw the group of ETL Developers consisting of up to 25 on-shore developers.
- Data Warehouse Architect responsible for overseeing the entire new Data Warehouse Model and ETL architecture which supports it. Implemented a dimensional model for the membership subject area.
- Responsible for managing 15 DataStage ETL resources across multiple concurrent projects.
Candidate Info
years in workforce
years at this job
Math And Computer Science
Vice President / Sr. ETL Architect
System Profile: Data warehouse and reporting system for ETD. The North America ETD team focused on rolling out the same technologies to the EMEA and APAC regions, maturing the architecture, increasing trade processing capacity, and reducing software outages
- Developed Global Online Listed Derivatives data warehouse platform to be a one stop shop ETD analysis with an effective combination of the near real time and historical transactions with retention of 3 years
- Rebuilt data services platform that helped increase revenue and generated new revenue stream; designed and developed robust ETL approach to process Futures, Future Options, Swaps, and other OTC trades seamlessly
- Implemented various enterprise-wide ETL projects for the ETD platform. Most of the work has been towards Position, Cash and Collateral management for various operations teams such Trade Management System, Credit Risk, Treasury, Prime Brokerage Repository and Data Consolidator
- Built ETL process for Regulatory reporting projects, such as Dodd-Frank, Basel and EMIR to provide more controls of trading processes. Project was critical to meet deadlines for Regulatory compliance
- Developed and implemented a novel automated structure for reports to replace manual data entry
- Managed a team of offshore contractors for both development and testing
- Conducted weekly nightly-batch production support
- Worked directly with business users to gather and document requirements, establish technical specifications and set deadlines and milestones
Candidate Info
years in workforce
year at this job
Computer Science
Data Architect / Sr. ETL Architect
Completed a major Data Conversion project using Oracle Warehouse Builder (OWB 10Gr2), Oracle 10Gr2, Erwin etc.
- Responsible for the architecture, design, Data modeling (Logical and Physical) for Enter prize data warehouse and all its Data Marts, security and implementation of DWH.
- Architected Designed and developed the ETL extraction and loading.
- Data extraction, its integrity and standardization were the main challenge met.
- Acted as main person to guide client in requirement development and gathering and their final approval.
Candidate Info
years in workforce
months at this job
Metallurgical Engineering
Mathematics
Computer Science
ETL Architect
- Architect for ETL/ELT data automation projects using Talend and Microsoft SQL Server.
- Elicited and gathered requirements, designed, developed and tested Microsoft SQL Server and Talend ETL data automation solutions for Alignment Common Publish, MDM Common Publish and Veeva.
- Recommended and established best practices and naming conventions for Talend and SVN.
- Prepared and authored documents for the Architecture of Talend and SVN. Prepared and presented Microsoft PowerPoint presentations to the business users.
- Designed, developed, saved, tested and exported Talend ETL java code into zip files and migrated code into various environments from development through to production.
- Performed unit, integration and system testing of the Talend ETL jobs.
- Authored release documents for migration of data automation jobs from development to production.
Candidate Info
years in workforce
year at this job
Computer Science
Information Technology
Computer Science
Dw Etl Architect
Designed ETLs using Informatica 9, SQL Server as DW, SAP and SQL Server as source
- Worked with BA and DA to come up with Data Mappings
- Managed off shore resources, Deploy code to production
- Scheduled jobs considering all dependencies using Control M
- Optimized long running ETLs and supporting production environment
Candidate Info
years in workforce
years at this job
Bachelor of Arts
Bachelor of Business Administration
ETL Architect, Sr. BSA
- Evaluated business needs and system capacity to maximize utilization of IT resources.
- Developed and recommended solutions for improving ETL processes performance, and designing new applications.
- Reviewed new technologies and suggested upgrades, including conducting feasibility and cost analysis studies.
- Compiled and organized user requirements to define project scope and technical specifications.
- Oversaw projects and served as liaison between key stakeholders, internal technology professionals, and external resources.
- Served as the Technical Lead for a startup $1.5 million Auto Finance Data Warehouse and Operational Data Store project that required coordinating on site and off shore developers in India.
- Designed an ETL process to populate 110 Data Warehouse entities comprised of 750 elements based on the IBM LEGOS financial model.
- Managed and coordinated production support with offshore staff for prompt turn around resolutions.
Candidate Info
years in workforce
months at this job
Certificate
Mechanical Engineering
Business Management
ETL Architect/ Data Integration Lead Consultant
Delivered technical architecture around outbound feeds from IBM's Banking Data warehouse to support Credit Risk and MIS reporting as part of Basel II regulatory requirements for "Risk Data Platform Initiative". This architecture formed the basis for all data marts which were built around the data warehouse to support the reporting systems.
- Delivered technical architecture around [company name] outbound feeds sourcing information from IBM's BDW solution.
- Developed an architecture document and designed data models and a data flow processes to support the reporting needs.
- Lead a team and was actively involved in solution design, data mapping activities and supporting the ETL team during development of outbound interfaces.
Candidate Info
years in workforce
months at this job
Computer Science
Data Warehouse/etl Architect Consultant
Data Warehouse/ETL Architect for the corporate Business Intelligence team.
- Acted in advisory role for atomic warehouse and data mart modeling efforts.
- Performed SAP/R3 source system data analysis and created ETL source to target mappings and transformation specifications to support source to universal normalized atomic data
- Created ETL source to target mappings and aggregation specifications to support data
- Toolset: Power Designer, SQL Server 2000, Data Stage and Business Objects.
Candidate Info
years in workforce
year at this job
Electrical Engineering
SAS Dataflux Consultant / ETL Architect
- Served as a Lead Data Migration expert in the Firm's major initiative to consolidate vendor, customer and product master data from over 30 finance and accounting legacy applications into a single SAP platform.
- Developed various DataFlux data profiling, enrichment, cleansing and transformation jobs to create SAP conversion/load files containing several thousands of customer and vendor master data.
- Created data mapping, reconciliation and various ad-hoc analysis reports to support the implementation team.
- Demonstrated excellence providing timely and high-quality reports and developing innovative conversion utility tools.
Candidate Info
years in workforce
months at this job
Business Administration And Computer Science
Astronomy/astrophysics
ETL Architect/developer - SAP (bods) Data Services
Created complex data flows, workflows and Jobs for the creation of interfaces between different OLTP sources using SAP Data Services (BODS)
- Created design requirements and standards for Data Services developers.
- Configured BODS Job Server and Job configurations in support with Oracle and SQL Server database environments.
- Created Datastores in support of ETL development.
- Performed migration of content between local and central repositories in Dev, QA and Prod environments.
Candidate Info
years in workforce
months at this job
Electrical Engineering
Business Administration
ETL Architect/
- Analyzed the current state of ETL architecture and conducted requirements gathering to future state roadmap as well as solution blueprint.
- Profiled data warehouse data for Managed Care and Government Pricing data elements, compiled inventory list, determined the scope and assisted in finalizing the statement of work.
- Created architectural solutions and managed the off-shore effort of technical design phase.
- Defined data consolidation strategy from source to Operational Data Store, Data Mart, Data Warehouse and user-access (BO Universe) layer.
Candidate Info
years in workforce
months at this job
Computer Engineering
Computer Science
Finance
ETL Architect
Developed detail technical solutions for an Ecommerce data warehouse System to track drop-ship sales orders.
- Designed controls and handshake protocol between all internal and external systems transmitting data through ETL.
- Managed the ETL team's project plans and status reporting.
- Managed dependencies between ETL team development work and front-end application development.
Candidate Info
years in workforce
months at this job
Electrical Engineering
ETL Architect
Our solution approach provided the basis for recommendations and provided guidelines to manage business criticality, technology constraints and the architectural aspect of the solution.
- Defined specification for ensuring audits, balance, and controls between the source system of record and the eCDW (Enterprise Consolidated Data Warehouse).
- Developed data monitoring techniques for data quality
- Defined the project's data quality requirements captured from the project team
- Evaluate the existing data management solutions impacting the project for effectiveness
- Identified any existing data management gaps and issues risking project and existing eCDW data assets
- Recommend actions to the project team.
- Responsible for managing the monitoring and reporting on the data defects identified through the data quality controls implemented using various data quality monitoring techniques for the Business and IT stakeholders.
- Applied best practices with Enterprise Data warehouse, Data Integration (ODIEE) and Master Data Management (MDM)/Data Governance.
Candidate Info
years in workforce
years at this job
Medicine
Computer Science
Big Data Engineer/etl Architect
Built Big Data analytical framework for processing healthcare data for medical research using Python, Java, Hadoop, Hive and Pig. Integrated R scripts with MapReduce jobs.
- Perform data transformation using Pig, Python, and Java
- Designed efficient data model for loading transformed data into Hive database.
- Created analytics reports using Hive.
- Designed, developed, and implemented conceptual, logical and physical data models for highly scalable and high performance relational database systems.
- Designed, developed, and implemented highly scalable and efficient ETL flows using SSIS.
- Extensive experience in tuning SQL query and multi-terabyte databases for high performance; Utilized new features of SQL Server 2012, such as Columnstore indexes, table partitioning to increase performance in data warehousing.
- Developed various T-SQL Scripts, Stored Procedures, and UDFs, C# code for data extraction, transformations and data load.
- Performed SSIS tuning for efficiency ETL and utilized best practices SSIS design pattern to improve ETL performance and scalability.
Candidate Info
years in workforce
years at this job
Advance Computing
B Tech
Sr. Datastage Consultant/etl Architect
Designed and developed jobs to handle the business transformation rules using Datastage 8.5.
- Designed the process to integrate various applications like EBS, Lawson, Biceps using Datastage 8.5
- Designed Direct to Store ETL Process
- Helped in migration of jobs from Datastage 8.1 to 8.5 platforms.
- Involved in requirement gathering discussions with business users.
- Provided required suggestions to Production Application Support team on resolving critical incidence and providing suggestions on performance tuning.
- Designed real Time integration ETL process for Vendor Portal
- Was part of real time ETL architect integration team used new xml stage, xml pack, MQueue stage in Datastage 8.5 and Teradata v13
- Worked on Performance tuning project of existing Datastage jobs.
Candidate Info
years in workforce
years at this job
Accounting
ETL Architect
Collaborated with team to design a new dimensional model to better serve our internal and external customers.
- Developed ETL using SSIS 2008 to populate 2 DataMarts
- Migrating all ETL to new framework utilizing SSIS 2012 including data quality and master data services.
- Manage the configuration and deployment of our solution to all environments.
- Provide ongoing support to our Production solution.
Candidate Info
years in workforce
months at this job
ETL Architect/lead Customerdb / Digitized Transactions, Contractor
Project: CustomerDB / Digitized Transactions Project. Build CustomerDB from 30+ Legacy Data Application source Admin Systems
- Worked with Program manager and project manager/Architect to streamline tasks and their dependencies for building a Go Green plan.
- Participate in Data analysis and mapping exercise from Mainframe & AS400 Legacy applications and ODS to new Oracle based single Customer Database.
- Work with other groups including offshore in collaborative working sessions
- Design and create/code mappings to extract data from Mainframe PDS, DB2 etc. to Oracle DB
- Developed ETL Jobs using Informatica 9.x
Candidate Info
years in workforce
month at this job
Electrical And Electronics Engineering
ETL Architect / Solution Architect
Project: ETL Implementation Analysis
- Interacted with various stakeholders to understand the batch jobs, workflows, dependencies and document them.
- Conduct a feasibility study for migrating the batch jobs to IBM DataStage ETL tool.
- Prepare a road-map and approach for migration of batch jobs to IBM DataStage ETL tool.
- Prepare a project plan for Batch migration and Automation.
- Developed a prototype job in IBM DataStage Job and conducted a performance benchmark against the existing Batch jobs
Candidate Info
years in workforce
years at this job
Computer Applications
ETL Architect/lead
Used proof of concepts approach to leverage a solution that enables all Ab Initio developers to forklift data from source into target in less time.
- Created several generic components that is being used by all abinitio developers to minimize development hours.
- Leveraged an ETL architecture and Ab Initio solution to build Consolidate DataMart which collects member data from various sources. Leveraged a Solid ETL framework to unload , build and load data into datamart. This frame work is highly de-coupled and having greater re-start ability.
- Mentoring junior resources to help as needed to finish their assignments in ETL domain.
- Responsible for deliverables and communicates management regular basis to give updates to the management.
- Responsible to set LOE for all deliverables and work with team members to make sure ETL deliverables are met as promised.
Candidate Info
years in workforce
year at this job
Bachelor of Science
ETL Architect/senior Datastage 8 Developer
Taking the business requirements document and data model, designed a high level ETL Flow and Technical specifications document for the junior developers to replace the legacy system based ETL.
- Leading a team on-shore and off-shore to provide DataStage (Information Server 8.0) and Oracle 9i based ETL solution to replace the current Shell programs.
- Responsibilities include requirement gathering, business analysis, Data Quality Analysis, DataStage configuration issues, decoding Unix Shells, C, java and PL/SQL packages and programs.
- ETL high level design walk through with project sponsors and stakeholders and answering any related question to the design and technicality.
- Managing field mapping documents to ensure consistency, reliability and quality of data within data warehouse.
- Accountable for delivering high level ETL flow and providing technical specification for ETL jobs per business requirements.
- Involved in coding, testing, system testing, data migration from production to test environment and developing test plans for ETL jobs in Information Server (DataStage 8.0.1) environment.
Candidate Info
years in workforce
year at this job
Computer Engineering
Management Information Systems
Lead ETL Architect and Developer Stakeholder
A Social media data and sentiment analysis platform to extract, transform, load and analyze Twitter, Stocks,
Facebook, Google Analytics, Slideshare, News and Blogs websites data in a Multidimensional way
- Developed ETL framework using SSIS and custom Java/Python wrappers to source data from Social media
- Designed Social media Star schema model with conformed dimensions for flexible reporting and analytics
- Discovery and exploration of Twitter and Facebook networks using Gephi and Microsoft NodeXL
Candidate Info
years in workforce
months at this job
Computer Science
ETL Architect/lead Analyst
ETL Architect/Lead Analyst for the extraction, transformation and loading of data from the Vista Health Plans Enterprise Data Warehouse to the Coventry Health Plans Enterprise Data Warehouse.
- Data included all encounters for Private, Group and Medicaid plans for Pharmacy, Vision, Dental and Mental Health claims plus all providers, labs, premiums and capitations.
- ETL Architect/Lead Analyst for the extraction, transformation and loading of data from the Mutual of Omaha Health Plans Enterprise Data Warehouse to the Coventry Health Plans Enterprise Data Warehouse. Data included all claims and premiums for Government, Private and Group plans.
- Responsible for resource estimation and allocation for all projects in the Vista Data Warehouse Group.
- Lead and provide direction to Informatica developers.
- Provide weekly project reports on status and issues to management.
- Train and mentor other staff members on all aspects of Informatica PowerCenter, including maps, maplets, transformations, sessions, workflows, worklets and deployment groups.
Candidate Info
years in workforce
year at this job
Bachelor of Arts
ETL Architect for MDM
Tasked with proposing and evaluating various architectural options for real time/NRT data synchronization with MDM by bringing in legacy data across multiple business lines
- Providing consultations on building up ETL new application infrastructure and providing guidance to fellow team members
- Actively engaging with various external teams to obtain agreements on various matters pertaining to infrastructure setup, design decisions, architectural approach and others
- Engaged with various source system owners to capture specifics around data and metadata which would help enable various design decisions for the ETL processes
- Provided consultation on metadata and data lineage capabilities across multiple ETL products to enable enterprise solutioning for metadata repository
- Engaged with program management and business owners to better translate business needs into best feasible ETL solutions for supporting MDM
Candidate Info
years in workforce
year at this job
Electrical Engineering
Master of Arts
Technology Management
IT Consultant/etl Architect/data Architect
MS SQL Server DB/ Sybase DB Developer/ETL Architect in UNIX env. handling large datasets for reporting.
- MS SQL Server stored procedures, triggers/T-SQL/Stored Procedure Tuning
- Migration from Sybase to MS SQL SERVER
- Data Analysis/Modeling /Developing Reporting Database
- Perl programming to access data from Database.(Sybase/MS Sql Server).
- Analyze Business Requirements, design logical data models and systems functions and present to stakeholders
- Coordinate and interact with technical and business groups within the department
Candidate Info
years in workforce
years at this job
Project Management
Etl Architect/ Onsite Project Manager
Client facing project team management, Project planning and management
- Delivery management, requirement elicitation, high level estimation
- Develop the LLD of mappings, creating and debugging mappings, reviewing mappings.
- Delivery of the successfully completed and tested modules to the customer at proper time.
- System Test, UAT, Co-coordinating with off-shore team for the smooth delivery of the product. Analysis of the existing system and processes & flows, quality analysis and improvement, Low level work estimation and allocation of jobs among team members
- Project Estimation, Scope forecasting, Contract related tasks etc.
Candidate Info
years in workforce
year at this job
Bachelor of Science
Mining
Senior ETL Architect/data Warehouse Architect
Provided Informatica Expertise for Legacy Procurement to SAP middleware development. Recommending standards, best practices and mentoring junior developers.
- Developed several middleware interfaces for Legacy to SAP conversion.
- Provided emergency resource for the Corporate HR Hyperion project. Redesigning processes, developing Informatica objects and creating a test plan in a shortened time frame in order to successfully meet the projects timelines and quality assurance standards.
- Worked with Program Management and Solutions Architect to successfully review and gather requirements for Interface and Reporting solutions. Meeting organizational needs and goals for the implementation of the Maintenance Data Service application.
- Successfully documented adhoc reporting requirements for Production Support team. Providing cost benefit analysis to help determine scope and priority of project.
- Implemented use of Web Service Hub for a Data Service Product. Allowing the Web Service XML application to effectively communicate with the internal data warehouse applications.
- Gathered and documented Functional Specifications for Interface and Reporting systems. Creating proof of concept models for the Web Service Interface as well as the reporting Universe design.
- Constructed application flow charts to describe the detail of processing data and development across multiple platforms.
- Performed conceptual, logical database design for Maintenance Data System. Successfully implementing a plan to meet capacity and security requirements.
- Provided technical leadership for other team members on Database Architecture and interface design.
Candidate Info
years in workforce
years at this job
Information Systems
Computer Science
ETL Architect
Architected the Sybase IQ table design and the schema design.
- Environment, Oracle 9i, 10g, 11g, Solaris, Linux , Business Objects, Sybase IQ, Sybase Power designer, Java
- Architected the [company name] data copy jobs.
- Tuned SQLs for better performance from a Query Standpoint as well as the reporting interface standpoint.
- Architected the merging of slowly changing and snapshot dimensions to Sybase IQ.
- Developed code in Sybase IQ for faster aggregation of summary tables where necessary.
- Involved in the Project Management process for the Sybase IQ migration.
- Designed the interface of Sybase IQ to the Business Objects and Composite data federation Layers.
- Created Criteria for Vendor Selection of the Columnar Database based on weighted average method.
- Led a team of offshore ETL and PL\SQL developers, created technical specifications, developed hands-on a substantial part of ETL processes, developed /validated migration and test plans
Candidate Info
years in workforce
years at this job
Project Management
Electronics And Communications
ETL Architect
As an ETL architect updated the data model, data flow and ETL processes to improve the performance, reliability and create an agile data warehouse environment.
- Develop strategies for data acquisition and warehouse implementation.
- Coordinate with project managers and application managers to ensure solutions are meeting long term Business and IT strategic goals.
- Maintain critical relationships with data providers.
- Ensure operational SLA's are met
- Mentor development team in ADCBI data standards and best practices.
- Supervising data management, integration and migration.
Candidate Info
years in workforce
months at this job
Business Administration
ETL Architect/developer (consultant)
Technology: Oracle 11g, Informatica PowerCenter 8.6, 8.1 UNIX (Solaris)
- Architect and Developer for Data QC processes
- Troubleshoot data quality issues with various data loads coming from external sources
- Established best practices for internal ETL development
- Perform analysis on data to indentify data variances and errors
- Design, develop, test and implement mappings, workflows and scripts that perform error capturing and reporting
- Optimize and simplify ETL processes for performance and ease of maintenance
Candidate Info
years in workforce
months at this job
Electronics And Instrumentation
ETL Architect
Performed requirement analysis to design dimension and fact tables for Customer, Service Location , Meter Read and Billing data
- Performed data profiling on source system to check the health of data
- Involved in Modeling and Database Planning & Design
- Design and implement ETL Mapping and Stored Procedure
- Design and build Informatica mapping using Power Exchange for SAP R3
- Design and build Informatica mapping using Power Exchange for real time CDC
- Co-ordinate with Clients for change in requirements
- Provide high level ETL design to team members, perform code reviews, aid in system test plan development and system testing
- Lead a 8 member ETL team in development of ETL mapping.
- Technology used: Informatica 9.1.0, DB2 UDB V9, SQL Server2005, stored procedure, Shell Scripts, GlobalScape
Candidate Info
years in workforce
months at this job
Electrical / Computer Engineering
ETL Architect/lead
This project involves working with Prime Brokerage data marts for Prime View team. PB data is sourced globally and loaded in to front end application for all Hedge fund related reporting. Fixed Income Forwards, Equities is the primary source of data from different vendors
- Implementing the standards of creating Informatica Workflows.
- Implemented standards for naming Conventions, Mapping Documents, Technical Documents, Migration form
- Performed Code Review with the team members
- Extensive experience with End Users for understanding/analyzing the requirements.
- Detailed Analysis of the Data and Cleaning the Data
- Modeling the Schema. Analysis of the End user requirements for creating the Model
- Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
- Used ETL to extract and load data from Oracle, and flat files to Oracle.
- Scheduling the jobs using Autosys
Candidate Info
years in workforce
year at this job
Bachelor of Arts
Senior ETL Architect/data Warehouse Architect
- Provided Informatica Expertise for Legacy Procurement to SAP middleware development.Recommending standards, best practices and mentoring junior developers.
- Developed several middleware interfaces for Legacy to SAP conversion.
- Provided emergency resource for the Corporate HR Hyperion project. Redesigning processes, developing Informatica objects and creating a test plan in a shortened time frame in order to successfully meet the projects timelines and quality assurance standards.
- Worked with Program Management and Solutions Architect to successfully review and gather requirements for Interface and Reporting solutions. Meeting organizational needs and goals for the implementation of the Maintenance Data Service application.
- Successfully documented adhoc reporting requirements for Production Support team.Providing cost benefit analysis to help determine scope and priority of project.
- Implemented use of Web Service Hub for a Data Service Product. Allowing the Web Service XML application to effectively communicate with the internal data warehouse applications.
- Gathered and documented Functional Specifications for Interface and Reporting systems. Creating proof of concept models for the Web Service Interface as well as the reporting Universe design.
- Constructed application flow charts to describe the detail of processing data and development across multiple platforms.
- Performed conceptual, logical database design for Maintenance Data System.Successfully implementing a plan to meet capacity and security requirements.
- Provided technical leadership for other team members on Database Architecture and interface design.
Candidate Info
years in workforce
months at this job
Mechanical Engineering
Informatica ETL Architect
System Design: Multi-Layer framework, Designing ETL Layout, Data Design
- Designing of audit control unit to monitor and triggering the ETL and Reporting jobs.
- Design and develop data reconciliation queries
- Design and develop various reusable components for ETL common process
- Develop the framework to execute the workflow from Web interface
Candidate Info
years in workforce
years at this job
Department Of Chemistry
Senior Oracle /sql Server DBA, Data ETL Architect
Oracle 10g and 9i production and develop administration on Callidus commission system and databases.
- Oracle Callidus database performance tuning.
- SQL Server 2000, 2005 and 2008 R2 production, test, and develop database administration, database mirroring, replication, and cluster. Physical and application database administration.
- Administrate and support SQL BI and Data warehouse databases in SQL environment.
- Implement Safety-Kleen Microsoft CRM - Microsoft Dynamics system.
- Implement cloud SalesForce.com - Safety-Kleen system and operational delta processes with winning high appreciation from company executives and end users.
- Build interfaces and data transfer processes to connect SalesForce and other company systems with APEX data loader and SQL Server DTS, SSIS packages.
- Build and support Pervasive ETL processes to various data resources.
- Support tax application software such as InSource and Sabrix.
- Support sale commission software Callidus system.
Candidate Info
years in workforce
year at this job
Statistics
Lead Etl Architect/developer
Project: Data Ware House and Decision Support Systems
- Analysis, design, and development of data warehouse and decision support system databases
- Logical and physical data modeling
- Design and development of ETL processes using INFORMATICA Power Mart and Power Center Mappings, Transformations and Workflows to upload data from legacy applications into various operational Oracle database systems and centralized Oracle data ware house and decision support systems databases
- Environment: Sun Unix, MS Windows XP, Toad, Informatica (6.1) Power Mart and Power Center, Oracle 9i, SQL*Plus, SQL*Loader, SQL, PL/SQL, Packages, Functions, Stored Procedures, Triggers, Shell scripts, Erwin
Candidate Info
years in workforce
months at this job
Computer Science
Data Warehouse and ETL Architect
Provide leadership in the execution of Data Warehousing initiatives. Responsible for the development of and implementation of best practices and design related to data cleansing, data quality and data consolidation.
- Create and maintain best practices for ETL processes.
- Ensure that the requirements are adequately understood and documented.
- Design the application architecture based on the documented requirements.
- Assist in the development of the ETL application.
- Perform QA functions for the ETL application.
- Perform data analysis necessary to resolve issues uncovered relating to source data.
- Execute test plans and document results and discrepancies.
- Update and maintain metadata.
Candidate Info
years in workforce
years at this job
Business It
ETL Architect/lead
- Interacted with the Business Analysts to analyze to transform the business requirements into the technical requirements.
- Worked with Data modellers in optimizing the OFSA data model.
- Create overall architecture for the implementation.
- Created technical design for the ETL implementation.
- Worked on different sources like Mainframe files, DB Tables, flat files and FTP sources.
- Worked with multiple pipeline mappings.
- Created complex workflows with more than 50 sessions including decision and event tasks.
- Created Mapping documents, Production Implementation Documents and Production turnover Documents.
- Assign work to offshore teams and monitor the progress of the project.
Candidate Info
years in workforce
years at this job
High School Diploma
Education Qualification
Data Architect, ETL Architect, OWB to Informatica Migration
- Working on requirement gathering from users.
- Worked on design of mappings in OWB and assigned to offshore.
- Gather the reporting requirements and develop them in OBIEE.
- Deployment of OWB and OBIEE code.
- Developing the road map for upgrading OWB to Informatica.
- Working on the technical specification of OWB code to convert them to Informatica code.
- Working on back up process for the down time in migration.
- Setting up Informatica on Linux server.
- Installations and set up complete Informatica and conversion of OWB code to Informatica.
Etl Architect Resume Success Stories
