ETL Test Engineer (Remote, KA, IN)
NTT DATA
IndiaremotePosted 27 days ago
Skill Required
ETL-Testing-EngineerOffshore-Dbt-DeveloperData-EngineerETL-DeveloperData-Warehouse-EngineerETL-Test-ArchitectRemote-Test-Automation-EngineerRemote-Quality-Assurance-EngineerRemote-QA-EngineerRemote-Software-Development-Engineer-In-TestSenior-ETL-EngineerETL-EngineerRemote-QA-AnalystTest-EngineerETLQuery Optimizationdata engineeringGitHub ActionsData StructuresCD pipelinesAzureWeb AccessibilityInformaticaEngineeringSnowflakesecuritydesignDevOpsGitCI/CDClouddbtSQLandCICDAIFulltime
Key highlights
- Required Experience: 7+ years in Data Engineering/ETL/DW (2+ years in dbt)
- Location: Remote, Karnātaka, India
- Key Requirement: Strong SQL skills on Snowflake
- Key Requirement: Experience with dbt concepts and CI/CD integration
Role overview
NTT DATA is seeking an ETL Test Engineer (Offshore dbt Developer) to join their team in Remote, Karnātaka (IN-KA), India (IN). The role involves migrating legacy Informatica mappings and business rules into dbt models on Snowflake, ensuring data quality and functional equivalence during the migration process.
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 (schema tests, data tests, custom tests) to ensure data quality and integrity.
- Implement snapshots, seeds, macros, and reusable components where appropriate.
- Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently.
- Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs.
- Participate in performance tuning of dbt models and Snowflake queries.
- Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations.
- Contribute to documentation of dbt models, data lineage, and business rules.
- Participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases.
Requirements
- 7+ years of experience in Data Engineering / ETL / DW, with 2+ years working with dbt (Core or Cloud).
- Strong SQL skills, especially on Snowflake or another modern cloud DW.
- Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures.
- Understanding of CI/CD practices and integrating dbt into automated pipelines.
- Knowledge of data modeling (dimensional models, SCDs, fact/dimension design).
- Experience working in offshore delivery with onshore coordination.
- Good communication skills and ability to read/understand existing ETL logic and requirements documentation.
Nice to have
- Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable.
Additional details
- Req ID:385640
- Location: Remote, Karnātaka (IN-KA), India (IN)
- NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100.
- NTT DATA is a Global Top Employer with experts in more than 50 countries and is part of NTT Group, which invests over $3 billion each year in R&D.
- While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements.
- For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs.
- NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses.
- NTT DATA is an equal opportunity employer.
- Originally posted on Himalayas