AWS Data Engineer

EXL Talent Acquisition Team; Gurugram District; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

EXL Talent Acquisition Team is seeking a Data Engineer for Gurugram with a hybrid work setup. You will translate business needs into scalable data models and reverse engineer existing data structures from databases and SQL scripts.

The role requires 5+ years of experience, strong SQL (including joins and CTEs), Snowflake, ETL, CI/CD, and proficiency in Python. Familiarity with AWS services (S3, Glue, Athena) is preferred.

Qualifications

• 5+ years of experience as a Data Engineer.
• Strong SQL querying skills including joins, subqueries, and CTEs.
• Experience with Snowflake, ETL, SQL, CI/CD.
• ETL processes and data modeling concepts.
• Knowledge of star and snowflake schemas.
• Experience with AWS services such as S3, Athena, Glue, EMR/Spark.
• Good knowledge of Python.

Responsibilities

• Understand and translate business needs into data models for long-term solutions.
• Reverse engineer physical data models from databases and SQL scripts.
• Analyse data-related system integration challenges and propose solutions.
• Assist with data architecture direction including data movement, strategy, and related considerations.

Skills

SQL

Snowflake

Python

ETL

CTEs

Data modeling

CI/CD

Education

Bachelor's degree in CS/Engineering/MIS

Tools

AWS S3

AWS Glue

AWS Athena

EMR/Spark

SQL

Job description

Role: Data Engineer
Location: Gurugram (Hybrid)

Key Role and Responsibilities:

• Understand and translate business needs into data models supporting long-term solutions.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Analyse data-related system integration challenges and propose appropriate solutions.
• Assist with and support setting the data architecture direction (including data movement approach, architecture/technology strategy, and any other data related considerations to ensure business value).

Requirements:

• 5+ Years of experience as a Data Engineer
• Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries, CTEs, aggregation)
• Strong knowledge of joins and common table expressions (CTEs)
• Experience in Snowflake, ETL, SQL, CI/CD
• Strong expertise in ETL process and with various data model concepts
• Knowledge of star schema and snowflake schema
• Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a major emphasis on S3 and Glue
• Good knowledge of Python

Education:

Bachelor's degree in computer science, Software Engineering, MIS or equivalent combination of education and experience

Key Skills:

SQL, Snowflake, Python, AWS