Senior Data Systems Analyst - DW, ETL & Big Data

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

Job summary

Luxoft is expanding its Kuala Lumpur technology centre with experienced data analytics consultants. The role focuses on GDW, Data Warehouse and Data Mart initiatives, translating business requirements into technical specs and driving data integration efforts across AS400/DB2, Teradata and Oracle SQL environments.

You will work with Informatica BDM, IDQ and IDL, Hadoop clusters, and BI/reporting tools while collaborating with business users and engineers to resolve production issues and deliver

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

Data analysis

SQL

Data modelling

ETL processes

Big data

Tools

Informatica BDM

IDQ

IDL

Teradata

Oracle SQL

AS400/DB2

Hadoop/Cloudera

Hive

Impala

Spark

Job description

Luxoft is expanding its Kuala Lumpur technology centre with experienced data analytics consultants. The role focuses on GDW, Data Warehouse and Data Mart initiatives, translating business requirements into technical specs and driving data integration efforts across AS400/DB2, Teradata and Oracle SQL environments.

You will work with Informatica BDM, IDQ and IDL, Hadoop clusters, and BI/reporting tools while collaborating with business users and engineers to resolve production issues and deliver