Teradata Developer - Banking

Hong Kong Unison Limited; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Unison Group seeks an experienced Teradata Developer with Banking domain experience to develop, enhance, and support enterprise data warehouse solutions for banking applications. The candidate will work closely with business analysts, data engineers, and technical teams to deliver robust data solutions.

Key responsibilities include developing Teradata database solutions, writing optimized SQL, and designing ETL/ELT processes for high-volume banking data.

Qualifications

• Hands-on Teradata development experience in enterprise data warehouse environments.
• Proficient in Teradata SQL, including complex queries and optimization.
• Experience with banking data domains and data integration.

Responsibilities

• Develop, enhance, and maintain Teradata database solutions for banking applications.
• Write and optimize Teradata SQL queries, stored procedures, macros, and scripts.
• Design and implement ETL/ELT processes and data pipelines.

Skills

Teradata dev

Teradata SQL

Data warehousing

ETL/ELT

Banking data

Performance tuning

Stored procedures

Data modeling

Analytical thinking

Job description

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.

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.

Unison Consulting established in the year 2012 in Singapore. We provide technology consulting, systems implementation, and integrations service to Asia Pacific customers. We help transform enterprise data in actionable insights. Our consultants have wide range of functional expertise within Banking and Financial services spectrum, working closely with clients to anticipate, illuminate and overcome complex business challenges.

Our objective is to be a one-stop solution provider all enterprise business intelligence and data warehousing needs of organizations.

Our mission is to consistently deliver our services to our clients in a cost-effective way without compromising the quality.

Our current clients include - DBS, OCBC, Standard Chartered Bank and Maybank.