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.

Education

bachelor's degree in Computer Science