SAP BODS Developer

SAP BODS Developer

Req number:

R4820

Employment type:

Full time

Worksite flexibility:

RemoteWho we are

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

We are seeking a highly skilled and experienced SAP BODS Developer to Designs and develops ETL solutions using data warehouse design best practices for Next Generation Analytics platform. if you are looking for your next career move, apply now.

Job Description

We are seeking a highly skilled and experienced SAP BODS Developer to join our IT team. This position will be full-time and Remote.

What You’ll Do

• Designs and develops ETL solutions using data warehouse design best practices for Next Generation Analytics platform

• Analyze data requirements, complex source data, data models, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects.

• Analyze business requirements and outline solutions.

• Have deep working knowledge of on-prem & cloud ESB architecture to address the client’s requirements for scalability, reliability, security, and performance

• Provide technical assistance in identifying, evaluating, and developing systems and procedures.

• Document all ETL and data warehouse processes and flows.

• Develop and deploy ETL job workflow with reliable error/exception handling and rollback.

• Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning.

• Design, Develop, Test, Adapt ETL code & jobs to accommodate changes in source data and new business requirements.

• Create or update technical documentation for transition to support teams.

• Develop automated data audit and validation processes

• Provides senior technical leadership to design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintainability

• Manage automation of file processing as well as all ETL processes within a job workflow.

• Develop, Contribute and adhere to the development of standards and sound procedural practices.

• Proactively communicate innovative ideas, solutions, and capabilities over and above the specific task request

• Effectively communicate status, workloads, offers to assist other areas.

• Collaboratively work with a team and independently. Continuously strive for high performing business solutions

• Perform and coordinate unit and system integration testing.

• Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications.

• Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth.

What You'll Need

• 8+ years of experience in ETL design, development, optimization & testing using SAP Data Services (BODS), PL/SQL etc

• 5+ PL/SQL, Complex SQL Tuning, Stored Procedures, Data Warehousing best practices etc.

• 3+ Experience in data migration using BODS from SAP ECC to SAP S/4 HANA

• 3+ years of experience in relational and Cloud database design, optimization and performance; preferably with SAP HANA, BW, Oracle, Hadoop, S3 and RedShift

• 3+ years of experience in developing flows using batch, Realtime and streaming process to personalize experiences for our customers

• 2+ years of experience in designing service-oriented architecture (SOA), RESTful APIs and enterprise application integration (EAI) solutions utilizing MuleSoft Platform

• 2+ years of experience with CI/CD tools like Jenkins, GIT, Java and Shell scripting

• Data stores creation on sources and targets of ECC, BI, and databases.

• Performance tuning using caches and parallel execution using bulk loading and dataflow execution.

• Loading delta records on both source and target level CDC on type1, type 2, and type 3 SCD.

• Integrating Business Objects Data Services with SAP and Non SAP Data Sources.

• Developed complex data models using SAP Native HANA studio modeling tools.

• Strong problem-solving capabilities. Results oriented. Relies on fact-based logic for decision-making.

• Ability to work with multiple projects and work streams at one time. Must be able to deliver results based upon project deadlines.

• Willing to flex daily work schedule to allow for time-zone differences for global team communications

• Strong interpersonal and communication skills

Physical Demands

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor.

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.