| Urgent Requirement || ETL Developer || Onsite || C2C at Melville, New York, USA |
| Email: [email protected] |
| Title: ETL Developer Location: Melville, NY 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 -- Keywords: information technology New York |
| [email protected] View all |
| Mon Dec 04 20:56:00 UTC 2023 |