Senior AWS Redshift Data Engineer

Techmango Technology Services Private Limited; India; Hybrid; INR 1,000,000 - 1,500,000; Full time

Benefits offered by this job

Competitive salary and performance-based incentives

Opportunity to learn advanced cloud technologies

Collaborative work environment

Job summary

A leading tech service provider is searching for a Senior AWS Redshift Data Engineer to join their team in India. The role involves designing and maintaining high-performance data pipelines, ensuring data reliability and optimization. Candidates should have over 7 years of experience, with deep expertise in AWS, Redshift, and data pipeline development. This position offers competitive salary, performance incentives, and opportunities for growth in a collaborative work environment. Applicants must be ready for remote work with occasional travel to Madurai for meetings.

Qualifications

• 7+ years of experience in database engineering or backend systems development.
• Deep expertise with MySQL, Amazon Redshift, and Snowflake.
• Proven track record maintaining data freshness SLAs.
• Strong problem-solving skills.

Responsibilities

• Design and maintain scalable schemas in MSSQL, Redshift, and Snowflake.
• Architect and optimize complex queries and indexing strategies.
• Build and maintain data pipelines for timely delivery of data.
• Collaborate with teams to ensure data models align with requirements.

Skills

AWS

PySpark

AWS Glue

Redshift

Data Build Tool

S3‑based Medallion architecture

SQL Server Query Optimization

Complex Queries

Lambda

Lakehouse

ETL orchestration patterns

API

GitHub

CI/CD integration

Job description

Senior AWS Redshift Data Engineer

We are looking for a seasoned Data Engineer to join our Engineering organization and take ownership of the systems that power our data‑driven decisions. You will architect and maintain high‑performance data pipelines and databases across platforms like MSSQL, Redshift, and Snowflake, ensuring data is reliable, accessible, and optimized for scale.

About the Company

At Techmango, we believe that true transformation happens at the intersection of deep engineering and business intelligence. For over 15 years, we have operated as a Gold Standard Service Provider, delivering over 350+ engineering solutions that help global organizations scale with resilience. We are a team of 260+ technical experts who do more than just write code; we build with purpose. Our philosophy is simple: impact grows when strategy aligns with execution.

Key Details

• Job Title: Senior AWS Redshift Data Engineer
• Location: Madurai (Remote work with monthly travel to Madurai for onboarding and meetings)
• Employment Type: Full‑Time
• Experience: 7+ Years
• Shift Timing: 2 PM – 11 PM IST
• Notice Period: Immediate joiner preferred
• Primary Skills: AWS, PySpark, AWS Glue, Redshift, Data Build Tool, S3‑based Medallion architecture, SQL Server Query Optimization, Complex Queries, Lambda, Lakehouse, ETL orchestration patterns, API, GitHub, CI/CD integration, modernization

What You Will Do

Design and maintain scalable, efficient, and well‑partitioned schemas in MSSQL, Redshift, and Snowflake.

• Architect and optimize complex queries, stored procedures, indexing strategies, and partitioning for large datasets.
• Build, monitor, and maintain data pipelines that ensure timely and accurate delivery of data to internal and external consumers.
• Own and enforce data refresh SLAs, ensuring availability, consistency, and reliability across production and reporting environments.
• Collaborate with software engineers, analysts, and DevOps teams to ensure data models and queries align with product and reporting requirements.
• Proactively identify and remediate performance bottlenecks, slow queries, and data inconsistencies.
• Implement and manage database change workflows using schema migration/versioning tools.
• Define and promote best practices for data access, security, compliance, and observability.

Requirements

• 7+ years of experience in database engineering or backend systems development.
• Deep expertise with MySQL, Amazon Redshift, and Snowflake, including schema design and performance optimization.
• Design, build, and maintain scalable data pipelines and ETL processes tailored to client needs.
• Proven track record maintaining data freshness SLAs and data quality across production pipelines.
• Hands‑on experience with T‑SQL, LinkSQL, query optimization, and indexing strategies.
• Experience with query optimization, mapping tables to blocks and partitions, sub‑table structure and keying/indexing for efficiency.
• Experience with relational data modeling and schema versioning in support of software development.
• Experience as the sole or lead database expert on a development team.
• Familiarity with source control systems (e.g., Git/Bitbucket) and CI/CD integration.
• Strong problem‑solving skills.
• Transforming product requirements into workable solutions, collaborating with multiple development and testing teams.
• Writing robust functions, procedures, and scripts using SQL.
• Involved in day‑to‑day business operations dealing with support and performance issues.
• Diagnosing and troubleshooting data‑related issues, providing quick and effective resolutions.
• Analyzing data workflows and identifying areas for improvement, recommending and implementing solutions to optimize performance.
• Utilizing a proactive approach to foresee potential problems and address them before they impact operations.

Benefits

• Work with a fast‑growing global data engineering team.
• Opportunity to learn and grow in advanced cloud and analytics technologies.
• Competitive salary and performance‑based incentives.
• A collaborative and innovation‑driven work environment.

Interview Process

• L1 Technical Discussion: Virtual discussion via Gmeet or Teams.
• L2 Technical Discussion: In‑Person (Face‑to‑Face) at the Chennai/Madurai location.
• Client Interview: Virtual.
• HR Discussion: Virtual / In‑Person.
• Onboarding: Mandatory visit to the Chennai/Madurai branch.

Contact: Arumugam Veera – LinkedIn: Arumugam Veera