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.