Position : Data Engineer

- DBT Snowflake

Location : Pune/ Nagpur/ Chennai/ Bangalore

Type of Employment : Full-time

Key Result Areas and Activities :

- Code conversion, refinement and optimization - Convert complex SSIS transformations into dbt staging/intermediate/mart models, review and validate tool converted dbt transformations to ensure accuracy maintainability alignment with enterprise modelling standards.
- Data Quality Framework Implementation -Define reconciliation strategies, implement automated validation checks, and ensure regression coverage across transformation pipeline.
- Incremental Pipeline Implementation - Implement incremental loading strategies, snapshots and dependency-aware model execution to support efficient and scalable transformation workflows.
- Documentation and lineage support - Maintain transformation documentation, mapping logic, testing evidence, and lineage metadata to support governance and audit readiness.
- Collaboration & Delivery Support - Work closely with Cross-functional teams and client stakeholders to resolve transformation discrepancies and ensure timely migration delivery
- ETL/ELT Development & Integration - Build and maintain ETL/ELT workflows using Snowflake-native features or external tools (DBT, Airflow).
- Performance Optimization & SQL Tuning - Optimise transformation logic for snowflake execution efficiency insuring balance compute utilization and query performance.
- Migration governance and tribute support - R eview transformation output, mentor junior engineers to ensure adherence to modelling standards documentation practices and delivery timelines.

Essential Skills :

- Strong SQL optimization and transformation design experience




- Hands-on experience with dbt core and dbt cloud implementations
- Experience designing staging, intermediate, and mart transformation layer
- Experience implementing incremental load and SCD type 2 strategies
- Experience converting legacy ETL pipelines (SSIS/Informatica/ADF) into ELT frameworks
- Experience developing reusable macros and modular transformation framework
- Experience performing reconciliation automation and regression validation
- Understanding of dimension data modelling and warehouse designing principles
- Hands-on experience working with Snowflake transformation workloads
- Familiarity with version control systems (GIT/Azure DevOps)

Desirable Skills :

- Exposure to dbt mesh architecture implementation
- Experience supporting UAT validation cycle and migration sign-off
- Experience with Airflow orchestration integration
- Exposure to CI/CD pipeline implementation for dbt deployment
- Knowledge of metadata management or data catalogue integration
- Experience mentoring junior engineers in transformation programmes

Qualifications :

- Experience :5+ years of experience in data engineering, ETL/ELT development, hands-on dbt development and Exposure to mentoring engineers preferred
- Education :Bachelor’s or master’s degree in computer science, Information Technology, or equivalent.

Qualities :

- Solid ownership, analytical and problem-solving mindset
- Cross-team coordination capability
- Structured Troubleshooting approach
- Validation strategy planning and Defect triage prioritization
- Detail-oriented with focus on data accuracy and reliability
- Attention to transformation accuracy
- Good communication and collaboration skills

Location

Pune, Maharashtra, India

Years Of Exp

5 to 7 years

📌 Data Engineer-dbt Snowflake (Pune)
🏢 InfoCepts
📍 Pune