Application Support Engineer (L2 Support)

LTM; Chennai District, Bengaluru; Hybrid; INR 600,000 - 900,000; Full time

Job summary

LTM is seeking an experienced MSBI, SSIS, and Python Support Engineer in Chennai, India, to provide L2 application support for enterprise data integration and reporting platforms. The role emphasizes monitoring SSIS jobs, Python-based applications, and ETL workflows in production environments.

Ideal candidates will troubleshoot data issues, perform RCA, and implement preventive actions while ensuring SLA commitments and collaborating with business users, L3, and infrastructure teams.

Qualifications

• Hands-on experience with enterprise data integration and reporting platforms.
• Experience in production support and incident management.
• Strong troubleshooting, RCA, and documentation skills.

Responsibilities

• Monitor and troubleshoot SSIS jobs, Python-based applications, and ETL workflows.
• Investigate and resolve data issues and production incidents.
• Perform RCA and implement preventive actions.
• Ensure adherence to SLA commitments.
• Collaborate with business users, L3 teams, and infrastructure teams to support production environments.
• Implement minor enhancements and drive continuous service improvements.
• Support incident, problem, and change management processes.
• Monitor production systems and maintain operational stability.
• Prepare RCA documentation and support reports.

Skills

MSBI Suite

SSIS

SSRS

SQL Server

Query writing

Data analysis

Python Scripting

Production support

Incident, Problem, Change MGMT

RCA & documentation

Control-M

ITIL L2 support

Tools

SSIS

SSRS

SQL Server

Control-M

Job description

We are seeking an experienced MSBI, SSIS, and Python Support Engineer to provide L2 application support for enterprise data integration and reporting platforms.

The role involves:

• Monitoring and troubleshooting SSIS jobs, Python-based applications, and ETL workflows
• Investigating and resolving data issues and production incidents
• Performing Root Cause Analysis (RCA) and implementing preventive actions
• Ensuring adherence to SLA commitments
• Collaborating with business users, L3 teams, and infrastructure teams to support production environments
• Implementing minor enhancements and driving continuous service improvements
• Supporting incident, problem, and change management processes
• Monitoring production systems and maintaining operational stability
• Preparing RCA documentation and support reports

Key Skills Required

• MSBI Suite
• SSIS (SQL Server Integration Services)
• SSRS (SQL Server Reporting Services)
• SQL Server
• Query writing and optimisation
• Data analysis
• Python Scripting
• Production support monitoring and troubleshooting
• Incident, Problem, and Change Management
• Root Cause Analysis (RCA) and documentation
• Knowledge of scheduling tools such as Control-M (preferred)
• Strong understanding of ITIL-based L2 Support processes

Experience Profile

The ideal candidate should have hands-on experience in:

• Enterprise data integration platforms
• Reporting solutions and ETL support
• Production support environments
• Stakeholder communication and issue management
• Service improvement initiatives and operational excellence