Data Architect

2 weeks ago

Noida, Uttar Pradesh, India Falcon Smart IT (FalconSmartIT) Full time
Job Description

Job Title: Data Architect (SQL Expertise)

Location: NCR Region

Job Type: Permanent

Job Summary:

As a Data Architect, you will be responsible for designing, implementing, and maintaining high-performance database systems. You will work closely with cross-functional teams to develop data solutions that meet business needs and support MMC Tech long-term data strategy. Your expertise in both SQL and NoSQL databases, along with your experience in ETL processes and cloud services, will be crucial in driving our data architecture forward.

Key Responsibilities:

Design and implement high-performance database configurations using Microsoft SQL Server and MongoDB.

Develop and manage ETL processes with SaaS services, data lakes, and data sources such as Dremio and Databricks.

Collaborate with reporting and analytics teams to integrate systems like Power BI, Qlik, and Crystal Reports.

Provide strategic direction for long-term data strategy and architecture.

Understand and implement AWS cloud services related to database management.

Identify and implement performance fixes and scalability solutions for existing systems.

Troubleshoot and resolve performance issues in database systems.

Develop and maintain data schemas while ensuring compliance with ACID rules.

Lead hands-on implementation of both SQL Server and MongoDB.

Optimize system performance and provide recommendations for improvements.

Understand and implement PaaS, SaaS, and IaaS solutions in both on-premises and cloud environments.

Manage security, user roles, and access controls within database systems.

Provide guidance and direction to teams on data strategy and architecture best practices.

Re-engineer existing databases based on load requirements and implement performance improvements.

Document database designs, ER diagrams and publish functional domain documentation.

Key Skills:

Microsoft SQL Server Expertise:

Proficient in writing and optimizing stored procedures, triggers, and complex queries.

Strong understanding of indexes and their impact on performance.

Ability to analyze and optimize execution plans for query performance.

Experience in high-performance schema design using both bottom-up and top-down approaches.

Database Design and Performance:

Expertise in re-engineering existing databases to enhance performance based on load analysis.

Strong understanding of data schema design and ACID principles.

Hands-on experience with SQL and NoSQL database implementations, particularly with MongoDB.

Good understanding with security best practices and user management in database systems.

Cloud and Integration:

Good understanding of AWS cloud services related to database management.

Experience with PaaS, SaaS, and IaaS concepts in both on-premises and cloud environments.

Qualifications:

15-20 years of experience in data architecture, database design, and implementation.

Strong experience with ETL processes and data integration using SaaS services.

Proficiency in reporting and analytics tools such as Power BI, Qlik, and Crystal Reports.

Strategic mindset with the ability to develop and execute long-term data strategies.

Excellent communication and leadership skills, with the ability to direct teams effectively.

  • Solution Architect

    1 week ago

    Noida, Uttar Pradesh, India NTT DATA Full time

    Req ID 315953 NTT DATA strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Solution Architect to join our team in Noida Uttar Pradesh IN-UP India IN Role overview ...

  • Network-solution Architect

    2 weeks ago

    Noida, Uttar Pradesh, India NTT DATA Full time

    Req ID 280299NTT DATA Services strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Network-Solution Architect to join our team in Noida Uttar Pradesh IN-UP India IN Requirements Bachelor ...

  • Solution Architect With Grc

    3 weeks ago

    Noida, Uttar Pradesh, India NTT DATA Full time

    Req ID 329643 NTT DATA strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Solution Architect with GRC to join our team in Noida Uttar Pradesh IN-UP India IN Lead creation of...

  • Data Architect Opportunities

    2 weeks ago

    Noida, Uttar Pradesh, India beBeeDataArchitect Full time ₹ 4,00,000 - ₹ 8,00,000

    Job Title:Data Architect for Enterprise Data WarehouseThis is a unique opportunity to join our organization as a senior data architect with expertise in enterprise data warehouse implementation, design, and development. As a key member of the team, you will oversee the development of information architecture for the data warehouse, including staging areas,...

  • Data Engineer

    3 weeks ago

    Noida, Uttar Pradesh, India NTT DATA Full time

    Req ID 303115NTT DATA strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Data Engineer to join our team in Noida Uttar Pradesh IN-UP India IN Job Duties As a data engineer you will have a...

  • GCP Data Architect

    2 weeks ago

    Noida, Uttar Pradesh, India HCLTech Full time

    Role: GCP Data Architect Total years of experience: 12+ Years Location: Noida, Bangalore, Chennai, Pune, Hyderabad Relevant experience for engagement: 10 Years Relevant skillset: Maintain architecture principles, guidelines and standards Data Warehousing Programming Language: Python/Java Big Data Data Analytics GCP Services Relevant technology domains:...

  • Azure Data Architect

    3 weeks ago

    Noida, Uttar Pradesh, India Optimus Information Inc. Full time

    Company DescriptionOptimus Information is a leading technology consulting company that provides professional and managed services in cloud migration and management, DevOps, application development and modernization, data analytics, and testing. With deep Azure expertise and a global delivery model, we help clients achieve their digital transformation goals....

  • Azure Data Architect

    3 weeks ago

    Noida, Uttar Pradesh, India Optimus Information Inc. Full time

    Company Description Optimus Information is a leading technology consulting company that provides professional and managed services in cloud migration and management, DevOps, application development and modernization, data analytics, and testing. With deep Azure expertise and a global delivery model, we help clients achieve their digital transformation...

  • Data Architect

    2 weeks ago

    Noida, Uttar Pradesh, India IGREENTREE PRIVATE LIMITED Full time

    Who We Are :At iGreenTree, we're passionate about empowering energy and utility providers with innovative IT solutions. With deep domain knowledge and a dedication to innovation, we help our clients stay ahead of the curve in a rapidly changing industry. Whether you need IT consulting, application development, system integration, or digital transformation...

  • Data Architect Leader

    2 weeks ago

    Noida, Uttar Pradesh, India beBeeArchitecture Full time ₹ 2,00,00,000 - ₹ 2,50,00,000

    Job TitleData Architects design, develop, and maintain the enterprise data architecture.Required Skills & Experience7+ years of experience in data architecture, data modeling, and database management.Proficiency in designing and implementing relational (SQL) and non-relational (NoSQL) database solutions.Strong experience with data integration tools, ETL/ELT...