Description

You will design, develop, and maintain complex ETL programs and reporting solutions for the Enterprise Data Warehouse.

This role is remote.

Responsibilities

• Design and implement metadata, ETL, and reporting components, including testing and deployment.
• Develop complex Informatica mappings, sessions, and workflows to optimize data movement.
• Translate business processes into BI reporting and analytical solutions.
• Perform root cause analysis and identify BI application performance bottlenecks.
• Produce technical deliverables including design documentation, configuration docs, and unit test plans.

Required Skills

• 6 to 7 years of experience with Power BI, IDMC, BigQuery, and Python.
• Expertise in Informatica (IDMC) design and management.
• Advanced SQL and PL/SQL skills, including indexing and query tuning.
• Experience with Oracle RDBMS 19c.
• Knowledge of Star/Snowflake schema design, dimensional modeling, and slowly changing dimensions.
• Proficiency in the Software Development Lifecycle (SDLC).
• Foundational knowledge of Unix, Linux, or Windows operating systems and version control.
• Bachelor's degree in Computer Science or a related field.

Preferred Skills

• Working knowledge of Informatica PowerExchange or PowerCenter.
• Experience with Tableau and OLAP technologies.

Key Skills

Education

Bachelor's degree in Computer Science