About Position:

-
- Role: Project Lead:
- Location: Chennai:
- Experience: Between 5 to 8 Years:
- Job Type: Full Time Employment

-
- What You'll Do:
- 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, system upgrades, and performance tuning initiatives.

-
- Expertise You'll Bring:
- 5 to 8 years of experience in SQL development, data engineering, or data integration roles.
- Solid expertise in SQL (Oracle / SQL Server / PostgreSQL / MySQL) with hands-on experience in writing complex queries, stored procedures, and performance tuning.
- Experience working with ETL tools like Informatica, SSIS, DataStage, or similar data integration platforms.
- Solid understanding of data warehousing concepts, dimensional modelling (star/snowflake schema), and data transformation techniques.
- Hands-on experience in data migration and legacy system integration.
- Knowledge of data quality checks, validation, and reconci

📌 Project Lead (Chennai)
🏢 Persistent
📍 Chennai