Our Client, An American manufacturer of premium and commercial paints, is seeking a SAP BODS Developer.
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