Senior Developer
Malaysia
Apply now
Job Description
Senior Developer
Kuala Lumpur, Federal Territory of Kuala Lumpur

Job Summary

We are seeking an experienced Informatica System Analyst to support enterprise data warehousing initiatives within the banking domain. The role involves system analysis, solution design, ETL development, and L3 production support across complex data platforms including Informatica, Teradata, Hadoop, and Oracle. The ideal candidate will act as a bridge between business stakeholders and technical teams, translating business requirements into scalable, high-quality data solutions while ensuring data integrity and adherence to governance standards.

 

Key Responsibilities

System Analysis & Solution Design — Perform end-to-end system analysis, solution design, and implementation for Enterprise Data Warehouse (EDW) projects. Gather and translate business requirements into functional specifications and technical designs.ETL Development & Optimization — Design, develop, and implement ETL processes using Informatica PowerCenter / IICS. Ensure accurate extraction, transformation, and loading of data from various source systems into target databases. Optimize ETL processes for performance and data quality.L3 Production Support — Provide L3 support including incident management, root cause analysis (RCA), and performance tuning of data pipelines. Monitor and troubleshoot production issues related to ETL jobs and data integration failures.Data Modeling & Mapping — Design and review data models, data marts, data flows, and data mappings aligned with business requirements. Work on OLTP and OLAP processes to ensure efficient data retrieval and reporting.Data Platform Management — Support and manage data platforms including Teradata, Hadoop (Hive), and Oracle (at least one). Ensure data consistency, accuracy, and integrity across data lake and warehouse environments.Governance & Compliance — Ensure adherence to SDLC, ITSM/ITSC, and data governance standards. Maintain comprehensive documentation for ETL processes, data mappings, transformations, and technical designs.Automation & CI/CD — Drive automation and continuous improvement initiatives. Work with CI/CD tools (Jira, Jenkins, Bitbucket) for deployment and release management.Stakeholder Collaboration — Collaborate with business analysts, data architects, data scientists, and cross-functional teams to deliver high-quality data solutions. Participate in Agile sprint planning, estimation, and retrospectives.Mentoring — Mentor and guide junior team members on best practices in ETL development, data integration, and system analysis.

Skill Requirements

# Skill Description
1 Informatica (Certified) Informatica Certification is mandatory. Strong hands-on experience with Informatica PowerCenter / IICS (Data Integration, CDI, CAI, CDQ).
2 Teradata OR Hadoop (Hive) & Oracle Hands-on experience in at least one: Teradata (TD) or Hadoop (HD/Hive) & Oracle. Any one is mandatory.
3 SQL & PL/SQL Strong proficiency in SQL and PL/SQL for data manipulation, querying, stored procedures, and performance tuning.
4 Data Warehousing Concepts Strong knowledge of data modeling, data marts, star/snowflake schema, SCD Type-1 & Type-2, and ETL best practices.
5 Banking / Financial Domain Prior experience in the banking or financial services domain is mandatory.
6 SDLC & Release Management Understanding of SDLC, release management, IT support processes, and governance standards.

 

Other Requirements

null
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.