Developer

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.