Role & responsibilities

Architecture & Strategy

- Define enterprise data modernization strategy and target-state architecture leveraging Databricks Lakehouse and dbt.
- Design scalable, secure, and high-performance data platforms supporting analytics, AI/ML, reporting, and self-service BI.
- Develop migration blueprints for legacy ETL, data warehouses, and reporting platforms.
- Create reference architecture, standards, and governance frameworks

Data Platform Migration

- Lead migration initiatives from platforms such as:
- Teradata, Oracle ,SQL Server ,Netezza ,Hadoop ,Informatica ,Ab Initio ,Talend, Snowflake (optimization/consolidation scenarios)

- Assess source systems and define migration patterns, tooling, and execution strategies.
- Drive workload transformation to Databricks using Delta Lake, Unity Catalog, and Lakehouse architecture.
- Lead ETL/ELT modernization using dbt.

Databricks Architecture

- Design and implementation:
- Delta Lake architecture
- Medallion Architecture (Bronze, Silver, Gold)
- Unity Catalog governance model
- Data Quality frameworks
- Performance optimization strategies
- Cost optimization and FinOps practices

- Establish best practices around Spark, PySpark, SQL,



and Databricks Workflows.

dbt Leadership

- Define enterprise dbt standards and deployment strategies.
- Design modular, reusable dbt models and frameworks.
- Implement testing, lineage, documentation, and CI/CD pipelines.
- Establish best practices for semantic layers and data transformation governance.

Cloud & DevOps

- Architect solutions on Azure, AWS, or GCP.
- Implement Infrastructure as Code (Terraform preferred).
- Integrate CI/CD pipelines using Azure DevOps, GitHub Actions, Jenkins, or GitLab.
- Drive DataOps and MLOps practices across teams.

Leadership & Stakeholder Management

- Lead teams of architects, data engineers, and consultants.
- Conduct architecture reviews and technical governance forums.
- Engage business stakeholders to understand transformation goals.
- Provide executive-level presentations, estimates, risk assessments, and roadmaps.

Preferred candidate profile

Technical Skills

- SQL (Expert Level), PySpark / Spark, Python, Data Modeling (Dimensional & Data Vault) , ETL/ELT Architecture, Data Warehousing Concepts ,API Integrations

📌 Lead Technical Architect (Hyderabad)
🏢 Tata Consultancy Services
📍 Hyderabad