Erp/crm/sap - Sap Bods+etl+sql - Adarsh @ Vega Intellisoft

Job Description

: "Mandatory Skills: SAP BODS, ETL, SQL
Optional Skills: Scripting, Debugging
Experience Range: 6 to 10 Years
Work Location: Bangalore/Chennai/Hyderabad/Pune/Trivandrum/Kochi/Noida
Job Description:
Design of complex ETL interfaces with various source/target types of SAP BODS is preferred. Knowledge in other ETL tools will be an added advantage.
Performance Tuning & Troubleshooting skills across SAP BODS, SQL and scheduling tools.
Strong in DB and SQLs with decent data modelling skills
Ability to lead the developers and QA and adhere to timelines committed. Agile experience is preferred.
Ability to work with both upstream, downstream and reporting system stakeholders and convert the business requirements into technical requirements / JIRA stories.
Strong proficiency in SAP BODS development, including job design, data flow creation, scripting, and debugging.
Create and maintain data integration workflows, ensuring optimal performance and scalability
At least 5+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break fix, user maintenance, CDC, worked with different sources targets to load the data (Oracle, SAP, Files as source; SQL Server, file uploads etc. as targets).
Responsible for Planning, Developing, Implementing and Managing Data Warehouse Project Deliverables, Design Documents and High-Level Data Mapping for ETL Specifications
Knowledge in scheduling tools like Redwood, Control-M.
Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load
Provide support for integration testing, defect fixing and deployment.
Proficient knowledge in transformations like Query, Push down, SQL, Table Comparison, Pivot, Look up () etc.
Proficient Knowledge in Databases like Oracle (SQL Queries), SQL Server
Proficient Knowledge in Dimensional modelling, Data Mining and Data warehouse concepts
Should have Excellent Analytical Skills
Knowledge to transfer data from Oracle, SQL Server tables and Web Services either Incrementally (Delta Load) or full Load to the Data warehouse on periodic basis. Knowledge in Trouble shooting existing ETL jobs and improve performance of the existing jobs
Should be able to create and load data into Aggregate Tables using transformations.
Should be able to perform multiple tasks individually and independently.
Knowledge of Python and AWS will be an added advantage." Key Skills: SAP BODS, ETL, SQL Location: Bengaluru/Bangalore, Chennai, Hyderabad, Pune, Trivandram, Trivandrum Required Experience: 6-10 yrs Positions: 25 Contact Person: AM Team 2 - Con Email ID: hidden_email Qualification: B.Tech. Req Received Date: 28 Oct 2023 End Client: SVB Mode of Work: Full-Time Client RMG: Adarsh Client SPOC

+ View Contact

Keyskills:   break fix data flow etl tools sql server design data mining web services data mapping data modeling data cleansing data integration scheduling tools performance tuning integration testing business requirements project administration troubleshooting skills technical requirements sap bods statements of work sow