HGS is a global leader in customer experience management. With more than 18,000 employees spread across 9 countries, our mission is to make our clients more competitive by providing exceptional experiences. Powered by a people first philosophy and experience serving over 1100 of the world’s leading brands, HGS is the perfect place to build your future!

Job Overview:

We are seeking a highly skilled ETL Developer with expertise in Python and SQL to join our dynamic team. In this role, you will be responsible for developing and deploying multiple data interfaces, managing data pipelines, and leveraging PL/SQL to deliver business functionality with optimal performance and scalability. You will work closely with cross-functional teams to design, implement, and maintain integration scripts while utilizing your Python programming skills and SQL expertise to handle data efficiently.

Key Responsibilities:

• Python Development:
• Write clean, efficient, and reusable Python code to automate tasks, process data, and build Integrations.
• Work with Python libraries like boto3 for AWS interaction and other data-related libraries (e.g., Pandas, NumPy) for data manipulation and processing.
• SQL Database Management:
• Design, optimize, and manage SQL databases (e.g., Amazon RDS, MySQL, PostgreSQL) for efficient querying and storage.
• Write complex SQL queries, stored procedures, and scripts to extract and manipulate data.
• Monitor and optimize database performance, including query optimization and indexing.
• Data Integration & ETL:
• Integrate third-party APIs and data sources into database.
• Implement data validation, cleansing, and transformation procedures.
• Security and Compliance:
• Maintain compliance with industry standards and regulations in cloud architectures.
• Collaboration & Support:
• Collaborate with DevOps and infrastructure teams to ensure seamless deployment and integration.
• Troubleshoot and resolve application and infrastructure issues in a timely manner.
• Provide technical guidance and support to junior team members.

Requirements:

Technical Skills:

• Python: Proficiency in Python programming for cloud applications, automation, and data processing.
• SQL: Advanced skills in writing optimized SQL queries and working with relational databases (RDS, MySQL, PostgreSQL).
• Data Processing: Familiarity with tools like Pandas, and ETL frameworks.
• Version Control: Experience with Git and version control best practices.

Additional Skills:

• Strong problem-solving and debugging skills.
• Excellent communication skills, both written and verbal.

As an equal opportunity employer, HGS is dedicated to diversity, inclusivity and Equity. HGS does not discriminate on the basis of the race, ethnicity, religion, sex, national origin, age, veteran disability, or genetic information or any other reason prohibited by law in employment. We believe in the power of diversity to create an environment where every individual excels, and our diverse customer and colleague base is deeply understood.