ETL BODS Developer

Role : Sr ETL BODS Developer

Location: Melville NY

Duration: 12 months

Job Description:

• Experience in SAP BODS ETL design and implementation involving extraction and provisioning of data from a variety of legacy systems.
• Experience in Data Conversion/Data Migration / Data Warehousing projects that includes analysis and development of Dataflows mappings using needed transformations using BODS.
• Develop Jobs Workflows and Data flows based on the specifications using various stages in BODS.
• Experience in BODS Designer Components Projects Jobs Workflow Data Flow Scripts Data Stores and Formats.
• Experience validating the ETL code and do Unit Testing by writing SQL queries
• Exposure in BODS performance tuning techniques using parallel processing (Degree of Parallelism) Multithreading Partitioning and Database Throughputs to improve job performance
• Hands on exp in debugging execution errors using Data Services logs (trace statics and Error)
• Should have work experience in different types of transformations like Query transformation Merge Case Validations Map operation History Preserving and Table Comparison transformations.
• Should have clear understanding of DW Lifecycle and contributed in preparing technical design documents and test plans

Must require skill:

• Create Manage and Enhance the ETL Pipeline build in EDWH environment using SAP Data Services
• Ensure risks issues and dependencies are being recorded monitored and proactively highlighted to the management
• Ensure to successful timely delivery
• Should be capable of deliver complex ETL requirements Knows about SAP DS architecture.
• Good hands on experience in SAP Data Services
• Good understanding of RDBMS

Nice to have :

• Knowledge of integrating third party APIs how to use
• Knowledge of Python scripting language.
• Knowledge of Sales Force backend a strong plus
• Knowledge of Cloud Platform (GCP AWS Azure etc..)