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.
...Salesforce Business Analyst Colorado Springs, CO 80920 OR Owings Mills, MD 21117 OR Onsite Day 1: Hybrid Model: 3 Days Onsite! 12 + Months Requirements gathering (working with users and partners to gather details) User story writing Managing a feature from end to...
...Description Job Description 45Press is looking for a creative Graphic Designer to join our team. He/she will be primarily responsible for delivering website designs, logos, email marketing campaigns, web banners, and more. The position is full-time on-site at our...
...Travel Medical Assistant Bring preventive healthcare directly to patients in their homes across Washington. In this field-based Medical Assistant role, you'll start with home visits in Clark County, WA and help seniors and families complete wellness-focused visits...
...Ingredion Incorporated in Bridgewater, NJ is seeking a Summer 2027 Digital Innovation Intern to accelerate predictive formulation and digital capabilities across the organization. You will work with formulation scientists and digital leaders to develop AI-powered tools...
...Job Description Its time for a sweeping change to your career so that you can pursue what matters to you! At Aramark, making sure we provide clean environments is something in which we take pride and is a skill set that can help take you further in your career....