Data Analyst

Mako IT Lab Pvt Ltd.; Chennai; On-site; INR 650,000 - 900,000; Full time

Job summary

MAKO IT is seeking a Data Migration Engineer in Chennai to join our team for handling customer data migrations. The role requires 1+ years of Python, SQL, ETL, and API integration experience and will contribute to an AI-powered data migration platform.

The position is full-time and based at the Chennai office with a 2:00 PM – 11:00 PM IST shift. The candidate should possess strong problem-solving abilities, learn AI-driven technologies, and collaborate cross-functionally to ensure accurate data

Qualifications

• 1+ years of Python development and data migration/ETL experience.
• Experience with data extraction, transformation, and loading processes.
• Familiarity with API integrations and data quality checks.
• Knowledge of CSV, Excel, JSON, XML data formats.

Responsibilities

• Develop and maintain Python scripts for data extraction, transformation, loading and validation.
• Handle CSV/Excel/JSON data, databases and REST APIs.
• Perform data mapping, cleansing, transformation and reconciliation.
• Create reusable migration scripts and automation components.
• Identify data mismatches, duplicates and migration failures.
• Manage API authentication, pagination, rate limits and errors.
• Collaborate with Technical Leads on customer data migrations.
• Maintain migration documentation, logs and validation reports.
• Contribute to AI-powered data migration platform development.
• Explore AI-assisted mapping, transformation and validation techniques.

Skills

Python

SQL

Pandas

REST APIs

ETL

CSV/Excel/JSON/XML

Git

Education

BE/B.Tech in CS/IT

Tools

Docker

Cloud technologies

Job description

Job Description – Data Migration Engineer

Company: MAKO IT

Experience: 1+ Years

Location: Chennai (Work from Office)

Shift Timing: 2:00 PM – 11:00 PM IST

Employment Type: Full-Time

About the Role

We are looking for a motivated Data Migration Engineer with 1+ years of experience in Python, SQL, ETL processes, and API integrations.

The candidate will work on customer data migration projects and contribute to the development of our AI-powered Data Migration Platform, designed to automate data extraction, mapping, transformation, validation, and migration processes.

We are seeking someone with strong technical fundamentals, problem-solving abilities, and a willingness to learn and work with AI-driven technologies.

Key Responsibilities

• Develop and maintain Python scripts for data extraction, transformation, loading, and validation.
• Work with CSV, Excel, JSON, databases, and REST APIs.
• Perform data mapping, cleansing, transformation, and reconciliation.
• Develop reusable migration scripts and automation components.
• Identify and resolve data mismatches, duplicates, and migration failures.
• Handle API authentication, pagination, rate limits, and error handling.
• Collaborate with Technical Leads to execute customer data migration projects.
• Maintain technical documentation, migration logs, and validation reports.
• Contribute to the development and improvement of an AI-powered Data Migration Platform.
• Explore AI-assisted data mapping, transformation, data cleansing, and validation techniques.
• Learn and adopt emerging AI tools and automation frameworks to improve migration efficiency.

Required Technical Skills

• Python: Scripting, file processing, exception handling, and automation.
• SQL: Joins, queries, data manipulation, and validation.
• Pandas: Data processing, cleaning, and transformation.
• REST APIs: API integration, JSON handling, and authentication.
• ETL: Understanding of data extraction, transformation, and loading.
• Data Formats: CSV, Excel, JSON, and XML.
• Git: Basic version control knowledge.

Good to Have

• Experience with SaaS application data migration.
• Knowledge of PostgreSQL or MySQL.
• Familiarity with Docker and cloud technologies.
• Basic understanding of AI, LLMs, and prompt engineering.
• Exposure to AI-assisted development tools.
• Interest in intelligent automation and AI-based ETL platforms.

Candidate Expectations

• Strong analytical and problem-solving skills.
• Ability to independently handle assigned migration tasks.
• Good communication and collaboration skills.
• Willingness to learn new tools, technologies, and frameworks.
• Strong interest in learning and working on AI-powered data migration and automation platforms.
• Adaptability to AI-driven development practices.
• Willingness to work from the Chennai office during the 2:00 PM – 11:00 PM IST shift.

Educational Qualification

B.E. / B.Tech in Computer Science, Information Technology, or related disciplines.

Experience: Minimum 1 year of relevant experience in Python development, data migration, ETL, or data engineering.