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..)