5+ years of Data Warehousing ETL experience using Informatica Power Center 10.x/9.x
Experience working on relational databases such as Oracle 10g/9i or SQL Server 2008
Extensive experience with ETL tool Informatica in designing and developing complex Mappings and Mapplets
Expertise in scheduler tools like Autosys
Exposure and knowledgeable on AWS platform and configuration (EC2, RDS)
Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i MS SQL Server DB2 Teradata and Flat Files into the staging
Possess expert level skills in scripting across the UNIX and windows environment
Strong database tuning experience in SQL Server
Perform impact analysis on Change Requests and document proposed solution and estimated required effort
Coordinate and plan with Infra and change management teams for application deployment activities in Devops environment.
Review and contribute to test planning for SIT and UAT
Experience in leading, with good results, design gathering and design workshops with users as part of change delivery or defects fixes work