Data Architect

3 weeks 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)

  • [Apply Now] Oracle Fusion Data Intelligence Architect

    1 week ago

    Bengaluru, India NTT Data Full time

    Job Description NTT 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 Oracle Fusion Data Intelligence Architect to join our team in Bangalore, Karntaka (IN-KA), India (IN). 1. FDI...

  • Data Architect-Life Insurance

    3 weeks ago

    Hyderabad, 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 Data Architect-Life Insurance to join our team in Hyderabad, Telangana (IN-TG), India (IN). Skills: - 10+ years of...

  • Data Governance

    4 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 Data Governance & Stewardship Architect to join our team in bangalore, Karntaka (IN-KA), India (IN). Role: Data...

  • FDI Architect

    2 weeks ago

    Bengaluru, India NTT Data Full time

    Job Description NTT 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 FDI Architect to join our team in Bangalore, Karntaka (IN-KA), India (IN). 1. FDI Architect 1. Hands on...

  • ▷ 15h Left! Salesforce Technical Architect

    4 weeks ago

    India NTT DATA Full time

    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 Salesforce Technical Architect to join our team in NoidaBengaluruChennaiHyderabad Karnataka India Job Summary We are seeking a highly...

  • Data Architect

    4 days ago

    India Recro Full time

    Central Data Office – Data Architect Role Summary Our client’s Central Data Office (CDO) aims to build enterprise data sets and treat data as a strategic asset to maximize business value. The Data Architect will collaborate with data architects, SMEs, engineers, and developers to design and govern enterprise-level data architectures, ensuring alignment...

  • Data Architect

    3 days ago

    India Recro Full time

    Central Data Office – Data Architect Role Summary Our client’s Central Data Office (CDO) aims to build enterprise data sets and treat data as a strategic asset to maximize business value. The Data Architect will collaborate with data architects, SMEs, engineers, and developers to design and govern enterprise-level data architectures, ensuring alignment...

  • Data Architect

    1 week ago

    India Recro Full time

    Job Description Central Data Office Data Architect Role Summary Our client's Central Data Office (CDO) aims to build enterprise data sets and treat data as a strategic asset to maximize business value. The Data Architect will collaborate with data architects, SMEs, engineers, and developers to design and govern enterprise-level data architectures, ensuring...

  • Data Architect

    3 days ago

    India Methodhub Software Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Data ArchitectJob Role SummaryClients Central Data Office (CDO) has a mission to develop enterprise data sets in support of the corporate strategy to treat data as an asset to maximize business value. The Data Architect will work closely with other Data Architects, subject matter experts (SMEs), data engineers and developers to design enterprise data sets...

  • AI Architects

    3 weeks ago

    Pune, 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 Pune, Mahrshtra (IN-MH), India (IN). Location: | Experience: 15+ years (5+ in AI/ML...