Profile -SAP BODS Developer
Experience – 5 to 10 years
Required Skill Set
•Good communication and must be able to guide peers and help them in functional and technical aspects of BODS.
•Strong ETL knowledge in building Real Time jobs, Batch jobs, Scheduling and Web Services
•Hands on experience inETL process/design, source-target mapping, reviewing, writing, tuning complex BODS ETL code.
•Strong knowledge in Data Services and Data Quality transformations with good data analysis experience using SQL, analysing redundant and inconsistent data, diagramming data flows and process flows.
•Strong knowledge on concepts of Slowly Changing Dimension, ABAP Data flow Extractions, Data warehouse concepts Star Schema, Snowflake Schema, OLTP and OLAP
•Experience in physical characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning etc
•Experience in establishing connection with heterogeneous sources like Hadoop, Hive, Amazon, Salesforce, HANA, ServiceNow, API’s, Web service REST, Web service SOAP, various Databases etc.
•Good knowledge on File formats definition for flexible usage, File location Objects (SFTP, FTP, local, HDFS, Amazon S3 etc)
•Expertise in defining data models using WADL, WSDL, API’s, Nested schemas.
•Performance tuning in BODS using Bulk loader, parallelism etc to optimized long running jobs.
•Hands on experience writing scripting language for custom functions, lookup functions, validation rules, transformation logic, command scripts.
•Developing code to automate jobs using Realtime services, flexible coding to keep/remove dependencies and reusable objects.
•Information steward development on data insights, Task, score cards, data profiling, validation using business rules.