Senior Architect- Snowflake, DBT

3 weeks ago

india Tredence Full time

About Tredence

Tredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in building Scalable Big Data Solutions on Onprem/GCP/Azure cloud in a very cost effective and easily scalable manner for our clients. We also come in with some strong IP and pre-built analytics solutions in data mining, BI and Big Data. 
 

Job Location

Bangalore / Chennai / Gurgaon / Pune

Roles & Responsibilities

Working experience in Snowflake; use of Snow SQL CLI, Snow Pipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc. Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts. Extensive experience in DBT CLI, DBT Cloud, GitHub version control and repository knowledge, and DBT scripting to design & develop SQL processes to perform complex ELT processes and data pipeline build. Ability to independently envision and develop innovative ETL and reporting solutions and execute them through to completion. Triage issues to find gaps in existing pipelines and fix the issues Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines. Develop and maintain data pipelines using DBT Provide advice, guidance, and best practices around Snowflake Provide guidance on moving data across different environments in Snowflake Create relevant documentation around database objects Troubleshoot production support issues post-deployment and come up with solutions as required. Good Understanding and knowledge of CI/CD process and GitHub-> DBT-> Snowflake integrations. Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge of stored procedures. Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel and understanding how to use these features. Help joiner team members to resolve issues and technical challenges. Drive technical discussions with client architect and team members. Good experience in developing scripts for data auditing and automating various database platform manual activities. Understanding of the full software lifecycle and how development teams should work with DevOps to create more software faster. Excellent communication, working in Agile Methodology/Scrum

Qualification & Experience

Bachelor's and/or master’s degree in computer science or equivalent experience. Must have experience in data Integration, ETL/ETL development, and database design or Data warehouse design. Deep understanding of Star and Snowflake dimensional modelling. Strong knowledge of Data Management principles Working experience in Snowflake; use of Snow SQL CLI, schema modelling, performance tuning etc. Develop and maintain data pipelines using DBT. Experience with writing complex SQL queries, especially dynamic SQL Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts. Experience with performance tuning and optimization of SQL queries Experience of working with Retail Data Experience with data security and role-based access controls Comfortable working in a dynamic, fast-paced, innovative environment with several ongoing concurrent projects Should have experience working in Agile methodology. Strong verbal and written communication skills. Strong analytical and problem-solving skills with high attention to detail.

Why Join Tredence?

There is a reason we are one of the fastest growing private companies in the country You will have the opportunity to work with some of the smartest and fun-loving people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our reputed clients, some of the largest and most innovative global business brands. Our people are our greatest asset and we value every one of them. We are an equal opportunity employer who adhere to our core values & reflect this in our day to day life. So, please come & see why we’re so successful in one of the most competitive and fastest growing industries in the world.

  • Immediate Opening for Senior Snowflake Consultant

    2 months ago

    India GyanSys Inc. Full time

    Experience : 7+ yrs Notice Period : Immediate - 15 days Qualifications 5+ years of overall experience in Data warehousing projects Previous experience as a data engineer or in a similar role 3+ years Experience in Data Build Tool (DBT) 3+ Experience in Snowflake Platform Work experience in designing and developing databases, and integrations using dbt in...

  • Snowflake Architect

    2 days ago

    india BigTapp Analytics Full time

    Job Description: We are seeking a skilled Snowflake Architect with 8-10 years of experience to join our team. The ideal candidate will be responsible for designing, implementing, and managing Snowflake solutions to support our data infrastructure needs. As a Snowflake Architect, you will collaborate closely with crossfunctional teams to develop scalable and...

  • Snowflake Architect

    1 week ago

    india LTIMindtree Full time

    12+ years of experience in the Data warehouse, ETL, BI projects and 3+ years working as Data Architect. At least 2 years of Snowflake hand-on experience. Excellent knowledge of RDBMS topics, SQL, OLAP, OLTP, NO-SQL databases, JSON. Must have hands-on experience in SnowSQL, JavaScript Stored Procedures, performance tuning, Streaming Ingestion and Streams....

  • Snowflake Lead Developer

    1 month ago

    India 6 concourse parkway Full time

    Job Summary for Snowflake lead Developer:Our client is looking for someone who will lead and deliver technical solutions for large-scale digital transformation projects. Working with the latest data technologies in the industry, you will be instrumental in helping our clients evolve for a more digital future.Job Responsibilities and Qualifications for...

  • Snowflake Lead Developer

    1 month ago

    india 6 concourse parkway Full time

    Job Summary for Snowflake lead Developer: Our client is looking for someone who will lead and deliver technical solutions for large-scale digital transformation projects. Working with the latest data technologies in the industry, you will be instrumental in helping our clients evolve for a more digital future. Job Responsibilities and Qualifications for...

  • Snowflake Data Engineer

    3 days ago

    india Lapis Data Analytics Full time

    Company Description Lapis Data Analytics is a dynamic and innovative data engineering company founded in 2020 and located in Chennai. Our primary focus is on designing, building, and maintaining robust data pipelines that convert raw data into actionable insights. With a team of seasoned experts and cutting-edge technology, we deliver customized data...

  • Snowflake Architect

    4 weeks ago

    Anywhere in India/Multiple Locations/Bangalore Mobile Programming Full time

    Skills Required: 8+ years of experience architecting, designing, developing and optimizing large scale data solutions, out of which at least 5 years is in SaaS domain Strong experience in building with GCP and/or AWS infrastructure and services Expert knowledge and deep hands-on experience with cloud data platforms/services such as Snowflake, Azure...

  • Snowflake Architect

    4 weeks ago

    Anywhere in India/Multiple Locations/Bangalore Mobile Programming Full time

    Job Description Required : 6 +years of experience architecting, designing, developing and optimizing large scale data solutions, out of which at least 5 years is in SaaS domain Strong experience in building with GCP and/or AWS infrastructure and services Expert knowledge and deep hands-on experience with cloud data platforms/services such as Snowflake,...

  • Data Engineer

    2 months ago

    india SKYGATE CONSULTING Full time

    Data Engineer (Snowflake) Job Description :As part of the team, you will be responsible for building and running the data pipelines and services that are required to support business functions/reports/dashboard.. We are heavily dependent on BigQuery/Snowflake, Airflow, Stitch/Fivetran, dbt , Tableau/Looker for our business intelligence and embrace AWS with...

  • Data Architect

    1 week ago

    india Coders Brain Technology Pvt. Ltd. Full time

    Position Name : Data ArchitectExperience Required : 10yrsNotice period : Immediate joiner Job Type : Full timeLocation : RemoteJob Description : - 10+ years of proven experience as a Data Engineer with 5+ years as Data Architect. - Bachelor's degree in computer science, Information Technology, or related field.- Proficiency in Snowflake with Hands-on...

  • Snowflake

    2 weeks ago

    india LTIMindtree Full time

    Skill: Snowflakes Developer Experience: 5-8Yrs Notice period: Imm to 30 days Location: Chennai, Hyderabad, Kolkata, Bangalore, Mumbai, Pune. JD: "Senior Snowflake developer/Technical Lead Experience with data and batch loading processes. - Strong hands on experience on Snowflake development and support of Data warehouse and interaction with Data Lakes. - DB...

  • Solution Architect

    2 weeks ago

    Anywhere in India/Multiple Locations, IN koantek Full time

    Job Description :- Undergraduate degree or higher in Computer Science, Information Systems, or relevant experience.- Minimum 8+ years experience in a technical role, preferably in the data or cloud field.- Knowledge of at least one of the public cloud platforms AWS, Azure, or GCP is required.- Knowledge of a programming language - Python, Scala, or SQL-...

  • Solution Architect

    2 weeks ago

    Anywhere in India/Multiple Locations koantek Full time

    Job Description : - Undergraduate degree or higher in Computer Science, Information Systems, or relevant experience.- Minimum 8+ years experience in a technical role, preferably in the data or cloud field.- Knowledge of at least one of the public cloud platforms AWS, Azure, or GCP is required.- Knowledge of a programming language - Python, Scala, or SQL-...

  • Senior Data Engineer

    3 weeks ago

    india YASH Technologies Full time

    Responsible for designing and implementing data pipelines, ETL processes, and data modeling in Snowflake Responsible to translate business requirements into ELT pipelines using data replication tools and data transformation tools (such as DBT) or advanced SQL scripting (views, Snowflake Store Procedure, UDF). Deep understanding of Snowflake architecture...

  • Data Architect

    5 days ago

    Anywhere in India/Multiple Locations Coders Brain Technology Pvt. Ltd. Full time

    Position Name : Data ArchitectExperience Required : 10yrsNotice period : Immediate joiner Job Type : Full timeLocation : RemoteJob Description : - 10+ years of proven experience as a Data Engineer with 5+ years as Data Architect. - Bachelor's degree in computer science, Information Technology, or related field.- Proficiency in Snowflake with...

  • Data Architect

    2 weeks ago

    Anywhere in India/Multiple Locations Selsoft Full time

    Role : Snowflake data architect. 6 months project Start of the project : Next week. Timings : 1pm to 10pm. Remote (WFH). Responsibilities : Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling). Experience with data security and data access controls and design in Snowflake....

  • Snowflake Architect

    2 months ago

    Anywhere in India,Multiple Locations Marktine Technology Solutions Full time

    Job Description :- Hands-on Snowflake Solution Architect with expertise in Design, and Implementation of highly scalable, highly available solution- The ideal candidate will have strong knowledge as well as a strong understanding of data warehousing and data engineering principles- Assess and understand the ETL jobs, workflows, BI tools and reports- Improve...

  • Data Engineer

    1 week ago

    india Luminary Talent Sourcing Full time

    Job Description About the Role:  We are seeking a highly skilled and experienced Senior Data Engineer / Architect to join our team and lead the design and development of a real-time analytics platform. The successful candidate will be part of a team responsible for architecture, designing, and building the data infrastructure and pipelines to enable...

  • Data Engineer

    3 weeks ago

    india Reliable Group Full time

    POSITION DESCRIPTION :WHAT YOU'LL DO :- Architect, Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow.- Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.- Actively monitor and triage technical...

  • Data Engineer

    5 days ago

    india Suitable.AI Full time

    Role : .Net Core you will do : - Architect, Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using DBT, airflow. - Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. - Actively monitor and triage technical...