Job Description :
Position: Informatica Developer
Location: Troy, MI
Duration: 12+ months contract

Requirements - Education and/or Experience:
Bachelor’s Degree in Computer Science or equivalent 5 years of experience working with large enterprise class Data Warehouse projects as an ETL Developer or equivalent combination of education and work experience.
Advanced Informatica PowerCenter Development Skills. Experience working with Informatica PowerCenter 9.x or higher.
Hands on experience in Oracle CDC using Informatica Power Exchange.
Exposure to Cloud Data technologies is a Plus. Azure experience is desirable.
Experience in “Informatica Cloud” is a plus.
Data Lake, Hadoop, and other Big data technologies knowledge is helpful.
Experience in creating detail design documents and mapping documents.
Performance tuning of Informatica Mappings, processes, and load routines.
Solid experience in database query/performance optimizations.
Proven communication and presentation skills to effectively communicate information to all levels within the organization, and to interact well in a team environment

The Informatica Developer will be working with Data Modelers and Solution Architects to create and test Informatica ETL Mappings. The developer will also be responsible for scheduling, tuning, testing, and maintenance of systems in support of new, and existing Data Platform initiatives.

RESPONSIBILITIES:
Develop, perform tests, validate all data flows and prepare all ETL processes according to business requirement.
Adapt ETL processes to accommodate changes in source systems and new business user requirements.
Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
Document design specs, requirements, and mapping templates.
Provide support and maintenance on ETL processes.
Troubleshoots and resolves data, system and performance issues.
Strive to continuously improve the software delivery processes and practices

Competencies / Technical Required Skills:
Advanced Informatica PowerCenter Development Skills. Experience working with Informatica PowerCenter 9.x or higher.
Hands on experience in Oracle CDC using Informatica Power Exchange.
Exposure to Cloud Data technologies is a Plus. Azure experience is desirable.
Experience in “Informatica Cloud” is a plus.
Data Lake, Hadoop, and other big data technologies experience also a plus.
Experience in creating detail design documents and mapping documents.
Performance tuning of Informatica Mappings, processes, and load routines.
Solid experience in database query/performance optimizations.
Proven communication and presentation skills to effectively communicate information to all levels within the organization, and interacts well within a team environment.

Professional:
Excellent verbal and written communication skills and the ability to interact professionally with a diverse group; executives, managers, and subject matter experts.
Ability to work in a fast paced environment while managing business analysis. timelines and deliverables around multiple projects.
Experience in managing customer expectations effectively.
Excellent organizational skills and attention to detail.
Thinks “outside the box” to generate fresh ideas/approaches.

Educational Requirements:
Bachelor’s Degree in Computer Science or equivalent 5 years of experience working with large enterprise class Data Warehouse projects as an ETL Developer or equivalent combination of education and work experience.
             

Similar Jobs you may be interested in ..