Key skills
AWSETLPythonSparkSQLSnowflakeS3GlueAthenaCI/CD
About this role
Role Overview
- 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
Tech Stack
- AWS
- ETL
- Python
- Spark
- SQL
Benefits
- EXL never requires or asks for fees/payments or credit card or bank details during any phase of the recruitment or hiring process and has not authorized any agencies or partners to collect any fee or payment from prospective candidates. EXL will only extend a job offer after a candidate has gone through a formal interview process with members of EXL’s Human Resources team, as well as our hiring managers.