ETL Informatica Developer

VUI SYSTEMS PTE. LTD.; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

VUI SYSTEMS PTE. LTD. in Singapore is seeking a BI ETL Designer with Informatica expertise to design and develop data integration solutions supporting EDW and BI reports.

You will work with BI Analysts to translate business needs into technical specifications, prepare design and ETL mappings, and deploy data models using OBIEE.

The role requires 4+ years of BI experience, SQL on Oracle/Teradata/MS-SQL, and a degree in CS/IT; join a team delivering NHGPBI CR & enhancements.

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.

Responsibilities

• Build strong relationships with BI Analysts to understand business requirements and use cases for data products.
• Translate essential business needs into technical specifications used as reference for data product design.
• Regular use of Informatica to design and develop data models for BI Analysts, Data Scientists and Analysts.
• Prepare Technical design, ETL mapping & UT docs with proper standards.
• Integrate data models on OBIEE to assist BI Analysts to design and develop reports/dashboards.
• Assure end-to-end data product development, including production development and UAT testing.
• Develop working knowledge of available technology capabilities and deployment options.

Skills

ETL design

Data modelling

SQL

Education

Bachelor's/Diploma in CS/IT/Engineering

Tools

Informatica

SAP BODS

OBIEE

Job description

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