Implement ETL systems that are operationally stable, efficient, and automated. This include 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 devise requirements of data integrations, specific to Data Warehouse/Data Marts implementations.
Key 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.
Work with DBAs, application specialists and technical services to tune performance of the ETL system to meet performance standards and SLAs.
Assist in the development, documentation and application of best practices and procedures
Qualifications
Strong knowledge in SQL writing skills.
Familiarity with ETL tools like DataStage, Informatic, 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
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 Informatic, Data Stage or Oracle Data Integrator (ODI)
2+ years' experience performing data analysis and profiling, and designing ETL systems/programs.
Job Type: Permanent
Pay: RM11,500.00 - RM13,000.00 per month
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.