Data Warehouse Architect

2 weeks ago


Hyderabad Telangana, India Allnessjobs Full time

Allnessjobs is seeking a highly motivated and experienced Datawarehouse Architect to join our team and play a key role in

Building, Managing and Optimizing our mission-critical Enterprise Datawarehouse. You will be responsible for

designing, developing, implementing, and supporting complex Enterprise Data Warehouse build on multiple ERP

expertise in all aspects of Data Warehousing, with a strong focus on ETL and Reporting.

Skills:

- 10+ years of experience as an Architect.
- Proven experience in building designing, implementing, and managing Enterprise Data Warehouse.
- Extensive experience with Oracle Data Integrator (ODI).
- Strong Experience of database migration best practices and tools.
- Strong Experience in Oracle SQL and PL/SQL.
- Experience with scripting languages like Python or Bash is a plus.
- Experience with cloud-based environments (e.g., AWS).
- Strong Knowledge of Oracle ERP modules and underlying database tables for (Finance, Supply chain, HR)
- Expensive experience in Data Extraction from Oracle ERP and underlying data model.
- Excellent communication, interpersonal, and problem-solving skills.
- Ability to work independently and as part of a team.
- Strong commitment to quality and continuous improvement.
- Knowledge of PostgreSQL, MySQL and automation (Shell Scripting, Ansible, Python) will be an added

advantage.

Responsibilities:

- Design, Develop, Enhance, Manage and Optimize existing Data Warehouse.
- Provide leadership and technical expertise to enable effective Business Intelligence and Data Warehouse

(BI/DW) strategies and goals in a global implementation of BI.
- Provide leadership for the architectural direction and provide consultation to agile teams.
- Work together with various business units (BI, Product, Reporting) to develop data warehouse platform

vision, strategy, and roadmap
- Design ETL architecture and approach.
- Develop reports using BI Tools
- Follow various ETL Processes to prepare design for all metadata
- Analyze and troubleshoot and fix erroneous results, determines the root causes, logs the defects and

provide solutions.
- Build ETL - Extract Data from new Data Sources such as Oracle ERP, Data Files and Integrate with

Warehouse
- Design, Build and Extend Warehouse Data Model
- Perform ongoing performance monitoring, optimization, and troubleshooting of Warehouse.
- Stay up-to-date with the latest Data Warehouse and Analytics technologies and trends.
- Document procedures and maintain accurate technical documentation.

**Job Types**: Full-time, Permanent

Pay: Up to ₹4,589,419.33 per year

**Benefits**:

- Health insurance

Schedule:

- Night shift
- US shift

Supplemental pay types:

- Performance bonus
- Yearly bonus

Ability to commute/relocate:

- Hyderabad, Telangana: Reliably commute or planning to relocate before starting work (required)

**Experience**:

- Data Warehouse Architect: 10 years (required)
- Enterprise Data Warehouse: 7 years (required)

Work Location: In person


  • Data Architect

    3 weeks ago


    Gachibowli, Hyderabad, Telangana, India BigLynx Inc. Full time

    **As a Data Architect/Consultant, you will play a critical client-facing role, assisting clients in achieving business success by making data understandable and actionable. You will be involved in requirements gathering, identifying and implementing KPIs, measures, dimensions, and other key business drivers to enhance the clients business operations. Your...


  • Hyderabad, Telangana, India SUMMIT CONSULTING SERVICES PRIVATE LIMITED Full time

    Job Description :At the intersection of science and technology, Clovertex is a Life Sciences systems integrator specializing in architecting, building, automating, and managing scientific applications, databases, data warehouse, data lakes, and workflowsusing cloud computing is an AWS Advanced Tier Partner. Our team has deep scientific domain experience and...


  • Hyderabad, India SUMMIT CONSULTING SERVICES PRIVATE LIMITED Full time

    Job Description :At the intersection of science and technology, Clovertex is a Life Sciences systems integrator specializing in architecting, building, automating, and managing scientific applications, databases, data warehouse, data lakes, and workflowsusing cloud computing is an AWS Advanced Tier Partner. Our team has deep scientific domain experience and...


  • Hyderabad, India SUMMIT CONSULTING SERVICES PRIVATE LIMITED Full time

    Job Description : At the intersection of science and technology, Clovertex is a Life Sciences systems integrator specializing in architecting, building, automating, and managing scientific applications, databases, data warehouse, data lakes, and workflowsusing cloud computing is an AWS Advanced Tier Partner. Our team has deep scientific domain experience...


  • Hyderabad, Telangana, India Computronics System ( India) Pvt. Ltd Full time

    Department: Logistics/Warehouse Reports To: Warehouse Manager Job Summary: The Warehouse Coordinator will oversee and coordinate daily warehouse activities such as receiving and storing goods, managing inventory levels, ensuring the efficient delivery of goods, and maintaining the overall organization and cleanliness of the warehouse. This role is...


  • Hyderabad, India Evnek Technologies Pvt Ltd Full time

    Job DescriptionDuration:6 monthsLocation: HyderabadTimings: Full Time (As per company timings)Notice Period: within 15 days or immediate joinedExperience: 10-15 YearsRequirementsMust have 5+ years of experience working with large data with transactions in the order of 5 – 10M records.Expert at performance tuning, Transactions, DeadLock management, Triggers...

  • Data Architect

    2 days ago


    Hyderabad, Telangana, India HCLTech – Engineering and R&D Services Full time

    Job Title: Data Architect at [Company Name]Responsible for defining overall data architecture, data modeling, and data warehouse managementDefine optimal data pipeline strategy for data ingestion, curation, and transformation processesDevelop data visualization and data security strategiesImplement data life cycle management and data quality assuranceConduct...

  • Solution Architect

    3 weeks ago


    Hyderabad, Telangana, India NTT DATA Full time

    **Req ID**: 283839 We are currently seeking a Solution Architect to join our team in Hyderabad, Telangana (IN-TG), India (IN). Our Solution Architects are fundamental to ensuring the digital technology and related services that NTT DATA builds for our clients are valuable, intuitive, and impactful. The work of Solution Architects provides our clients and...


  • hyderabad, India Anicalls (Pty) Ltd Full time

    Candidate should be able to:Develop and document standards, policies, and procedures for the form, structure, and attributes of the business intelligence tools and systems.Interact with the user community to produce reporting requirements.Work on multiple projects as a team member and may lead projects of moderate complexity.Reviews and validates data loaded...


  • hyderabad, India Anicalls (Pty) Ltd Full time

    Candidate should be able to:Develop and document standards, policies, and procedures for the form, structure, and attributes of the business intelligence tools and systems.Interact with the user community to produce reporting requirements.Work on multiple projects as a team member and may lead projects of moderate complexity.Reviews and validates data loaded...

  • Data Architect

    2 weeks ago


    Hyderabad, Telangana, India Accellor Full time

    **Role** - Design, implement and lead Data Architecture, Data Quality, Data Governance across - Defining data modeling standards and foundational best practices - Develop and evangelize data quality standards and practices - Establish data governance processes, procedures, policies, and guidelines to maintain the integrity and security of the data. - Drive...

  • Data Architect

    1 week ago


    Hyderabad, Telangana, India DataEconomy Full time

    **Job Information**: Industry - IT ServicesCity - Hyderabad/PuneState/Province - TelanganaCountry - IndiaZip/Postal Code - 500081**About us**: - About DATAECONOMY: We are a fast-growing data & analytics company headquartered in Dublin with offices inDublin, OH, Providence, RI, and an advanced technology center in Hyderabad,India. We are clearly...

  • Senior Data Architect

    2 weeks ago


    hyderabad, India Insight Global Full time

    Required Skills and Experience *- 7+ years of experience of data architecture and engineering experience with a focus in the Azure tech stack- Proficient with SQL, PySpark, Azure cloud, Azure data lake, Azure data warehouse, Azure data catalogues, and Azure Power View- In depth knowledge of ServiceNow and ServiceNow's ITSM and ITOM modules- Experience with...

  • Senior Data Architect

    4 weeks ago


    hyderabad, India Insight Global Full time

    Required Skills and Experience *- 7+ years of experience of data architecture and engineering experience with a focus in the Azure tech stack- Proficient with SQL, PySpark, Azure cloud, Azure data lake, Azure data warehouse, Azure data catalogues, and Azure Power View- In depth knowledge of ServiceNow and ServiceNow's ITSM and ITOM modules- Experience with...

  • Warehouse Incharge

    2 weeks ago


    Hyderabad, Telangana, India Whatnot India Private Limited Full time

    Raise Sales Invoices, Purchase Bills. - Checking the stocks and preparing stock reports. - Work closely with team members to assist with the month-end close - Knowledge on Accounts Receivables and payables. - Looking after warehouse activities - Handling warehouse people and their operations - Stock Maintenance - Data Entry of stocks **Job Types**:...

  • Data WareHouse

    4 weeks ago


    Hyderabad, India Infospoke Integrated Solutions LLP Full time

    Job Title : DWH ArchitectJob Description Experience : 10yrs-15yrs. Proven expert at writing SQL code with at least 10 years of experience. ü  Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü  Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü  Proven...

  • Data WareHouse

    2 weeks ago


    Hyderabad, India Infospoke Integrated Solutions LLP Full time

    Job Title : DWH ArchitectJob Description Experience : 10yrs-15yrs. Proven expert at writing SQL code with at least 10 years of experience. ü  Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü  Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü  Proven...

  • Data WareHouse

    4 weeks ago


    hyderabad, India Infospoke Integrated Solutions LLP Full time

    Job Title : DWH Architect Job Description  Experience : 10yrs-15yrs.  Proven expert at writing SQL code with at least 10 years of experience. ü  Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü  Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü ...

  • Data WareHouse

    2 days ago


    Hyderabad, Telangana, India Infospoke Integrated Solutions LLP Full time

    Job Title :DWH ArchitectJob DescriptionExperience : 10yrs-15yrs.Proven expert at writing SQL code with at least 10 years of experience.üMust have 5+ years of experience working with large data with transactions in the order of 5 – 10M records.üExpert at performance tuning, Transactions, Dead Lock management, Triggers etc.üProven expert in Modeling...

  • Data WareHouse

    2 days ago


    Hyderabad, Telangana, India Infospoke Integrated Solutions LLP Full time

    Job DescriptionJob Title : DWH ArchitectJob Description Experience : 10yrs-15yrs. Proven expert at writing SQL code with at least 10 years of experience. ü Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü Proven...