Data Migration Engineer (Informatica / DBT)

Predoole Analytics

Mumbai, Pune District

Sur place

INR 1 200 000 - 1 800 000

Plein temps

14 jours+

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Predoole Analytics is seeking a Data Migration Engineer (Informatica / dbt) to maintain ETL pipelines and lead the migration toward dbt and cloud data platforms. You will bridge traditional ETL with modern analytics engineering best practices.

The role requires 3+ years of data engineering experience, hands-on Informatica and dbt expertise, and familiarity with Airflow and CI/CD. Located in Mumbai/Pune with strong collaboration across the analytics team.

Qualifications

  • 3+ years of IT/data engineering experience focused on data integration and warehousing.
  • Hands-on with Informatica PowerCenter, IDMC, or PowerCenter designer-building mappings.
  • dbt Core or dbt Cloud experience (model layering, macros, tests, incremental updates).
  • Advanced SQL skills (complex joins, window functions, CTEs) and Python for scripting.
  • Cloud data warehouses exposure: Snowflake, BigQuery, or Azure Synapse/Databricks.
  • Familiarity with Apache Airflow, Git-based workflows, and CI/CD concepts.

Responsabilités

  • ETL/ELT development using Informatica PowerCenter/IDMC and dbt Core/Cloud.
  • Assist in migrating legacy Informatica mappings and workflows into dbt models.
  • Build data warehouse layers (Staging, Intermediate, Marts) with dbt.
  • Help orchestrate workflows with Airflow or cloud schedulers.
  • Implement dbt tests and reconcile data between sources and warehouse.
  • Collaborate on CI/CD deployments with Git and review code.

Connaissances

3+ years experience
SQL
Python

Outils

Informatica PowerCenter
IDMC
dbt Core/Cloud
Apache Airflow
Git/GitHub/GitLab
Snowflake
BigQuery
Azure Synapse/Databricks

Description du poste

Job Description

Data Migration Engineer (Informatica / dbt)

Predoole Analytics

Location: Mumbai / Pune

Function: Analytics Team

Reporting to: Technical Account Manager

Experience: 3- 5 years of relevant experience

About Predoole Analytics

Predoole Analytics is a 17-year-old company, leader in the business of data analytics and intelligence, focused on helping organizations derive actionable business insights through technology.

Role Purpose

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 designerbuilding 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
Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Data Migration Engineer (Informatica / dbt)
Data Migration Engineer (Informatica / dbt)

Predoole Analytics Pvt. Ltd. • Mumbai

Sur place
INR 1 200 000 - 1 800 000
DBT Migration Developer (Informatica to dbt)
DBT Migration Developer (Informatica to dbt)

Trinity Technology Solutions LLC • Chennai

Sur place
INR 800 000 - 1 200 000
Assistant Manager- Data Engineer- Mumbai
Assistant Manager- Data Engineer- Mumbai

BDO India • Mumbai

Sur place
INR 1 500 000 - 2 200 000
Data Migration Engineer (SWP Workstream)
Data Migration Engineer (SWP Workstream)

NTT DATA, Inc. • Gurgaon

Sur place
INR 1 800 000 - 2 400 000
Data Engineer- DBT
Data Engineer- DBT

AuxoAI • Bengaluru Urban

Sur place
INR 1 500 000 - 2 500 000
Data Specialist – R01573377
Data Specialist – R01573377

Brillio • Bengaluru

Sur place
INR 1 200 000 - 1 600 000
Data Engineer DBT
Data Engineer DBT

Multiverse Solutions • Dadri

Sur place
INR 900 000 - 1 300 000
Data Engineer (DBT) (2-6 Years ) Pune
Data Engineer (DBT) (2-6 Years ) Pune

Acceline Digital Media Private Limited • Pune

Sur place
INR 1 200 000 - 1 800 000
Data Engineer (DBT)
Data Engineer (DBT)

Accel Digital Ad Operations • Maharashtra

Sur place
INR 1 200 000 - 2 400 000
Data Engineer – Databricks & dbt
Data Engineer – Databricks & dbt

Durapid Technologies Pvt Ltd • Inde

À distance
INR 2 617 000 - 7 850 000