Productionsupport

Tata Consultancy Services Limited; Singapore; On-site; SGD 78,000 - 117,000; Full time

Job summary

Tata Consultancy Services Limited in Singapore seeks an experienced developer with production support background in Banking/Wealth Management to design, troubleshoot, and optimize data pipelines. You will work with Oracle/SQL Server, ETL tools, and data warehouses, ensuring robust operations and timely incident response.

Proficiency in SQL and PL/SQL, plus experience with Informatica, Talend, SSIS and cloud warehousing (BigQuery) is valued.

Qualifications

• Experience in Banking sector with Application Developer/Production support background within the Wealth Management industry.
• Able to demonstrate team skills with a proven ability to communicate with clients, business, vendors, management and project team at all levels.
• Experience working with relational databases such as Oracle (EXCC) and SQL server.
• Proficiency in SQL for querying, troubleshooting, and performance tuning.
• Able to understand and debug Oracle procedures, function and triggers.
• Familiarity with ETL tools (e.g., Informatica, Talend, SSIS) and data pipeline management.
• Understanding of data warehouse concepts, star/snowflake schemas, and dimensional modelling.
• Experience with cloud-based data warehouses (Google BigQuery) is a plus.
• Unix file systems, commands, shell ing development and trouble shooting
• Windows systems, batch ing development and trouble shooting
• Oracle PL/SQL queries development and trouble shooting
• Managing / monitoring Control-M and Tivoli/Geneos monitoring tools
• Job Automation tool like Control-M
• Incident ticketing tool - Service Now
• Extensive Experience in banking and Finance domains preferred Private banking.

Skills

Client communication

Team collaboration

SQL

Oracle PL/SQL

SQL Server

Unix shell scripting

Windows batch scripting

Tools

Oracle

SQL

Informatica

Talend

SSIS

Google BigQuery

Control-M

Tivoli

Geneos

ServiceNow

Job description

• Experience in Banking sector with Application Developer/Production support background within the Wealth Management industry
• Able to demonstrate team skills with a proven ability to communicate with clients, business, vendors, management and project team at all levels.
• Experience working with relational databases such as Oracle (EXCC) and SQL server
• Proficiency in SQL for querying, troubleshooting, and performance tuning.
• Able to understand and debug Oracle procedures, function and triggers.
• Familiarity with ETL tools (e.g., Informatica, Talend, SSIS) and data pipeline management.
• Understanding of data warehouse concepts, star/snowflake schemas, and dimensional modelling.
• Experience with cloud-based data warehouses (Google BigQuery) is a plus.
• Unix file systems, commands, shell ing development and trouble shooting
• Windows systems, batch ing development and trouble shooting
• Oracle PL/SQL queries development and trouble shooting
• Managing / monitoring Control-M and Tivoli/Geneos monitoring tools
• Job Automation tool like Control-M
• Incident ticketing tool - Service Now
• Extensive Experience in banking and Finance domains preferred Private banking.