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 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.
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
Skills & Competencies
Strong knowledge in SQL writing skills.
Familiarity with ETL tools like DataStage, Informatica, Oracle Data Integrator
Data Integration
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.
Buat amaran kerja untuk carian ini
Senior Executive • Kuala Lumpur, Kuala Lumpur, Malaysia