Senior Software Engineer

Tech Mahindra; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Tech Mahindra is seeking an ETL Developer to design, build, and manage data pipelines for extraction, transformation, and loading of data. You will ensure that the data is clean and easily accessible for analytics.

This role involves collecting raw data, validating and standardizing it, and loading it into warehouses. The successful candidate will work collaboratively with various teams and optimize performance of ETL processes.

Responsibilities

• Collect raw data from various sources such as databases, applications, ERP/CRM systems, and external platforms.
• Clean, validate, and standardize data.
• Load transformed data into data warehouses, data lakes, or other storage systems to support reporting and analytics.
• Design and implement automated workflows for data movement and transformation.
• Monitor and validate data to maintain accuracy, consistency, and integrity.
• Tune ETL processes to efficiently handle large-scale data.
• Work closely with data architects, analysts, and BI teams.

Job description

ETL Developer Role Overview

An ETL (Extract, Transform, Load) Developer is responsible for designing, building, and managing data pipelines that extract, transform, and load data. This ensures that data is clean, well-structured, and easily accessible for business intelligence and analytics.

Core Responsibilities

ETL Developers manage the flow of data from multiple sources into centralized storage systems. Their key responsibilities include:

1. Data Extraction

• Collect raw data from various sources such as databases, applications, ERP/CRM systems, and external platforms.

2. Data Transformation

• Clean, validate, and standardize data.
• Perform aggregations and conversions to ensure data consistency and usability for analysis.

3. Data Loading

• Load transformed data into data warehouses, data lakes, or other storage systems to support reporting and analytics.

4. ETL Pipeline Development

• Design and implement automated workflows for data movement and transformation.
• Ensure reliability, scalability, and efficiency of data pipelines.

5. Data Quality Assurance

• Monitor and validate data to maintain accuracy, consistency, and integrity.
• Identify and resolve data discrepancies.

6. Performance Optimization

• Tune ETL processes to efficiently handle large-scale data.
• Troubleshoot errors, performance issues, and bottlenecks.

7. Collaboration

• Work closely with data architects, analysts, and BI teams.
• Understand business requirements and deliver actionable data solutions.