AWS Data Engineer

ApTask; Chennai District; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

ApTask in Chennai, India, is seeking a data engineer with strong experience in cloud data warehousing and SQL optimization. You will design and optimize data pipelines, and work with Redshift, Snowflake, or BigQuery in a fast-paced environment.

Required skills include Python for data engineering, dimensional modelling, and Git-based CI/CD. The role favors hands-on practitioners who can leverage AI-assisted development tools to boost productivity.

Qualifications

• Strong experience with data warehouse concepts and dimensional modelling.
• Advanced SQL with complex query optimization.
• Hands-on Python for data engineering and automation.
• Experience with Git-based CI/CD workflows and AI-assisted tooling.

Skills

Amazon Redshift

Snowflake

Google BigQuery

SQL

Data Warehouse concepts

Dimensional Modelling

Python

Data Analysis

Git-based CI/CD

AI-assisted development tools

Tools

Apache Airflow

Mage

dbt

AWS S3

RDS PostgreSQL

IAM

GitHub

GitLab

Job description

• Strong experience with Amazon Redshift (Candidates with strong Snowflake or Google BigQuery experience can also be considered.)
• Advanced SQL skills with experience writing and optimizing complex queries.
• Strong understanding of Data Warehouse concepts and Dimensional Modelling (Star & Snowflake Schemas).
• Strong hands‑on experience with Python for data engineering and automation.
• Excellent Data Analysis and problem‑solving skills.
• Experience with Git‑based CI/CD (GitHub/GitLab).
• Experience leveraging AI‑assisted development tools (GitLab Duo, Gemini, Copilot, ChatGPT, or similar) to improve engineering productivity.

Preferred Skills

• Experience with orchestration tools such as Apache Airflow, Mage, or equivalent.
• Hands‑on experience with AWS services such as S3, RDS PostgreSQL, and IAM.
• Experience with dbt.
• Experience supporting production data pipelines, troubleshooting issues, and handling day‑to‑day engineering operations.