Professional Summary
- 13 years of IT experience with a strong background in SDLC, Data Integration tools including Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), Informatica PowerExchange, IDQ and business Intelligence tools like Power BI - Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling. Effort Estimation, ETL Design, development, System testing. Implementation and production support. - Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems. - Experience working with IICS concepts relating to data integration, Monitor, Administrator, deployments, permissions, schedules. - Expertise in Informatica Power Center 10.5/10.4/10.2/10.1/9.5.1/9.0.1/8.6/7. 1 extracting data from Oracle, SQL Server, Teradata, DB2 databases, Flat files, Web Services, API's, XML & Json files. - Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, Union etc., - Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions. - Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. - Experience in Installation, Configuration of Informatica Power center 10.x/9.x Client, Server in UNIX. - Experience in Performance Tuning and Debugging of existing ETL processes. - Experience in Integration of various data sources like Oracle, Teradata, SQL Server, DB2 and Flat Files in various formats like fixed width, CSV and excel. Designed complex mappings to load into Snowflake. - Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.