Lead Data Engineer

Mako IT Lab; Chennai; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Mako IT Lab is seeking a hands-on Data Analyst Lead in Chennai, India. This role focuses on driving ETL and data migration projects, leading small teams of data analysts, ensuring quality and timely delivery, and interacting with clients to clarify data requirements. Candidates should have strong experience in ETL, advanced SQL skills, and the ability to handle large datasets. This position requires attention to detail and strong communication skills in a fast-paced environment.

Qualifications

• Strong experience in ETL and data migration projects.
• Advanced SQL skills.
• Experience handling large datasets.
• Experience in data validation and reconciliation.

Responsibilities

• Perform end-to-end data migration (Extract, Transform, Load).
• Create and manage data mapping documents.
• Validate migrated data against source systems.
• Work directly with clients to understand data requirements.
• Manage timelines for assigned projects.

Skills

ETL and data migration projects

SQL

Handling large datasets

Data validation and reconciliation

Python (for automation)

ETL tools (Informatica, Talend, etc.)

SaaS product migrations

APIs / integrations

Attention to detail

Good communication

Job description

We are looking for a hands-on Data Analyst Lead to drive ETL and data migration projects end-to-end.

This role is execution-focused, responsible for:

• Leading small teams of data analysts
• Ensuring timely and accurate delivery

The candidate should be comfortable working in a fast-paced, client-facing implementation environment.

Key Responsibilities

1. ETL & Data Migration Execution (Core Responsibility)

• Perform end-to-end data migration (Extract, Transform, Load)
• Work on:
  • Data extraction from source systems
  • Data transformation and mapping
  • Data loading into target systems
• Handle large datasets with accuracy and performance in mind

2. Data Mapping & Transformation

• Create and manage:
  • Data mapping documents
  • Transformation logic
• Perform:
  • Data cleansing
  • Deduplication
  • Data normalization
• Validate migrated data against source systems
• Prepare reconciliation reports
• Identify and fix:
  • Data mismatches
  • Missing or inconsistent data
• Guide and support junior data analysts
• Review their work (mapping, validation, outputs)
• Ensure quality and consistency in delivery

5. Client Interaction

• Work directly with clients to:
  • Understand data requirements
  • Clarify mapping and transformation rules
• Data workshops

6. Delivery Ownership

• Manage timelines for assigned projects
• Take ownership of delivery under tight deadlines

Required Skills & Qualifications

Must Have

• Strong experience in ETL and data migration projects
• Advanced SQL skills
• Experience handling large datasets
• Experience in data validation and reconciliation

Good to Have

• Experience with Python (for automation)
• Exposure to ETL tools (Informatica, Talend, etc.)
• Experience in SaaS product migrations (CRM, PSA, ERP)
• Basic understanding of APIs / integrations
• Ability to work under pressure
• Attention to detail and data accuracy
• Good communication with clients and internal teams