Senior Executive, Data Integration

GoKardz Technologies; Kuala Lumpur; On-site; MYR 100,000 - 167,000; Full time

Job summary

GoKardz Technologies is looking for an experienced ETL Specialist to implement scalable ETL systems and automate batch processing. The role focuses on stability, performance, and reusable job designs within a Data Warehouse context.

The candidate will review requirements, apply best practices, and collaborate with DBAs, developers, and analysts to ensure timely, quality data integration solutions.

Qualifications

• Bachelor’s degree in computer science/IT or equivalent.
• More than 5 years total work experience.
• 2+ years’ experience programming ETL programs using Informatica, Data Stage or ODI.
• 2+ years’ experience performing data analysis and profiling, and designing ETL systems/programs.

Responsibilities

• Review requirements and ensure the data integration platform meets requirements.
• Apply industry best practices for ETL design and development.
• Produce deliverables for technical design, system testing and implementation activities.
• Conduct system testing – execute job flows, investigate defects, document results.
• Tune performance with DBAs and other teams to meet SLAs.
• Develop, document and apply best practices and procedures.

Skills

SQL

Data integration

Independent worker

Education

Bachelor's degree in CS/IT

Tools

DataStage

Informatica

ODI

Job description

Role Purpose

Implement ETL systems that are operationally stable, efficient and automated. This includes technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business.

Monitor and optimize batch jobs, including automation and scheduling. Consistently review and enhance performance with key focus on ease of maintenance & jobs reusability. Work closely with internal/external teams to devise requirements of data integrations, specific to Data Warehouse/Data Marts implementations.

Key Accountabilities and Responsibilities

• Review business and technical requirements and ensure the data integration platform meets requirements.
• Apply industry best practices for ETL design and development.
• Produce written deliverables for technical design, system testing and implementation activities.
• Conduct System Testing – execute job flows, investigate system defects, resolve defects and document results.
• Work with DBAs, application specialists and technical services to tune performance of the system to meet performance standards and SLAs.
• Assist in the development, documentation and application of best practices and procedures.

Skills & Competencies

• Strong knowledge in SQL writing skills.
• Familiarity with ETL tools like DataStage, Informatica, Oracle Data Integrator.
• Understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc.
• Exposure in data warehouse architecture, data analysis/data profiling of source systems.
• Able to function well in a fast-paced and adaptive environment.
• Financial domain experience is a plus.
• Ability to work independently and communicate across multiple levels (Product owners, Executive sponsors, Team members).
• Work experience in Agile methodology is a plus.
• A very good team player & good communication skills.
• Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts.

Requirements

• Minimum Bachelor’s Degree in computer science/Information Technology or equivalent.
• Candidates should have more than 5+ years total work experience, 2+ years’ experience programming ETL programs using Informatica, Data Stage or Oracle Data Integrator (ODI).
• 2+ years’ experience performing data analysis and profiling, and designing ETL systems/programs.