Design and maintain data models, reverse-engineer physical data models, address data integration challenges, and support data architecture strategy. The role requires advanced SQL, ETL, Snowflake, Python, CI/CD, AWS services, and data modeling expertise, with emphasis on AWS S3 and Glue.
The summary above was generated by AI
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
ResponsibilitiesKey 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).
QualificationsBachelor Degree
About Us EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 54,000 employees spanning six continents. For more information, visit www.exlservice.com.
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. About the TeamEXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration – and we’ve been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that’s unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It’s our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we’re some of the best in the business. Contact us to see how we can help you achieve your goals.
