Data Engineer

Lavu Tech Solutions Sdn Bhd; Cyberjaya; On-site; MYR 180,000 - 260,000; Full time

Job summary

Lavu Tech Solutions Sdn Bhd in Cyberjaya, Malaysia seeks a Senior Data Engineer to design and implement scalable data store solutions supporting operational and strategic needs. You will build robust ETL pipelines with Talend, optimize Oracle PL/SQL, and ensure data quality across platforms.

You will collaborate with cross-functional teams, document data flows, and participate in CI/CD deployments and performance tuning.

Qualifications

• Minimum 7 years of hands-on experience in Talend ETL development.
• At least 5 years of end-to-end experience designing, building, and implementing data store/data marts/data warehouses.
• Strong proficiency in Oracle PL/SQL development, including performance tuning and optimization.
• Strong knowledge of Oracle performance features such as query optimizer, execution plans, and indexes.
• Experience with Oracle Autonomous Database (ADB) is preferred.
• Solid understanding of data modelling, data governance, and data integration best practices.
• Excellent ETL skills for integration with Oracle and other RDBMS databases.
• Good UNIX shell scripting and scheduling skills.
• Experience in Agile environments with distributed, cross-functional teams.

Responsibilities

• Design, develop, and implement data store solutions to support operational and business needs.
• Build and maintain robust ETL pipelines using Talend and implement automated deployment workflows with CI/CD tools.
• Develop, optimize, and tune Oracle PL/SQL queries, procedures, and packages for high performance.
• Ensure data quality, integrity, and security across all data platforms.
• Monitor, troubleshoot, and resolve data workflow and performance issues proactively.
• Translate business requirements into effective technical solutions across the project lifecycle.
• Prepare and maintain documentation for technical designs, data flows, and procedures.
• Perform thorough testing to guarantee solution reliability and data integrity.
• Collaborate with project managers, business analysts, and cross-functional teams to meet goals.
• Support implementation activities and post-launch operations.
• Conduct system performance tests and implement improvements.
• Work with delivery team to meet specifications, tracking tasks to schedule and quality.
• Take ownership of deliverables and propose process improvements and innovations.
• Mitigate regulatory compliance risks and stay aware of industry trends.

Skills

Talend ETL

Data warehouses

Oracle PL/SQL

Data modelling

Unix shell scripting

Agile environments

Financial services domain

Data governance

Data integration

Communication

Tools

Talend ETL

Oracle Autonomous Database

UNIX shell

Job description

As a Senior Data Engineer, you are responsible for designing, developing, and implementing scalable data store solutions that support both operational and strategic business needs. The role demands strong technical expertise, a proactive mindset, and a commitment to continuous improvement, compliance, and innovation in data engineering practices.

• Design, develop, and implement data store solutions to support operational and business needs.
• Build and maintain robust ETL pipelines using Talend and implement automated deployment workflows for these ETL processes with CI/CD tools.
• Develop, optimize, and tune Oracle PL/SQL queries, procedures, and packages to ensure high performance and reliability.
• Ensure data quality, integrity, and security across all data platforms.
• Monitor, troubleshoot, and resolve data workflow and performance issues proactively.
• Translate business requirements into effective technical solutions, ensuring alignment throughout the project lifecycle.
• Prepare and maintain comprehensive documentation for technical designs, data flows, and operational procedures.
• Perform thorough testing to guarantee solution reliability and data integrity.
• Collaborate with project managers, business analysts, and cross-functional teams to ensure solutions meet business goals and stakeholder expectations.
• Support implementation activities and provide post-launch support to ensure smooth operations.
• Conduct system performance tests and implement improvements as needed.
• Work closely with the delivery team to deliver systems according to specifications, tracking assigned tasks to meet project schedules and quality standards.
• Take ownership of assigned deliverables, proactively identify areas for improvement, and implement solutions. Demonstrate initiative in addressing issues, optimizing processes, and proposing innovations to enhance data engineering practices.
• Takes accountability in considering business and regulatory compliance risks and takes appropriate steps to mitigate the risks.
• Maintains awareness of industry trends on regulatory compliance, emerging threats and technologies in order to understand the risk and better safeguard the company.
• Highlights any potential concerns /risks and proactively shares best risk management practices.

Requirements

We are looking for people who:

• Minimum 7 years of hands-on experience in Talend ETL development.
• At least 5 years of end-to-end experience designing, building, and implementing data store/data marts/data warehouses.
• Strong proficiency in Oracle PL/SQL development, including performance tuning and optimization.
• Strong knowledge of key Oracle performance features such as query optimizer, execution plans, and indexes.
• Experience working with Oracle Autonomous Database (ADB) is preferred.
• Solid understanding of data modelling, data governance, and data integration best practices.
• Excellent technical skills in ETL tools for integration with Oracle and other RDBMS databases.
• Good technical skills in UNIX shell scripting and scheduling.
• Have experience working in Agile environments with distributed, cross-functional teams.
• Ability to evaluate, understand, and implement detailed business, functional, and non-functional technical requirements.
• Experience in the financial services industry is an advantage.
• Excellent problem-solving skills, attention to detail, and the ability to approach challenges from multiple perspectives.
• Strong communication and collaboration abilities.
• Independent team member capable of making sound judgment calls in fast-changing or ambiguous environments.
• High level of integrity, takes accountability of work and good attitude over teamwork.
• Takes initiative to improve current state of things and adaptable to embrace new chang