Software Engineer - ETL and Data Warehousing

Software Engineer

Summary:
Software Engineer with 4 years of experience in ETL and Data Warehousing. The ideal candidate will have strong hands-on expertise in SQL development across Hive, Spark, and Impala, along with a solid understanding of cloud ecosystems. This role requires proficiency in big data technologies and scripting, as well as flexibility to collaborate during U.S. business hours. AWS certification is a plus.
Core Responsibilities:
Design, develop, and maintain ETL workflows and data pipelines for large-scale data processing.
Write and optimize medium-complexity SQL queries on Hive, Spark, and Impala for use case-driven scenarios.
Develop and maintain scripts using HIVE, PySpark, Spark, and Scala for data transformation and processing.
Implement and troubleshoot Unix Shell scripts for automation and system tasks.
Collaborate with cross-functional teams to ensure data integrity and performance.
Work in alignment with U.S. business hours for meetings and deliverables.
Contribute to cloud-based data solutions and ensure best practices in data engineering.
Requirements:
Experience: 4 years in ETL and Data Warehousing.
Technical Skills:
Strong SQL skills with Hive, Spark, and Impala.
Proficiency in HIVE / PySpark / Spark / Scala scripting.
Good understanding of Unix Shell scripting.
Conceptual knowledge of cloud ecosystems (AWS preferred).
Certifications: AWS Certified applicants are highly desirable.
Soft Skills: Strong problem-solving ability, adaptability, and communication skills.
Work Hours: Flexibility to overlap with U.S. business hours.

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.

.

Experience Level

Mid Level