ETL cloud Architect

SENIOR CLOUD ETL ARCHITECT

InfoVision | Pune & Bangalore, India

ROLE SUMMARY

Seeking Senior Cloud ETL Architect (10+ yrs) to lead enterprise data warehouse & ETL platform design on Azure, AWS, GCP. Architect end-to-end data integration solutions, lead presales/RFP initiatives, mentor delivery teams. Proven experience with ADF, Synapse, Snowflake, Python, SQL, data warehouse design, and enterprise governance frameworks.

KEY RESPONSIBILITIES

• Design & own ETL/ELT architecture (Azure Data Factory, AWS Glue, Databricks, Synapse)
• Lead presales—RFP responses, technical proposals, client workshops, CXO engagement
• Architect enterprise DWH (Kimball, Data Vault, dimensional modeling)
• Define data governance, compliance, metadata management, data lineage
• Design CI/CD, monitoring, observability for data pipelines
• Mentor data engineers, establish architectural standards, build accelerators

REQUIRED QUALIFICATIONS

• 10+ yrs data engineering/architecture
• 3+ yrs senior architect/tech lead

• Super Mandatory Skills:

1) Presales/RFP (RFP responses, technical solutioning)

2) Enterprise solutioning (multi-cloud strategy)

3) Cloud platforms (Azure, AWS, GCP)

4) ADF or equivalent ETL (Azure Data Factory, AWS Glue)

5) SQL/T-SQL (advanced data modeling, optimization)

6) DWH design (Kimball, Data Vault, enterprise warehouse architecture)

• Advanced SQL (T-SQL, PL-SQL, PySpark SQL)
• Python & PySpark for transformations
• RDBMS (Oracle, MSSQL, PostgreSQL, MySQL)
• Data modeling (dimensional, hierarchies, SCD)
• Data governance, GDPR/HIPAA compliance
• Azure DevOps, Terraform, CI/CD pipelines

PREFERRED QUALIFICATIONS

• Kafka/streaming (Event Hubs, Kinesis)
• Power BI semantic modeling
• Azure certifications (DP-203, AZ-305)
• Consulting/practice delivery background
• Databricks, Snowflake, dbt expertise

TECHNICAL STACK

Azure Data Factory · Azure Synapse · AWS Glue · Databricks · Snowflake · Python · PySpark · SQL · Terraform · Azure DevOps · Power BI · Kafka