Job Description

Our client is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies. Powered by more than 84,000 entrepreneurial professionals across more than 30 countries, it caters to over 700 clients with its extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomesRole: DBT With SQL & SnowflakeExperience: 5 to 12 yearsWork Mode: HybridEmployment Type: Full TimeCTC: 1900000 to 2800000 LPALocation: Bangalore, Hyderabad, Chennai, Mumbai, Pune, Kolkata, CoimbatoreNotice period: Immediate to 30 DaysJob description

• 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.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 Snowflake stored producers, schema modelling, performance tuning etc.Good Understanding and knowledge on CI/CD process and GitHub- DBT- Snowflake integrationsAdvance 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.Use DBT to build and manage ETL processes for ingesting, transforming, and loading data into Snowflake.Strong experience building ELT pipelines (batch and streaming) in Snowflake cloud warehouse.Experience in implementation of data transformation framework, database design, troubleshooting and maintenance.Proficient in SQL, Stored Procedures, Functions, Triggers in Snowflake, Oracle.Have working experience in batch load process using any of the database (Oracle, SQL, Snowflake)Should have knowledge on creating producer and consumer in Kafka; use of Kafka Connectors, setup security while data is in Topic.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.Excellent communication and presentation skills.Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.Experienced in internal as well as external stakeholder management. Regular engagement with teams for status reporting and routine activities.Possess ownership right from start to finish.

People Prime Worldwide