Job Description :
The Senior ETL Architect is responsible for architecting and developing solutions and successful project delivery & process engagements. This position provides ongoing day-to-day operation support for production applications using knowledge of Informatica and Oracle technologies.
REQUIRED SKILLS:
10-12+ years of experience implementing large scale ETL processes using Informatica PowerCenter
Design high level ETL process and data flow from source system to target databases
MDM/ODS architect and knowledge, best practices
Strong experience with Oracle databases and strong SQL and PL/SQL knowledge
Experience with EDQ
Participate in writing and reviewing logical and physical data models. ERWIN a plus
Work with appropriate leads and review high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions
Develop & unit test Informatica ETL processes for optimal performance utilizing best practices
Performance tune Informatica ETL mappings and report queries
Perform detailed data analysis to understand the source system data
Review source to target data mapping document for ETL processes
Coordinate ETL and database development work with offshore ETL developers and conduct code reviews
Work closely with database administration team and ensure the database is architected and designed to handle concurrent ETL and reporting query jobs
Good understanding of project life cycle, especially tasks within the ETL phase
Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment
Must be a team player and be able to lead and mentor other developers onsite and offshore
Excellent communication and presentation skills
Self-starter with ability to manage priorities