ETL Development Lead job at Omni Inclusive Morristown, NJ, US

Job Description

ROLE RESPONSIBILITIES

Develop new ETL, complex enhancements and modify existing code using Informatica PowerCenter. Work independently to develop, configure, and unit test programs from specs (source to target mappings).
Work closely with data architects, reporting team and application team on ETL development efforts.
Design and document ETL solutions for projects, estimate work effort and provide status of tasks.
Coordinate development work of all Informatica ETL developers which are located offshore and onshore. Allocate work as needed to ensure high quality for their deliverables and support their development.
Provide technical support for the administration and production support of Informatica.
Provide level three troubleshooting, baseline, and operational support.
Create and maintain best practices and methodologies for ETL development team.
Prepare runbooks that describe, and support code that is developed, as well as production support.
Identify improvements to the data warehouse environment. Work with the offshore team to implement these solutions.
Know when to escalate issues to the right party as required.

TECHNICAL QUALIFICATIONS

7+ years of experience in a Lead development role for a data warehouse.
10+ years of experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
Experience working with complex SQL for ETL development.
Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
Expertise with integration technologies and processes.

GENERAL QUALIFICATIONS

Excellent analytical, organization, presentation, and facilitation skills; ability to multitask under tight deadlines.
Working knowledge of Kimball, Inmon, Millbrook design methodology.
Knowledge of testing tools and techniques.
Experience within window environment.
Working knowledge of EDW reconciliation solutions.

Minimum Mandatory Skills:

7+ years of experience in a Lead development role for a data warehouse.
10+ years of experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
Experience working with complex SQL for ETL development.
Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
Expertise with integration technologies and processes.

Desired Skills:

7+ years of experience in a Lead development role for a data warehouse.
10+ years of experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
Experience working with complex SQL for ETL development.
Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
Expertise with integration technologies and processes.

Job Tags

Similar Jobs

ARAMARK

Hourly Supervisor Chick Fil A Student Union Job at ARAMARK

Aramark is seeking a dedicated and energetic individual to take on the role of Hourly Supervisor at our Chick-fil-A outlet located in the Student Union. This position demands a leader who can inspire exceptional hospitality and operational excellence, maintaining the high...

Movado Restaurant

Bartender Job at Movado Restaurant

.... For more information please click the link to view the job on the National Job Bank. Skills and Abilities Work setting -Restaurant Tasks -Arrange the bar area to make attractive displays -Serve food or snacks -Collect cash, credit/debit cards or other...

Thermo Fisher Scientific

Sr. Product Owner Job at Thermo Fisher Scientific

...Work Schedule Standard (Mon-Fri) Environmental Conditions Office Job Description Senior Product Owner R- Burlington Can ada As part of the Thermo Fisher Scientific team youll discover meaningful work that makes a positive impact on a global scale...

Fayez Spa

Registered Massage Therapist Job at Fayez Spa

Fayez Spa welcomes RMTs and new graduates for full-time, part-time or occasional opportunities. For new graduates, we offer immediate positions after finishing school while waiting to receive your registration number. Employee or contractor positions available. Pay structure...

Hozio

Web Developer Technical SEO Job at Hozio

Job Description: We are seeking a skilled and motivated Technical SEO Specialist to join our growing team. The ideal candidate will be responsible for optimizing websites to achieve higher search engine rankings, drive organic traffic, and improve user engagement. You will...