Requirement:
· Design all extraction and integration (ETL) processes
· Implement execution framework including reporting, auditing and alerting
· Maintain Data lineage from source system to the data warehouses
· Work closely with Technical Architects, QA, Business Intelligence Analysts, BI/Report Designers, Data Stewards, Database developers, Database Administrators and support staff throughout the full Data warehouse life cycle
· Mentor team members in BI/ETL/Database development and support practices
· Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies
· Maintain a deep understanding of the integrated data and work with end users for how to best interpret
· Provide in-depth troubleshooting skills to assist in resolving errors and performance issues including tier 2 production supports
· Maintain confidentiality of all data
· Work closely with software developers and architects to deploy solutions to production
Must Have:
· Solid working experience in Informatica PowerCenter 9.x, Data Exchange/Data Transformation (DX/DT) environments
· Strong experience with Business Intelligence and Data Warehousing design principles and industry best practices
· Experience in requirements gathering and creating architectural, detail design documents and mapping documents
· Experience with many of the transformations of Informatica including complex lookups, stored procedures, update strategy, mapplets, etc.
· Skilled in developing Informatica objects - mappings, sessions, and workflows based on the prepared low level design documents
· Experience in debugging mappings and identifying errors and error rows so that they can be corrected and re-loaded into a target system
· Performance tuning of Informatica Mappings, processes, and load routines
· Experience with Data Integration Web Services, Data Quality, and Data Validation Option
· Ability to work efficiently following an Agile Methodology
· Analyze business requirements holistically and as they relate to the ETL process, research, evaluate and recommend alternative solutions
· Experience automating ETL processes with Informatica PowerCenter
· Ability to perform relational and multidimensional modeling and schema creation
· Ability to navigate and query a relational database (Oracle) to both develop reports and to perform data validation using common tools including SQL/PLSQL
· Good understanding of XML and corresponding XSD's
· Solid experience in database query/performance optimizations
· Ability to interact with other departments and business users who are not as technical in nature
· Ability to understand system functionality, process, and architecture at a technical and business level
· Hands on experience with Informatica Cloud Services
· Excellent analytical, problem-solving, and decision-making skills
· Excellent written and verbal communication skills
Education: A Bachelor's Degree or Higher in a Computer Relate Fields or Foreign Equivalent required.