8+ years of strong Data Warehousing experience using Informatica Power Center (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Exchange, OLAP, OLTP.
…
8+ years of strong Data Warehousing experience using Informatica Power Center (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Exchange, OLAP, OLTP.
8+ years in Information Technology experience in Data Warehousing teamed with Business Requirements Analysis, Application design, Data Modeling, Development, Testing and Documentation. Proficient in Data Warehousing Concepts like Ralph Kimball and Bill Inmon Methodologies and Dimensional Data Modeling experience using Star Schema/Snowflake modeling, Fact & Dimensions tables.
Experience in ETL processes for extracting data from operational and legacy systems to data warehouse using Informatica. Understands complex mappings, transformation rules, data conversion and efficient in performance tuning of sources, mappings, targets and sessions.
Extensively used various active and passive transformations like Filter, Router, Expression Transformation, Source Qualifier, Joiner, Sequence Generator, Update Strategy, Rank, Sorter, Aggregator and Look Up.
Sound knowledge in tuning Informatica mappings and identifying bottlenecks and resolving issues to improve the performance.
Experience using Oracle 12c/11g, Teradata, MS SQL Server, DB2, SQL, SQL*Plus, Tidal, Control M, UNIX Shell Scripting.
Developed mappings using Talend to extract data from MongoDB and create flat files per requirements.
Extensive knowledge with Teradata SQL Assistant.
Excellent Client Interaction, Communication and Presentation Skills.
● Support UMV (Unified Member View) project team on ETL end by monitoring all the Real Time CDC jobs in Power Center that source from Power Exchange and load to Tibco queues.
● Support the transition of Tibco queues to Kafka Topic.
● Support to reconcile existing jobs where data is being replaced from an existing vendor to a new vendor.
● Work with Finance team to gather requirements for generating xml files on member claims in vendor specified format.
● Document mappings and technical details on a confluence page that is shared across the department.
● Support the transition of scheduled jobs from Tidal to Control-M.
● Working on jobs that load multiple files using In-direct loading option through a session task.
● Use Service Now to submit Change Requests.
● Stored reformatted data from relational, flat file, xml files using Informatica (ETL).
● Used Informatica Power Center to create mappings, sessions and workflows for populating the data into required data mart tables simultaneously from different source systems.
● Implemented Post-Command task to merge data from multiple flat files to one flat file and moved files to FTP location.
● Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
● Involved in Production Support to resolve issues and bugs.
Support UMV (Unified Member View) project team on ETL end by monitoring all the Real Time CDC jobs in Power Center that source from Power Exchange and load to Tibco queues.
Support the transition of Tibco queues to Kafka Topic.
Support to reconcile existing jobs where data is being replaced from an existing vendor to a new vendor.
Work with Finance team to gather requirements for generating xml files on member claims in vendor specified format.
Document mappings and technical details on a confluence page that is shared across the department.
Support the transition of scheduled jobs from Tidal to Control-M.
Working on jobs that load multiple files using In-direct loading option through a session task.
Use Service Now to submit Change Requests.
Stored reformatted data from relational, flat file, xml files using Informatica (ETL).
Used Informatica Power Center to create mappings, sessions and workflows for populating the data into required data mart tables simultaneously from different source systems.
Implemented Post-Command task to merge data from multiple flat files to one flat file and moved files to FTP location.
Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
Involved in Production Support to resolve issues and bugs.
Involved in INDIANA HEALTH INSURANCE PROGRAM (INHIP) project.
Extracted data from existing EDW tables to load data mart designed specifically for the project.
Worked closely with Business Analysts and ETL Architect for performing data analysis and gathering business requirements.
Worked and supported to enhance the existing stored procedures in Teradata.
Documented technical specifications of the ETL process flow.
Used Informatica Power Center to create mappings, sessions and workflows for populating the data into required data mart tables simultaneously from different source systems.
Created Teradata Parallel Transporter (TPT) connections to load target tables and improve performance.
Created mappings using various Transformations to generate flat files of given standard specific to the State of Indiana.
Implemented Post-Command task to merge data from multiple flat files to one flat file and moved files to FTP location.
Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
Used Debugger to test the mappings and fixed the bugs.
Involved in unit testing and documentation of the ETL process.
Prepared Source to Target mapping documents, Unit Testing documents.
Scheduled workflow jobs using Tidal scheduler and implemented appropriate job dependencies to automate the process.
Implemented Success / Failure email notification under session task for notifying the team on daily job status.
Involved in State Transforming Agency Resources (STAR) project.
Prepared the Source to Target (STT’s) mapping documents for the designed staging, dimension, and fact table mapping.
Co-ordinated Joint Application Development (JAD) sessions with Business Analysts for performing data analysis and gathering business requirements.
Developed technical specifications of the ETL process flow.
Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Oracle.
Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
Used version mapping to update the slowly changing dimensions to keep full history at the target database.
Implemented sending of Post-Session Email once data is loaded.
Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
Used Debugger to test the mappings and fixed the bugs.
Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
Involved in unit testing and documentation of the ETL process.
Created change request using Cherwell.
Tested and validated source and target data using Power Center Data Validation Option (DVO).
Involved in Production Support to resolve issues and bugs in mappings.
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
