5 years of Experience in IT industry, related to various aspects involving Data integration and Data warehousing techniques, using ETL tools like Informatica Power Center, Informatica Intelligent Cloud Service (IICS), Ha…
5 years of Experience in IT industry, related to various aspects involving Data integration and Data warehousing techniques, using ETL tools like Informatica Power Center, Informatica Intelligent Cloud Service (IICS), Having 2 years of working experience in IICS/Snowflake. Having working experience in IICS components –Data Integration. Experience loading data into Snowflake Table as a part of flat files to Snowflake migration. Worked extensively with Data staging, Data cleansing, Extraction, Transformation and Loading of data from multiple sources to data warehouse. Sound knowledge in Informatica Partitioning, Pushdown Optimization, and other Performance Enhancements features. Independently perform complex troubleshooting, root-cause analysis, and solution development. Expert in all phases of software development life cycle (SDLC) – Project analysis, Requirements, Design Documentation, Development, Unit testing, UAT, Implementation, Post implementation support and Maintenance. Working knowledge of data warehouse technique and practice, experience including ETL processes, dimension data modelling (Star Schema, Snowflake Schema, FACT & Dimension Tables), OLTP and OLAP. Effective working relationships with client team to understand development requirements, and effectively manage client expectations. Excellent communication, presentation, project management skills, a very good team player and selfstarter with ability to work independently and as part of a team.
5 year of Experience in IT industry. related to various aspects involving Data integration and Data warehousing techniques. using ETL tools like informatica power center, informatica Intelligent Cloud Service (IICS), and Snowflake.
Involved in preparing High level design document, technical document and Mapping preparation.
Extracted data from Legacy systems and load to a staging database.
Created mapping documents with detailed source to target transformation logic, Source data column information and target data column information.
Designed, Developed and Implemented ETL processes using IICS Data Integration.
Extensively used performance tuning techniques while loading data into Oracle using IICS.
Extensively used cloud transformations – Aggregator, Expression, Filter, Joiner, Lookup, Rank, Router, Sequence Generator, Sorter, Update Strategy, Union Transformations.
Extensively used push down optimization option to optimize processing and use limitless power of Oracle.
Extensively used parameters (Input and IN/OUT parameters), Expression Macros and source partitioning partitions.
Developed complex informatica cloud Taskflows (parallel) with multiple mapping tasks and taskflows.
Automated/Schedule the cloud jobs to run daily with email notifications for any failures.
Implemented SCD Type1, SCD Type2, CDC and Incremental load strategies.
Experience in Snowflake, Data Cloning and Time travel, Data sharing, Access Control.
Experience in multiple aspects of Snowflake, Data Warehouse, ETL and Legacy Modernization.
Experience loading data into Snowflake Table as a part of flat files to Snowflake migration.
Used Snowflake SQL queries to validate the data after loading.
Involved in Development, Unit Testing and UAT phases of project.
Extracted source data from, flat files, Oracle and loaded to a relational warehouse.
Created Transformations like Source Qualifier, Aggregator, and Normalizer, Sequence generator, Rank, Joiner, and Update Strategy transformations in Informatica Designer.
Developed Informatica Mappings and Mapplets to load data using various Power Center transformations.
Created transformations starting concurrent batch process in server and performed backup, recovery and tuning of sessions.
Involved in tuning the Mappings for Optimum Performance.
Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
Establishing and monitoring issue management, change management and quality management processes.
Monitoring the Workflows using Workflow Monitor.
Performed Unit testing.
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
