Key Role and Responsibilities: /n /n
Understand and translate business needs into data models supporting long-term solutions.
/n
Perform reverse engineering of physical data models from databases and SQL scripts. Analyze data-related system integration challenges and propose appropriate solutions.
/n
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)
/n
Design and implement data pipelines, Optimize data processing and storage, Ensure data solutions meet performance standards, Provide technical support, Collaborate with stakeholders.
/n /n Must Have: /n /n
8+ Years of experience as a Data Engineer
/n
Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries, CTEs, aggregation)
/n
Solid knowledge of joints and common table expressions (CTEs)
/n
Robust experience with Python
/n
Experience in Snowflake, ETL, SQL, CI/CD
/n
Strong expertise in ETL process and with various data model concepts
/n
Knowledge of Star Schema and snowflake schema
/n
Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a major emphasis on S3 and Glue.
/n /n Valuable-to-Have Skills: /n /n
Experience with Big Data Tools and technologies
/n
Valuable Understanding of data structures and data analysis
/n
Knowledge of Insurance Domain is an addition.
/n /n Qualifications: /n /n
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field.
/n
7+ years of experience in data engineering roles using AWS and Snowflake.
/n
Strong problem-solving, communication, and collaboration skills.
/n
📌 Senior Data Engineer Gurugram
🏢 EXL
📍 Gurugram