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 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.

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