ETL Developer

Role :ETL Developerlocation : Kl /Selangor Job description& Interpret upstream and downstream data flow, do data profiling, data mapping and check data quality from source to target.impact analysis of new systems, new interfaces & integration. Work on impact analysis to reference data (domain/dimension; data elements/properties; base members/data sets; hierarchies) to ensure compliance with Data Governance principles.high-quality solutions by translating business requirements into integration specifications, working with ETL developers to oversee the implementation of ETL designs.to develop ETL architectural and design patterns, considerations, solution options, and impact.develop, and implementation ETL solutions using ODI v12.2.1.4 tool.to analyse, map, transform, and transfer data between varieties of data formats.in writing PL/SQL, stored procedures, views, and optimizing database queriesto conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues.and definition of reporting and analytics business requirements.post-production batch support.unit test, SIT, and provide UAT support.

Hands-on experience on: Oracle Data Integrator (ODI v12.2.1.4)Oracle Big Data Appliance (CDH v6.3.4)Query (Hadoop) – Intermediate / Advance– PL/SQL, SQL-Loaderknowledge in SQL , Unix and python is additional.Familiar with ETL Tool like ODI/NiFi with experience in HadoopExposure in the data warehouse

Ideal to have but not pre-requisite:

AIX basic command & shell scripts(Job scheduler)

Key Skills

• Linux