SAP BODS Developer

• 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