Connecting...

Senior ETL Developer

Job Title: Senior ETL Developer
Contract Type: Permanent
Location: Kuala Lumpur
Industry:
Salary: RM Attractive
Reference: A002325 (AVQH-801433)
Contact Name: Chandra Surya Govindarajoo
Contact Email: chandrasurya.govindarajoo@ellwoodconsulting.com.my
Job Published: April 11, 2019 11:16

Job Description

About our client

A multi-national organization producing on-demand software for SCM industry across the globe, is expanding their IT team.

 

About the role

Hiring a talented database ETL developer to join a growing global data operations team.  As a Data Center Operations team member, you will be joining a collaborative team responsible for delivery and support of mission critical EDI infrastructure used by major global brands. 

 

Your responsibilities

  • Analysis, design and build ODS, Data Warehouse, Data Mart & Data Lake in association with the Business Intelligence (BI) semantic layers to drive and optimize business analytics and reporting.

  • Develop new ETL flows for On-Premise to On-Premise, On-Premise to Cloud and/or from Cloud to Cloud.

  • Enhance and maintain existing ETL application function and performance.

  • Lead efforts to understand content & patterns, as well as investigate data issues; quality, lineage or decision-making business questions.

  • Collaboration with other teams to optimize fault tolerant features to ensure High Availability.

  • Develop, maintain, and document code for Application Deployment and Administration.

  • Work within Agile methodology to build and deploy new functionality.

  • Work within ITIL framework for change, incident & problem management processes.

 

You will have

Prior Experience

  • At least 5+ years’ of Data Warehouse & Information Management experience.

  • At least 3+ years’ experience with Oracle or Postgres databases.

  • At least 2+ years’ experience with PL/SQL Development.

  • At least 2 years’ experience with RedShift, Python.

  • At least 2 years’ experience with Oracle Data Integrator.

 

Skills & Qualities

  • Proficient in Data Integration/Modeling, Reporting/Analytics and Business Intelligence tools.

  • Solid understanding of ETL concepts and Data Mart skills are required.

  • Proficient with Python and/or Java.

  • Working knowledge of ETL, Data and Application Integration tools and technologies.

  • Proficient in SQL, PL/SQL and T-SQL and optimization and monitoring.

  • Proficient in Oracle Data Integrator (ODI).

  • Proficient with *NIX shell and batch scripting and processing.

  • Familiarity with AWS products; RedShift, RDS, Lambda, Data Pipe.

  • Familiarity with Dell Boomi a plus.

  • Experience with columnar databases.

 

Education & Professional Qualifications

  • B.S. Computer Science/Engineering or equivalent computer-related education.