SAP BODS Consultant

Job Description

The SAP BODS Consultant is responsible for keeping the SAP BODS system running smoothly and building and supporting data integration solutions. They should have experience with SAP HANA modeling, which involves creating and managing data models in SAP HANA using Calculation Views, dimensions, and SQL Scripting.

Responsibilities

• Install, configure, and maintain SAP BODS servers and repositories
• Manage user roles and permissions
• Create and manage data sources and targets
• Monitor and troubleshoot BODS jobs
• Perform backup and recovery of BODS repositories
• Implement performance tuning techniques
• Deploy code across Dev, QA, and Production environments using central repositories
• Responsible for developing BODS workflows/dataflows/mapping
• Good knowledge of various BODS transformations including DQ-like address cleansing, data cleansing, and Match
• Possess strong knowledge/experience of HANA View Modeling, using calculation views and performance tuning
• Experience with SQL and procedures in Native HANA
• Loading delta records on both source and target level CDC on type 1, type 2, and type 3 SCD
• Must be a resourceful problem solver who possesses creativity in resolving problems

Qualifications

• Bachelor's degree in Business (or Management), Computer Science, Engineering, or related discipline, or equivalent work experience is required
• At least 5 years of experience in Business Objects Data Services (Admin, workflows, mapping, dataflows, Data integrator/Data Quality/Platform transformations etc.)
• At least 5 years of experience in Data warehousing
• At least 5 years delivering complex data management engagements including all phases of the project life cycle from scoping and planning, requirements gathering, design, development, testing, and go live phases
• Significant amount of experience in SAP HANA Modelling (calculation views)
• Strong knowledge of data modeling and star schemas
• Working knowledge and experience with SQL language (4+ Years)
• A good understanding of best practices such as naming conventions in creating BODS jobs
• Experience working with a large data warehouse is a plus
• Experience in connecting BODS with a REST/SOAP API is a plus
• Experience in extracting semi-structured data like JSON is a plus
• Have strong analytical skills and strong process orientation with significant attention to detail
• Effective interpersonal skills with the ability to participate in and lead "Virtual" teams
• Has extensive experience building ETL (extract, transform, load) jobs using BODS
• Has built type 2 dimensions
• Has used transformations such as Data Quality, Match, Merge, Table Comparison, and others
• Has worked on several data warehouse projects, not just data migration projects
• Has extensively used SAP Data Services Management Console to monitor jobs
• Has provided production support and can debug jobs for any issues
• Has strong experience with HANA SQL and creating calculation views