ETL Test Engineer

NTT
Bengaluru
Workplace: OnsiteFull timeFunction: QA, Test & Release EngineeringExperience: 7+ yearsSkills: ["Communication","Collaboration"]

Translate legacy Informatica mappings, transformations, and business rules into dbt models running on Snowflake. Build staging, core, and mart layers with standard dbt patterns, and create dbt tests and data quality checks (including custom tests, snapshots, seeds, and macros). Collaborate with Snowflake developers and functional teams to ensure output equivalence, and support migration through defect analysis, bug fixes, and performance tuning, including CI/CD automated runs.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
NTT
NTT
3 weeks ago

ETL Test Engineer

✓ Verified Job

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

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

Job Summary

Translate legacy Informatica mappings, transformations, and business rules into dbt models running on Snowflake. Build staging, core, and mart layers with standard dbt patterns, and create dbt tests and data quality checks (including custom tests, snapshots, seeds, and macros). Collaborate with Snowflake developers and functional teams to ensure output equivalence, and support migration through defect analysis, bug fixes, and performance tuning, including CI/CD automated runs.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: QA, Test & Release Engineering
Seniority: Mid level

Key Responsibilities

  • •Translate Informatica mappings, transformations, and business rules into dbt models (SQL) on Snowflake.
  • •Design and implement dbt staging, core, and mart layers using standard patterns and folder structures.
  • •Develop and maintain dbt tests to ensure data quality and integrity.
  • •Collaborate with Snowflake developers and functional teams to ensure efficient physical data structures and functional equivalence.
  • •Integrate dbt into CI/CD pipelines and support defect analysis, bug fixes, and performance tuning during migration and stabilization.

Key Requirements

  • •7+ years of experience in Data Engineering/ETL/Data Warehousing, including 2+ years working with dbt (Core or Cloud).
  • •Strong SQL skills, especially with Snowflake or another modern cloud data warehouse.
  • •Experience with dbt concepts such as models, tests, sources, seeds, snapshots, and macros.
  • •Prior Informatica experience (developer-level understanding of mappings/workflows) is highly desirable.
  • •Knowledge of CI/CD practices for integrating dbt into automated pipelines and collaborating with onshore/onshore coordination.
Experience:7+ yearsData engineeringETLData warehousingSnowflakeDbtInformatica
Skills:CommunicationCollaboration
Tech Stack:DbtSQLSnowflakeInformaticaAzure DevOpsGitHub ActionsCI/CDData modelingDimensional modelsSCDsFact/dimension design

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