Tata Consultancy Services
SAP BODS Lead
Tata Consultancy Services, Columbus, Ohio, United States, 43224
JobTitleSAP BODS Lead
RelevantExperience (in Yrs)7+ years ofexperience in ETL Development, SAP BODS, SQL Queries, Stored Procedure
Technical/FunctionalSkills•Experience in Data Warehousing thatincludes analysis and development of Dataflows, mappings using neededtransformations using BODS.•Experience in Development of SAPHANA Models•Develop Jobs, Workflows and Dataflows based on the specifications using various stages in BODS.•Experience in BODS DesignerComponents- Projects, Jobs, Workflow, Data Flow, Scripts, Data Stores andFormats.•Knowledge on Data QualityTransformation.•Implementation of SCD type2dimensions to maintain the History of dimensional data.•Must have knowledge on ETL, DataManagement and Data warehousing.•Create and monitor testing to verifydata quality and consistency in business processes and reporting.
Auditdata in accordance with the Master Data Governance program that defines andmonitors the process of creating, modifying, storing and deleting data.•Exposure in BODS performance tuningtechniques using parallel processing (Degree of Parallelism), Multithreading,Partitioning, and Database Throughputs to improve job performance•Experience in Data ServicesManagement Console for Monitoring, Execution and Scheduling BODS jobs.•Hands on exp in debugging executionerrors using Data Services log s (trace, statics and Error)•Should have involved in thedevelopment and implementation of the Enterprise Data Warehousing (EDW) processand Data Warehouse.•Should have work experience indifferent types of transformations like Query transformation, Merge, Case,Validations
ExperienceRequired•7+ Experience in data migrationusing BODS from SAP ECC to SAP S/4 HANA•Experience with SQL and proceduresin Native HANA.•Experience in ensuring Data Quality,Data Integrity and ETL•Experience using SAP Best PracticesData Migration (BPDM) AIO/RDS methodology jobs for SAP BW/ECC/CRM.•Possess strong knowledge/experienceof HANA View Modeling, using calculation views and performance tuning.
Roles& Responsibilities•Responsible for:
oData Cleansing and Data Qualityactivities.
oData migration mapping sessions withbusiness and functional teams.
oCreation of users in the managementand central management consoles.
oData stores creation on sources andtargets of ArcGIS, WMS and databases.
oPerformance tuning using caches andparallel execution using bulk loading and dataflow execution.
oLoading delta records on both sourceand target level CDC on type1, type 2, and type 3 SCD.
oIntegrating Business Objects DataServices with SAP and Non SAP Data Sources.
oDeveloping complex data models usingSAP Native HANA studio modeling tools.•Integration of Business Objects DataServices with SAP and Non SAP Data Sources.•Point of contact to the offshoreteam to resolve the issues and for any concern in requirement gathering.•Work collaboratively with projectmanagers, SAP Offshore Consultants, and partner consultants to developconsulting and project methodology, techniques, tools, and solutions.
GenericManagerial SkillsMust haveexceptional communication, organization, and time management skills
EducationBachelors Degree or equivalent
RelevantExperience (in Yrs)7+ years ofexperience in ETL Development, SAP BODS, SQL Queries, Stored Procedure
Technical/FunctionalSkills•Experience in Data Warehousing thatincludes analysis and development of Dataflows, mappings using neededtransformations using BODS.•Experience in Development of SAPHANA Models•Develop Jobs, Workflows and Dataflows based on the specifications using various stages in BODS.•Experience in BODS DesignerComponents- Projects, Jobs, Workflow, Data Flow, Scripts, Data Stores andFormats.•Knowledge on Data QualityTransformation.•Implementation of SCD type2dimensions to maintain the History of dimensional data.•Must have knowledge on ETL, DataManagement and Data warehousing.•Create and monitor testing to verifydata quality and consistency in business processes and reporting.
Auditdata in accordance with the Master Data Governance program that defines andmonitors the process of creating, modifying, storing and deleting data.•Exposure in BODS performance tuningtechniques using parallel processing (Degree of Parallelism), Multithreading,Partitioning, and Database Throughputs to improve job performance•Experience in Data ServicesManagement Console for Monitoring, Execution and Scheduling BODS jobs.•Hands on exp in debugging executionerrors using Data Services log s (trace, statics and Error)•Should have involved in thedevelopment and implementation of the Enterprise Data Warehousing (EDW) processand Data Warehouse.•Should have work experience indifferent types of transformations like Query transformation, Merge, Case,Validations
ExperienceRequired•7+ Experience in data migrationusing BODS from SAP ECC to SAP S/4 HANA•Experience with SQL and proceduresin Native HANA.•Experience in ensuring Data Quality,Data Integrity and ETL•Experience using SAP Best PracticesData Migration (BPDM) AIO/RDS methodology jobs for SAP BW/ECC/CRM.•Possess strong knowledge/experienceof HANA View Modeling, using calculation views and performance tuning.
Roles& Responsibilities•Responsible for:
oData Cleansing and Data Qualityactivities.
oData migration mapping sessions withbusiness and functional teams.
oCreation of users in the managementand central management consoles.
oData stores creation on sources andtargets of ArcGIS, WMS and databases.
oPerformance tuning using caches andparallel execution using bulk loading and dataflow execution.
oLoading delta records on both sourceand target level CDC on type1, type 2, and type 3 SCD.
oIntegrating Business Objects DataServices with SAP and Non SAP Data Sources.
oDeveloping complex data models usingSAP Native HANA studio modeling tools.•Integration of Business Objects DataServices with SAP and Non SAP Data Sources.•Point of contact to the offshoreteam to resolve the issues and for any concern in requirement gathering.•Work collaboratively with projectmanagers, SAP Offshore Consultants, and partner consultants to developconsulting and project methodology, techniques, tools, and solutions.
GenericManagerial SkillsMust haveexceptional communication, organization, and time management skills
EducationBachelors Degree or equivalent