Talent.com
Senior Data Architect
Senior Data ArchitectTredence Inc. • Hosur, Krishnagiri (district), India
Senior Data Architect

Senior Data Architect

Tredence Inc. • Hosur, Krishnagiri (district), India
30+ days ago
Job description

SNOWFLAKE ARCHITECT

Location : Bengaluru, Pune, Gurugram, Kolkata, Chennai and Hyderabad

Primary Roles and 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.

    Skills and Qualifications :

  • Bachelor's and / or master’s degree in computer science or equivalent experience.
  • Must have total 13+ yrs. of IT experience and 5+ years' experience in data Integration, ETL / ETL development, and database design or Datawarehouse 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.

    Create a job alert for this search

    Senior Data Architect • Hosur, Krishnagiri (district), India

    Related jobs
    Azure Data Architect

    Azure Data Architect

    Confidential • Hosur, Krishnagiri (district), India
    We are seeking a skilled and motivated Azure Data Architect with 8-12 years of relevant experience.Candidate will play a pivotal role in designing, implementing, and optimizing large-scale data sol...Show more
    Last updated: 5 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Genisys Group • Hosur, Tamil Nadu, India
    Job Overview The Data Lead / Data Architect will own the vision, design, and delivery of cutting-edge enterprise data platforms and modern analytics solutions across public clouds and hybrid infr...Show more
    Last updated: 19 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Best Infosystems Ltd. • Hosur, Tamil Nadu, India
    Data Architect_Full-Time_Trivandrum / Bangalore / Chennai / Kochi Job Title : Data Architect Job Type : Full-Time Location : Trivandrum / Bangalore / Chennai / Kochi Exp : 10+ years Job Description : - Des...Show more
    Last updated: 19 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Quantiphi • Hosur, Tamil Nadu, India
    Role : Architect - Data Experience Level : 8 Years and above Work location : Bangalore, Mumbai OR Trivandrum (Hybrid) What you’ll do : You will be working as a Data architect designing and ...Show more
    Last updated: 30+ days ago • Promoted
    Architect / Senior Architect

    Architect / Senior Architect

    Valeo • Hosur, Tamil Nadu, India
    Participate and lead in the software architecture design of the software platform for both embedded software & development environment. Strong programming experience : C++, design patterns, DOORS, Ca...Show more
    Last updated: 30+ days ago • Promoted
    Senior Architect - Data

    Senior Architect - Data

    Quantiphi • Hosur, Krishnagiri (district), India
    Quantiphi is an award-winning Data Science and Machine Learning Software and Services Company focused on helping organizations translate the big promise of Machine Learning technologies into quanti...Show more
    Last updated: 5 hours ago • Promoted • New!
    Data Solutions Architect

    Data Solutions Architect

    Arcesium • hosur, India
    Arcesium is a global financial technology firm that solves complex data-driven challenges faced by some of the world’s most sophisticated financial institutions. We constantly innovate our platform ...Show more
    Last updated: 16 hours ago • Promoted • New!
    Senior Data Architect

    Senior Data Architect

    Lyzr AI • Hosur, Tamil Nadu, India
    Expectations @ Lyzr Work directly with enterprise customers to understand the workflow they want to automate and translate it into clear agent + data architecture on Lyzr.Map all relevant data sour...Show more
    Last updated: 19 hours ago • Promoted • New!
    Technical Data Architect

    Technical Data Architect

    GrayMatter Software Services • Hosur, Tamil Nadu, India
    Job Overview : We are seeking a highly skilled Technical Architect with 12+ years of experience to oversee and guide the development of advanced data architectures, business intelligence solutions...Show more
    Last updated: 30+ days ago • Promoted
    Data Architect

    Data Architect

    NeerInfo Solutions • Hosur, Krishnagiri (district), India
    Modern Data Architect to lead the design and implementation of next-generation data platforms.Responsible for architecting scalable, cloud-native, and real-time data ecosystems to support advanced ...Show more
    Last updated: 5 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Recloud Consulting • Hosur, Tamil Nadu, India
    We are seeking an experienced Data Architect with 10+ years of expertise in designing, implementing, and optimizing enterprise-scale data architectures. The ideal candidate will have very s...Show more
    Last updated: 19 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Tredence Inc. • Hosur, Tamil Nadu, India
    Role - Senior Data Architect - Snowflake Job Location - Bangalore, Chennai, Pune, Gurugram, Kolkata Joining Time Required - Immediate - Max 30 Days. Responsibilities : Design and develop com...Show more
    Last updated: 14 days ago • Promoted
    Cloud Data Architect

    Cloud Data Architect

    Brillio • Hosur, Tamil Nadu, India
    The ideal candidate is passionate about learning, data, scalability, and agility.You'll leverage your strong collaboration skills and data architecture expertise, along with a deep understanding of...Show more
    Last updated: 19 hours ago • Promoted • New!
    Md - Data Architecture

    Md - Data Architecture

    Leading MNC • Hosur, Tamil Nadu, India
    We are looking for a •highly seasoned Data Architecture leader • to head our enterprise data architecture function.The ideal candidate is someone who has built and scaled large-scale data platforms ...Show more
    Last updated: 19 hours ago • Promoted • New!
    Gcp Data Architect

    Gcp Data Architect

    HCLTech • Hosur, Tamil Nadu, India
    Job Title - GCP Data Architect Experience - 15 to 20 years Location - Bangalore / Chennai / Hyderabad / Noida Key Responsibilities Architectural Leadership : Contribute to architectural decisions ...Show more
    Last updated: 19 hours ago • Promoted • New!
    Senior Data Architect

    Senior Data Architect

    LTIMindtree • Hosur, Krishnagiri (district), India
    Senior data architect with experience in Supply Chain domain - JD.Senior data architect with mandatory experience in Supply Chain domain (one or more of logistics, planning, materials management, e...Show more
    Last updated: 5 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Datamatics • Hosur, Krishnagiri (district), India
    Demonstrated domain experience in BFSI and Manufacturing industries.Lead strategic enterprise data transformations with SAS to Databricks migration as a core capability. Architect cloud-native data ...Show more
    Last updated: 5 hours ago • Promoted • New!
    Enterprise Data Architect

    Enterprise Data Architect

    Aptus Data Labs • Hosur, Tamil Nadu, India
    Enterprise Data Architect – Job Description Location : Bangalore (Hybrid) Experience : 15+ years in Data Engineering & Data Platforms Employment Type : Full-time About Aptus Data Labs Aptus Da...Show more
    Last updated: 16 days ago • Promoted