Teradata Developer - Banking

Unison Group; Singapore; On-site; SGD 100,000 - 150,000; Full time

Job summary

Unison Group is seeking an experienced Teradata Developer with Banking domain experience to develop, enhance, and support enterprise data warehouse solutions for banking applications.

The ideal candidate will have strong hands‑on expertise in Teradata SQL, database development, performance tuning, ETL processes, and banking data, with the ability to work closely with business analysts, data engineers, and technical teams.

Qualifications

• Strong hands-on Teradata development within enterprise data warehouse environments.
• Proficiency in Teradata SQL, complex queries, joins, subqueries, analytical functions, and query optimization.
• Experience developing stored procedures, macros, views, and other Teradata database objects.
• Strong understanding of data warehousing concepts, data modelling, ETL/ELT processes, and data integration.
• Proven experience working on banking or financial services projects.
• Good understanding of banking data domains such as customer accounts, transactions, payments, cards, loans, finance, or regulatory reporting.
• Experience in data reconciliation, data quality validation, debugging, and performance troubleshooting.
• Ability to analyse functional and technical requirements and translate them into effective database solutions.
• Strong analytical, problem-solving, communication, and teamwork skills.

Responsibilities

• Develop, enhance, and maintain Teradata database solutions for banking and financial services applications.
• Write, develop, and optimize complex Teradata SQL queries, stored procedures, macros, and database scripts.
• Design and implement data extraction, transformation, loading, and integration processes.
• Work with high-volume banking data involving customer information, accounts, transactions, payments, cards, and loans.
• Perform query optimization, performance tuning, indexing, and troubleshooting to improve database efficiency.
• Develop and maintain data warehouse tables, views, data models, and other database objects.
• Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Collaborate with business analysts, data architects, ETL developers, and banking stakeholders to understand requirements and deliver technical solutions.
• Support SIT, UAT, production deployment, and post-implementation activities.
• Investigate and resolve data-related defects, performance issues, and production incidents within agreed SLAs.
• Prepare technical documentation, unit test cases, and implementation plans in accordance with project standards.

Skills

Teradata development

Teradata SQL

Query optimization

ETL processes

Data warehousing concepts

Data modelling

Banking data/domain knowledge

Communication

Teamwork

Tools

Informatica

DataStage

Unix/Linux shell scripting

Job description

Job Summary

Unison Group is seeking an experienced Teradata Developer with Banking domain experience to develop, enhance, and support enterprise data warehouse solutions for banking applications. The ideal candidate will have strong hands‑on expertise in Teradata SQL, database development, performance tuning, ETL processes, and banking data, with the ability to work closely with business analysts, data engineers, and technical teams.

Key Responsibilities

• Develop, enhance, and maintain Teradata database solutions for banking and financial services applications.
• Write, develop, and optimize complex Teradata SQL queries, stored procedures, macros, and database scripts.
• Design and implement data extraction, transformation, loading, and integration processes.
• Work with high-volume banking data involving customer information, accounts, transactions, payments, cards, and loans.
• Perform query optimization, performance tuning, indexing, and troubleshooting to improve database efficiency.
• Develop and maintain data warehouse tables, views, data models, and other database objects.
• Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Collaborate with business analysts, data architects, ETL developers, and banking stakeholders to understand requirements and deliver technical solutions.
• Support SIT, UAT, production deployment, and post-implementation activities.
• Investigate and resolve data-related defects, performance issues, and production incidents within agreed SLAs.
• Prepare technical documentation, unit test cases, and implementation plans in accordance with project standards.

Required Skills & Experience

• Strong hands‑on experience in Teradata development within enterprise data warehouse environments.
• Proficiency in Teradata SQL, complex queries, joins, subqueries, analytical functions, and query optimization.
• Experience developing stored procedures, macros, views, and other Teradata database objects.
• Strong understanding of data warehousing concepts, data modelling, ETL/ELT processes, and data integration.
• Proven experience working on banking or financial services projects.
• Good understanding of banking data domains such as customer accounts, transactions, payments, cards, loans, finance, or regulatory reporting.
• Experience in data reconciliation, data quality validation, debugging, and performance troubleshooting.
• Ability to analyse functional and technical requirements and translate them into effective database solutions.
• Strong analytical, problem‑solving, communication, and teamwork skills.

Preferred Skills

• Experience with ETL tools such as Informatica, DataStage, or similar platforms.
• Knowledge of Unix/Linux shell scripting and batch processing.
• Exposure to banking data warehouse, regulatory reporting, risk, AML, or financial data projects.
• Experience in production support, incident management, and root cause analysis.
• Familiarity with Agile delivery, SDLC, SIT, UAT, and release management processes.

Ideal Candidate Profile

A technically strong Teradata Developer with hands‑on banking project experience, capable of developing complex SQL solutions, handling large volumes of banking data, optimizing database performance, and delivering reliable data warehouse solutions in a banking environment.