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.
Alight is a leading cloud-based human capital technology and services provider for many of the world’s largest organizations. Through the administration of employee benefits, Alight powers confident health, wealth, leaves and wellbeing decisions for 35 million people and dependents. Our Alight Worklife® platform empowers employers to gain a deeper understanding of their workforce and engage them throughout life’s most important moments with personalized benefits management and data-driven insights, leading to increased employee wellbeing, engagement and productivity. Learn how Alight unlocks growth for organizations of all sizes at alight.com.
