Senior Developer
Software Engineering
Posted on Jun 11, 2026
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
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.
