NTT DATA North America · 1 day ago
DBT Junior Engineer
NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. They are currently seeking a DBT Junior Engineer to join their team, responsible for translating Informatica mappings into dbt models and ensuring data quality through various testing and documentation processes.
ConsultingDigital MarketingInformation ServicesInformation TechnologyIT Management
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
Qualification
Required
3–6 years of experience in Data Engineering / ETL / DW, with 1–3+ 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
Preferred
Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable
Company
NTT DATA North America
NTT DATA, Inc. is a trusted global innovator of business and technology services.
H1B Sponsorship
NTT DATA North America has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (144)
2024 (182)
2023 (257)
2022 (871)
2021 (809)
2020 (1266)
Funding
Current Stage
Late StageRecent News
2025-12-05
Company data provided by crunchbase