Description
Design, build, and maintain ETL pipelines while validating data integrity through comprehensive backend testing on AWS.
This role is on-site.
Responsibilities
- Design, build, and maintain ETL pipelines for cloud-based data solutions.
- Analyze data models and business requirements to ensure accurate data processing.
- Troubleshoot data issues, debug complex queries, and optimize performance across MySQL, Oracle, and MS SQL Server.
- Execute backend test cases to validate data insertion, updates, and deletion logic.
- Create and maintain documentation for processes, systems, and test coverage.
Required Skills
- 5-7 years of experience in ETL development and SQL testing.
- Proficiency in writing complex SQL queries and understanding database relationships.
- Hands-on experience with AWS cloud solutions and ETL tools.
- Experience with multiple database systems: MySQL, Oracle, MS SQL Server.
- Understanding of data modeling principles and DevOps practices.
- Strong debugging and performance tuning skills.
- Bachelor's degree in a relevant field.