Data Engineer

Access | Information Management; Chennai District; Hybrid; INR 1,200,000 - 2,800,000; Full time

Job summary

Access | Information Management in Chennai is seeking a Data Engineer to build scalable data platforms and ETL/ELT pipelines powering analytics, reporting, and data products across the organization. You will develop robust data workflows, optimize data quality, and enable trusted data for business intelligence and decision-making.

You will translate business requirements into robust database logic, automated data workflows, and insightful dashboards, contributing to solution design, development,

Qualifications

• Strong SQL skills with performance tuning and query optimization.
• Experience building robust ETL/ELT pipelines and data ingestion.
• Hands-on with cloud data services and data warehousing concepts.
• Ability to translate business requirements into data models and analytics-friendly outputs.

Responsibilities

• Build, optimize, and manage data ingestion workflows from multiple sources.
• Develop and optimize SQL queries, procedures, functions, and views for high-volume databases.
• Design and maintain data models to support analytics and reporting.
• Develop scalable pipelines using SQL, Python, and modern ETL/ELT frameworks.
• Perform data profiling, cleansing, validation, and quality monitoring.
• Optimize performance via indexing, partitioning, and tuning.
• Collaborate with product managers and stakeholders to deliver analytics-ready data.
• Support data product development with reliable, scalable datasets.
• Document pipelines, models, designs, and processes per governance standards.
• Implement data security, governance, metadata management, and compliance.

Skills

SQL

Python

ETL/ELT

Data modeling

Data warehousing

T-SQL/PL-SQL

Azure Data Services

AWS Data Services

BI/Reporting

Education

Bachelor's degree in Computer Science, Information Technology, or Engineering

Tools

SSIS

Azure Data Factory

Fivetran

AWS Glue

Azure Synapse

ADLS

S3

Lambda

Job description

Job Description:

We are seeking skilled Data Engineers to build, and maintain scalable platforms and pipelines that power analytics, reporting, and data products across the organization. You will develop robust ETL/ELT solutions, optimize data workflows, and enable trusted, high-quality data for business intelligence, advanced analytics, and data-driven decision-making. You will translate business requirements into robust database logic, automated data workflows, and insightful dashboards that enable data-driven decision-making across the organization. Depending on experience level, the role will contribute to solution design, development, optimization, and technical leadership within the data services team.

Roles and Responsibilities

• Build, optimize, and manage data ingestion workflows from multiple structured and unstructured data sources.


• Develop and optimize SQL queries, stored procedures, functions, and views for high-volume relational databases.


• Design and maintain data models that support analytics, reporting, and data products.


• Design, develop, and maintain scalable data pipelines using SQL, Python, and modern ETL/ELT frameworks.


• Perform data profiling, cleansing, validation, and quality monitoring to ensure data accuracy, integrity, and consistency.


• Optimize database and pipeline performance through indexing, partitioning, query tuning, and workload optimization.


• Collaborate with Product Managers, and business stakeholders to understand business requirements and deliver analytics-ready data solutions.


• Support the development and enhancement of data products by delivering reliable, scalable, and governed datasets.


• Document data pipelines, data models, technical designs, and operational processes in accordance with data governance standards.


• Implement best practices for data security, governance, metadata management, and compliance.


• Contribute to automation, reusable frameworks, and continuous improvement initiatives.

Qualifications & Experience

• Bachelors degree in computer science, Information Technology, and Engineering.


• 4--10+ years of strong hands-on experience in SQL development, ETL, and BI/reporting.

Required Skills & Experience

• Strong proficiency in SQL (T-SQL / PL-SQL) with advanced query writing and performance tuning.


• Hands-on experience with ETL/ELT tools such as SSIS, Azure Data Factory, Fivetran, AWS Glue


• Experience with Azure Data Services, such as: Azure Data Factory, Azure Synapse Azure Data Lake Storage (ADLS), Azure SQL Database, Microsoft Fabric.


• Hands-on experience with AWS Data Services including AWS Lambda, S3, Athena, Lake Formation & DataZone.


• Strong programming skills in Python for data engineering and automation.


• Strong data analysis skills, including data exploration, profiling, validation, KPI development, and translating business requirements into actionable insights.


• Solid understanding of data warehousing concepts, star/snowflake schemas, and dimensional modeling.


• Experience supporting or developing data products and understanding the end-to-end data product lifecycle.

Preferred Skills:

• Familiarity with version control (Git) and CI/CD for data pipelines.


• Exposure to Power BI, Service administration, gateways, and workspace management.


• Understanding of data privacy, retention, and governance frameworks.

Competencies:

• Strong communication and stakeholder management skills.


• Ability to work both independently and collaboratively in a hybrid.


• Attention to detail and commitment to data accuracy.


• Adaptability and eagerness to learn new tools and technologies.

Requirements: