- Excellent experience in designing and development of ETL Methodology using Informatica cloud IICS and
Informatica PowerCenter 10.5, 9.6.1/9.1.1
- Having experience in working with ORACLE 11g/10g, MySQL, SQL Server 2017/2014 databases.
- Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x
- Worked extensively in Requirements gathering, Development, testing and Production deployment.
- Prepared various types of documents like Data Mapping, Test cases, Data dictionary etc.
- Expert in writing SQL query using multiple databases like ORACLE, SQL Server, MySQL etc.
- Extensive knowledge of Informatica tuning and SQL tuning.
- Experience in integration of various data sources into staging area.
- Experience on Informatica cloud Services (ICS) by using bundles, Integration Templates, Mappings, Task Flows,
Saved Queries, Input / Output Macro fields, Mapping Configuration Tasks and Cascading Filters.
- Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
- Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
- Designed and developed complex mappings, mapplets, tasks and workflows and tuned it.
- Experience in Debugging and Performance tuning of targets, sources, mappings and sessions.
- Good understanding of the Data modeling concepts like Star-Schema, Snowflake Schema Modeling.
- Experience in optimizing the Mappings and implementing the complex business rules by creating reusable transformations like mapplets.
- Extensively used Slowly Changing Dimension (SCD) technique in business application.
- Used UNIX command for multiple file operation for data viewing, data parsing and filtering.
- Experience in migrating code through CI/CD pipeline using GIT and Bitbucket
- Experience in Performance tuning of ETL process using pushdown optimization.
- Understanding of AWS cloud and some of its Product like S3 Bucket, EC2 etc.
- Good experience in working with onshore, offshore team and End to End teams to ensure commitments are met.
