Snr Data Engineer

Mployee.me; Dadri; Remote; INR 2,000,000 - 4,000,000; Full time

Benefits offered by this job

Health benefits from Day One

Wellbeing programs

Career growth opportunities

Job summary

Alight is seeking a Senior ETL Engineer to design and build scalable data pipelines in a modern cloud environment. You will work with Spark, PySpark, and Scala, leveraging AWS Glue, Lambda, S3, and Redshift to deliver robust data solutions.

You will lead end-to-end data orchestration using Airflow or similar tools, implement best practices for security and compliance, and collaborate with stakeholders to translate data into actionable insights.

Qualifications

• 4–8 years of ETL experience in Big Data environments.
• Strong expertise in Spark, Cloudera, and data pipelines on AWS.
• Experience orchestrating workflows with AWS Step Functions.
• End-to-end serverless data architectures using Glue, Lambda, S3, Redshift.

Responsibilities

• Build and maintain high-volume ETL/ELT pipelines on Hadoop and AWS.
• Develop data processing with PySpark, Spark SQL, and scalable cloud patterns.
• Design reusable ingestion frameworks and orchestration processes.
• Ensure data governance, partitioning, and performance optimizations.

Skills

ETL development

Big Data (Spark)

AWS Step Functions

Serverless data architecture

Scala/PySpark

SQL (Hive/Impala)

Python/Shell scripting

CI/CD & Git

Data Warehousing

Data modelling (star/snowflake)

Airflow/Control-M

Security & compliance in Cloud

Docker/ECS/EKS

Data governance

Tools

Airflow

Control‑M

Docker

ECS/EKS

Kinesis

Job description

Our Story

At Alight, we believe a company’s success starts with its people. Alight embraces values that come directly from our people – purposeful, human, united and growth-minded – reflecting our inclusive culture and promise that our clients expect. We are passionate about connecting purpose with impact. Alight empowers clients to build a healthier and more financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, navigation, and absence management.

Our Benefits

With a comprehensive total rewards package, Alight offers programs and plans that support your mind, body, wallet, and life. Benefits include health, starting Day One. Additionally, Alight colleagues enjoy wellbeing programs, retirement plans, and career growth opportunities – all within a thriving global organization.

Great Place to Work

Thanks to the work of every colleague, Alight has received multiple awards of recognition including "Great Place to Work" for the past 7 years and Fortune's "Best Companies to Work For." To learn more about our company culture and awards.

JD – Snr Software Engineer (ETL)

Experience & Expectations

• Leverage extensive experience (4 to 8 years overall ETL experience, to assist in solution design and delivery along with build of new ETLs).
• We are seeking an experienced ETL Developer with strong expertise in Big Data (Spark, Cloudera).
• Experience orchestrating workflows using AWS Step Functions (state machines) for reliable and scalable data pipelines.
• Ability to implement end-to-end serverless data architectures integrating Glue, Lambda, S3, and Redshift

Core Responsibilities

• Build and maintain high volume ETL/ELT pipelines across Hadoop (HDFS, Hive, Spark, Kafka) and AWS (Glue, EMR, Lambda, Step Functions, Redshift).
• Develop distributed data processing solutions using PySpark, Spark SQL, and scalable cloud serverless patterns.
• Implement reusable data ingestion frameworks for batch, ability to design & implement Orchestration process and Leverage AI
• Optimize data workflows using partitioning, bucketing, compression, file formats (Parquet/ORC).
• Understanding hybrid data lake architectures using S3 + HDFS, ensuring data governance and best practices are adheres
• Experience to deliver complex projects in an Agile environment
• Assist in Design and build the robust, scalable and secure software solutions across the having no/least adoption
• Define clear technical specifications and make architecture decisions that align with business goals and long-term scalability.
• Implement best practices (including secure code guidelines) through the implementation of unit tests, automation, leverage and code reviews. Drive continuous improvement in code quality and maintainability.
• Troubleshooting issues and proactively solving problems as they arise, ensuring the smooth operation of full stack applications
• Ability to understand the data flow diagram, data modelling and Lineages
• Job orchestration using Airflow, Control M, Step Functions, or event-driven triggers.
• Ensure data is protected and compliant with regulatory standards.
• Work closely with business stakeholders to enable high quality datasets.
• Work on best practice adoption and provide guidance to peers/juniors in team.
• Ability to respond on incidents, and troubleshooting Spark performance issues, job failures, and cluster bottlenecks.
• Collaborate closely with team members, QA and cross product teams to streamline release processes.
• Collaborate with business stakeholders to gather, analyse, and translate data into technical solutions

Technical Skills

• Strong experience with the AWS data stack (S3, Glue, EMR, Lambda, Kinesis, Redshift, Step Functions etc.,).
• Strong hands‑on expertise in Scala, PySpark, Spark optimization techniques, HiveQL, and distributed computing.
• Good understanding of Hadoop ecosystem (HDFS, Hive, Spark, YARN, Kafka).
• Good work experience in SQL in hive and impala
• Proficiency in at least one scripting/programming language: Python, Shell scripting.
• Strong experience with CI/CD, GitHub, Git commands.
• Expertise in ETL and Data Warehousing and cloud concepts.
• Good understanding of data modelling (star/snowflake), partitioning strategies, and schema evolution.
• Expertise in data profiling and decision making.
• Able to understand, design and create data flow diagrams.
• Able to understand the architecture and design end-to-end data flow.
• Hands‑on experience with Airflow, or Control‑M, or other orchestrators.
• To monitor and support BAU and year end activities, if needed.
• Exposure to security and compliance aspects in Cloud.
• Familiarity with serverless patterns and containerization (Docker, ECS/EKS).

Other Requirements

• Strong logical and analytical, problem-solving, and communication skills.
• Communicate effectively and concisely with multiple stakeholders and coordinate and collaborate with cross functional teams.
• AWS certifications (Data Engineer, or Developer) are a plus.

Detail-Oriented and proactive in problem-solving and issue resolution

Application and Interview

By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight’s employment policies. Background checks may include some or all the following based on the nature of the position: Government ID education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

Alight requires all virtual interviews to be conducted on video. Please be aware that Alight is a camera‑on culture and may require occasional travel to one of our physical office locations.

Our commitment to Inclusion

We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful.

At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future.

As part of this commitment, Alight will ensure that persons with disabilities are provided with reasonable accommodation for the hiring process. If reasonable accommodation is needed, please contact [e-mail] .

Equal Opportunity Policy Statement

Alight is an Equal Employment Opportunity employer and does not discriminate against anyone based on sex, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state, or local law. In addition, we take affirmative action to employ disabled persons, disabled veterans, and other covered veterans.

Alight provides reasonable accommodation to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices and observances, unless doing so would result in undue hardship. Applicants for employment may request reasonable accommodations/modifications by contacting their recruiter.

Authorization to work in the Employing Country

Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not, now or in the future, require sponsorship of a visa for employment authorization in the Employing Country and with Alight.

Note, this job description does not restrict management's right to assign or reassign duties and responsibilities of this job to other entities; including but not in limited to subsidiaries, partners, or purchasers of Alight business units.

We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

DISCLAIMER

Nothing in this job description restricts management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units.