Principal Data Engineer/Architect

Excelencia iTech Consulting; Tiruchirappalli; On-site; INR 1,200,000 - 2,300,000; Full time

Job summary

Chennai City Corporation in India seeks a data engineering professional to design, build, and optimize data pipelines and analytics infrastructure across ETL/ELT processes. Responsibilities include developing SQL queries, leveraging cloud data warehouses (Snowflake, Redshift, BigQuery) and data lakes, integrating ingestion tools, and ensuring data security and quality.

The role requires strong Python/Java/C++ skills, experience with Airflow, Hadoop/Spark, and ability to communicate with

Qualifications

• Experience in data pipelines and BI/ DW architecture across ETL/ELT.
• Strong SQL proficiency with performance tuning and complex queries.
• Hands-on cloud data warehouse and data lake experience (Snowflake, Redshift, BigQuery).
• Experience with data ingestion tools (Fivetran, Stitch, Matillion) and cloud platforms.
• Proficient in Python/Java/C++, scripting (Bash), and Airflow for workflows.
• Demonstrated leadership, communication, and stakeholder management.

Responsibilities

• Develop, maintain, and enhance data pipelines and processes with star/snowflake schemas.
• Deliver data solutions using cloud technologies and modern data platforms.
• Implement data security and optimize data storage and processing.
• Create and optimize complex SQL queries; perform data sourcing and reconciliation.
• End-to-end lifecycle work: requirements gathering, testing, deployment.
• Collaborate with cross-functional teams and communicate with stakeholders.

Skills

Data pipelines

SQL

Python

Java

C++

Scala

Bash

Airflow

Hadoop

Spark

ML in production

Data security

Cloud DW

Tools

PowerCenter

IDMC

IICS

Fivetran

Stitch

Matillion

Azure

AWS

GCP

Airflow

Snowflake

Redshift

BigQuery

Job description

Chennai City Corporation, India | Posted on 06/29/2026

• Development, maintenance, andenhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledgeof star/snowflake schemas
• Hands on experience inPowerCenter/IDMC/IICS.
• Developingcomplex SQL queries and SQL optimization
• Development experience must be full Life Cycleexperience including business requirements gathering, data sourcing,testing/data reconciliation, and deployment within Business Intelligence/DataWarehousing Architecture.
• Designing and implementing data security
• Monitoring and optimizing data storage and dataprocessing
• Delivering Data Solutions using Cloud Technologies
• Advanced SQL skills and experience with relationaldatabases and database design like Oracle and SQLSERVER.
• Significant experience working with cloud DataWarehouse and Data Lake solutions (e.g., Snowflake, Redshift, BigQuery, AzureData Lake Storage, Amazon S3, etc.)
• Experience working with data ingestion tools such asFivetran, stitch, or Matillion.
• Working knowledge of Cloud-based solutions (e.g.,Azure, AWS and GCP).
• Experience building and deploying machine learningmodels in production.
• Strong proficiency in object-oriented languages:Python, Java, C++, Scala.
• Strong proficiency in scripting languages like Bash.
• Strong proficiency in data pipeline and workflowmanagement tools (e.g., Airflow, Azkaban).
• Familiarity with big data frameworks such as ApacheHadoop and Apache Spark
• Strong project management and organizational skills.
• Excellent problem-solving, communication, andorganizational skills.
• Demonstrated leadership experience and skills
• Ability to communicate effectively and influence technical and businessstakeholders at all levels of the organization

Requirements

Experience in Supply Chain andManufacturing Domains- understand the data, the use cases, and thevalue it drives rather than just the code

• Inventoryand warehouse management data
• Demandplanning and forecasting
• Productionorders, BOMs, routings
• Qualitysystems (defects, CAPA, nonconformance)