Experienced ETL Developer with 3.5 years of expertise in developing and implementing ETL processes to extract, transform, and load data from multiple sources into a data warehouse. Strong Experience in Informatica Intell…
Experienced ETL Developer with 3.5 years of expertise in developing and implementing ETL processes to extract, transform, and load data from multiple sources into a data warehouse. Strong Experience in Informatica Intelligent Cloud Services, Informatica Power center and SQL. Skilled in performance tuning and optimizing the data using Snowflake. Strong collaborative skills, working effectively with cross-functional teams to meet project objectives.
<p>Extensive experience in data extraction, transformation, and loading data from various source systems like Snowflake, flat files and XML sources.<br>
Translated the business requirements into data pipelines using various transformations in IICS and Informatica PowerCenter.<br>
Developed and enhanced the existing complex mappings by developing or modifying strategies to meet the business.<br>
Developed complex transformations using expression, routers, joiners, lookups, and aggregators in Informatica to meet intricate business requirements.<br>
Creating mapplets, reusable transformations, worklets, and using them in different mappings and workflows.<br>
Well-versed in developing complex SQL merge and join queries, views, and stored procedures.<br>
Wrote Unix scripts to call the files from the landing zone and process the files.<br>
Used WinSCP for file management and Unix scripting to handle the file processing.<br>
Extensively used the Slowly Changing Dimension technique in mappings, and used SQL Override in the source qualifier to customize SQL and filter the data according to requirements.<br>
Worked on migration projects to move the ETLs from PowerCenter to the IICS environment, and moved the entire database and tables from Oracle to Snowflake.<br>
Prepared a unit test plan and test cases for the developed mappings and code deployment processes.<br>
Tuned Informatica mappings to improve the execution time by applying suitable partitioning mechanisms and tuning individual transformations inside the mapping by optimizing caches for lookup.<br>
Scheduling and monitoring the workflows using AutoSys.<br>
Performed code migration through an automated deployment process in lower environments, and completed post-production validations.<br>
Created detailed documentation for ETL processes, data mappings, transformations, and facilitating knowledge transfer.<br>
Worked closely with cross-functional teams, including business analysts, data architects, and QA teams, to gather requirements, perform impact analysis, and deliver solutions that met business needs.<br>
Providing support to team members on the technical side to achieve the project timeline.</p>
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
