Data Architect

1 day ago


Itanagar India The IT Firm Full time

Job Description Data Architect/ Developer Mode : Work From Office(5 Days)/ Remote Time : India Time and U.S overlap. Work Location : Hyderabad Job Description : (Architect is required to know AWS Redshift.) - Design, develop, test, deploy and troubleshoot SQL scripts, Stored Procedures that implement complex PLSQL solutions. - Must have experience in Query Optimization. - Must be able to understand complex business logic, fine tune long-running queries - Must be expert at reverse engineering and extracting business requirements and rules from the code. - Scheduling and monitoring the ETL jobs using SSIS. - Build and review functional and business specifications - Expert understanding of PostgreSQL, Stored Procedures, Views, and Functions. - Provide the estimates for the ETL work - Database/Data Warehouse performance tuning, monitoring and troubleshooting expertise. - Expertise in query construction, including writing and optimizing complex SQL queries that contain sub queries, joins, and derived tables - Troubleshooting and fixing the code - Unit testing the code and documentation of results - Must be expert at providing non-functional requirements. - Help creating test data and provide support to QA process. - Work with gate keeper on promoting the data stage jobs from QA to Production. - Build, patch and data fix in production environment. - Ensure very high availability to scale of 99.999%. - Establish coding practices, best practices, and SoPs. Participate in code reviews and enforce relevant process. - Strong analytical and thinking capabilities, good communication skills to conduct requirement gathering sessions/interview customers - Ability to perform independent research to understand the product requirements and customer needs - Communicates effectively with the project teams and other stakeholders. Translate technical details to non-technical audience. - Expert at creating architectural artifacts for Data Warehouse. - Team, effort management. - Ability to set expectations for the client and the team. Ensure all deliverables are delivered in time at highest quality. Technical Skills - ETL-SSIS - SQL - Stored Procedure, Functions, Triggers etc - Query Optimization - Server monitoring - ETL : AWS-Glue - DBMS : AWS Aurora MySQL, AWS Redshift, PostgreSQL - Cloud Services : AWS cloud services, including EC2, RDS, S3, and IAM. - Data Skills : SQL Performance tuning. - Coding : knowledge of programming language like C#, Python or Java. To oversee dev resources. - Team and people management. - Agile scrum practices - Great learning attitude - Eagerness to take ownership - A global mindset - Excellent communication skills (ref:hirist.tech)


  • Azure Data Architect

    3 weeks ago


    Bengaluru, India NTT Data Full time

    Job Description 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 Azure Data Architect to join our team in Bangalore, Karntaka (IN-KA), India (IN). Azure - Architect Job...

  • Azure Data Architect

    3 weeks ago


    Bengaluru, India NTT DATA North America Full time

    Job Description Req ID: 341135 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 Azure Data Architect to join our team in Bangalore, Karntaka (IN-KA), India (IN). Azure -...

  • ServiceNow Architect

    3 weeks ago


    Itanagar, India Congregate Technologies Full time

    Role OverviewWe are looking for an experienced ServiceNow Architect with advanced expertise in IT Operations Management (ITOM). The ideal candidate will design, architect, and implement scalable ITOM solutions, including Discovery, Service Mapping, Event Management, and CMDB strategies, to enable intelligent operations and seamless integrations across...


  • Itanagar, Arunachal Pradesh, India Congregate Technologies Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Role OverviewWe are looking for an experienced ServiceNow Architect with advanced expertise in IT Operations Management (ITOM). The ideal candidate will design, architect, and implement scalable ITOM solutions, including Discovery, Service Mapping, Event Management, and CMDB strategies, to enable intelligent operations and seamless integrations across...


  • Itanagar, Arunachal Pradesh, India DHI Solutions Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job DescriptionExperience: 10+ years in Salesforce implementations with at least 5 years specializing in Salesforce Data Responsibilities :Work with business and technical teams to gather data migration requirements and design end-to-end data migration solutions.Perform data analysis to identify gaps, inconsistencies, and cleansing needs; define and drive...

  • AI Architects

    3 weeks ago


    Mumbai, India NTT Data Full time

    Job Description 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 AI Architects to join our team in Mumbai, Mahrshtra (IN-MH), India (IN). Location: | Experience: 15+ years (5+ in...

  • AI Architects

    3 weeks ago


    Bengaluru, India NTT Data Full time

    Job Description 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 AI Architects to join our team in Bangalore, Karntaka (IN-KA), India (IN). Location: | Experience: 15+ years (5+ in...

  • Databricks Architect

    3 weeks ago


    Bengaluru, India NTT Data Full time

    Job Description 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 Databricks Architect to join our team in Bangalore, Karntaka (IN-KA), India (IN). Databricks Data Platform -...

  • Ai Architect

    3 days ago


    India Crayon Data Full time

    **AI Architect (Non-Cloud Large Language Models)** **Chennai (Hybrid)** Seeking a visionary AI Architect to lead the strategic implementation of non-cloud Large Language Models (LLMs) across our organization. As a strategic leader, you'll bridge the gap between business objectives and technical innovation, ensuring the successful and sustainable adoption...

  • GCP Architect

    3 weeks ago


    Bengaluru, India NTT Data Full time

    Job Description 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 GCP Architect to join our team in Bangalore, Karntaka (IN-KA), India (IN). GCP - Architect Job Description Role...