Senior Data Warehouse Analyst & ETL Specialist

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

Job summary

Luxoft Malaysia is seeking an experienced Senior Data & Systems Analyst to support a major bank’s data warehouse initiatives in Kuala Lumpur. You will translate business requirements into technical specs and collaborate with data engineers across Teradata, Oracle SQL, and Big Data tools.

You will lead data integration, quality, and lineage efforts, work with AS400/DB2 environments, and contribute to governance and production support while coordinating with multiple stakeholders.

Qualifications

• 9+ years of experience in System Analysis / ITBA / Data projects.
• Strong experience in Data Warehouse and Data Mart environments.
• Strong knowledge of GDW and data integration.
• Hands-on experience with Teradata and Oracle SQL.
• Experience with AS400/DB2.
• Strong SQL and data analysis skills.
• Experience with Informatica BDM, IDQ and IDL.
• Knowledge of data modelling, data mapping, data quality and reconciliation.
• Experience working with Hadoop/Cloudera, Hive, Impala or Spark.
• Strong understanding of enterprise data flows and source-to-target data integration.
• Experience in requirement gathering, impact analysis, functional specifications and production support.
• Good stakeholder management and communication skills.

Responsibilities

• Analyse business and functional requirements related to GDW, Data Warehouse and Data Marts.
• Perform requirement gathering, impact analysis and translate business requirements into functional/technical specifications.
• Work with data from AS400, Teradata, Oracle, SQL Server and PostgreSQL environments.
• Support data integration and ETL processes using Informatica BDM, IDQ and IDL.
• Work with Teradata technologies including TD Studio, IFX, MDM, FSLDM/GCFR and View Point.
• Analyse and troubleshoot data issues across source systems, data warehouse and downstream data marts.
• Support data quality, validation, reconciliation and data lineage activities.
• Work with Hadoop/Big Data technologies including Cloudera, Spark, HUE, Hive, Impala and Kafka.
• Support BI and reporting solutions using Power BI, Qlik Sense, SAS, Microsoft R and Business Objects.
• Coordinate with business users, developers, data engineers and other technology teams.
• Support production issues, perform root-cause analysis and provide functional/technical solutions.
• Work with JIRA, Jenkins, Bitbucket, SonarQube, Aldon and Control-M as part of development, deployment and support processes.
• Prepare functional specifications, data mappings, impact analysis and technical documentation.
• Provide senior-level guidance and support for data-related initiatives and production issues.

Skills

System Analysis

IT Business Analysis

Data projects

Data Warehouse

Data Mart

SQL proficiency

Tools

Teradata

Oracle SQL

AS/400 DB2

Informatica BDM

Informatica IDQ

Informatica IDL

Hadoop/Cloudera

Hive

Spark

Job description

Luxoft Malaysia is seeking an experienced Senior Data & Systems Analyst to support a major bank’s data warehouse initiatives in Kuala Lumpur. You will translate business requirements into technical specs and collaborate with data engineers across Teradata, Oracle SQL, and Big Data tools.

You will lead data integration, quality, and lineage efforts, work with AS400/DB2 environments, and contribute to governance and production support while coordinating with multiple stakeholders.