Sr. ETL Developer Resume

SUMMARY:

Seeking Data Analyst/ETL Developer position where I can use my strong technical skills to solve complex problems, deliver quality solutions, and have an opportunity to increase my knowledge

TECHNICAL SKILLS:

ETL Tools: Talend, Informatica, Pentaho Java, SQL, JavaScript, HTML, SAS Programming

Databases: Oracle, MySQL, MS SQL Server

Windows: Japersoft (iReport Designer), Tableau

Others: MS Office, MS Project, SAP BODS

PROFESSIONAL EXPERIENCE:

Sr. ETL Developer

Confidential

Responsibilities:

Participated in all phases of development life cycle wif extensive involvement in teh definition and design meetings, functional and technical walkthroughs
Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
Involved in Requirement Analysis and teh required documents for streamlining teh process
Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
Performed extensive testing on teh mappings and wrote queries in SQL to check if teh data was loading to teh dimension tables and fact tables properly
Created reports from teh OLAP systems using Tableau and report Designer

ETL Developer

Confidential

Responsibilities:

Involved in designing, developing, and documenting of teh ETL (Extract, Transformation and Load) strategy to populate teh Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
Designed and developed complex mappings in Informatica to load teh data from various sources such as SQL server, Flat files, Oracle using different transformations such as, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations
Designed and developed mappings, parameters, defined workflows, and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery
Created and configured workflows, worklets, and sessions to transport teh data to target warehouse Oracle tables using Informatica Workflow Manager
Implemented Slowly Changing Dimensions (SCD) to update teh dimensional schema.
Performed extensive testing on teh mappings and wrote SQL queries to check if teh data was loading to teh dimension tables and fact tables

Associate ETL Developer

Confidential

Responsibilities:

Analyzed teh source data to know teh quality of data by using Data Quality Tools(Talend Data Quality)
Development of ETL Mappings and Transformations
Data Validations as per User’s requirements by using Lookups
Involved in tuning and optimization of SQL statements and used SQL hints and indexes to improve teh performance of queries
Performed Unit Testing and prepared unit testing documentation. Developed teh Test Cases and Test Procedures. Extensive use of TDQ for data profiling and quality

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship