Ref No.: 17-00955
Location: Hickory, North Carolina
- The candidate would be working in SAP Data Services(DS) & Information Steward(IS) projects.
- Expected to work independently or with teams on design of complex ETL flows and Data Quality jobs.
- Will be required to work in data warehousing, migration & integration scenarios in SAP as well as non-SAP environments.
- Profiling various information systems, capture source/target mappings and transformations based on project requirements
- Designing complex SAP Data Services job flows to extract from/load to SAP systems such as SAP ECC, SCM, BW, TM as well as non-SAP systems such as Oracle, MS SQL Server,
- Experience with DI transforms such as Query, Validation, Case transforms as well as DQ transforms such as Match, Associate, Data Cleanse & Address Cleans
- Tuning jobs for high volume and complex transformation scenarios
- Configuring DS components including job server and repositories-
- Setting up DS data stores to connect to variety of data sources such as SAP ECC, SAP BW, Oracle, MS SQL Server
- Develop jobs to extract data from SAP Extractors & Tables, SAP BW DSOs, load to BW PSA
- Automation of DS/IS jobs using in-built and third party schedulers
- Developing and executing advanced data profiling, data validation scenarios
- Data Migration from Non SAP to SAP and SAP to SAP Experience is mandatory
- Excel expertise is mandatory
- Understand the business process and business needs to map the master data set up and transaction data during data conversions.

General Qualifications:
- 8+ years and above experience in SAP BODS (Business Objects Data Services)
- Experience implementing and optimizing ETL processes using SAP Business Objects Data Services.
- Expertise in SAP Data Quality Management, SAP Information Steward.
- Experience working on data integration projects with SAP and knowledge of database tables and relationships in SAP.
- Understanding relational data models.
- Worked with SAP ECC, and BW Extractors in BODS and must have done Custom ABAP code generation.
- ETL Performance tuning