Role : SAP BODS / ETL Developer
- Experience in Data migration from various data sources like Excel, SQL server, Oracle, Flat files, SAP ECC and SAP CRM to S4HANA, SAP C4C Using SSIS packages / SAP BODS, Monitoring, debugging and tuning ETL jobs and Workflows.
- Experience with working on reading and converting different file formats, like Parquet, ORC, text, and CSV’s, from Azure Data Lake store using Spark clusters and Synapse Analytics.
- Good hands on using various snowflake features like time travel, fail-safe, shares, zero copy clones, virtual warehouse.
- Having experience in Databricks, Logic apps, Power Automation, PostgreSQL, Alteryx and Azure Purview
- Having experience in creating Notebooks in Databricks using PySpark.
- Having experience in Snowflake.
- Experience in SAP DATA Migration using SAP BODS and Syniti Data Migration (ADM) to Migrate data from legacy SAP system to SAP S4HANA.
- Experience in Syniti ADM Collect, Map, Construct, Transform and Data Services Autogen.
- Data warehousing experience using BODS (ETL), Designer, Management Console, Repository manager.
- Extensively used BODS Designer tools like Projects, Jobs, Workflows, Data flows, Data Store and Formats.
- Used different performance tuning techniques like Parallel processing, multi-Threading, partitioning etc. to improve the extraction and loading performance.
- Developing the Transforms and Data Flows based on the specifications.
- Extensively worked on Data Services Designer Components-Jobs, Transforms, Data Stores, built-in functions, and Custom Functions.
- Worked on Data Profiling and Data Cleansing using Data Services Designer.
- Experience in Using Business Objects Data Services / Integrator in development of data marts according to the Business Requirements.
- Experience in Migrate the data from SAP ECC and other applications to Databases.
- Expertise in Extraction of data from SAP HANA& loading into SAP HANA Database.
- Used ABAP Dataflow to extract from BW&ECC systems.
- Created Open Hub systems to extract data from SAP BW systems using SAP BODS
- Extracted & transferred source data from different databases like SAP BW, SAP ECC, , Oracle, SQL Server, DB2, and Excel Files &Flat files.
- Experience in Debugging &Performance Tuning of Targets, Sources & Mappings.
- Configuration of Central Repository for Multiuser Environment.
- Hands on Installation of Business objects Data Services / Integrator on windows & Unix Server.
- Hands on Migration of Databases , Repositories & upgrade of Repositories.
- Experience in Creating SSIS packages & Scheduling (through SQL Server).
- Working on Unix Server for Flat files storage & Scheduling jobs.
- Good Experience in Creation of qvd&qvw files QlikView integration with SAP BODS.
- Good Experience in Integration of FRaD tool with SAP BODS.
30+ days ago