DBT Junior Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

NTT DATA North America · 1 day ago

DBT Junior Engineer

NTT DATA is a leading business and technology services provider, committed to innovation and client success. They are seeking a DBT Junior Engineer to translate Informatica mappings into dbt models, implement data quality tests, and collaborate with Snowflake developers to ensure efficient data structures.

ConsultingDigital MarketingInformation ServicesInformation TechnologyIT Management
check
H1B Sponsor Likelynote

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

DbtSQLSnowflakeInformaticaCI/CD practicesData modelingOffshore delivery experienceCommunication skills

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

company-logo
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 Stage

Leadership Team

leader-logo
John Barr
Vice President - Insurance Strategy
linkedin
Company data provided by crunchbase