Responsibilities :
- ETL Development & Implementation : Design, develop, implement, and maintain complex ETL (Extract, Transform, Load) processes using SAP BODS (Business Objects Data Services) to facilitate data integration and migration.
- Data Modeling & Warehousing : Collaborate with data architects and business analysts to understand data requirements and translate them into efficient data models for data warehousing solutions.
- Data Extraction & Transformation : Develop robust data extraction routines from various source systems (SAP and non-SAP) and implement complex data transformation logic within BODS.
- Data Quality & Cleansing : Implement data quality rules and data cleansing routines within BODS to ensure high integrity and accuracy of migrated or integrated data.
- Performance Tuning & Optimization : Optimize BODS jobs for performance, ensuring efficient execution and minimal processing time for large volumes of data.
- Job Scheduling & Monitoring : Configure and manage BODS job schedules, monitor job executions, and troubleshoot any failures or issues.
- Documentation : Create and maintain comprehensive technical documentation, including ETL specifications, data flow diagrams, and design documents.
- Troubleshooting & Support : Provide technical support and troubleshoot issues related to BODS jobs, data loads, and data quality.
- Cross-functional Collaboration : Work closely with functional teams, source system owners, and target system teams to understand requirements and ensure seamless data integration.
- Unit & Integration Testing : Conduct thorough unit and integration testing of developed BODS jobs to ensure data accuracy and process reliability.
Required Skills :
Strong proficiency in SAP BODS (Business Objects Data Services) for ETL development and data integration.Solid understanding of data warehousing concepts, dimensional modeling, and ETL methodologies.Ability to extract data from various source systems (e.g., SAP ECC, S / 4HANA, databases, flat files).Experience in designing and implementing complex data transformation logic.Knowledge of data quality, data profiling, and data cleansing techniques.Ability to perform performance tuning and optimization for BODS jobs.Strong SQL skills for data manipulation and analysis.Excellent problem-solving and debugging skills.Good communication and collaboration abilities.Skills Required
Etl Development, Sap Bods, Data Extraction, Performance Tuning, Unit Testing, data transformation services