Description

Lead the design, development, and operational support of complex ETL processes within an Informatica environment to support the Enterprise Data Warehouse and Data Marts.

This role is on-site.

Responsibilities

• Design, develop, and implement complex ETL processes for data integration and warehousing initiatives.
• Manage Informatica environment operations, including automation, job scheduling, monitoring, patches, upgrades, and security.
• Optimize and tune system performance to ensure efficient data processing and integration.
• Analyze and evaluate data sources and targets to ensure accurate mapping and domain definition.
• Mentor junior staff and serve as a subject matter expert on data integration.

Required Skills

• 5-7 years of experience in Informatica ETL development for Data Warehouse and OLAP projects.
• At least 3 years of proven experience with the Informatica PowerCenter Suite.
• 5+ years of experience working in an Oracle PL/SQL environment.
• Expertise in database concepts, including logical and physical design and development.
• Proficiency in dimensional data modeling.
• Experience with Erwin data modeling toolset.
• Bachelor's Degree in Computer Science or equivalent experience.

Preferred Skills

• Experience with Python.

Key Skills

Education

Bachelor's Degree in Computer Science