Technical Architect Data ETL

Tata Consultancy Services; Dadri; On-site; INR 2,800,000 - 5,200,000; Full time

Job summary

Tata Consultancy Services in India seeks an experienced Technical Architect - Data & ETL to design and oversee enterprise-scale data integration and ETL solutions. You will lead data architecture, implement scalable pipelines, and collaborate with stakeholders.

The role emphasizes cloud data migration, governance, and mentoring ETL developers. Ideal candidates have 7-12 years in data engineering or architecture, strong SQL, and experience across Big Data tools.

Qualifications

• Experience designing end-to-end data architecture and ETL frameworks.
• Ability to lead data integration across multiple source/target systems.
• Strong grounding in data modeling and governance standards.

Responsibilities

• Design and implement end-to-end data architecture and ETL frameworks.
• Lead data integration initiatives across multiple source and target systems.
• Architect scalable data pipelines for structured and unstructured data processing.
• Define data models, data governance standards, and best practices.
• Collaborate with business and technology teams to gather requirements and translate them into technical solutions.
• Review ETL designs, code quality, and performance optimization strategies.
• Ensure data quality, data integrity, security, and compliance standards.
• Troubleshoot complex data and integration issues.
• Mentor and guide ETL developers and data engineers.
• Participate in architecture reviews and technology roadmap discussions.
• Drive cloud data migration and modernization initiatives.

Skills

Data governance

Stakeholder management

Communication

Cloud architecture

Dimensional modeling

Data quality

Leadership

Agile experience

Mentoring

Problem-solving

Education

Bachelor's or Master's degree in Computer Science/IT

Certifications in Azure/AWS/Snowflake/Informatica

Tools

Talend

SSIS

DataStage

Oracle

SQL Server

PostgreSQL

Snowflake

AWS

Spark

Hadoop

Databricks

CI/CD

DevOps

Job description

We are seeking an experienced Technical Architect - Data & ETL to design, develop, and oversee enterprise-scale data integration and ETL solutions. The ideal candidate will have strong expertise in data architecture, ETL development, data warehousing, cloud technologies, and team leadership. The role requires close collaboration with business stakeholders, architects, developers, and data engineering teams to deliver scalable and high-performance data solutions.

Key Responsibilities

• Design and implement end-to-end data architecture and ETL frameworks.
• Lead data integration initiatives across multiple source and target systems.
• Architect scalable data pipelines for structured and unstructured data processing.
• Define data models, data governance standards, and best practices.
• Collaborate with business and technology teams to gather requirements and translate them into technical solutions.
• Review ETL designs, code quality, and performance optimization strategies.
• Ensure data quality, data integrity, security, and compliance standards.
• Troubleshoot complex data and integration issues.
• Mentor and guide ETL developers and data engineers.
• Participate in architecture reviews and technology roadmap discussions.
• Drive cloud data migration and modernization initiatives.

Required Skills

Technical Skills

• Strong experience in ETL/Data Integration tools such as:
• Talend
• SSIS
• DataStage
• Strong SQL and database expertise.
• Experience with Data Warehousing concepts and dimensional modeling.
• Expertise in Oracle, SQL Server, PostgreSQL, Snowflake, or similar databases.
• Experience in cloud platforms:
• AWS
• Strong understanding of data governance, metadata management, and data quality frameworks.
• Experience with Big Data technologies is an added advantage:
• Spark
• Hadoop
• Databricks
• Knowledge of CI/CD and DevOps practices for data platforms.
• Data Modeling
• Performance Tuning & Optimization
• Security and Compliance

Required Experience

• 7-12 years of experience in Data Engineering, ETL Development, or Data Warehousing.
• Minimum 2-3 years in an Architect or Technical Lead role.
• Strong stakeholder management and communication skills.
• Experience working in Agile environments.

Preferred Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
• Certification in Azure, AWS, Snowflake, Informatica, or Data Engineering is preferred.
• Experience in Banking, Financial Services, Healthcare, Retail, or Telecom domains is a plus.