ETL Test Engineer (Remote, KA, IN)
NTT DATA
IndiaremotePosted 8 days ago
Skill Required
ETL-Testing-EngineerOffshore-Dbt-DeveloperData-EngineerETL-DeveloperData-Warehouse-EngineerETL-Test-ArchitectETL-Data-EngineerSenior-ETL-EngineerETL-EngineerTest-EngineerETLQuery Optimizationdata engineeringGitHub ActionsData StructuresCD pipelinesAzureWeb AccessibilityInformaticaEngineeringSnowflakesecuritydesignDevOpsGitCI/CDClouddbtSQLandCICDAIFulltime
Key highlights
- Role: Offshore dbt Developer / ETL Test Engineer
- Location: Remote, Karnātaka, India
- Experience: 7+ years in Data Engineering/ETL
- Skill Required: 2+ years dbt (Core or Cloud)
- Environment: Snowflake and modern cloud DW
- Company Rank: Global Top Employer
Role overview
NTT DATA is currently seeking an ETL Test Engineer to join their team as an Offshore dbt Developer in Remote, Karnātaka, India. The role involves translating legacy Informatica mappings into dbt models on Snowflake, designing data layers, and ensuring data quality through automated testing and CI/CD integration.
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.
- 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.
Benefits
- Remote or hybrid work options (subject to change based on client requirements).
- Inclusion in a Global Top Employer organization.
- Access to a robust ecosystem of innovation centers and partners.
- Equal opportunity employer commitments and EEO rights protection.
Additional details
- Req ID: 385640
- Location: Remote, Karnātaka (IN-KA), India (IN)
- Company: NTT DATA, a $30 billion business and technology services leader serving 75% of the Fortune Global 100.
- NTT Group invests over $3 billion each year in R&D.
- Recruitment Safety: 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.
- Accessibility: If you need assistance completing the application process, contact information is provided for accommodation requests (cannot be used for application status inquiries).
- Equal Opportunity Statement: Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
- Local Hiring Policy: NTT DATA hires locally to offices or client sites whenever possible to provide timely support.
- Office Attendance: For employees near an office or site, in-person attendance may be required for meetings or events based on business needs.
- Source: Originally posted on Himalayas.