ETL Architect

ETL Lead

Location : Pune, India (Hybrid / Remote)

Job Type : Full-Time

Experience : 10+ years

About Company

Accelirate is a leading AI and automation firm that builds intelligent agents transforming enterprise operations. We’re a certified partner of UiPath, Microsoft, and Salesforce, automating over 1500+ processes annually across industries. We’re proud to be recognized as a Top Workplaces USA winner five years in a row. Our work empowers humans, agents, and robots to collaborate and work smarter.

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.