Senior ETL Developer Resume Samples

Description :

1. Gathered business and technical requirements, wrote BRD and prepared FSD (functional specification document).
2. Gathered business and technical requirements from clients for maintenance tasks.
3. Prepared technical design documents (both hld and lld) for each enhancement and maintenance releases.
4. Involved as primary on-site ETL developer during the analysis, planning, design, development, and implementation stages of various projects using IBM infosphere/websphere software (datastage 8.7/8.1/7.5, quality stage, web service, information analyzer).
5. Datastage software migration from 7.5 to 8.1 to increase parallel performance during 2011. Datastage software migration from 8.1 to 8.7 during 2013 and developed new jobs on 8.7 version.
6. Utilized ODI(Oracle data integrator) for poc of re-engineering existing ETL DataStage jobs to expedite the cycle time using Oracle 11g Exadata.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Engineering

Description :

1. Creating functional, technical design and data mapping documents by interacting with customers subject matter expert (SME).
2. In addition, participating in requirement gathering, analyzing the requirements, creating the technical design specifications based on client functional specs.
3. Designing data mappings to extract data from SAP using ABAP, iDoc, BAPIS & setting up business content mappings i.e. Listener, send request, processing & clean up to load into EWD for upstream Cognos reporting system.
4. Identifying, activating, creating processing mappings for BCIs and extracting data sources for attribute & text tables for SD, MM, FI & CO modules.
5. Outage handling(escalation procedure, running metadata queries and procedures, checking database , creating outage log).
6. Performed migration of mappings and session from dev to test repository, taking backup and restoring of Informatica repository, upgrades and security issues.
7. Involved in the migration of Informatica objects in all phases (dev, int and prd) of the project and trained developers to maintain system when in production.
8. Regular monitoring of the Informatica server environment on AIX UNIX server.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology

Description :

1. Involved in the development of ETL packages or newly built data mart by using SSIS.
2. Addressed the issues related to "834 benefit enrolment & maintenance transactions". Improvement of existing process and implementation of new ETL design.
3. Designed and implemented a data schedule and time-code data from the different entities and processing the data to provide a unified view of the platform (conformed dimension).
4. Supported and implemented appropriate HIPPA standard compliance consolidate redundant operational process using EDI and up gradation from 4010 to 5010 and maintenance of upfront application for research analyses between b2b. Platform (conformed dimension).
5. Developed IDQ standardization mappings according to rules using IDQ transformations and address validators accelerators.
6. Involved in building the logical and physical models for dimensional modeling projects.
7. Loaded the interacting with clients to gather requirements on cleansing rules and data remediation.

Experience

10+ Years

Level

Management

Education

MSC

Description :

1. Working closely with data acquisition and data distribution team to maintain consistent data availability for financial reporting.
2. Lead ETL developer for retirement partners and MDM project. Currently responsible for loading data from various sources to LPL’s advisor facing servers.
3. Responsible for implementing the new Exa-Data platform for LPL. Managed SSRS report server for lpl reporting team.
4. Responsible for deployment and maintenance of Rdl files on LPL’s report server.
5. Creating and managing Informatica mappings for retirement partners project (owner of the project), creating the delivery method and workflow dependencies. Involving in deployment and release activities.
6. Responsible for LPL's MDM implementation using Informatica MDM working with offshore ETL team to develop and deliver a company-wide solution.
7. Developed number of complex Informatica mappings, mapplets and reusable transformations for recreating the logic in epm solution.
8. Worked with etl factory software to developed templates that could be used to quickly develop mappings to move data from source to target.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Working on "UHG Talend Migration Project" as an ETL specialist to execute CSP platform which includes Datastage 8.7 ETL to Talend studio ETL with Hadoop.
2. Responsible for building scalable distributed data solutions using Hadoop.
3. Worked for hands-on Datastage 8.7 ETL migration to Talend studio ETL process.
4. Designing, developing, validating and deploying the Talend ETL processes for the DWH team using Hadoop (pig, hive) on Hadoop.
5. Collaborate with the data warehouse team to design and develop required ETL processes, performance tune ETL programs/scripts.
6. Handled importing of data from various data sources, performed transformation like ETL (extract transform and load) and ELT (extract load and transform) into HDFS.
7. Extracted the data from Oracle 12c, transformed and load in HDFS using Talend studio ETL tool.
8. Analyzing the data extraction by performing hive queries and running Oracle SQL to know user behavior.
9. Continuous monitoring with admin and managing the Hadoop cluster through Cloudera manager.
10. Developing hive queries to process the data and generating the data cubes for visualizing.

Experience

10+ Years

Level

Management

Education

Bachelor Of Engineering

Description :

1. Extensively worked on understanding the business requirements, data modeling, and ETL structure.
2. Developing ETL scripts to extract and cleansing data from SQL databases.
3. Generating the required metadata at the source side, in the Informatica mappings.
4. Have prepared the impact analysis document and high-level design for the requirements.
5. Involving in performance tuning by collecting statistics and observing explain plan.
6. Carrying out performance tuning both on Informatica side and database side.
7. Involving in the analysis, requirements gathering and documentation of functional & technical specifications.
8. Worked on data analysis to find the data duplication and existed data pattern.
9. Developing high-level technical design specifications and low-level specifications based on business requirements.

Experience

10+ Years

Level

Management

Education

Bachelor Of Technology

Description :

1. Analyzing, extracting and documenting the functional requirements of the existing legacy system.
2. Deducing the business rules and process rules from the stored procedures that were an active part of the file loading process and validating with CMS compliance guidelines.
3. Creating module architectural design, interface design, and detailed level design documents.
4. Creating requirements traceability matrix for the development team to monitor deliverables.
5. Exporting IDQ mappings as applets in PowerCenter for validation and audit of source data prior to loading.
6. Creating views, indexes, sequences, synonyms, materialized views for ETL development.
7. Developing mappings to perform consolidation process, identifying the potential discrepancies of data and calculating payment reconciliation for various healthcare clients to maximize the accuracy of payments to CMS.
8. Designing and developing mappings to incorporate the existing SQL code logic into Informatica using transformations like source qualifier, sorter, aggregator, expression, joiner, dynamic lookup and connected and unconnected lookups, filters, sequence, router and update strategy.
9. Developed mappings to load data into SQL server from Teradata and Oracle databases.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Involved in receiving web service calls from an external vendor and perform ETL to integrate it with banks internal host using Informatica data integration hub. Partnered with bi team on multiple.
2. Partnered with cross-functional teams to implement advanced analytics on customers and products.
3. Working on integrating customer data from multiple data sources to achieve consistency in data and providing a single source of truth for business decision making.
4. Gathering the business requirements from the business users and performing an extensive data analysis on the internal host system.
5. Working closely with the business analysts to create mapping documents.
6. Designing complex and custom ETL code based on the requirements of the external vendor and internal host.
7. Modifying the schema XSDS based on the changing requirements.
8. Work with the external vendors technical team closely on the changes in the design of the interface.
9. Working with the bank's network team and external vendor to establish connectivity between the systems.
10. Performed troubleshooting if any issue arises.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Involved in understanding the booking system, for developing the various data marts for which understanding the business system necessary. The booking system can be thought of as a piece of an object model in which an account has a collection of trips.
2. Created entity relationship diagrams, function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
3. Analyzed existing logical data model (LDM) & made appropriate changes to make it compatible with business requirements.
4. Expanded physical data model (PDM) for OLTP application using Erwin.
5. Studied the existing oltp system(s) and created facts, dimensions and star schema representation for the data mart.
6. Extensively worked over the online tracking system for work-requests, database change request issues, automated unix scripts modification issues and various scheduler jobs issues.
7. Involved in data model reviews with internal data architect, business analysts, and business users with an explanation of the data model to make sure it is in-line with business requirements.
8. Developed PL/SQL scripts and conducted data masking on the testing environment to protect sensitive data.
9. Designed and developed complex informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.

Experience

10+ Years

Level

Consultant

Education

College

Description :

1. Analyzed the business requirements and designed ETL solution and developed the code using informatica power center.
2. Understood the requirement specifications, prepared the functional and technical design documents.
3. Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic and reduced running time.
4. Worked on up gradation process of informatica from version 9.1 to 9.5.
5. Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.
6. Responsible for retrofitting the code to qa environment, and extending the support for the qa and uat for fixing the bugs.
7. Responsible for batch monitoring and break fix in the production environment.
8. Responsible for escalation management during the production support along with fixing the bugs.

Experience

10+ Years

Level

Consultant

Education

College