Senior Data Warehouse & ETL Systems Lead

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

Job summary

Luxoft seeks a senior Data & Analytics Consultant to analyse requirements for GDW/Data Warehouse, translate to specs, and coordinate with data engineers across AS400, Teradata and Oracle environments. You will support ETL processes using Informatica tools, across Hadoop ecosystems, and assist BI/reporting solutions.

The role involves delivering functional/technical documentation, ensuring data quality, and guiding production issue resolution within a global technology center in Kuala Lumpur.

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

Data Warehouse

Data Mart

Teradata

Oracle SQL

AS400/DB2

Data Modeling

Informatica BDM

Informatica IDQ

Informatica IDL

JIRA

Jenkins

Bitbucket

SonarQube

Aldon

Control-M

Hadoop

Tools

Teradata TD Studio

Informatica BDM

Informatica IDQ

Informatica IDL

Job description

Luxoft seeks a senior Data & Analytics Consultant to analyse requirements for GDW/Data Warehouse, translate to specs, and coordinate with data engineers across AS400, Teradata and Oracle environments. You will support ETL processes using Informatica tools, across Hadoop ecosystems, and assist BI/reporting solutions.

The role involves delivering functional/technical documentation, ensuring data quality, and guiding production issue resolution within a global technology center in Kuala Lumpur.