ETL Architect

8 years

0 Lacs

Posted:4 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

AI and Data ETL Architect


If you are available for a Face to face interview on10th Jan Saturday In Pune. Then please share your CV to monica_sharma@hcl-software.com with the below details:


Total Experience-

Current CTC-

Expected CTC-

Notice period-


If shortlisted you will be invited for a F2F interview


Role Context

Own ETL architecture patterns, reusable frameworks, and standardization for multi-source data integration. Ensures scalability, maintainability, and governance across ETL delivery, aligning to product roadmap and data model strategy.

Key Responsibilities

  • Define reference architecture for ETL/ELT pipelines: ingestion → transform → serving layers.
  • Establish standards for metadata/config-driven ETL, naming, error handling, and replay.
  • Design scalable patterns for CDC, incremental processing, backfills, and dependency orchestration.
  • Define CI/CD patterns for ETL and govern environment promotions.
  • Define observability standards: logs, metrics, lineage, data quality monitoring, SLAs.
  • Review designs for performance, cost, security, and operational readiness.
  • Align ETL patterns with data modelling and downstream analytics/ML needs.

Must Have

  • 8 to 12 years in data engineering with strong ETL architecture ownership.
  • Expertise across ETL tools/frameworks (dbt + orchestration, ADF/Glue/Informatica/Talend etc.).
  • Strong SQL performance and warehouse optimization knowledge.
  • Airflow (or equivalent) architecture-level orchestration design.
  • Python capability for framework/tooling design and automation.
  • Strong knowledge of cloud data architecture (AWS/Azure/GCP).
  • Delivery engineering maturity: CI/CD, versioning, release discipline, rollback strategies.
  • Non-technical: strong documentation, workshop facilitation, ability to influence teams.

Good To Have

  • Experience with event streaming architectures (Kafka) and lakehouse patterns.
  • Exposure to data catalog/lineage tooling and governance practices.
  • Familiarity with ML pipeline needs (feature readiness, time semantics).

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You

pune, maharashtra, india

pune, maharashtra, india

pune, maharashtra, india

pune, maharashtra, india

ghaziabad, uttar pradesh, india