ETL Developer
Important Information
Location: Kuala Lumpur Malaysia
Experience: 9-10 years
Job Mode: Contract
Work Mode: On-Site
Job Summary
ETL (Extract, Transform, Load) Developer to design, build, and maintain robust data pipelines and data integration solutions. Hands-on experience working with ETL tools, databases, and scripting to support business intelligence, data warehousing, and analytics initiatives.
Responsibilities & Duties
- Perform requirement gathering and analysis with business stakeholders
- Perform hands-on ETL solution design, development, test execution and production deployment.
- Provide BAU support for existing and new data platforms
- Collect multiple streams of data and decompose them into concise specifications.
- Ensure that final product meets requirement specifications.
- Follow company and industry defined best practices to ensure smooth and continuous product development operations.
- Develop process improvements that ensure product quality and productivity.
- Communicate product efficiency or enhancement ideas and concepts to Manager.
- Analyse and troubleshoot product issues in a timely fashion.
- Understand and evaluate existing SQL
- Design and develop queries for a high-performance environment.
- Design, develop and implement complete solutions throughout the product life cycles.
- Maintain and manage revisions of code in production, testing and development environments.
- Contribute to the specification and software design phases of the software development life cycle and performing and aiding in quality assurance testing, performance testing, troubleshooting application and environment issues, and production support.
- Accountable to development and delivery of solutions that meets and exceeds quality standards
- Deliver multiple projects on-time, on-budget and with targeted zero defects
- Provide support for Quality Assurance testing
- Provide estimation and coordination of technical activities related to system development
- Ensure solutions alignment to Enterprise Architecture policies and best practices; ensure that process methodologies are followed in system development
- Create technical documentation including the Technical Design document
- Manage day to day technical challenges and communicate to project manager any risks or issues associated with the development activities
- Identify opportunities for system reuse and system simplification
- Collaborate with IT partners to devise capacity plan and ensure appropriate infrastructure for the end to end system delivery
- Production support required on rotation basis.
Qualifications & Skills
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
- 9 years+ of experience in ETL development or data engineering roles.
- Proficiency in SQL and experience with large-scale data processing.
- Experience with one or more ETL tools (e.g., Informatica, Talend, SSIS, Pentaho, Apache NiFi, dbt).
- Familiarity with scripting languages such as Python, Shell, or Bash.
About Encora
Encora is the preferred digital engineering and modernization partner of some of the world’s leading enterprises and digital native companies. With over 9,000 experts in 47+ offices and innovation labs worldwide, Encora’s technology practices include Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering.
At Encora, we hire professionals based solely on their skills and qualifications, and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.