Overview
Skills
Job Details
Location: Montvale, NJ
Position Type: Full-Time/Perm
Schedule: Hybrid - 3 Days Onsite
Job Summary:
* 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.
* 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.
Job Functions:
* 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:
* Production Support
* 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.
Education:
* Bachelor's degree in Business (or Management), Computer Science, Engineering, or related discipline, or equivalent work experience is required
Experience:
* 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
$145k Max