Full Time Senior System Analyst – Enterprise Data Warehouse (EDW) Jobs, in Lancesoft Malaysia WP Kuala Lumpur - Maukerja

Job Title: Senior System Analyst – Enterprise Data Warehouse (EDW)

Location: Kuala Lumpur

Experience: 6–9 Years

Domain: Data / Enterprise Data Warehouse (EDW)

Job Summary:

We are hiring a Senior System Analyst with strong experience in Enterprise Data Warehouse (EDW), ETL development, and production support within the banking domain. The candidate will be responsible for system analysis, solution design, data integration, and L3 support for enterprise data platforms using Informatica, Teradata, Hadoop, and Oracle technologies.

Key Responsibilities:

• Perform system analysis, requirement gathering, and solution design for EDW projects
• Handle L3 production support, incident management, and root cause analysis
• Design and review data models, data marts, and ETL/data mapping processes
• Manage ETL workflows using Informatica or SAS while ensuring data quality
• Support enterprise data platforms including Teradata, Hadoop, and Oracle
• Collaborate with business and technical stakeholders to translate requirements into technical solutions
• Ensure compliance with SDLC, ITSM/ITSC, and governance standards
• Support automation, optimization, and continuous improvement initiatives
• Mentor junior team members when required

Required Skills:

• 6–9 years of experience in Data Warehousing and System Analysis
• Strong hands-on experience in Informatica or SAS ETL tools
• Experience with Teradata, Hadoop (Hive), or Oracle databases
• Strong SQL, data modeling, and data mapping knowledge
• Banking or financial services domain experience is mandatory
• Familiarity with CI/CD and DevOps tools such as Jira, Jenkins, and Bitbucket
• Experience in Unix/Linux/Windows/AIX environments
• Relevant certifications in ETL, database, analytics, or big data technologies preferred