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.