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.