Data Engineer - ETL, Advanced SQL, DBT, and Python

Role Overview

We are looking for skilled Data Engineers with 6 to 12 years of experience to join our team in Hyderabad. The successful candidate will be responsible for designing and maintaining automated data pipelines for ETL processes, ensuring data validation and quality at every stage.

Key Responsibilities

• Design, develop, and maintain complex ETL data pipelines to automate and streamline data ingestion and transformation.
• Build and execute advanced SQL queries and stored procedures on large-scale databases like Snowflake and Oracle.
• Leverage Python to support data processing and automation tasks related to data workflows.
• Utilize orchestration tools such as Airflow to schedule and manage data tasks efficiently.
• Develop data validation and testing frameworks using DBT to ensure integrity and quality of data.
• Employ cloud infrastructure technologies including AWS and GCP for scalable data solutions.
• Create dashboards and reports using Tableau integrated with SQL for comprehensive data insights.
• Manage the complete data analysis lifecycle from gathering requirements to delivering actionable insights.
• Identify opportunities for process optimization and introduce improvements proactively.
• Incorporate AI-based code generation tools like Claude Code to enhance development efficiency.

Candidate Profile and Requirements

• Strong experience in building and maintaining ETL pipelines.
• Proficiency in advanced SQL development including complex queries and stored procedures.
• Hands-on experience with Python scripting for data workflows.
• Familiarity with orchestration frameworks such as Apache Airflow.
• Expertise with DBT for data testing and validation.
• Knowledge of cloud platforms like AWS and Google Cloud Platform.
• Experience working with large-scale data warehouses such as Snowflake and database systems like Oracle.
• Skills in Tableau and SQL-based reporting.
• Ability to manage end-to-end data analysis processes.
• Exposure to AI-driven coding tools for improved productivity.
• Minimum academic qualification: Any graduate degree.