Application Support Lead(ETL)

LTM; Pune District; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

LTM is seeking a detail-oriented database and backend specialist in Pune to support production releases, incident management and root cause analysis. You will coordinate with offshore and onshore teams to drive project deliveries while ensuring coding standards, security and best practices are followed.

You will apply expert knowledge of Oracle, SQL Server and PostgreSQL, with strong Python development, scripting, data integration, and batch scheduling to build robust data-centric solutions in a

Qualifications

• Strong hands-on experience with Oracle Database, SQL Server, PostgreSQL.
• Experience with SQL query writing and performance optimization.
• Proficiency in stored procedures, functions, triggers, and indexing for high-volume systems.
• Expertise in database design, data modelling and data integration concepts.
• Strong Python development experience with scripting and automation.
• Experience with APIs, data processing frameworks, and batch scheduling.
• Linux/Unix administration and shell scripting.
• Experience leading teams and mentoring developers in Agile/Scrum environments.

Responsibilities

• Support production releases, incident management and root cause analysis.
• Coordinate with offshore/onshore teams and drive project deliveries.
• Ensure adherence to coding standards, security and best practices.

Skills

SQL Query Writing

Stored Procedures

Functions

Triggers

Indexing

Performance Tuning

Database Design

Data Modelling

Programming

Python development

Scripting automation

APIs and data integration

Perl scripting

Linux/Unix administration

Shell scripting

Batch scheduling

Code reviews

Leadership

Stakeholder management

Agile/Scrum

Analytical problem solving

Tools

Oracle Database

Microsoft SQL Server

PostgreSQL

Job description

Role & responsibilities

• Support production releases incident management and root cause analysis.
• Coordinate with offshore onshore teams and drive project deliveries
• Ensure adherence to coding standards security and best practices

Preferred candidate profile:

• Strong handson experience with
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• Expertise in
• SQL Query Writing Optimization
• Stored Procedures
• Functions
• Triggers
• Indexing Performance Tuning
• Database Design Data Modelling
• Programming
• Strong Python development experience
• Experience with scripting automation and data processing frameworks
• Good understanding of APIs and data integration concepts
• Scripting Operating Systems
• Working knowledge of PERL scripting
• Strong Linux Unix administration and shell scripting knowledge
• Experience in batch scheduling and job monitoring
• Domain Expertise Preferred
• Asset Management
• Capital Markets
• Investment Management
• Order Management Systems OMS
• Portfolio Management Systems PMS
• Trade Lifecycle
• Securities Equities Fixed Income Mutual Funds
• Leadership Soft Skills
• Experience leading teams of 510 members
• Strong stakeholder management and client communication skills
• Ability to perform code reviews and mentor junior developers
• Experience in AgileScrum delivery models
• Strong analytical and problemsolving skills