Technical Architect Data ETL

Job Summary

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:
• Informatica PowerCenter / IICS
• Talend
• SSIS
• DataStage
• ADF (Azure Data Factory)
• 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:
• Microsoft Azure
• AWS
• Google Cloud Platform (GCP)
• 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.

Architecture Skills

• Enterprise Data Architecture
• Data Modeling
• Data Migration Strategy
• Integration Architecture
• 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.
• Experience delivering large-scale enterprise data projects.
• 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.