Data Warehouse Architect

3 months ago


Kharadi Pune Maharashtra, India edgematics Full time

**Title - **Data Warehouse Architect

**Location -** Kharadi, World Trade Center, Pune

**Experience Range** **-** 15 Years

**Roles & Responsibilities**:

- **Data Warehouse Design**:Define the architecture and structure of the data warehouse, including data models, schemas, and data integration processes.
- ** Data Modeling**: Develop data models (e.g., star schema, snowflake schema) to optimize data storage and retrieval for reporting and analysis.
- ** ETL (Extract, Transform, Load)**: Design and oversee the implementation of ETL processes to extract data from source systems, transform it to meet business needs, and load it into the data warehouse.
- ** Performance Optimization**: Continuously monitor and optimize the data warehouse’s performance to ensure efficient query processing and data retrieval.
- ** Data Quality Assurance**: Implement data quality checks and validation processes to maintain data accuracy and consistency within the data warehouse.
- ** Security and Access Control**: Establish security protocols and access controls to protect sensitive data within the data warehouse, ensuring compliance with data privacy regulations.
- ** Scalability and Growth**: Plan for the scalability of the data warehouse to accommodate future data growth and evolving business requirements.
- ** Documentation**: Maintain comprehensive documentation of the data warehouse architecture, data flows, and transformation processes.
- ** Collaboration**: Work closely with business analysts, data analysts, and data engineers to understand data requirements and translate them into data warehouse solutions.
- ** Vendor Evaluation**: Evaluate and recommend data warehousing tools and technologies, such as data warehouse platforms (e.g., Snowflake, Amazon Redshift, Azure Synapse Analytics), ETL tools, and BI tools.
- ** Performance Tuning**: Identify and resolve performance bottlenecks, optimizing query performance and system efficiency.
- ** Disaster Recovery and Backup**: Implement strategies and plans for data warehouse backup, disaster recovery, and business continuity.
- ** Data** **Governance**: Enforce data governance and data management best practices to maintain data quality, lineage, and compliance.

**Must Skills**:

- **Data Modeling**: Develop data models (e.g., star schema, snowflake schema) to optimize data storage and retrieval for reporting and analysis.
- ** ETL (Extract, Transform, Load)**: Design and oversee the implementation of ETL processes to extract data from source systems, transform it to meet business needs, and load it into the data warehouse.
- ** Performance Optimization**: Continuously monitor and optimize the data warehouse’s performance to ensure efficient query processing and data retrieval.
- ** Data Quality Assurance**: Implement data quality checks and validation processes to maintain data accuracy and consistency within the data warehouse.
- ** Security and Access Control**: Establish security protocols and access controls to protect sensitive data within the data warehouse, ensuring compliance with data privacy regulations.
- ** Scalability and Growth**: Plan for the scalability of the data warehouse to accommodate future data growth and evolving business requirements.
- ** Documentation**: Maintain comprehensive documentation of the data warehouse architecture, data flows, and transformation processes.
- ** Collaboration**: Work closely with business analysts, data analysts, and data engineers to understand data requirements and translate them into data warehouse solutions.
- ** Vendor Evaluation**: Evaluate and recommend data warehousing tools and technologies, such as data warehouse platforms (e.g., Snowflake, Amazon Redshift, Azure Synapse Analytics), ETL tools, and BI tools.

**Good to have skills**
- **Big Data Technologies**: Familiarity with big data technologies such as Hadoop, Hive, and HBase can be valuable.
- ** Cloud Services**: Knowledge of cloud platforms like AWS, Azure, or Google Cloud can be essential, as many organizations are moving their data warehousing solutions to the cloud for scalability and cost-effectiveness.

**Qualifications and Education Requirements***
- Bachelor’s degree in computer science, information technology, or a related field.
- Proven experience as an DW Architect or similar role.

**Job Category**:Tech**Job Type**:Full Time**Job Location**:India



  • Pune, Maharashtra, India Synechron Full time

    As an Ab Initio Developer at Synechron, you will play a crucial role in designing and developing data warehousing and data migration projects using the ETL tool Ab Initio. With a focus on Banking and Financial Services (BFS) Domain and Insurance domain, you will create robust data warehouse process models, including sourcing, loading, transformation, and...


  • Pune, Maharashtra, India Tata Consultancy Services Full time

    At Tata Consultancy Services, we are seeking an experienced Data Warehouse Architect and ETL Developer to join our team in India.About the RoleThis is a challenging opportunity for a skilled professional to design and build data warehouse structures, develop innovative solutions, and support the development and validation of data warehousing and business...


  • Pune, Maharashtra, India Worldline Full time

    Worldline Data Management Team: DWH Project in LatviaWe are the innovators at the heart of the payments technology industry, shaping how the world pays and gets paid. The solutions our people build today power the growth of millions of businesses tomorrow.Our technology addresses the persistent challenges of the payment world. We design and operate leading...


  • Pune, Maharashtra, India Salorix Consulting Full time

    Job OverviewAs a highly skilled Data Warehouse Architect, you will be responsible for designing and developing robust data warehouse solutions using Oracle Data Integrator (ODI). With 5+ years of experience in building functions and stored procedures using ODI, you will create data warehouse tables and accompanying documentation.The ideal candidate will have...


  • Pune, Maharashtra, India NTT DATA Full time

    **Req ID**: 304038 We are currently seeking a Data Governance Architect to join our team in Pune, Mahārāshtra (IN-MH), India (IN). Job Duties: Lead the data management practice that includes but not limited to - Data Governance/catalog - MDM - Data Quality - Testing Minimum Skills Required: Must have experience in data analysis, data engineering for 10+...

  • Data Architect

    6 months ago


    Balewadi, Pune, Maharashtra, India Soft-brilliance Full time

    **Job Title**: Sr. Data Architect/Modeler This person will work with Insurance clients and business analysts to gather data requirements, and then design and develop data solutions to provide business insights and manage business performance. The person will be responsible for the _data modeling and architecture_analysis, modelling, design and delivery of...

  • Data Architect

    1 month ago


    Pune, Maharashtra, India Nozomi Enterprises Full time

    **Data Architect** **Exp -** 10+ yrs **Location - **Pune, Aundh IT Park, Pune **Type - (HYBRID)** Need to go to office 1-2 times in a month **Job Summary**: An expert SQL Developer DBA, who has worked on Redshift/warehousing concepts. Need extensive experience on reporting and performance tuning Technical stack: SQL, Redshift, EMR, S3, AWS, MongoDB/AWS...

  • Data Architect

    2 months ago


    Pune, Maharashtra, India Job Matchmakers Full time

    **Position :Data Architect** **Exp -** 10+ yrs **Location -** Aundh IT Park, Pune **Contract Duration** - 6 months to 1 year **Work Mode - **Need to go to office 1-2 times in a month **Job Summary**: An expert SQL Developer DBA, who has worked on Redshift/warehousing concepts. Need extensive experience on reporting and performance tuning Technical...

  • Data Architect

    6 months ago


    Pune, Maharashtra, India Expleo Group Full time

    Overview: As a Data Architect, you will be responsible for designing, implementing, and maintaining data architectures that support our business objectives and enable data-driven decision-making. You will work closely with stakeholders across the organization to understand requirements, assess technical feasibility, and develop robust data models and...


  • Pune, Maharashtra, India Ashra Technologies Pvt Ltd Full time

    Job Description: Customer is looking for a proven experience as a Snowflake Developer with strong understanding of Snowflake architecture, SQL, Python Scripting and data warehousing concepts. MUST TO HAVE SKILL SET 1. Writing Snowflake Stored Procedure 2. SQL expertise 3. Common ELT/ETL (Snow pipe and Copy Command) best practices in Snowflake with Error...

  • Data Architect

    6 months ago


    Mumbai, Maharashtra, India Startrac Technologies Full time

    **Qualifications** - 7+ years of overall experience in a Data Architect role, supporting warehouse and big data platforms/environments. - 5+ years of experience working in an Enterprise/Senior Data Architect role, including with Cloud data platforms. - Strong expertise in data exploration using SQL and a deep understanding of data relationships. - Extensive...

  • Azure Data Architect

    2 weeks ago


    Hinjawadi, Pune, Maharashtra, India BirlaSoft Full time

    Country/Region: IN- Requisition ID: 19799- Work Model: - Position Type: - Salary Range: - Location: INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI**Title**:Azure Data Architect**: - Description: **Short Description**: **About Birlasoft**: Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine...


  • Kondhwa, Pune, Maharashtra, India Plainsurf Solutions Full time

    **Job Title**: Data Warehouse and Merchandising Intern **Company**: Plainsurf Solutions **Location**: Pune **Type**: Full-time **Responsibilities**: - Design, develop, and maintain data warehouse solutions to support business intelligence and analytics needs. - Integrate and manage data from various sources to ensure data accuracy and integrity. -...

  • Data Architect

    6 months ago


    Pune, Maharashtra, India Quorum Business Solutions Full time

    **Data Architect** **Location: Pune, India** **Model of Work: Hybrid** Are you excited by challenges? Do you enjoy working in a fast-paced, international and dynamic environment? Then now is the time to join Quorum Software, a rapidly growing company and industry leader in oil & gas transformation. Quorum Software is the world's largest provider of...


  • Pune, Maharashtra, India Rojgar Group Full time

    Job Title: Warehouse Management Systems ArchitectJob Summary: We are seeking an experienced Warehouse Management Systems Architect to lead the design, implementation, and ongoing support of WMS deployments. The ideal candidate will have expertise in Blue Yonder (formerly JDA/RedPrairie) WMS and a deep understanding of supply chain management.Key...


  • Pune, Maharashtra, India Javin Full time

    Job Title: Senior Data Architect LeadJob Summary: We are seeking a highly skilled Senior Data Architect Lead to join our team at Javin. As a key member of our data architecture team, you will be responsible for designing and implementing efficient data warehouses and data management systems.Design and develop data warehouse architectures that meet business...

  • Solution Architect

    6 months ago


    Hinjawadi, Pune, Maharashtra, India BirlaSoft Full time

    Country/Region: IN- Requisition ID: 13398- Work Model: - Position Type: - Salary Range: - Location: INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI**Title**:Solution Architect**: - Description: - **JD - Snowflake Architect** **Mandatory Skillset: Snowflake, DBT, Data Architecture Design experience in Data Warehouse.** **Good to have Informatica/Any ETL...

  • Data Architect

    6 months ago


    Pune, India Change Leader Full time

    "Job Description: Azure Data Solution Architect Profile: Data Architect in Azure cloud with overall 12+ years of experience and minimum 2+ year of experience in architecting and designing Data Analytics solution on Azure Must have skills: - Solution Architect for Azure Data Platforms with deep Azure Synapse, Azure Databricks, ADF, Azure SQL, ADLS Gen 2 -...

  • Solution Architect

    7 months ago


    Hinjawadi, Pune, Maharashtra, India BirlaSoft Full time

    Country/Region: IN- Requisition ID: 10924- Work Model: - Position Type: - Salary Range: - Location: INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI**Title**:Solution Architect**: - Description: - 10 - 12 years of IT experience with 3+ years of Data Architecture experience in Data Warehouse, 4+ year in Snowflake. - Oversees and designs the information...

  • Data Architect

    2 days ago


    Pune, Maharashtra, India Nityo Infotech Full time

    Job Title: Data ArchitectLocation: Pune, IndiaExperience: 8-15 YearsJob Description:We are looking for a skilled data architect to design and implement scalable data models with expertise in DAX calculations and data modeling.In-depth knowledge of data integration techniques and tools, including data pipeline orchestration and automation.Proficiency in SQL...