Job Description:
ETL (Informatica), OBIEE Designer.
To Perform ETL (Informatica),OBIEE Design & Development and data modelling capabilities to support EDW to deliver NHGPBI CR & Enhancements.
Role and Responsibilities:
Communication:
- Build strong relationships with Business Intelligence Analysts to understand business requirements and use cases for data products.
- Identify issues, gather information from various sources, and translate essential business needs into technical specification that are used as reference for data product design.
Functional & Technical Expertise:
- Regular use of leveraging common data management tools, such as Informatica to design and develop the data models for use by Business Intelligence Analysts, Data Scientists and Analysts to speed up the development of data products.
- Prepare Technical design, ETL mapping & UT docs with proper standards.
- Integrate the data models on common BI tools, such as OBIEE to assist the Business Intelligence Analysts to design and develop business reports and/or dashboards.
- Possess superior organization skills to be able to assist in end-to-end data product development with production development, conducting system integration/user acceptance testing.
- Develop good working knowledge of available technology capabilities and how and where to deploy them
Requirements / Qualifications:
- Degree/Diploma in Computer Science/ Engineering, Information Technology/ System or equivalent.
- Minimum 4 years of experience in design, develop, deploy and maintenance of BI solutions
- Equipped with key SQL Skillsets on Oracle, Teradata and MS-SQL Server databases
Skills Required
ETL tools such as Informatica (Primary), SAP BODS
o Data visualization tools such as OBIEE
o Data modelling