Job Description :
Responsible for the design and development of ETL solutions. Work closely with internal business users and business analysts to develop requirements. Design, develop, test, and deploy mappings. Provide production support of Informatica processes. Interpret and implement business requirements for ETL development. Create ETL components for data warehouse and other distributed applications that are optimized and efficient. Perform in-depth unit testing for all enhancements/new development including data analysis for verification of accuracy and performance tuning for optimal execution. Adhere to existing ETL development and load management standards and processes. Manage timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation. Troubleshoot and support ETL systems in a production environment, including resolving issues and deploying bug fixes in a timely manner.

? 10+ years' experience in data warehousing and data integration projects
? 10+ years' hands-on experience creating advanced mapping, transformations, and workflows using Informatica PowerCenter
? Ability to analyze data integration requirements, data sources/targets, business rules, and transformation logic
? Experience designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data into various cloud based data warehouses
? Ability to collaborate with technical and business users to define performance requirements and improve efficiency
? Strong analytical and problem solving skills
? Strong SQL knowledge
? Experience writing / debugging Oracle PL/SQL triggers, procedures, packages, & functions is a PLUS.
? Hands on data modeling / db design experience using Erwin tool desired.
? Hands on experience writing / debugging shell scripts / PowerShell scripts is a must.
? Excellent communication skills .