SAP BW (Business Warehouse) Consultant

Position Description:

Founded in 1976 CGI is among the worlds largest independent IT and business consulting services firms. With 94000 consultants and professionals globally CGI delivers an end-to-end portfolio of capabilities from strategic IT and business consulting to systems integration managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more .

Job Title: SAP BW (Business Warehouse) Consultant with Hana Migration
Position: LA / AC
Experience: 8 years of experience
Category: Software Development
Job location: Bangalore Chennai
Position ID: J0625-0399
Work Type: Hybrid
Employment Type: Full Time / Permanent
Qualification: Bachelors or Masters degree in Computer Science Engineering or a related field.

We are seeking an experienced SAP BW Consultant to lead the migration of our existing SAP BW system running on Oracle to SAP BW/4HANA. The ideal candidate should have hands-on experience with SAP BW 7.x Oracle databases and SAP BW/4HANA architecture along with a strong understanding of data modelling ETL processes and SAP HANA optimization.

Key Responsibilities:
Evaluate and work on end-to-end migration from SAP BW on Oracle to SAP BW/4HANA.
Assess current BW landscape and define the most suitable migration path (In-place Remote or Shell Conversion).
Redesign legacy BW objects (InfoCubes DSOs Multiproviders) into BW/4HANA-compatible objects (ADSO Composite Providers).
Use SAP BW/4HANA Transfer Cockpit and other SAP tools to facilitate migration.
Perform data validation reconciliation and performance tuning post-migration.
Collaborate with business and technical teams to ensure minimal disruption during migration.
Work with functional consultants to verify data and troubleshoot any issues that arise during the migration.
Maintain comprehensive documentation of data migration processes and procedures including DoMD (Data Migration mapping documents) Document migration strategy technical specifications and test plans.

Required and must have Skills:
Strong experience with SAP BW 7.x on Oracle and SAP BW/4HANA.
Proficiency in SAP HANA modeling and SQL scripting.
SAP BO reporting including working on IDT/UDT tools and Power BI working experience.
Working experience in Oracle Materialized view is a must.
Develop and enhance BW objects such as InfoObjects InfoCubes Infosources/Data Sources Master Data Transformations Update Rules DSO Extractors Infosets Aggregates Process Chains DTPs User Exits BADI and HANA objects like Schemas Calculated Analytical or Scripted Views using HANA Modeler.
Able to debug issues post migration and must have ABAP and AMDP working experience.
Experience with SAP migration tools (Transfer Cockpit RSB4HCONV etc).
Design and manage ETL (Extract Transform Load) processes including the development of load programs using tools like LSMW LTMC and others.
Ensure seamless data integration with SAP FI SD MM and COPA modules.
Conduct unit testing integration testing and UAT to validate data accuracy.
Technical expertise in: Data Models Database Design Oracle SQL optimize queries & individually debug queries.
Knowledge of SAP data warehousing concepts and architecture.
Ability to write ABAP for custom enhancements and debugging.
Experience in backup/Restore/Recovery of SAP/Oracle installations Server Monitoring and optimizing techniques.
Good to have understanding of oil and gas industry processes and KPIs.
Excellent problem-solving and communication skills.

CGI is an equal opportunity employer. In addition CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

#LI-GB9

Skills:

• SAP DW Workbench

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.