Have 8+ Years of Experience and expertise in Data Warehouse and ETL designing/implementation with Informatica, Oracle,SQL
Have 2 years of Experience in ADF
Have basic knowledge on snowflake
Experience in working with Ti…
Have 8+ Years of Experience and expertise in Data Warehouse and ETL designing/implementation with Informatica, Oracle,SQL
Have 2 years of Experience in ADF
Have basic knowledge on snowflake
Experience in working with Tivoli Workflow Scheduler (TWS) &ApacheAirflow to create job definitions and job streams for Informatica ETL’s and scheduling them.
Have good knowledge/exposure in Jenkins &GitHub Services.
Have good knowledge on Airflow scheduling tool
Worked in Agile process, Kanban broad
Extensively Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformations Developer and Mapping Designer.
Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume data.
Designing and implementing complex ETL processes.Created High Level Document (HLD), Low Level Document (LLD) for the design and translated the business requirements into the technical requirements to the rest of the developers in team.
Experience in tools like Informatica, Oracle, Tivoli and UNIX.
Experience in Smoke/Functional/System/Regression/Database Testing
Expertise in all types of test documentation: Test Estimations, Test Plans, Test Completion Reports, Test Scenarios and Test Cases
Informatica production support.
Performing oncall activities and fixing the issues. based on the priority.
Daily standup meetings on the on going issues
Involved in Monthly deployments using change tickets.
Implemented the code migration process with Jenkins & GitHub services.
Involved in oracle to Snowflake migration.
Involved in all the existing releases and helped the team in resolving critical issues.
Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
Extracted data from various heterogeneous sources like Mainframes, DB2, Flat Files.
Developed complex mapping using Informatica PowerCenter tool.
Used joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
Created Sessions, Tasks, Workflows and using Workflow manager.
Worked with Data modeler in developing STAR Schemas.
Involved in Performance tuning and Query optimization.
Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).
Created pre sql and post sql scripts which need to be run at Informatica level.
Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
Used Debugger to fix the defects/ errors and data issues.
Expertise in using both connected and unconnected Lookup Transformations.
Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
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
