Lead Senior ETL Developer & Application

Developers/Programmers (Information & Communication Technology) Full time Responsibilities:

• Provide mentorship and guidance to a team of ETL developers, fostering professional growth and skill development.
• Assign tasks and projects to team members, ensuring on-time delivery with the highest standards of quality.
• Conduct thorough code reviews to ensure adherence to design principles, standardization, and industry best practices.
• Educate and train team members on new data technologies, ETL best practices, and application support methodologies, promoting a culture of continuous learning and improvement.

ETL Design and Development:

• Lead the design, development, and optimization of ETL processes to extract, transform, and load data from diverse data sources into target data stores.
• Collaborate with business analysts to understand data requirements, ensuring ETL solutions are aligned with business needs.
• Execute comprehensive testing across all stages of the ETL process from data extraction to loading, ensuring that final data in the target system is accurate, reliable, and ready for use.
• Implement and enforce ETL development best practices, including robust error handling, detailed logging, and performance tuning to ensure high-quality outcomes.
• Review and prepare documentation required for deployment, present it to the Change Management Committee to secure necessary approvals.

Application Support and Maintenance:

• Work closely with the application support team, ensuring that all applications run smoothly, and any issues are resolved, as well as SLAs are met.
• Assist in the investigation, diagnosis, and resolution of application-related issues, minimizing downtime and disruption to daily BAU operations.
• Coordinate regular maintenance activities, such as patches, upgrades, and backups, ensuring that applications are up-to-date and secure.

Collaboration and Stakeholder Management:

• Collaborate closely with cross-functional teams, including support teams, data architects, business analysts, and other stakeholders to ensure seamless alignment of ETL processes and application support initiatives.
• Regularly communicate progress updates to stakeholders regarding ETL development, deployment, and application support activities.
• Deliver high-level estimates (HLE) on the efforts required for new ETL process demands.

Technology Assessment and Continuous Improvement:

• Perform regular assessments of server and application performance and utilization to identify opportunities for optimization and ensure adherence to established policies and procedures related to technology and data security.
• Analyze server utilization both before and after deployments and upgrades to evaluate their impact on existing Service Level Agreements (SLAs).
• Develop and implement remediation plans based on findings from Vulnerability Assessment and Penetration Testing (VAPT).
• Engage in the Proof of Concept (PoC) projects to evaluate the effectiveness and suitability of new data technologies.

Qualifications:

• 5-7 years of experience in ETL development and application support, with at least 3 years in a lead or supervisory role.
• Strong proficiency in ETL tools (e.g. Informatica) and data integration technologies.
• Experience in RDBMS (e.g. PostgreSQL, SQL Server, DB2, Oracle), data warehousing concepts (e.g. LDM, PDM), and data ingestion framework.
• Experience in Big Data & Analytics technologies and tools (such as Starburst Galaxy Data Lakehouse, Trino, Iceberg, Kafka, Spark, etc).
• Experience in UNIX environment and Unix scripting.
• Knowledge of data modeling, master data management, and data quality principles.
• Experience in Informatica products, especially Informatica MDM, DEI/DQ, AXON & EDC.
• Extensive experience in IT system review, design, development, implementation and user support principles and practices.
• Experience working in a collaborative multi-disciplinary and matrixed environment.

Required Competencies and Skills:

• Familiar with various project management tools (e.g. Microsoft Project).
• Possess analytical and strategic skills with a track record of success in delivering results within a large complex organization.
• Must have strong leadership and people management skills; ability to influence, organizational ability and time management.
• Embody the organization culture and align with the organization vision and mission.
• Excellent interpersonal, written and communication skills.
• Highly result-oriented and able to work independently.
• Demonstrates ability to build relationships and work well with peers from both business and technology stakeholders and interact effectively with internal and external parties.
• Ability to plan and prioritize work/projects in the team.
• Display good leadership qualities, high commitment and drive to complete the assignment.

Your application will include the following questions:

• What's your expected monthly basic salary?
• Which of the following types of qualifications do you have?
• How many years' experience do you have as an Extract Transform Load Developer?
• How many years' experience do you have as a manager/team lead?
• Which of the following Relational Database Management Systems (RDBMS) are you experienced with?

Company Overview: CIMB Group is one of ASEAN’s leading universal banking groups and is Malaysia’s second largest financial services provider, by assets. It offers consumer banking, commercial banking, investment banking, Islamic banking and asset management products and services. Headquartered in Kuala Lumpur, the Group is present in all 10 ASEAN nations (Malaysia, Indonesia, Singapore, Thailand, Cambodia, Brunei, Vietnam, Myanmar, Laos, and Philippines). Beyond ASEAN, the Group has a market presence in China, Hong Kong, India, Sri Lanka, Korea, the US, and UK. For more information, please visit . #J-18808-Ljbffr