AWS Data Engineer

EXL; Dadri; Hybrid; INR 1,500,000 - 2,300,000; Full time

Job summary

EXL in Gurugr am is seeking a Data Engineer with 5+ years' experience to design data models and enable scalable data solutions. You will translate business needs into analytical models and support data integration initiatives in a hybrid work setup.

Proficiency in SQL, Snowflake, Python and AWS is required, along with knowledge of ETL processes, star/snowflake schemas, and CI/CD. A Bachelor's degree in CS/SE/MIS is expected.

Qualifications

• 5+ Years of experience as a Data Engineer.
• Strong SQL querying skills (joins, subqueries, CTEs).
• Knowledge of star and snowflake schema concepts.
• Experience with Snowflake, ETL, SQL, CI/CD.
• AWS services such as S3, Glue, EMR/Spark is beneficial.
• Strong Python proficiency.

Responsibilities

• Understand and translate business needs into data models.
• 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 to ensure business value.

Skills

SQL

Snowflake

Python

AWS

ETL

Data Modeling

CI/CD

Education

Bachelor's degree in Computer Science / Software Engineering / MIS

Tools

ETL Tools

CI/CD Pipelines

Databases

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