Key Responsibilities
- Design, develop, and maintain scalable ETL pipelines using SQL and Python.
- Work independently across the full lifecycle: requirement gathering, solution design, development, testing, and production deployment.
- Write complex and optimized SQL queries to support ETL processes and data transformations.
- Implement and manage data warehousing solutions following best practices.
- Develop thorough unit tests to ensure data accuracy, reliability, and code quality.
- Create and maintain detailed technical documentation for ETL processes and data models.
- Collaborate with stakeholders to understand data requirements and deliver robust data solutions.
- Handle multiple tasks and priorities effectively in a fast-paced environment.
Must Have Skills
- Strong experience in designing and developing ETL pipelines.
- Excellent SQL skills with hands-on experience in writing complex queries for ETL.
- Proficiency in Python for data processing and automation.
- Strong knowledge of Data Warehousing (DWH) concepts and architecture.
- Experience with AWS services such as Redshift, Lambda, and S3.
- Ability to work independently with minimal supervision.
- Experience in unit testing and ensuring high-quality, production-ready code.
- Strong documentation skills.
- Good understanding of Generative AI (GenAI) concepts and use cases.
- Demonstrated ability to work independently, with strong analytical, problem-solving, and client engagement skills.
- Willingness to work from office 45 days a week at Bangalore Yelahanka location.
- Strong scripting and programming skills (Python, SQL).
Good To Have Skills
- Understanding of transactional and marketing data.
- Exposure to Generative AI (GenAI) concepts or use cases.
- Experience with additional AWS data services or modern cloud data architecture.
- Experience working in Agile or fast-paced delivery environments.
Key Skills: ETL Pipeline Design & Development, SQL, Python, Data Warehousing (DWH) Concepts, AWS Services (Redshift, Lambda, S3), Data Modeling & Transformations, Unit Testing & Code Quality Assurance, Technical Documentation, Problem Solving & Independent Working, GenAI Exposure,
