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 $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
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