Snowflake DBT

3 weeks ago

Chennai India Virtusa Full time

Job Description Job Description: ETL Modernization Engineer (OSP Partner) This role is for an OSP provider resource to migrate legacy ETL pipelines (Informatica/Talend) to a modern data stack on Snowflake, dbt, and Fivetran, with strong DataOps, governance, and cost-aware design. Target experience: 7 to 8 years. Role Summary Lead end to end migration of legacy ETL workloads to Snowflake dbt Fivetran, including discovery, design, refactoring, validation, and cutover. Establish reusable patterns for ingestion, transformation, orchestration, testing, observability, and cost optimization. Collaborate with Enterprise Data Architecture, Security, and BI teams to ensure compliant, high-performance delivery. Key Responsibilities Assess current-state: inventory Informatica/Talend jobs, mappings, schedules, dependencies, SLAs, and data contracts. Design target-state: ingestion via Fivetran/ELT, dbt-based transformations, Snowflake schemas (raw/bronze, curated/silver, semantic/gold), and orchestration approach. Migrate And Refactor Convert mappings/workflows to dbt models, macros, seeds, and exposures. Replace hand-coded ingestions with managed connectors (Fivetran) or alternative ELT where required. Implement CDC patterns (e.g., Fivetran + dbt snapshots), SCD handling, and incremental strategies. Data quality and testing: implement dbt tests (schema, referential, accepted values, freshness), anomaly checks, and reconciliation with legacy outputs. Performance engineering: optimize Snowflake warehouses, clustering/partitioning strategies, query tuning, caching/materialization patterns, and costs. Security and governance: apply RBAC roles, masking, row access policies; integrate with lineage/catalog (e.g., OpenLineage/Marquez, Collibra/Atlan/Alation if applicable). Observability and reliability: configure logging/metrics, job run health, SLAs/SLOs, alerting, and incident runbooks. Cutover planning: parallel runs, backfills, data reconciliation, defect triage, rollout, and decommissioning legacy jobs. Documentation and knowledge transfer: architecture diagrams, runbooks, playbooks, and training for client teams. Required Skills And Experience 7 to 8 years in data engineering/ETL modernization with demonstrable migration projects from Informatica or Talend to ELT on cloud data warehouses. Hands on with Snowflake (warehouses, tasks, streams, time travel, Query Profile), performance tuning, security policies, and cost governance. Strong dbt expertise: model design, Jinja/macros, packages, exposures, snapshots, environment promotion, and CI/CD with Git. Practical Fivetran experience: connector configuration, sync scheduling, historical backfills, log based CDC, schema drift handling. Proficient SQL (advanced), with Python preferred for utilities e.g., migration scripts, validation Experience building star/snowflake schemas, dimensional modeling, and semantic layers for BI tools Power BI/Looker/Tableau DataOps and CI/CD: branching strategies, automated tests, deployment pipelines, environment management. Data quality frameworks and reconciliation techniques for migration sign off. Strong stakeholder management: work with architects, security, BI, and business SMEs in phased migration programs. Deliverables Current state inventory and dependency map of legacy pipelines. Target state architecture and migration plan, including cutover strategy. Re platformed pipelines: Fivetran connectors, dbt project(s), Snowflake schemas, roles, and policies.

  • Snowflake DBT

    1 week ago

    Chennai, India Virtusa Full time

    Job Description Data Pipeline Development Design develop and maintain efficient reliable and reusable ETLELT pipelines using DBT Snowflake and related technologies Data Modeling Build and optimize data models star snowflake schemas to support analytical and reporting use cases ensuring data quality accuracy and performance Data Integration Integrate data...

  • Snowflake DBT

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Referral Program Full time

    Data Pipeline DevelopmentDesign develop and maintain efficient reliable and reusable ETLELT pipelines using DBT Snowflake and related technologiesData ModelingBuild and optimize data models star snowflake schemas to support analytical and reporting use cases ensuring data quality accuracy and performanceData IntegrationIntegrate data from multiple sources...

  • Snowflake DBT

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Data Pipeline DevelopmentDesign develop and maintain efficient reliable and reusable ETLELT pipelines using DBT Snowflake and related technologiesData ModelingBuild and optimize data models star snowflake schemas to support analytical and reporting use cases ensuring data quality accuracy and performanceData IntegrationIntegrate data from multiple sources...

  • Snowflake + DBT Engineer

    4 weeks ago

    India MindBrain Full time

    Snowflake + DBT EngineerLocation: Pune — Remote/HybridExperience: 8+ yearsJob DescriptionWe are looking for a highly experienced Snowflake + DBT Engineer to architect, build, and optimize modern cloud data platforms. The ideal candidate should have deep expertise in Snowflake, ELT frameworks, and DBT transformations.ResponsibilitiesDesign and develop...

  • Snowflake Dbt

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Snowflake Management: SQL Proficiency: Write, execute, and troubleshoot SQL queries to extract, transform, and load data within Snowflake. Snowflake Administration: Understand user management, security policies, and warehousing concepts like materialized views and clustering keys. Snowflake Monitoring: Identify and troubleshoot performance issues within the...

  • Snowflake DBT

    2 days ago

    Chennai, Tamil Nadu, India Virtusa Referral Program Full time

    DBT responsibilities include designing, developing, and handling technical architecture, data pipelines, and performance scaling using tools to integrate Talend data and ensure data quality in a big data environment. The candidate must be very strong in PL/SQL, including queries, procedures, and JOINs. Experience in Snowflake SQL, writing SQL queries against...

  • Snowflake DBT

    2 days ago

    Chennai, Tamil Nadu, India Virtusa Full time

    DBT responsibilities include designing, developing, and handling technical architecture, data pipelines, and performance scaling using tools to integrate Talend data and ensure data quality in a big data environment. The candidate must be very strong in PL/SQL, including queries, procedures, and JOINs. Experience in Snowflake SQL, writing SQL queries against...

  • Snowflake Dbt

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Job Description: ETL Modernization Engineer (OSP Partner) This role is for an OSP provider resource to migrate legacy ETL pipelines (Informatica/Talend) to a modern data stack on Snowflake, dbt, and Fivetran, with strong DataOps, governance, and cost-aware design. Target experience: 7 to 8 years. Role Summary Lead end to end migration of legacy ETL workloads...

  • Snowflake DBT

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time US$ 1,24,000 - US$ 2,00,000 per year

    Data Pipeline DevelopmentDesign develop and maintain efficient reliable and reusable ETLELT pipelines using DBT Snowflake and related technologiesData ModelingBuild and optimize data models star snowflake schemas to support analytical and reporting use cases ensuring data quality accuracy and performanceData IntegrationIntegrate data from multiple sources...

  • Senior Snowflake + DBT Engineer

    3 weeks ago

    India MindBrain Full time

    Job Title: Snowflake + DBT EngineerLocation: Remote Experience: 8+ yearsJob DescriptionWe are looking for an experienced Snowflake + DBT Engineer to design, build, and optimize our cloud-based data platform. The role involves developing scalable data pipelines, creating DBT models, and ensuring high-quality, well-documented data...