T
Data Engineer (Advanced SQL)
T
Data Engineer (Advanced SQL)
Tata Consultancy Services- Posted 2 hours ago
- Be among the first 10 applicants
Job Description
Overall Experience: 6-10 Yrs
Technical Requirements & Skills
- Advanced SQL Mastery: Expert proficiency in writing analytical queries utilizing Window functions (RANK, LEAD/LAG), complex JOIN operations, and Common Table Expressions (CTEs).
- Database & Warehouse Platforms: Hands-on experience operating enterprise relational systems (e.g., PostgreSQL, SQL Server) and cloud-native analytical platforms (e.g., Snowflake, BigQuery, Databricks, Azure Synapse).
- Programming Languages: Proficient in Python, Scala, or PySpark to handle tasks that extend beyond pure SQL capabilities, such as advanced pipeline automation.
- ETL Tools & Orchestration: Experience utilizing workflow transformation and orchestration tools like dbt, Apache Airflow.
- Cloud Architecture: Foundational familiarity deploying data services within a major cloud landscape such as AWS, Google Cloud, or Microsoft Azure.
More Info
Key Skills
Common Table Expressions (CTEs)
Complex JOIN operations
