Data Migration Engineer (Informatica / dbt)

Predoole Analytics Pvt. Ltd.

Mumbai

On-site

INR 1,200,000 - 1,800,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Predoole Analytics Pvt. Ltd. is seeking a mid-level Data Migration Engineer to bridge traditional ETL with modern dbt-based pipelines. You will work on Informatica and dbt migrations, aiming for scalable data warehouses in the cloud.

The role focuses on designing, building, and validating data pipelines, collaborating with CI/CD teams, and ensuring data quality across Snowflake/BigQuery/Azure Synapse environments. 3+ years of experience required.

Qualifications

  • 3+ years of total IT/data engineering experience with a strong focus on data integration and warehousing.
  • Hands-on experience with Informatica PowerCenter, IDMC, or PowerCenter designer—building mappings, mapplets, sessions, and workflows.
  • dbt Core or dbt Cloud (model layering, writing macros, running tests, and incremental updates).
  • SQL & Python: Advanced SQL skills (complex joins, window functions, CTEs) and working knowledge of Python for scripting or automation.
  • Cloud Data Warehouses: Snowflake, Google BigQuery, or Azure Synapse/Databricks.
  • Orchestration/DevOps: Familiarity with Apache Airflow, Git-based workflows, and CI/CD concepts

Responsibilities

  • ETL / ELT Development: Design, build, and support data pipelines using Informatica PowerCenter / IDMC and dbt Core/Cloud.
  • Migration Support: Assist in refactoring and migrating legacy Informatica mappings, workflows, and stored procedures into modular dbt models (SQL/Jinja).
  • Data Modeling & Transformation: Build clean data warehouse layers (Staging, Intermediate, Marts) using dbt best practices.
  • Orchestration & Automation: Help orchestrate workflows using Apache Airflow or cloud-native schedulers.
  • Testing & Data Quality: Implement dbt tests and reconcile row counts/data discrepancies.
  • Collaboration & CI/CD: Work with Git/GitHub/GitLab for version control, participating in code reviews and CI/CD deployment pipelines.

Skills

SQL
Python
ETL/ELT
Data Warehousing

Tools

Informatica PowerCenter
IDMC
dbt Core/Cloud
Apache Airflow
Git/GitHub/GitLab

Job description

Data Migration Engineer (Informatica / dbt)

We are looking for a mid-level Data Engineer with 3+ years of experience to help maintain existing Informatica data integration pipelines while leading or assisting in the modern migration to dbt (data build tool) and cloud data platforms. You will bridge traditional ETL architectures with modern analytics engineering best practices

Key Responsibilities

ETL / ELT Development: Design, build, and support data pipelines using Informatica PowerCenter / IDMC (Intelligent Data Management Cloud) and dbt Core/Cloud.

Migration Support: Assist in refactoring and migrating legacy Informatica mappings, workflows, and stored procedures into modular dbt models (SQL/Jinja).

Data Modeling & Transformation: Build clean data warehouse layers (Staging, Intermediate, Marts) using dbt best practices, including incremental materializations, macro development, and snapshots.

Orchestration & Automation: Help orchestrate workflows using tools like Apache Airflow or cloud-native schedulers.

Testing & Data Quality: Implement dbt tests (unique, not_null, accepted_values, custom assertions) and reconcile row counts/data discrepancies between source systems and the target warehouse.

Collaboration & CI/CD: Work with Git/GitHub/GitLab for version control, participating in code reviews and CI/CD deployment pipelines.

Desired Candidate Profile

Experience: 3+ years of total IT/data engineering experience with a strong focus on data integration and warehousing.

Informatica: Hands-on experience with Informatica PowerCenter, IDMC, or PowerCenter designer—building mappings, mapplets, sessions, and workflows.

dbt (Data Build Tool): Practical experience with dbt Core or dbt Cloud (model layering, writing macros, running tests, and incremental updates).

SQL & Python: Advanced SQL skills (complex joins, window functions, CTEs) and working knowledge of Python for scripting or automation.

Cloud Data Warehouses: Exposure to Snowflake, Google BigQuery, or Azure Synapse/Databricks.

Orchestration/DevOps: Familiarity with Apache Airflow, Git-based workflows, and CI/CD concepts

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DBT Migration Developer (Informatica to dbt)
DBT Migration Developer (Informatica to dbt)

Trinity Technology Solutions LLC • Chennai

On-site
INR 800,000 - 1,200,000
Data Migration Engineer (Informatica / DBT)
Data Migration Engineer (Informatica / DBT)

Predoole Analytics • Mumbai, Pune District

On-site
INR 1,200,000 - 1,800,000
Data Engineer DBT
Data Engineer DBT

Multiverse Solutions • Dadri

On-site
INR 900,000 - 1,300,000
Sr Tech Data Validation & DBT Engineer
Sr Tech Data Validation & DBT Engineer

NTT DATA, Inc. • Bengaluru

On-site
INR 1,200,000 - 2,400,000
DBT/Snowflake Engineer
DBT/Snowflake Engineer

NTT DATA, Inc. • Bengaluru

On-site
INR 4,000,000 - 7,000,000
Senior DBT Engineer
Senior DBT Engineer

Saama Technologies • Pune District, Chennai

Hybrid
INR 3,000,000 - 5,000,000
Senior Data Engineer
Senior Data Engineer

Infomagnus • Hyderabad

Hybrid
INR 2,500,000 - 5,000,000
Data Migration Engineer (SWP Workstream)
Data Migration Engineer (SWP Workstream)

NTT DATA, Inc. • Gurugram District

On-site
INR 1,800,000 - 3,200,000
Data Engineer
Data Engineer

atsMantra® • Hyderabad

On-site
INR 1,500,000 - 2,600,000
Informatica Data Engineer
Informatica Data Engineer

Pwc India • Bengaluru

On-site
INR 1,000,000 - 1,400,000