Position : Senior Data Engineer-DBT Snowflake

Location : Chennai/Pune/Bangalore/Nagpur

Type of Employment : Full-time

Key Result Areas and Activities :

- DBT Architecture Strategy & Standardization - Define enterprise dbt architecture standards, layering conversions, naming framework, and modular transformation design approaches supporting large scale modernisation programmes.

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

- Legacy ETL Migration Enablement - Lead transformation strategies of migrating SSIS pipelines to dbt-based ELT framework while ensuring consistency scalability and maintainability.

- Reusable Framework & Accelerator Development - Establish micros libraries, reusable template migration accelerator to improve delivery efficiency across multiple transformation streams.

- Data Quality & Validation Strategy :

- Define reconciliation strategies/methodologies, parallel-run validation framework, and transformation testing standard supporting enterprise analytics reliability.

- Performance Alignment with Snowflake Platform - Collaborate with snowflake engineering teams to optimise execution strategy clustering approaches and warehouse utilization.

- Governance, CI/CD & Delivery Oversight -Establish version control standards, CI/CD integration practice as, and documentation framework supporting controlled migration execution.

- 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 Snowflake engineers,



QA team and client stakeholders to resolve transformation discrepancies and ensure timely migration delivery

Essential Skills :

- Robust experience designing enterprise-scale dbt transformation architecture
- Hands-on experience leading legacy ETL modernization programs (SSIS to ELT)
- Experience developing reusable macros framework and modelling standards
- Experience implementing incremental pipeline architecture at scale
- Experience defining data validation and reconciliation framework
- Strong enterprise in dimensional modelling and analytical layer design
- Hands-on experience optimising Snowflake transformation workload
- Experience implementing CI/CD workflow for transformation deployments
- Familiarity with version control systems (GIT/Azure DevOps)

Desirable Skills :

- Exposure implementing dbt mesh architecture
- Exposure to metadata driven transformation framework
- Experience integrating governance and lineage tooling
- Familiarity with terraform based infrastructure automation
- Exposure to enterprise data platform modernization programs
- Experience collaborating with platform engineer teams for workload optimization
- Experience mentoring junior engineers in transformation programs

Qualifications :

- Experience :7+ years of experience in data engineering, ETL/ELT development, hands-on dbt development.
- Education :Bachelor’s in computer science, Information Technology, or equivalent.

Qualities :

- Architecture-first thinking
- Ability to work with cross-functionally dependent teams and stakeholder alignment
- Migration risk anticipation capability
- Delivery acceleration mindset
- Validation strategy planning and Defect triage prioritization
- Detail-oriented with focus on data accuracy and reliability
- Attention to transformation accuracy

Location

Chennai, Tamil Nadu, India

Years Of Exp

7 to 9 years

📌 Senior Data Engineer- Dbt Snowflake (Chennai)
🏢 InfoCepts
📍 Chennai