Senior ETL & Data Integration Architect

GoKardz Technologies; Kuala Lumpur; Vor Ort; MYR 100.000 - 167.000; Vollzeit

Jobbeschreibung

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.