DBT/Snowflake Engineer Job at NTT America, Indiana, PA

  • NTT America
  • Indiana, PA

Job Description

Offshore dbt Developer Roles & 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. Experience & Skills 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. Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable. 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. #J-18808-Ljbffr NTT America

Job Tags

Similar Jobs

White Glove Community Care

ABA Early Intervention Position Job at White Glove Community Care

 ...Description Job Description Do you have experience in working with SEIT? This job is for you. We are seeking a dedicated ABA Early Intervention teachers to join our team. The ideal candidate will have a passion for working with young children and possess the necessary... 

Pepsico

Data Entry / Data Quality Specialist — Full-Time & Part-Time Remote Job at Pepsico

Job OverviewWe're looking for a reliable and detail-oriented Data Entry / Data Quality Specialist to help maintain accurate business records and support daily administrative operations.In this role, you'll enter, review, organize, and verify information across company...

Lucid Staffing Solutions

Travel Occupational Therapist (OT) - $2,557 per week in Mount Clemens, MI Job at Lucid Staffing Solutions

 ...with real clinical experience ~ In-House Compliance: fast updates, real communication, and none of the delays that come with outsourced vendors. ~ Health Coverage Options: Multiple medical plans plus dental, vision, and workers compensation ~401(k) Match:... 

HII's Mission Technologies division

Facilities Operations Assistant Job at HII's Mission Technologies division

 ...Warfare Systems (WS) , a business group within HIIs Mission Technologies division. Warfare Systems comprises cyber and mission IT; electronic...  ..., and personnel operations. The Facilities Operations Assistant provides technical support for the daily maintenance,... 

Industrial Valve

Pipeline Technician Job at Industrial Valve

 ...Competitive Benefits: Enjoy our benefits package that includes Medical, Dental, and Vision insurance (among other plans), competitive...  ...Bending, stooping, and walking Lift up to 50 pounds HUET and swing rope training Work Offshore when needed Work Out of town...