DBT TECHNICAL SPECIALIST

ZensarPune, MaharashtraOn-siteFull-timeStaff, 8–12 yearsListed 1 hour ago

Apply now

About this role

As a DBT Technical Specialist, you will provide technical solutioning across the full ETL/ELT modernization lifecycle – leading the migration of legacy Informatica IICS pipelines to a modern DBT-based transformation layer on Snowflake, orchestrated with Fivetran for data ingestion and Apache Airflow for pipeline orchestration – including integration with existing data and analytics platforms and tools (both on-premise as well as cloud databases). You would be working with a team of developers fostering a culture of support and collaboration.

9-12 Years of Data and Analytics experience with minimum 8+ years of hands-on experience across the modern ELT stack – DBT (Data Build Tool)/DBT Cloud, Fivetran, Apache Airflow and Snowflake – along with working knowledge of legacy ETL platforms such as Informatica IICS/PowerCenter, Spark, Kafka, Python etc.

- Excellent communication and presentation skills.
- Extensive experience in DBT – DBT CLI, DBT Cloud, GitHub version control and repository knowledge, DBT scripting to design & develop PLSQL processes to perform complex ELT processes and data pipeline build
- In-Depth experience on DBT concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses.
- Proven experience on End to End DBT project implementation technical solutions, including architecting, designing and development and guiding team as needed. Proven experience leading ETL/ELT modernization and migration engagements – translating legacy Informatica IICS/PowerCenter mappings and workflows into DBT models, defining the migration strategy, conversion standards and cutover/reconciliation approach, and mentoring developers through the transition. Experience in identifying architecture gaps that can improve availability, performance and security for productions systems and working towards resolving those issues along with development team.
- Working experience in Snowflake; use of SnowSQL CLI, SnowPipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc.
- Strong hands-on experience with Fivetran (or an equivalent EL/data ingestion tool) for automated data ingestion – architecting and governing connector strategy for SaaS applications, databases and files, handling schema drift, incremental sync/CDC, and defining standards for connector monitoring and troubleshooting.
- Strong working experience with Apache Airflow (or an equivalent orchestration tool) for pipeline orchestration – designing DAG architecture and dependency frameworks that sequence Fivetran ingestion and DBT transformation jobs, and defining standards for retries, SLA monitoring and failure alerting across the end-to-end pipeline.
- Good understanding and knowledge of CI/CD processes and GitHub->DBT->Snowflake integrations, including version control and deployment of Fivetran connector configurations and Airflow DAGs as part of the same pipeline
- Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions, Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures
- Good experience in developing UNIX and Python scripts for data auditing and automating various database platform manual activities.
- Working knowledge of the legacy ETL/ELT platform being modernized – Informatica PowerCenter/IICS – sufficient to interpret existing mappings and workflows for migration to the DBT-based target architecture; familiarity with SnowSQL, SnowPipe, Spark and Kafka is a plus
- Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.
- Experienced in internal as well as external stakeholder management
- dbt Analytics Engineering Certification, SnowPro-Core / SnowPro-Advanced certification, and/or Fivetran or Apache Airflow certification will be an added advantage.
- Nice to have skills: Working experience in Reporting technologies like Tableau or Power BI and Exposure to Cloud Analytics native services of AWS/AZURE/GCP etc.
- Good to have Retail / eCommerce (home furnishings or consumer retail) domain experience.