Senior Teradata System Analyst

Oxydata Software Sdn Bhd; Kuala Lumpur; Hybrid; MYR 180,000 - 260,000; Part time

Job summary

Oxydata Software Sdn Bhd invites a Senior Teradata System Analyst to support Financial Regulatory Reporting initiatives, focusing on the Global Data Warehouse and Data Marts. You will collaborate with business stakeholders, data architects, and developers to deliver scalable data solutions.

Must have 9+ years in enterprise data warehouse environments with strong Teradata/AS400 and Informatica experience. Excellent SQL, data modelling, and documentation skills are essential for this role in a

Qualifications

• Diploma or equivalent in related discipline.
• More than 9 years of experience as a System Analyst in enterprise data warehouse or regulatory reporting environments.
• Strong experience supporting GDW and Data Marts.
• Hands-on experience with Cloudera Hadoop Distribution (6.x), Teradata IntelliFlex, AS400, Informatica Data Integration Suite (BDM, IDQ, IDL), Microsoft BI, Qlik Sense, SAS, Microsoft R, Experian PowerCurve.
• Strong database knowledge in AS400 DB2, Teradata, Oracle, MS SQL Server, and PostgreSQL.
• Proficiency with AS400, Teradata (TD Studio, IFX, MDM, FSLDM/GCFR, ViewPoint), Oracle SQL Developer, Spark, Hive, Impala, Kafka, Cloudera DS Workbench, JIRA, Jenkins, Bitbucket, SonarQube, QuerySurge, Power BI, BO, PuTTY, Aldon, and Control-M.
• Strong SQL, data analysis, and data modelling skills.
• Experience in banking/financial services or regulatory reporting environments.
• Excellent analytical, stakeholder management, communication, and documentation skills.
• Informatica Administration (P4 - Expert).
• Nice-to-have: knowledge of regulatory reporting frameworks, data governance, metadata management, data lineage; experience with Agile/Scrum/DevOps; cloud data platforms; large-scale ETL optimization.

Responsibilities

• Analyse, document, and validate business and system requirements for FRR projects.
• Support the design, enhancement, and maintenance of the Global Data Warehouse (GDW) and Data Marts.
• Collaborate with stakeholders, data architects, developers, and project teams to deliver scalable data solutions.
• Perform data analysis, mapping, impact and gap analysis for regulatory reporting.
• Coordinate system integration, UAT, and production implementation activities.
• Ensure data quality, integrity, and consistency across enterprise data platforms.
• Investigate and resolve production incidents with root-cause analysis.
• Prepare functional specs, technical data flow documentation.
• Ensure compliance with enterprise architecture, governance, and regulatory standards.
• Participate in release planning, change management, and continuous improvement.

Skills

Teradata

GDW/Data Marts

SQL

Data modelling

Regulatory reporting

Cloudera Hadoop

Informatica

Power BI

Stakeholder mgmt

Documentation

Education

Diploma or equivalent

Tools

Teradata IntelliFlex

AS400

Informatica Suite (BDM/IDQ/IDL)

Oracle SQL Developer

Spark/Hive/Impala

Kafka

Cloudera Data Science Workbench

JIRA

Jenkins

Bitbucket

SonarQube

Power BI

Bo/PuTTY/Aldon/Control-M

Job description

Location: Kuala Lumpur, Malaysia

Work Mode: Hybrid

Employment type: Contract

Experience Level: Senior (More than 9 years)

Work Eligibility: Applicants must have the legal right to work in Malaysia. Visa sponsorship is not available for this position.

Oxydata Software Sdn Bhd established since 2012, helping regional enterprises drive digital transformation through Agentic AI Services, AI Automation & Integration, Data Engineering, AI Training, and IT Managed Services. We are a lean, high-impact team where engineers work directly on cutting-edge AI products serving enterprise clients across Malaysia and the region.

We are seeking an experienced Senior Teradata System Analyst to support Financial Regulatory Reporting (FRR) initiatives, focusing on the Global Data Warehouse (GDW) and Data Marts.

Responsibilities

• Analyse, document, and validate business and system requirements for Financial Regulatory Reporting (FRR) projects.
• Support the design, enhancement, and maintenance of the Global Data Warehouse (GDW) and Data Marts.
• Collaborate with business stakeholders, data architects, developers, and project teams to deliver scalable and reliable data solutions.
• Perform data analysis, data mapping, impact assessments, and gap analysis for regulatory reporting requirements.
• Coordinate system integration, user acceptance testing (UAT), and production implementation activities.
• Ensure data quality, integrity, and consistency across enterprise data platforms.
• Investigate and resolve production incidents, including root cause analysis and issue resolution.
• Prepare functional specifications, technical documentation, and data flow documentation.
• Work with development teams to ensure compliance with enterprise architecture, governance, and regulatory standards.
• Participate in release planning, change management, and continuous improvement initiatives.

Requirements

Must-have:

• Diploma or equivalent in a related discipline.
• Applicants must have the legal right to work in Malaysia. Visa sponsorship is not available for this position.
• More than 9 years of experience as a System Analyst in enterprise data warehouse or regulatory reporting environments.
• Strong experience supporting Global Data Warehouse (GDW) and Data Marts.
• Hands-on experience with Cloudera Hadoop Distribution (6.x), Teradata IntelliFlex, AS400, Informatica Data Integration Suite (BDM, IDQ, IDL), Microsoft Business Intelligence, Qlik Sense, SAS, Microsoft R, and Experian PowerCurve.
• Strong database knowledge in AS400 DB2, Teradata, Oracle, Microsoft SQL Server, and PostgreSQL.
• Proficiency with AS400, Teradata (TD Studio, IFX, MDM, FSLDM/GCFR, ViewPoint), Oracle SQL Developer, Spark, Hive, Impala, Kafka, Cloudera Data Science Workbench, JIRA, Jenkins, Bitbucket, SonarQube, QuerySurge, Microsoft Power BI, Business Objects, PuTTY, Aldon, and Control-M.
• Strong SQL, data analysis, and data modelling skills.
• Experience working within banking, financial services, or regulatory reporting environments.
• Excellent analytical, stakeholder management, communication, and documentation skills.
• Informatica Administration (P4 - Expert).

Nice-to-have:

• Experience with financial regulatory reporting frameworks and banking compliance requirements.
• Knowledge of enterprise data governance, metadata management, and data lineage.
• Experience with Agile, Scrum, or DevOps delivery methodologies.
• Familiarity with cloud-based data platforms and modern data engineering practices.
• Experience in performance tuning, ETL optimisation, and large-scale data migration projects.

Why Join Us

• Join a dynamic team at the forefront of financial data solutions, working on impactful regulatory reporting projects and cutting-edge data platforms.
• Experience a collaborative environment, exposure to industry-leading technologies, and the opportunity to contribute to critical initiatives within the banking and financial services sector.