Walk-in | Analytical Engineer_Walkin Drive_19th Sept_Kolkata

Tata Consultancy Services; Kolkata District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tata Consultancy Services is seeking a data engineer in Kolkata to design and optimize SQL-driven data pipelines, transforming data for analytics and reporting. You will work across cloud platforms like Snowflake, Databricks, and Azure Synapse, implementing robust data models and governance practices.

We value hands-on Python expertise, experience with Airflow and DBT, and strong collaboration with stakeholders, data scientists, and BI teams to deliver reliable analytics solutions in an Agile

Qualifications

• Proficient in SQL and data transformations for scalable pipelines.
• Experience building ETL/ELT workflows and maintaining data pipelines.
• Hands-on with cloud data platforms (Snowflake, Databricks, Redshift, Azure Synapse).
• Strong understanding of dimensional modeling, data warehousing concepts.
• Experience with orchestration tools like Airflow and transformation frameworks like DBT.
• Proficient in Python for data processing and analytics.
• Able to collaborate with business stakeholders, data scientists, and BI teams.
• Knowledge of data quality, governance, and metadata management.
• Familiar with Agile delivery methodologies.

Responsibilities

• Develop and optimize SQL queries and data transformations.
• Build and maintain scalable ETL/ELT pipelines.
• Work with Snowflake, Databricks, Redshift, or Synapse in cloud data platforms.
• Model data using dimensional modeling techniques for warehousing.
• Orchestrate workflows with Airflow; implement DBT transformations.
• Leverage Python for data processing and analytics tasks.
• Collaborate with stakeholders, data scientists and BI teams to deliver analytics solutions.
• Ensure data quality, governance, and metadata management across pipelines.
• Follow Agile practices in delivery and iteration cycles.

Skills

SQL

Data Warehousing

Data Transformation

Python

Airflow

DBT

Snowflake

Databricks

Redshift

Azure Synapse

Data Modeling

Stakeholder Collaboration

Metadata Management

SQL Optimization

Agile

ETL/ELT Pipelines

Tools

Airflow

DBT

Job description

Role & responsibilities

• Strong expertise in SQL and data transformation techniques.
• Experience in building and maintaining scalable ETL/ELT pipelines.
• Hands-on experience with cloud-based data platforms such as Snowflake, Databricks, Redshift, Azure Synapse, or equivalent.
• Strong understanding of data modeling, dimensional modeling, and data warehousing concepts.
• Experience with orchestration tools such as Airflow and transformation frameworks such as DBT.
• Proficiency in Python for data processing and analytics.
• Ability to collaborate with business stakeholders, data scientists, and BI teams to deliver analytics solutions.
• Experience in data quality management, performance tuning, governance, and metadata management.
• Familiarity with Agile delivery methodologies.