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

Professional Attributes :

· Good communication

· work in a team with good spirit

· Analytical skills

· presentation skills

· problem-solving skills

Job Type: Contract

Pay: $70,000.00 - $80,000.00 per year

Experience level:

• 10 years

Schedule:

• 8 hour shift

Work Location: In person