ETL Test Engineer

NTT
Karnataka
Workplace: RemoteFull timeFunction: OtherExperience: 7+ yearsSkills: ["Communication","Migration","Performance tuning"]

Translate Informatica mappings and business rules into dbt models using SQL on Snowflake. Build staging, core, and mart layers with standard dbt patterns, and ensure data quality through dbt tests, snapshots, and reusable components. Tune model and query performance, integrate dbt with CI/CD pipelines, and document data lineage and business logic. Collaborate with Snowflake and functional teams to validate equivalence during migration and stabilization.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
NTT
NTT
1 week ago

ETL Test Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 15 hours agoStatus: Live

Job Summary

Translate Informatica mappings and business rules into dbt models using SQL on Snowflake. Build staging, core, and mart layers with standard dbt patterns, and ensure data quality through dbt tests, snapshots, and reusable components. Tune model and query performance, integrate dbt with CI/CD pipelines, and document data lineage and business logic. Collaborate with Snowflake and functional teams to validate equivalence during migration and stabilization.
Location: Karnataka
Workplace: Remote
Employment Type: Full time

Key Responsibilities

  • •Translate Informatica mappings, transformations, and business rules into dbt models (SQL) on Snowflake.
  • •Design and implement staging, core, and mart layers using standard dbt patterns and folder structures.
  • •Develop and maintain dbt tests, snapshots, seeds, macros, and reusable components to ensure data quality and integrity.
  • •Collaborate with Snowflake developers to align physical data structures with dbt model efficiency.
  • •Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) and support migration by analyzing defects, fixing bugs, and improving models.

Key Requirements

  • •7+ years of experience in Data Engineering/ETL/Data Warehousing, including 2+ years with dbt (Core or Cloud).
  • •Strong SQL skills, especially with Snowflake or another modern cloud data warehouse.
  • •Experience with dbt concepts including models, tests, sources, seeds, snapshots, and macros.
  • •Prior experience with Informatica mapping/workflows (developer-level understanding) is highly desirable.
  • •Knowledge of data modeling (dimensional models, SCDs, fact/dimension design) and CI/CD practices for automated pipelines.
Experience:7+ yearsData engineeringETLData warehousingDbtSnowflakeCI/CDOffshore delivery
Skills:CommunicationMigrationPerformance tuning
Tech Stack:DbtSQLSnowflakeInformaticaAzure DevOpsGitHub ActionsCI/CDDimensional modelingSCDCI/CD pipelines

Company Brief

NTT
Dimension Data, operating under NTT Ltd, provides managed IT services, cloud and data center solutions, networking, cybersecurity, and digital transformation services to enterprise customers worldwide.
Industry: Professional Services
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Established Company
Valuation: Public Company (Market Cap in USD)
Headquarters: London, United Kingdom
Founded: 1983
WebsiteLinkedIn