Lead-Data Analytics Architect(ETL)

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.