5 ETL architecture Jobs in India

1. Company Description:

Tatvic, is a marketing analytics company focusing on generating insights from data using long association with Google & its infrastructure. We breed,recognize and reward performance. As a company we are growing very fast & we are under transformation. To enable this transformation we need future leaders with eyesight which balances execution & strategic understanding.

Website: www.tatvic.com

2. Role Details

• Role: Lead Data Engineer
• Band: L4
• Department: Data Engineering
• Reporting to: L5 / Head of Delivery
• Location: Ahmedabad
• Job Type: Full Time
• Experience: 6-8 years of relevant experience
• Education: Bachelor’s or Master’s degree in Computer Science, Data Science, or a related technical field.

3. Mission & Role Overview

• Mission: To create high-level organizational impact by leading a team to design and deliver scalable, high-performance cloud-native data solutions. The Lead Data Engineer (L4) is responsible for ensuring technical excellence—specifically in BigQuery optimization and secure GCP/AWS architectures—while driving the transition to Agentic AI workflows and creating value through the development of L1-L3 engineers.
• Role Overview: This is a pivotal leadership role on the Management Track, responsible for end-to-end data outcomes for the function. The Lead Engineer ensures the quality of engineering execution, manages team utilization and resource allocation, and serves as the primary technical representative in cross-functional forums with Marketing, Strategy, and Product teams.

4. Key Responsibilities

• Lead the design, development, and deployment of scalable and efficient cloud-based data pipelines and architectures.
• Build reusable data solutions and software components that serve multiple customers and use cases.
• Architect cloud environments using GCP, ensuring best practices in IAM, Security, and Networking.
• Conduct Exploratory Data Analysis (EDA) on clickstream and behavioral datasets to derive insights.
• Manage end-to-end ETL processes, including data extraction, transformation, and loading using Python, SQL, and Airflow.
• Design and build production-grade software (APIs, services, internal tools) with sound engineering practices — version control, testing, CI/CD, and code review.
• Extend data platforms with AI capabilities — integrating LLMs, RAG pipelines, and agentic workflows where they add clear business value.
• Perform Root Cause Analysis (RCA) and resolve data quality, pipeline, or application issues.
• Collaborate cross-functionally with Marketing, Insights, Product, and Engineering teams to align data initiatives with business goals.
• Document architectures, design decisions, and operations clearly and consistently.
• Coach and mentor team members, ensuring technical excellence and continuous learning.
• Participate in recruitment and knowledge-sharing through interviews, blogs, and webinars.

5. Must-Have & Good-to-Have Skills

Must-Have Skills:

• Strong understanding of clickstream data and data pipeline architecture
• Hands-on experience with cloud platforms (GCP)
• Expertise in SQL, Python, and Airflow
• Solid software engineering foundation — API design, testing, version control, and deployment practices
• Proven ability to perform exploratory data analysis and data validation
• Knowledge of cloud security, IAM, and networking best practices
• Working knowledge of building or integrating AI/LLM-based components into existing systems
• Excellent problem-solving, stakeholder management, and communication skills

Good-to-Have Skills:

• Certifications such as: Google Cloud Professional Data Engineer / Cloud Architect
• AWS Certified Data Analytics or Azure Data Engineer Associate
• Google Analytics 4 (GAIQ)
• Experience in marketing attribution, commerce data, or analytics ecosystems
• Exposure to cost optimization and cloud resource management
• Experience with agent frameworks (LangChain, ADK, MCP) or LLM APIs
• Experience building automation frameworks or internal data tools

6. Not-a-Fit Criteria

• Individual Contributor Focus: Operates as the team's best individual contributor instead of building team capability or empowering L3s.
• Information Hoarding: Keeps architectural patterns or tribal knowledge trapped in their head rather than creating reusable playbooks and documentation.
• Avoidance of Conflict: Avoids difficult performance conversations with underperforming team members, allowing capability gaps to persist.
• Activity Over Outcomes: Measures success by "tasks completed" rather than pipeline stability, data accuracy, or business impact.
• Functional Siloing: Fails to build partnerships with Marketing or Product teams, leading to misaligned data delivery.

Our Culture & Perks - Where Passion Meets Purpose:

• Competitive CTC: Based on experience and skillset
• Medical Insurance for you and your family
• Return-to-Work Program for New Moms — because career breaks shouldn’t break momentum
• 1 Work From Home Day/Month — flexibility when life calls
• 2 Birthday Leaves/Year — one for you, one for someone you love
• Monthly Engagement Activities — from game nights to learning sessions
• Inclusive Culture & Equal Opportunity Employer — diversity drives our innovation
• We Think Like Engineers & Athletes: we build, we iterate, we scale, we win — together
• 5-day workweek — because balance drives brilliance

Job Title : Alteryx Developer

Experience : 5+ Years (Senior profiles with 8 to 12+ years preferred)

Location : Remote

Employment Type : Contract

Job Summary :

We are looking for an experienced Alteryx Developer to design, develop, and optimize enterprise ETL workflows, data transformation processes, and workflow automation solutions. The ideal candidate should have strong expertise in Alteryx Designer, Alteryx Server, SQL, ETL development, and enterprise data integration.

Mandatory Skills :

Alteryx Designer, Alteryx Server, ETL Development, Workflow Automation, SQL, Data Transformation, Data Migration, SQL Server/Oracle/MySQL/PostgreSQL, API Integration, Azure/AWS, Git.

Key Responsibilities :

• Design and develop scalable Alteryx workflows and ETL pipelines.
• Build reusable macros, analytic apps, and automated workflows.
• Perform data extraction, transformation, validation, and migration.
• Integrate data from databases, APIs, cloud platforms, and flat files.
• Manage Alteryx Server, workflow scheduling, deployment, and production support.
• Optimize workflow performance and ensure data quality.
• Collaborate with business and analytics teams to deliver data solutions.

Required Skills :

• Hands-on experience with Alteryx Designer and Alteryx Server.
• Strong expertise in ETL development, workflow automation, and data transformation.
• Proficiency in SQL with experience working on large datasets.
• Experience with SQL Server, Oracle, MySQL, or PostgreSQL.
• Knowledge of data migration, data validation, and data cleansing.
• Experience integrating data through APIs, cloud platforms, and flat files.
• Hands-on experience with Git and version control.
• Exposure to Azure or AWS cloud platforms.
• Strong analytical, troubleshooting, and performance optimization skills.

Good to Have :

• Python or Java
• Power BI, Tableau, or Spotfire
• Data Warehousing & Data Modeling
• CI/CD, Agile/Scrum
• Alteryx Designer Core Certification

Job Title : Data / Generative AI Engineer

Experience : 5+ Years (Mid-Level) | 10+ Years (Senior)

Location : Remote

Employment Type : Contract

Open Positions : 5

Job Overview :

We are hiring Data / Generative AI Engineers for remote contract engagements supporting client-facing AI implementations. The role involves building production-grade Generative AI solutions on AWS, including conversational AI systems, RAG-based architectures, intelligent automation platforms, and scalable data engineering pipelines.

Mandatory Skills :

Amazon Bedrock, Generative AI, RAG Architecture, LangChain/LlamaIndex/Bedrock Agents, Python (3.9+), AWS Serverless (Lambda, API Gateway, Step Functions), Vector Databases, Data Engineering & ETL, AWS Glue, Amazon Athena.

Key Responsibilities :

• Design and build production-ready Generative AI applications on AWS.
• Implement Retrieval-Augmented Generation (RAG) architectures for enterprise AI solutions.
• Integrate Amazon Bedrock with foundation models and enterprise systems.
• Develop AI agent orchestration workflows using frameworks such as LangChain, LlamaIndex, or Bedrock Agents.
• Build and manage serverless architectures using AWS services like Lambda, API Gateway, and Step Functions.
• Implement vector databases and semantic search solutions for intelligent knowledge retrieval.
• Design and maintain data engineering pipelines and ETL workflows for large-scale data processing.
• Use AWS Glue for data transformation and orchestration.
• Utilize Amazon Athena for querying large datasets and performing analytics.
• Develop scalable Python-based APIs and backend services.
• Collaborate with cross-functional teams and clients to deliver AI-powered solutions in production environments.

Required Skills :

• Strong experience with Amazon Bedrock and foundation model integrations
• Hands-on experience with LangChain, LlamaIndex, or Bedrock Agents
• Advanced Python (3.9+) development and API building
• Experience with AWS serverless architectures (Lambda, API Gateway, Step Functions)
• Experience implementing vector databases and semantic search systems
• Strong knowledge of data engineering and ETL pipeline development
• Hands-on experience with AWS Glue for data transformation and orchestration
• Experience using Amazon Athena for querying and analytics
• Experience building RAG-based AI applications

Engagement Details :

• Contract Duration : Minimum 3 to 6 Months
• Work Timing : 8:00 AM – 4:00 PM EST
• Start Timeline : Within 2 Weeks
• Open Positions : 5

Job Title: Lead Data Engineer

📍 Location: Pune

🧾 Experience: 10+ Years

💰 Budget: Up to 1.7 LPM

Responsibilities

• Collaborate with Data & ETL teams to review, optimize, and scale data architectures within Snowflake.
• Design, develop, and maintain efficient ETL/ELT pipelines and robust data models.
• Optimize SQL queries for performance and cost efficiency.
• Ensure data quality, reliability, and security across pipelines and datasets.
• Implement Snowflake best practices for performance, scaling, and governance.
• Participate in code reviews, knowledge sharing, and mentoring within the data engineering team.
• Support BI and analytics initiatives by enabling high-quality, well-modeled datasets.

Enterprise Data Architect - Dataeconomy (25+ Years Experience)

About Dataeconomy:

Dataeconomy is a rapidly growing company at the forefront of Information Technology. We are driven by data and committed to using it to make better decisions, improve our products, and deliver exceptional value to our customers.

Job Summary:

Dataeconomy seeks a seasoned and strategic Enterprise Data Architect to lead the company's data transformation journey. With 25+ years of experience in data architecture and leadership, you will be pivotal in shaping our data infrastructure, governance, and culture. You will leverage your extensive expertise to build a foundation for future growth and innovation, ensuring our data assets are aligned with business objectives and drive measurable value.

Responsibilities:

Strategic Vision and Leadership:

Lead the creation and execution of a long-term data strategy aligned with the company's overall vision and goals.

Champion a data-driven culture across the organization, fostering cross-functional collaboration and data literacy.

Advise senior leadership on strategic data initiatives and their impact on business performance.

Architecture and Modernization:

Evaluate and modernize the existing data architecture, recommending and implementing innovative solutions.

Design and implement a scalable data lake/warehouse architecture for future growth.

Advocate for and adopt cutting-edge data technologies and best practices.

ETL Tool Experience (8+ years):

Extensive experience in designing, developing, and implementing ETL (Extract, Transform, Load) processes using industry-standard tools such as Informatica PowerCenter, IBM DataStage, Microsoft SSIS, or open-source options like Apache Airflow.

Proven ability to build and maintain complex data pipelines that integrate data from diverse sources, transform it into usable formats, and load it into target systems.

Deep understanding of data quality and cleansing techniques to ensure the accuracy and consistency of data across the organization.

Data Governance and Quality:

Establish and enforce a comprehensive data governance framework ensuring data integrity, consistency, and security.

Develop and implement data quality standards and processes for continuous data improvement.

Oversee the implementation of master data management and data lineage initiatives.

Collaboration and Mentorship:

Mentor and guide data teams, including architects, engineers, and analysts, on data architecture principles and best practices.

Foster a collaborative environment where data insights are readily shared and acted upon across the organization.

Build strong relationships with business stakeholders to understand and translate their data needs into actionable solutions.

Qualifications:

Education: master’s degree in computer science, Information Systems, or related field; Ph.D. preferred.

Experience: 25+ years of experience in data architecture and design, with 10+ years in a leadership role.

Technical Skills:

Deep understanding of TOGAF, AWS, MDM, EDW, Hadoop ecosystem (MapReduce, Hive, HBase, Pig, Flume, Scoop), cloud data platforms (Azure Synapse, Google Big Query), modern data pipelines, streaming analytics, data governance frameworks.

Proficiency in programming languages (Java, Python, SQL), scripting languages (Bash, Python), data modelling tools (ER diagramming software), and BI tools.

Extensive expertise in ETL tools (Informatica PowerCenter, IBM DataStage, Microsoft SSIS, Apache Airflow)

Familiarity with emerging data technologies (AI/ML, blockchain), data security and compliance frameworks.

Soft Skills:

Outstanding communication, collaboration, and leadership skills.

Strategic thinking and problem-solving abilities with a focus on delivering impactful solutions.

Strong analytical and critical thinking skills.

Ability to influence and inspire teams to achieve goals.