Description

You will design, develop, and implement metadata, ETL, and reporting components to support cross-functional data analysis.

Responsibilities

• Design and develop complex Informatica mappings, sessions, and workflows using Designer components and Workflow Manager.
• Build and maintain BI reporting solutions, including OBIEE RPD and BIP reporting data models.
• Translate business processes into actionable BI reporting and analysis solutions.
• Identify and tune BI application performance bottlenecks and query execution.
• Produce technical deliverables including design documentation, configuration guides, and unit test plans.

Required Skills

• 10+ years of experience with Power BI, OBIEE, Informatica, and Snowflake.
• Expertise in Advanced SQL and PL/SQL, including indexing and query tuning.
• Strong hands-on experience with Informatica Designer components and workflow management.
• Proficiency with Oracle RDBMS 12g.
• Deep understanding of Data Warehousing, Star/Snowflake schema design, and Dimensional Modeling.
• Experience with Big Data Lake and Hadoop implementations.
• Bachelor's degree in Computer Science or a related field.

Preferred Skills

• Experience with Informatica PowerExchange.
• Exposure to Tableau and BigQuery.

Key Skills

Education

bachelor's degree in Computer Science