ETL Developer Resume Samples

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 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. 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. 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

Description :

1. Translated business requirements into technical specifications for ETL processes.
2. Collaborated with data modelers to create design documents and understand data architecture.
3. Developed and maintained ETL mappings to align with evolving business logic.
4. Managed the migration of projects from UAT to Production environments.
5. Configured local Informatica environments, ensuring secure data source connectivity.
6. Generated XML targets from various non-XML sources for data integration.
7. Utilized SQL overrides to enhance business-critical tasks effectively.

Experience

0-2 Years

Level

Entry Level

Education

B.Sc. CS

Description :

1. Participated in the Financial Processing Program, focusing on ETL design and execution.
2. Designed and executed test cases for unit and integration testing to ensure data integrity.
3. Utilized SAFR ETL tools to develop scalable architectures for financial reporting.
4. Created Extract Views and Summary Views to meet business requirements efficiently.
5. Generated metadata documentation for Logical Records and Physical files.
6. Mapped fields from source data to views based on defined business requirements.
7. Analyzed metadata discrepancies between SAFR environments using DB2 SPUFI.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Developed and optimized ETL scripts for data extraction, transformation, and loading across multiple platforms, including MS SQL and Oracle.
2. Executed test plans and implemented performance tuning strategies to enhance ETL workflows.
3. Created detailed documentation, including Data Flow Diagrams (DFD) and mapping documents, to support data integration efforts.
4. Led the design and implementation of ETL architecture, mentoring junior developers in best practices.
5. Established standards for Informatica implementations, ensuring adherence to best practices.
6. Facilitated discussions with stakeholders to gather requirements and define data integration needs.
7. Gained functional expertise in key business areas, including Supply Chain Management and Health Care Management.

Experience

5-7 Years

Level

Senior

Education

B.S. in CS

Description :

1. Developed and optimized ETL processes to support data integration and data warehousing initiatives.
2. Designed data models using Erwin to align with client requirements, enhancing data accessibility.
3. Created detailed design and technical documentation from functional specifications, ensuring clarity in implementation.
4. Conducted knowledge transfer sessions for end-users, producing comprehensive guides on ETL processes.
5. Managed Teradata production and development systems, overseeing data loads from multiple flat file sources.
6. Wrote SQL scripts for data validation and transformation, ensuring high data integrity and quality.
7. Implemented Mapplets and reusable transformations to streamline development efforts across projects.

Experience

7-10 Years

Level

Management

Education

BSc

Description :

1. Created functional and technical design documents for ETL processes based on business requirements.
2. Developed PL/SQL procedures for ETL operations, collaborating with business users and system owners.
3. Played a key role in upgrading Informatica Power Center from version 7.1.3 to 8.5.1, ensuring minimal disruption.
4. Designed and implemented Informatica mappings for efficient data extraction, transformation, and loading.
5. Conducted performance tuning and resolved bottlenecks in production processes.
6. Developed scalable processes to manage high data volumes within specified load windows.
7. Collaborated with cross-functional teams for continuous process improvement and best practices implementation.

Experience

5-7 Years

Level

Senior

Education

B.S. in CS

Description :

1. Participated in the full lifecycle of ETL testing, from requirements gathering to execution and reporting.
2. Developed and executed detailed test plans and test cases for ETL processes, ensuring data accuracy and integrity.
3. Validated data transformations and data loading processes, identifying discrepancies and recommending solutions.
4. Collaborated with data engineers to troubleshoot and resolve ETL-related issues in a timely manner.
5. Documented test results and maintained testing artifacts to support compliance and auditing requirements.
6. Utilized SQL queries to validate data against source systems and ensure quality standards were met.
7. Assisted in the creation of user acceptance testing (UAT) scripts and supported end-user testing activities.

Experience

0-2 Years

Level

Entry Level

Education

B.Sc. CS

Description :

1. Monitored and managed production ETL jobs, ensuring timely execution and issue resolution.
2. Executed ad-hoc workflows to address failures and maintain data integrity.
3. Facilitated daily and weekly project status meetings to align team efforts.
4. Conducted root cause analysis for long-running jobs and implemented performance tuning strategies.
5. Oversaw weekly and monthly release activities for ETL updates.
6. Developed complex SQL queries and procedures to enhance data processing capabilities.
7. Collaborated with stakeholders to gather requirements and design ETL mappings in Informatica.

Experience

0-2 Years

Level

Fresher

Education

B.S. in CS

Description :

1. Designed and developed complex ETL mappings and workflows to load data into Oracle databases.
2. Created and optimized transformations such as Source Qualifier, Lookup, and Update Strategy to enhance data processing.
3. Configured and monitored sessions and workflows using Informatica Server Manager to ensure timely data delivery.
4. Conducted performance tuning of ETL processes, identifying bottlenecks and implementing solutions to improve efficiency.
5. Participated in requirements gathering and analysis to align ETL processes with business objectives.
6. Executed comprehensive testing, including unit, integration, and user acceptance testing, to ensure data integrity.
7. Authored and maintained detailed ETL documentation, including run books and troubleshooting guides.

Experience

10+ Years

Level

Management

Education

B.Sc. CS

Description :

1. Designed and developed ETL processes using Informatica PowerCenter to integrate data from multiple sources.
2. Utilized debugging tools to identify and resolve mapping issues, ensuring data integrity.
3. Implemented data transformations and applied business rules for accurate data extraction.
4. Created and maintained comprehensive ETL documentation for process transparency.
5. Managed user access and privileges within the ETL repository.
6. Optimized ETL workflows for performance improvements and reduced processing times.
7. Collaborated with stakeholders to gather requirements and deliver effective data solutions.

Experience

5-7 Years

Level

Senior

Education

B.Sc. CS

Description :

1. Developed ETL programs using Informatica PowerCenter to fulfill complex business requirements.
2. Engaged with business stakeholders to clarify requirements and address issues promptly.
3. Provided ongoing production support, troubleshooting data issues effectively.
4. Conducted performance tuning at both functional and mapping levels.
5. Minimized data transfer by utilizing optimized relational SQL queries.
6. Leveraged various transformations in Informatica to create robust data mappings.
7. Managed the transition of mappings, sessions, and workflows from development to UAT environments.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Designed and implemented ETL processes using Informatica PowerCenter to ensure efficient data flows.
2. Utilized various transformations to optimize data extraction and loading based on business requirements.
3. Conducted performance tuning of ETL workflows, improving overall system efficiency.
4. Collaborated with stakeholders to gather requirements and translate them into technical specifications.
5. Created and maintained documentation for ETL processes to ensure compliance and knowledge transfer.
6. Performed data quality checks to ensure accuracy and integrity of integrated data.
7. Engaged in troubleshooting and resolving ETL process issues to minimize downtime.

Experience

0-2 Years

Level

Entry Level

Education

B.Sc. CS

Description :

1. Collaborated with business analysts to gather requirements and translate them into technical specifications for the enterprise data warehouse.
2. Executed full ETL lifecycle processes, including Extraction, Transformation, and Loading of data using Informatica.
3. Developed System Requirement Specification and Functional Requirement Document based on comprehensive analysis.
4. Created conceptual, logical, and physical data models of the star schema using ERWIN.
5. Utilized Informatica Client tools extensively, including Source Analyzer, Mapping Designer, and Workflow Manager.
6. Designed and developed Informatica packages tailored for critical business functions in the Equity Capital Market.
7. Established daily audit and reconciliation processes to ensure data quality within the data warehouse.

Experience

5-7 Years

Level

Senior

Education

B.Sc. CS

Description :

1. Conducted comprehensive requirements gathering sessions with stakeholders to assess data integration needs.
2. Designed, developed, and deployed ETL processes in Informatica PowerCenter to streamline data workflows.
3. Created and managed reports using SSRS, transforming complex data into user-friendly dashboards.
4. Implemented performance tuning strategies for SQL queries and ETL processes, significantly enhancing execution speed.
5. Drafted detailed documentation for ETL processes, including metadata and technical guides for future reference.
6. Executed thorough testing and validation procedures to ensure data integrity and quality throughout the ETL lifecycle.
7. Collaborated with database teams to design optimal database structures and maintain referential integrity.

Experience

7-10 Years

Level

Management

Education

M.S.

Description :

1. Collaborated with business users to gather requirements and prepare Technical Specification Documents (TSD) for ETL mappings.
2. Conducted rigorous testing of stored procedures, unit tests, and integration tests for Informatica sessions and target data.
3. Executed extensive data cleansing processes prior to staging data from flat files.
4. Implemented Slowly Changing Dimensions (Type 2) for effective data tracking.
5. Scheduled batches and sessions using PowerCenter Workflow Manager to ensure timely data loads.
6. Utilized Maestro for job scheduling to streamline data loading into targets.
7. Leveraged SSIS to construct a comprehensive Data Warehouse for reporting purposes.

Experience

5-7 Years

Level

Senior

Education

B.Sc. CS

Description :

1. Managed the RDW Protocol Programs, loading repair flat files from ASC repair centers.
2. Provided production support for major and minor projects, including maintenance requests and bug fixes.
3. Developed SQL and PL/SQL scripts to migrate data from ASC repair Protocol files to Oracle databases.
4. Performed database administration tasks, managing tables, indexes, views, and procedures.
5. Conducted performance tuning of Oracle databases through partitioning and indexing strategies.
6. Enhanced application performance by optimizing SQL queries and PL/SQL procedures.
7. Created packages to retrieve complex data from remote databases using advanced SQL techniques.

Experience

10+ Years

Level

Management

Education

B.Sc. CS

Description :

1. Designed, developed, and implemented ETL jobs to efficiently load data into data marts from various sources.
2. Collaborated with business stakeholders to gather and analyze requirements for data integration projects.
3. Created comprehensive Source-Target Mapping documents for multiple dimensions and fact tables.
4. Modified ETL jobs to meet evolving business reporting needs on a monthly and quarterly basis.
5. Developed ETL processes to extract, transform, and load data from files, Oracle, Teradata, and SQL Server databases.
6. Executed complex data transformations from Oracle to Teradata, ensuring compliance with specifications.
7. Utilized Teradata utilities like Multi Load and Fast Load to optimize data loading processes into the data warehouse.

Experience

2-5 Years

Level

Junior

Education

BSCS