About Position:

We are looking for a Senior Engineering Lead with strong expertise in SQL, Data Integration, Legacy System Modernization, and Product Engineering to drive enterprise data transformation initiatives. The ideal candidate will be responsible for designing and optimizing data integration solutions, modernizing legacy platforms, building scalable ETL/ELT pipelines, and ensuring high-quality, secure, and reliable data delivery. This role requires robust technical leadership, problem-solving skills, and the ability to collaborate with cross-functional teams to support business-critical applications and analytics platforms.

Role: Senior Engineering Lead
Location: Chennai
Experience: Between 4 to 8 Years
Job Type: Full Time Employment

What You'll Do:

Design, develop, and maintain complex SQL queries, stored procedures, functions, and views for enterprise applications.
Build and manage ETL/ELT pipelines using tools like Informatica, SSIS, DataStage, or Azure Data Factory for structured and semi-structured data.
Perform data extraction, transformation,



and loading from multiple legacy systems (mainframe, flat files, ERP/CRM systems) into modern data platforms.
Develop and optimize data models (OLTP/OLAP), ensuring efficient query performance and scalability.
Implement incremental data loads, CDC (Change Data Capture), and batch processing frameworks.
Work on legacy system modernization, migration, and integration into cloud or modern data platforms.
Design and implement data validation, reconciliation, and quality frameworks across pipelines.
Ensure data governance, audit logging, traceability, and compliance for enterprise data workflows.
Collaborate with reporting/BI teams to enable data availability for dashboards and analytics.
Optimize SQL performance using indexing, partitioning, query tuning, and execution plan analysis.
Prepare technical documentation, data flow diagrams, and integration design specifications.
Participate in architecture discussions

📌 SQL Developer (Pune)
🏢 Persistent Systems
📍 Pune