Job Description

ETL Architect

Location:

Pune, India (Hybrid/Remote)

Job Type:

Full-Time

Experience:

10+ years

Job Summary:

We are seeking an experienced

ETL

Lead /

ETL

Architect

to design, develop, and optimize

scalable data pipelines

. This role involves working with

ETL

tools (e.g. Matillion, Informatica, Talend, SSIS, ADF, AWS Glue etc)

,

cloud data platforms (Snowflake, Azure, AWS, GCP)

, and

data warehousing best practices

to ensure efficient data integration and processing.

Key Responsibilities:

Design (Architect) end-to-end

data warehousing solutions for the customer Design and implement

high-performance

ETL

workflows

for structured and unstructured data. Develop and manage

data pipelines

on cloud platforms like

Snowflake, Redshift, or Azure Synapse

. Ensure

data quality, governance, and security

across all ETL processes. Collaborate with cross-functional teams to define

data requirements and integration strategies

. Optimize

ETL

performance, scalability, and cost efficiency

. Lead and mentor a team of ETL developers.

Required Skills & Experience:

10+ years

of experience in

ETL

development and data integration

. Expertise in

ETL

tools

(Matillion, Informatica, Talend, SSIS, AWS Glue etc). Strong

SQL skills

and proficiency in

Python or Scala

for automation. Hands-on experience with

cloud data warehouses (Snowflake, Redshift, Azure Synapse, BigQuery)

. Understanding of

data modelling, data lakes, and workflow orchestration (Airflow, ADF, AWS Step Functions)

. Strong problem-solving and leadership skills.

Preferred Qualifications:

Experience with

performance tuning and cost optimization

of ETL workflows. Knowledge of

real-time data processing and streaming technologies (Kafka, Kinesis, Azure Event Hub, etc)

. Familiarity with

data cataloguing, lineage tracking, and metadata management

. Hands-on experience in

data security and compliance (GDPR, HIPAA, SOC 2)

. * Certifications in

ETL

Tools

,

Snowflake, AWS, Azure, or GCP

would be appreciated.