Description

You will design, develop, and implement complex ETL processes to support the Enterprise Data Warehouse, Data Marts, and Business Intelligence projects.

Responsibilities

• Manage and administer the Informatica environment, including automation, job scheduling, monitoring, patches, upgrades, and security.
• Optimize and tune system performance within the Informatica environment.
• Analyze and evaluate data sources and targets to design complex ETL mappings and mapplets.
• Act as a Subject Matter Expert to mentor junior staff and provide technical guidance on business processes.
• Ensure project deliverables meet organizational standards, policies, and best practices.

Required Skills

• 5-7 years of experience in Informatica ETL development for Data Warehouse, Enterprise Data Warehouse, and OLAP projects.
• 3+ years of proven experience in design and development using the Informatica PowerCenter Suite.
• 5+ years of hands-on experience in an Oracle PL/SQL environment.
• Expertise in database concepts, including logical and physical design and development.
• Proficiency with dimensional data modeling.
• Experience using Erwin data modeling tools.
• Strong understanding of the full project life cycle and requirement documentation.
• Bachelor's Degree in Computer Science or equivalent practical experience.

Preferred Skills

• Experience with Python.

Key Skills

Education

Bachelor's Degree in Computer Science