Sap Bods Consultant

Primary Responsibilities:
• 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 clients 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.

Competencies & Experience Required/Desired:
• 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