Working as a Software Engineer with excellent experience in ETL tool Informatica PowerCenter, IICS, Oracle, PL/SQL, Data Modeling, UNIX, Snowflake and JIRA. Having around 4 years of experience in ETL data integration usi…
Working as a Software Engineer with excellent experience in ETL tool Informatica PowerCenter, IICS, Oracle, PL/SQL, Data Modeling, UNIX, Snowflake and JIRA. Having around 4 years of experience in ETL data integration using Informatica Power center 10.2, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Developer, Workflow Designer, Shortcuts and Informatica Power Exchange. Good knowledge in Star Schema/Snowflake, Fact and Dimension tables and Data Mart, Data Warehouse. Basic Knowledge in AWS (Glue, Athena, S3, Redshift) And ADF (Azure Data Factory). Experience in Data Analysis, Data Extraction, Transformation and loading processes. Have fare Knowledge in Informatica Intelligent Cloud Services (IICS), Oracle SQL, and PL/SQL.
I have created many IIICS mapping by using almost all transformation like source, target, aggregator, joiner, normalizer, sequence, lookup, hierarchy builder, hierarchy parse ect
I have created diff kind of task in IICS loke mapping task, data synchronization tasks, dynamic mapping task and data transfer task in IICS using various data source as oracle DB, saved queries and target as snowflake.
I have created diff type of component like saved query, hierarchical schema, fixed width file format, shared sequence and file listener.
I have created input parameter/ im-out parameter from parameter panel in data integration. created and used parameter files in diff MCTS.
I have implemented SCD Type 1 and SCD Type 2 mapping logic in IICS to load to the dimension tables.
Working as Software developer using ETL tools Informatica Power Center 10.2 and Informatica Intelligent Cloud Services (IICS).
Supporting tools included Oracle SQL, PL SQL, JIRA, and Teradata.
Database used was Oracle11g.
Scripting language used was UNIX.
Operating systems used were Windows platform and UNIX.
Understood the Business Requirements and developed an ETL process to load data from source to target.
Extensively used Informatica PowerCenter for loading the data from sources involving flat files to target as relational table.
Mainly involved in ETL developing to extract, transform and load the data into stage area and data mart.
Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, Normalizer and Sequence Generator to develop Data Mart from staging area.
Created sessions for mapping and validated the session.
Scheduled and monitored the sessions and workflows using Informatica Workflow Manager and Workflow Monitor on a daily basis.
Used Target Load Plan to optimize the performance of the server.
Identified bugs in existing mapping by analyzing the data flow.
Responsible for unit test case writing and testing.
Designed and executed a proof of concept (PoC) for migrating on-premises ETL processes to AWS Glue, leveraging cloud-based technologies to streamline data processing workflows.
Involved in requirement gathering and preparation of HLD and LLD.
Used ETL to load data coming from various sources especially Flat File and Relational File into the target.
Provided quick resolution to issues occurring during loading the production data.
Prepared the mapping document indicating the source/target tables, columns, data types, transformations required and business rules to be applied.
Implemented CDC approach, SCD-1 and SCD-2 for loading data in the dimensions table.
Used session and workflow logs to trace errors that occurred while loading the data.
Used various Informatica transformations and PL/SQL package tasks for ETL loading.
Wrote Stored Procedures and UNIX scripts for automation.
Scheduled workflows using Informatica Scheduler and corn job.
Managed end-to-end delivery from requirement gathering to actual development.
Designed unit test cases and performed unit testing.
Performed performance tuning of the Informatica mapping and SQL queries.
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
