Overview
On Site
Full Time
Skills
Writing
Stored Procedures
Data Integration
Dimensional Modeling
Scripting
Servers
Backup
Recovery
Quality Assurance
Data Cleansing
Performance Tuning
Change Data Capture
SCD
Problem Solving
Supervision
Testing
Optimization
Data Mapping
Extract
Transform
Load
Continuous Improvement
Management
Computer Science
Business Objects
Workflow
Mapping
Data Flow
Data Quality
Data Management
Requirements Elicitation
Development Testing
SAP HANA
Modeling
Data Modeling
SQL
Data Warehouse
SAP BODS
SOAP
API
JSON
Analytical Skill
Attention To Detail
Virtual Team
Job Details
Must have:
5+ yrs data warehousing
Data modeling
BODS ADMIN and ETL development experience
HANA development experience (writing SQL, stored procedure, calculation views, etc.)
Responsibilities
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.
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
Possess a project-oriented approach to development work
Ability to work independently and drive work to completion
Ability to manage a heavy workload, and achieve results while meeting project deadlines with minimal supervision
Must be able to perform quality testing and beta testing of the applications that are delivered.
Identify, define, and deliver in parallel complex programs and projects/enhancements in a matrix environment.
Translates business goals into appropriate solutions while assessing the feasibility and optimization of the solution.
Work in Planning, Developing, Implementing, and Managing Data Warehouse Project Deliverables, Design Documents, and High-Level Data Mapping for SAP BODS ETL Specifications.
Recognize BODS-related risks/issues that need escalation and arrange for appropriate assistance.
Support Activities
Must be able to analyze and troubleshoot data related issues (joins etc) in a timely manner and best practices of the company
Identify continuous process improvement opportunities and operationalize solutions for same.
Maintain SAP BODS Coding best practices and standards. Ensure that the best practices are enforced and followed during the development process.
Assist business and functional leads with day-to-day development, support, and troubleshooting.
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 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
#RecruitPS
5+ yrs data warehousing
Data modeling
BODS ADMIN and ETL development experience
HANA development experience (writing SQL, stored procedure, calculation views, etc.)
Responsibilities
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.
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
Possess a project-oriented approach to development work
Ability to work independently and drive work to completion
Ability to manage a heavy workload, and achieve results while meeting project deadlines with minimal supervision
Must be able to perform quality testing and beta testing of the applications that are delivered.
Identify, define, and deliver in parallel complex programs and projects/enhancements in a matrix environment.
Translates business goals into appropriate solutions while assessing the feasibility and optimization of the solution.
Work in Planning, Developing, Implementing, and Managing Data Warehouse Project Deliverables, Design Documents, and High-Level Data Mapping for SAP BODS ETL Specifications.
Recognize BODS-related risks/issues that need escalation and arrange for appropriate assistance.
Support Activities
Must be able to analyze and troubleshoot data related issues (joins etc) in a timely manner and best practices of the company
Identify continuous process improvement opportunities and operationalize solutions for same.
Maintain SAP BODS Coding best practices and standards. Ensure that the best practices are enforced and followed during the development process.
Assist business and functional leads with day-to-day development, support, and troubleshooting.
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 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
#RecruitPS
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.