Senior Informatica ETL Designer

Role Title: Senior Informatica ETL Designer

Location:  Michigan

Duration:   Long-term 5-8 years

Type:  Perm W2 with benefits and PTO

 

 

Purpose of Role/Organizational Unit:

 

This is a very senior position that requires 7+ years of ETL development. Thiso rganizational unit is responsible for managing the operational services delivery of the various elements of the Data Infrastructure, including Informatica ETL Jobs.  In this capacity,this Senior Informatica ETL Developer role is responsible for implementing and support of Informatica Tools(PowerCenter, PowerExchange(CDC), Data Quality and Data Services). Informatica Change Data Capture Tool knowledge is a must.

 

Functions Performed:

Thefollowing functions are the responsibility of the Senior Informatica ETL Designer within data management team. This individual will be responsible to architect, design and develop ETL solutions, perform code reviews, enhancestandards, performance tuning, code migrations from dev to QA and production. 

Position Responsibilities:

  • Has expertise in various Informatica suite of products: PowerCenter, PowerExhange(CDC), Data Quality and Data Services.
  • Experience in CDC to make Data Warehouse Near-Real Time is required.
  • Expertise on ETL performance tuning
  • Design responsibility for Operational and Data Warehouse ETLs
  • Oracle and SQL knowledge is must
  • Experiences with various tools such as Informatica Data Quality and Profiler Tools, Informatica Data Services, Web Services(Real time Edition) are important.

Skills Required:

  • Minimum of 7 years in Informatica tools and with focus in performance tuning
  • Experience with Informatica PowerCenter, PowerExchange (CDC), Informatica Data Quality (IDQ)¸ Informatica Data Services (IDS)
  • Creation of complex parallel loads and dependency creation using work flows
  • Data modeling and data mapping design experience
  • Experience in PL/SQL and conversion of PL/SQL into Informatica

Unique Competencies: 

  • Required – 7+ years experience in Informatica PowerCenter, Informatica PowerExchange (CDC), Informatica Data Quality (IDQ), Informatica Data Services  v8.6 or higher tools architecture and design

Educational Requirements: 

  • Bachelors Degree in Computer Science, Information Systems, or equivalent

To learn more or apply:

Send an email to recruiter1@advancedba.com.