Senior Data Warehouse & Systems Analyst

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

Job summary

Luxoft is seeking a senior Data Consultant to join its Kuala Lumpur technology centre. You will analyse GDW/Data Warehouse requirements, translate them into technical specs and work with diverse data sources including Teradata, Oracle and AS400/DB2.

You will support ETL using Informatica BDM/IDQ/IDL and engage with Hadoop ecosystems to enable reporting and governance across BI tools. The role requires 9+ years in data projects, strong stakeholder communication, and experience across data

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

Stakeholder management

Communication skills

Data analysis

Problem solving

Tools

Informatica BDM

Informatica IDQ

Informatica IDL

Teradata

Oracle SQL

AS400/DB2

Hadoop/Cloudera

Hive

Spark

Job description

Luxoft is seeking a senior Data Consultant to join its Kuala Lumpur technology centre. You will analyse GDW/Data Warehouse requirements, translate them into technical specs and work with diverse data sources including Teradata, Oracle and AS400/DB2.

You will support ETL using Informatica BDM/IDQ/IDL and engage with Hadoop ecosystems to enable reporting and governance across BI tools. The role requires 9+ years in data projects, strong stakeholder communication, and experience across data