ETL Developer

We are looking for an ETL Developer with 2+ years of experience in building and maintaining scalable data pipelines. The ideal candidate should have strong hands-on expertise in PySpark and Amazon Redshift, along with a solid understanding of ETL processes, data warehousing, and cloud-based data platforms. You will work closely with data engineers, AI engineers, and product teams to develop reliable data pipelines that power analytics, AI models, and customer decisioning systems.
Responsibilities:
Design, develop, and maintain scalable ETL/ELT pipelines using PySpark.
Develop and optimize data models and transformations within Amazon Redshift.
Build data ingestion pipelines from multiple structured and unstructured data sources.
Write efficient SQL queries for data extraction, transformation, validation, and reporting.
Monitor, troubleshoot, and optimize ETL workflows to ensure high performance and reliability.
Ensure data quality, consistency, and integrity across data pipelines.
Work closely with engineering and analytics teams to understand business and data requirements.
Participate in code reviews and follow engineering best practices for scalable development.
Support production deployments and resolve data-related issues promptly.
Collaborate with AI and analytics teams to prepare high-quality datasets for machine learning and customer analytics use cases.
Requirements:
2+ years of experience in ETL or data engineering.
Strong hands-on experience with PySpark (mandatory).
Strong experience working with Amazon Redshift (mandatory).
Strong SQL skills with experience writing complex queries and optimizing performance.
Good understanding of ETL/ELT concepts and data pipeline development.
Experience working with relational databases such as PostgreSQL, MySQL, SQL Server, or similar.
Experience working with AWS data services.
Good understanding of data warehousing concepts and dimensional data modeling.
Familiarity with Python for data processing and automation.
Experience with Git or other version control systems.
Strong analytical and problem-solving skills.
Good communication and collaboration skills.

Experience
2-5 yrs