Senior Data Architect

2 days ago

bangalore district, India Tredence Inc. Full time

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.

  • Enterprise Data Architect

    1 day ago

    bangalore, India Aptus Data Labs Full time

    Company Description Aptus Data Labs is a leading Data and AI company specializing in Pharma, Manufacturing & Supply Chain, Banking & FinTech, and Technology domains. We offer innovative analytical solutions and consulting services to help businesses make quick, data-driven decisions essential for growth and sustainability in evolving industries. Leveraging...

  • Enterprise Data Architect

    2 days ago

    bangalore, India Aptus Data Labs Full time

    Company DescriptionAptus Data Labs is a leading Data and AI company specializing in Pharma, Manufacturing & Supply Chain, Banking & FinTech, and Technology domains. We offer innovative analytical solutions and consulting services to help businesses make quick, data-driven decisions essential for growth and sustainability in evolving industries. Leveraging...

  • Senior Data Architect

    2 weeks ago

    Bangalore, India Sopra Steria Full time

    Position: Senior Data Architect Experience: 14+ years Location: Bangalore/ Noida Education: B.E./ B.Tech./ MCA Primary Skills: MDM, Data Architecture, Data Modelling, Data Catalogue, Data Governance, Data Quality, DWH Role Overview: xperienced Data Architect to design and develop comprehensive enterprise data architecture that enables scalability,...

  • Senior Data Architect

    2 weeks ago

    bangalore, India Sopra Steria Full time

    Position: Senior Data Architect Experience: 14+ years Location: Bangalore/ Noida Education: B.E./ B.Tech./ MCA Primary Skills: MDM, Data Architecture, Data Modelling, Data Catalogue, Data Governance, Data Quality, DWH Role Overview: xperienced Data Architect to design and develop comprehensive enterprise data architecture that enables scalability,...

  • Data Architect

    1 day ago

    bangalore district, India Best Infosystems Ltd. Full time

    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: •Design and implement scalable, secure, and cost-effective data architectures using GCP. •Lead the design and development of data pipelines with BigQuery, Dataflow, and...

  • Staff Engineer

    4 days ago

    bangalore district, India Wayfair Full time

    Staff Engineer - Data Platforms- Software Engineering Who we are Wayfair is seeking a passionate and driven Staff Engineer to join our “Data Platforms” team. In this pivotal role, you will be instrumental in shaping and executing Wayfair’s New-Age Data Platform strategy across large-scale Data Ingestion, Transformation, Real-time Messaging Platforms...

  • Senior Data Architect

    6 days ago

    bangalore, India Chevron Full time

    Total Number of Openings1About the position:Senior Data architects lead the design and implementation of data collection, storage, transformation, orchestration (movement) and consumption to achieve optimum value from data. They are the technical leaders within data delivery teams. They play a key role in modeling data for optimal reuse, interoperability,...

  • Data Architect

    2 weeks ago

    bangalore district, India Brillio Full time

    JD: 11+ years of experience in Data and Analytics. 2+ years of experience as a Data Architect. 3+ years of experience in Architecting, designing and implementing Modern Data Platforms and Solutions using Microsoft Azure Cloud and understands reference architectures. Deep understanding Data Migration Strategies with 2+ years of experience in Data Migration...

  • Senior Solution Architect

    2 weeks ago

    hyderabad district, India NTT DATA Business Solutions Full time

    We want to shape the future with vision and innovation. Be part of it and develop your full potential! As part of the global NTT DATA Group, one of the most successful IT service providers in the world, we specialize in value-added SAP solutions as NTT DATA Business Solutions. With over 16,000 employees in more than 30 countries, we design, implement, and...

  • Data Architect

    7 days ago

    bangalore district, India Quantiphi Full time

    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 delivering big data pipelines for structured and unstructured data that are running across multiple geographies, helping organizations achieve their business goals with use...