About This Role
Designing, developing, and maintaining scalable ETL pipelines is the core of this role for an experienced ETL Developer. The ideal candidate will have strong expertise in Python, SQL, and database technologies, with a focus on building reliable and high-performance data processing solutions, data integration, transformation, and migration.
Responsibilities
- Design, develop, and maintain ETL workflows using Python and SQL
- Build scalable data pipelines to extract, transform, and load data from multiple sources
- Develop and optimize SQL queries, stored procedures, and database objects
- Perform data cleansing, transformation, validation, and reconciliation
- Monitor ETL jobs and troubleshoot production issues
- Optimize ETL processes for performance, scalability, and reliability
- Collaborate with business analysts, application developers, and data engineers to understand data requirements
- Ensure data quality, security, and compliance with organizational standards
- Prepare technical documentation and follow coding best practices
Requirements
- 7+ years of experience in ETL development and data integration
- Basic understanding of Python
- Strong SQL development skills, including writing complex queries, stored procedures, and performance tuning
- Hands-on experience with relational databases such as PostgreSQL, BigQuery, Oracle, or MySQL
- Experience designing and developing ETL pipelines for data extraction, transformation, and loading
- Experience with Python libraries such as Pandas, SQLAlchemy, and database connectors
- Strong understanding of database design, data modeling, indexing, and query optimization
- Experience in data migration, data validation, and data quality processes
- Knowledge of Git for version control
- Familiarity with Windows/Linux/Unix environments and shell scripting
- Understanding of REST APIs and integrating data from multiple sources
Nice to have:
- Experience with ETL tools such as Talend
- Experience with cloud platforms such as AWS, GCP, or Azure
- Knowledge of cloud storage services (Amazon S3, Google Cloud Storage, Azure Blob Storage)
- Experience with Docker and CI/CD pipelines
- Experience working in Agile/Scrum teams
