AS400 & Informatica ETL Developer

Luxoft Malaysia; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Luxoft Malaysia is seeking consultants for a newly setup technology centre in Kuala Lumpur to support a leading bank in Asia. The role covers ETL development and data warehousing to deliver innovative financial technology solutions.

You will design and build ETL workflows with Informatica, optimize SQL queries in Oracle/SQL Server, perform data validation, and participate in SIT/UAT testing and deployment with production support duties.

Qualifications

• 3-5 years of experience in ETL / Data Warehouse development
• Strong hands-on experience in Informatica ETL
• Good experience with Oracle and/or SQL Server databases
• Strong SQL skills for data extraction and transformation
• Experience in Shell scripting
• Working knowledge of Operating Systems: AS400, Linux, and Windows environments
• Understanding of data warehouse concepts (ETL, data modelling, data flows)

Responsibilities

• ETL Development: design, develop, and maintain ETL workflows using Informatica
• Data Warehouse Support: work on Global Data Warehouse (GDW) systems and ensure data integrity
• Performance Optimization: optimize ETL jobs for performance and troubleshoot bottlenecks
• Testing & Deployment: participate in SIT/UAT cycles and support deployment
• Production Support: provide L2 support for ETL and data warehouse issues
• Cross-functional collaboration to resolve issues

Skills

ETL Development

Informatica ETL

Oracle/SQL Server databases

SQL

Shell scripting

OS: AS400/Linux/Windows

Data warehousing concepts

Tools

Informatica

Oracle

SQL Server

Job description

Luxoft Malaysia is seeking consultants for a newly setup technology centre in Kuala Lumpur to support a leading bank in Asia. The role covers ETL development and data warehousing to deliver innovative financial technology solutions.

You will design and build ETL workflows with Informatica, optimize SQL queries in Oracle/SQL Server, perform data validation, and participate in SIT/UAT testing and deployment with production support duties.