Database Developer (Informatica)
Complete Description:
The selected candidate shall work with MPD’s Quality Assurance team to identify and resolve data quality issues related to a large legacy data conversion project. The selected candidate should be able to analyze and document rules provided by the business team and design ETL objects to implement and verify them. This candidate will spend a major portion of his/her time writing complex SQL queries to analyze and resolve legacy data quality issues in a data conversion project. This candidate must be meticulous in all project tasks. The candidate must have strong verbal skills and must be able to communicate with non-technical people. He/she must also be able to write clear explanations of complex topics, as much of MPD’s correspondence is handled through e-mail.
Required Qualifications:
• Strong SQL querying knowledge of SQL Server 2005 and above
• Strong SQL querying knowledge of Oracle 10g and above
• Basic knowledge of performance tuning of long-running SQL queries using Oracle & SQL Server
• Must have worked on Informatica 8.6.1 or 9.x.
• At least 6 years experience working with Informatica Power Center
• Strong knowledge in design, development, testing, and implementation of ETL jobs in Informatica Power Center
• Working knowledge of ETL processes and Informatica Best Practices based on industry standards
• Ability to gather business requirements from a business team and transform them into functional requirements
• Ability to map source-to-target elements, design and develop transformation processes to load data from source to target, and develop and tune Informatica mappings and sessions
• Extensive knowledge in performance tuning, surrogate key assignments and partitioning techniques
• Understanding of Data Quality in OLTP systems and Business Intelligence environments
• Complete working knowledge of SDLC lifecycle model
• Understanding of change management and production support processes
• Ability to prepare implementation and contingency plans for supported applications
• Strong communication skills as well as ability to independently work with Business Analysts
• Working knowledge of logical and physical data modeling techniques.
• Working knowledge of data comparison and text editing tools like Exam-Diff, Beyond Compare and Edit
• Experience with Windows / Linux automation scripting knowledge
• Ability to be a team player and be pro-active,
• Demonstrated ability to set weekly goals and deliver on them
Preferred qualifications:
• Experience in Windows and Linux
• Certifications in SQL server, Oracle and Informatica
• Experience automating data validation processes in data conversion projects
• Experience in Unix CRON scheduler or other scheduling tools knowledge
• Experience with SharePoint desired
• Experience with Microsoft Project
Behavior Characteristics:
Works under IT supervisor and business process owner. Independently plans, designs and carries out assignments in accordance with established policies and practices. Must work in a team. Must be able to learn quickly and work well under pressure.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Experience with and strong SQL querying knowledge of SQL Server 2005 and above
Required
6
Years
3 - Expert
Experience with and strong SQL querying knowledge of Oracle 10g and above
Required
6
Years
3 - Expert
Experience with performance tuning of long-running SQL queries using Oracle & SQL Server
Required
6
Years
2 - Proficient
Experience with Informatica including 8.6.1 or 9.x.
Required
6
Years
2 - Proficient
Experience with Informatica Power Center - design, development, testing, and implementation of ETL jobs
Required
6
Years
3 - Expert
Experience with and working knowledge of ETL processes and Informatica Best Practices based on industry standards
Required
6
Years
2 - Proficient
Requirements gathering / analysis - creating functional requirements
Required
6
Years
2 - Proficient
Map source-to-target elements, design/develop transformation processes to load data from source to target, and develop/tune Informatica mappings
Required
6
Years
2 - Proficient
Extensive knowledge in performance tuning, surrogate key assignments and partitioning techniques
Required
6
Years
3 - Expert
Understanding of Data Quality in OLTP systems and Business Intelligence environments
Required
6
Years
2 - Proficient
Complete working knowledge of SDLC lifecycle model
Required
6
Years
2 - Proficient
Understanding of change management and production support processes
Required
6
Years
2 - Proficient
Experience preparing implementation and contingency plans for supported applications
Required
6
Years
2 - Proficient
Experience with logical and physical data modeling techniques
Required
3
Years
2 - Proficient
Experience with data comparison and text editing tools like Exam-Diff, Beyond Compare and Edit
Required
3
Years
2 - Proficient
Experience with Windows / Linux automation scripting knowledge
Required
6
Years
2 - Proficient
Experience in Windows and Linux
Desired
6
Years
2 - Proficient
Certifications in SQL server, Oracle and Informatica
Highly desired
6
Years
3 - Expert
Experience automating data validation processes in data conversion projects
Desired
6
Years
2 - Proficient
Experience in Unix CRON scheduler or other scheduling tools knowledge
Desired
3
Years
2 - Proficient