Job ID :
Company :
Internal Postings
Location :
Type :
Duration :
24 Months
Status :
Openings :
Posted :
16 Mar 2014
Job Seekers, Please send resumes to


·      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.