Job Summary

The key purpose is to involve in design, development, testing and implementation of reconciliation projects. Additional responsibilities include involvement in development of Python related activities, automation, develop tools using TLM product.

Key Responsibilities

• Incident Management: Restore services, troubleshoot system errors, and identify root cause
• Conducting Post-Incident Reviews (PIRs) to document findings and prevent recurrence.
• Design, develop, and maintain ETL workflows to load, transform and reconcile data for TLM.
• Develop Python scripts and components for data processing, automation, and integration with TLM.
• Write and optimize Oracle SQL (views, functions, procedures, packages) to support TLM interfaces and reporting.
• Develop and maintain Unix shell scripts for job scheduling, file handling, and batch processing.
• Participate in the end-to-end TLM implementation lifecycle: requirements analysis, solution design, development, unit testing, and deployment.
• Work closely with business, operations,



and BA teams to understand reconciliation rules, matching logic, and exception handling.
• Troubleshoot and resolve production issues related to ETL jobs, data quality, and TLM processing.
• Contribute to performance tuning across ETL processes, database queries, and scripts.
• Prepare and maintain technical design documents, data flow diagrams, and job run books.
• Create and update test cases, perform unit/system integration testing, and support UAT.
• Collaborate with infrastructure/DevOps teams for deployment, monitoring, and job scheduling.
• Ensure adherence to bank standards, security, compliance, and audit requirements.

Key Expertise

• TLM Product Knowledge
• Hands-on experience with ETL development (Informatica(Preferable), DataStage, or similar enterprise ETL tools).
• Python programming (data processing, automation, scripting)
• Oracle Database (SQL, PL/SQL, stored procedures, performance tuning)
• Shell Scripting (Uni

📌 Snr Manager, SRE (Chennai)
🏢 Standard Chartered India
📍 Chennai