Data Warehouse Architect

2 days 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 Warehouse Architect Role

    23 hours ago

    hyderabad, India beBeeSnowflake Full time

    Snowflake Lead/Architect Job OpportunityAs a key member of our technical team, you will be responsible for designing, developing and maintaining software applications using advanced analysis, coding, testing, deploying and supporting applications.This role requires hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe and Big Data model...

  • Data Solution Architect

    1 week ago

    Hyderabad, Telangana, India tezo Full time

    Tezo is a new generation Digital & AI solutions provider, with a history of creating remarkable outcomes for our customers. We bring exceptional experiences using cutting-edge analytics, data proficiency, technology, and digital excellence. **Role: Data Solution Architect** **Experience: 10-12 years** **Location**: Hyderabad (or willing to...

  • Oracle Fusion Analytics Warehouse-data Modelling-i

    1 week ago

    Hyderabad, Telangana, India Achutha Associates Full time

    Job Title: Oracle Fusion Analytics Warehouse - Data Modelling - | Duration : Contract - 6 months Location : (Onsite) _ Hyderabad Must Have Skills: Fusion Analytics Warehouse (FAW), Data Modelling Budget : Open To Discuss ( But keep it low) Experience: 6+ Details: Strong technical background in Data Warehouse and reporting concepts, including data...

  • Ai Data Architect

    1 week ago

    Hyderabad, Telangana, India NTT DATA Full time

    **Make an impact with NTT DATA** Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it’s a place where you can grow, belong and thrive. **Your day at NTT DATA** This...

  • Architect - Data Modeler

    3 hours ago

    Hyderabad, Telangana, India BirlaSoft Full time

    Country/Region: IN - Requisition ID: 22444 - Work Model: - Position Type: - Salary Range: - Location: INDIA - HYDERABAD - BIRLASOFT OFFICE **Title**:Architect - Data Modeler**: - Description: **Area(s) of responsibility**: Below is the JD for the Data Modeler: - Experience in any one of data modeling tool (currently NOV using SQL DBM) - Very good...

  • Snowflake Lead/Architect

    2 days ago

    hyderabad, India Boolean Data Systems Full time

    Job Tittle: Snowflake Lead/Architect Job Id: JPC - 67 Location: Hyderabad About The Company : Boolean Data Systems is a system integration company focusing on Snowflake products. We focus on helping companies implement innovative solutions combining People+ Process+ Technology to reach their maximum ROI. We are headquartered in Atlanta, GA with additional...

  • Data Architect

    3 weeks ago

    Hyderabad, India ValueMomentum Full time

    Primary Skills: Snowflake, and PythonSecondary Skills: AWS, Azure, GCP, Linux, Windows Environments, Redshift, and DatabricksJob Location: HyderabadMode of work: Work from OfficeExperience: 12+ Years of Experience in Data Modeling/Data Warehousing and 5+ years in Snowflake.Job Summary:We are seeking a highly skilled Architect with over 12 years of experience...

  • Data Architect

    2 weeks ago

    Hyderabad, India ValueMomentum Full time

    Primary Skills: Snowflake, and PythonSecondary Skills: AWS, Azure, GCP, Linux, Windows Environments, Redshift, and DatabricksJob Location: HyderabadMode of work: Work from OfficeExperience: 12+ Years of Experience in Data Modeling/Data Warehousing and 5+ years in Snowflake.Job Summary:We are seeking a highly skilled Architect with over 12 years of experience...

  • Data Architect

    4 weeks ago

    Hyderabad, India ValueMomentum Full time

    Primary Skills: Snowflake, and Python Secondary Skills: AWS, Azure, GCP, Linux, Windows Environments, Redshift, and DatabricksJob Location: HyderabadMode of work: Work from OfficeExperience: 12+ Years of Experience in Data Modeling/Data Warehousing and 5+ years in Snowflake.Job Summary:We are seeking a highly skilled Architect with over 12 years of...

  • Data Architect

    2 days ago

    Hyderabad, Telangana, India Amgen Full time

    **What you will do** Let’s do this. Let’s change the world. In this vital role you will be pivotal in shaping the data strategy that supports AI, business intelligence, and data integration patterns across the organization. The Data Architect will work closely with S/4HANA architects and functional architects across Amgen to ensure that S/4 data...