Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 12th Apr 2021
Experience in SAP Data Services (BODS) 4.2
Hands on experience in design, development and implementation with SAP and non - SAP data sources. End to end implementation experience with at least two full life cycle implementations is a must.
Should have good understanding of the BODS landscape and architecture.
Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirement
Expertise to handle data provisioning and error handling from various sources including SAP HANA, Files, MS SQL Server, Oracle, SAP ECC, web services
Experience in creating multiple data store configurations in Data services local object library with different databases to create unified data store.
Experience with DI transforms such as Query, Validation, Case transforms
Experience in Integrator mappings objects to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows
Extensively work on Installations and configure the repositories and establish the data source connections.
Hands on experience in job debugging, performance tuning and optimization
Experience with admin console, batch job scheduling, designer and server manager tools
Work experience on the Data warehousing and Business Intelligence solution implementations.
Strong SQL/PL SQL skills with experience in data validation and reconciliation
Knowledge on HANA
Strong knowledge in DWH concepts
Should have clear understanding of DW Lifecycle and contributed in preparing technical design documents and test plans
Participation in quality processes and implementation.
Good analytical & problem solving skills.
Interacted with users to know their business views while gathering their Interface requirements and provided several Data/File mock-ups and outline the proposed solution by creating proof of content to finalize the requirements.
Ability to interpret, configure and implement data mapping / transformation business rules into Data Services
Experienced in FTP/SFTP file transfer process using BODS
Experience in Scheduling jobs through Auto sys and other third party scheduler.
End to End execution in gathering requirement, Functional Analysis, HLD, LLD, Build, Testing & Production deployment with defined process