Data Engineer (Fivetran)

Job Description:

Must have Skills - FiveTran, Terraform and CI/CD

Location - Gurugram

We are seeking a Data Engineer with experience building and managing ingestion

pipelines using FiveTran, Python-based custom connectors, and cloud data platforms.

The role focuses on onboarding multiple source systems into the Bronze (raw) layer of an

enterprise data ecosystem, ensuring ingestion accuracy, reliability, and scalability.

Key Responsibilities

Data Ingestion & Pipeline Development

Develop and deploy custom FiveTran connectors using Python to ingest data from

systems that do not have native connectors.

Integrate data using standard FiveTran connectors for platforms such as CRM tools,

contact-center systems, SaaS platforms, and ERP or operational systems.

Build pipelines to ingest data from:

o Custom operational systems (via API or custom Python connector)

o Call center / workforce management systems (via FiveTran)

o Healthcare / operational software platforms (via custom Python-based connector)

o CRM systems (via FiveTran)

o Marketing and advertising platforms

Data Quality & Monitoring

Implement monitoring, logging, and alerting to ensure data freshness, completeness,

and schema stability.

Troubleshoot ingestion failures, API issues, connector errors, or schema drifts.

Data Modeling & Layering

Collaborate with data architecture teams to support ingestion patterns for

downstream Silver and Gold layer transformations.

Handle incremental loads, batch ingestion, and CDC (Change Data Capture) where

applicable.

Documentation & Collaboration

Maintain documentation, runbooks, and pipeline design specs.

Work with cross-functional teams across engineering, analytics, and product to

prioritize ingestion work.

Required Skills & Experience

5 - 7 years of Data Engineering experience.

Strong proficiency in Python, including API integration and ETL/ELT scripting.

Experience with FiveTran (connectors, setup, troubleshooting, and customization).

Hands-on experience with major cloud platforms (AWS, Azure, GCP) and modern data

warehouses (Snowflake, Redshift, Databricks, BigQuery).

Understanding of ingestion design, data lake architecture, and schema evolution.

Preferred Qualifications

Experience with orchestration tools (Airflow, Dagster, Prefect).

Exposure to CRM, marketing, operational, or call-center data structures.

Knowledge of metadata management, data governance, and data quality frameworks.

Soft Skills

Strong analytical and debugging mindset.

Ability to work autonomously in fast-paced environments.

Clear communication and documentation capabilities.

Strong cross-team collaboration skills.