- 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.
- 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
- Robust 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: 9+ 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
- Collaboration & Delivery Support - Work closely with Snowflake engineers, QA team and client stakeholders to resolve transformation discrepancies and ensure timely migration delivery
Location
Pune, Maharashtra, India
Years Of Exp
9 to 12 years
📌 Data Architect- Dbt (Snowflake) (Pune)
🏢 InfoCepts
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.