ETL Job Vacancies in Jaipur

Should have prime skill set on LTMC/LTMOM and Secondary skill set SAP BODS. Facilitate Data Migration Workshops Understand legacy applications data structure Good Hands-on SAP Fiori Apps for Data Migration. (SAP Version 2022) Knowledge to debug the code to find the root cause of errors. Should be able to generate data validation Programs. Map legacy applications data structure to S/4 Hana [ all modules] Lead Value-Field Mapping Sessions Create / Modify data load scripts Create / Modify data validation scripts Manage Data Load Sequences Understand legacy applications data structure Map legacy applications data structure to S/4 Hana [ all modules] Extensive experience in SAP BODS for ETL Experience on design and developing SAP Data services job to extract data from flat files, CSV files, Excel files, SQL server, Oracle, SAP ECC, etc. Should have good analytical skill to analyse the ETL issues and fix them independently Should have sound knowledge of BODS scheduling and Management console Extensively worked on platform, Data integrator and transforms Should have experience min 7 year max 10 min. Sound knowledge of SQL. Create/Modify the Extraction/Transform jobs to prepare Data load file Create/ Modify the Reconciliation jobs to prepare reconciliation report after data load to support data validation. Education: Graduate in Science / Technology Licensing/Certification: SAP S/4 Technical Knowledge: BODS, ABAP, ETL of Master and Transactional Data across SAP Modules -MM,PP,SD,FI,QM., LTMC, LTMOM LSMW, Migration Cockpit , Object Modeller, Interfaces, iDocs, 7-10 years exp.remote working.

Responsibilities:Design, develop, maintain and execute the SAP Data migration strategyDocument the SAP Data entity modelDesign, develop and coordinate the integrity of the Data Migration and its environments for the global templateDesign, develop and maintain an agreed set of Data Migration Test cycles in accordance with the agreed ERP deployment testing and DM strategiesDesign, develop and maintain an agreed set of Data Migration test scripts in accordance with the agreed ERP test cyclesCoordinate the execution of data test scriptsCoordinate the formal capture, analysis and remedial action of data related faults found as part of the testing cyclesCoordinate site data cleansing activityDesign, develop, implement and execute Extract, Translate and Load (ETL) processes and protocols e.g. data repositories, extract histories, error trapping conventions, error resolution processes and sign-off criteria -Design functional specifications for Data Extracts, Translations and Loads (ETL)Source appropriate ETL toolsetDesign, develop and implement data reconciliation processes and controlsUpdate test rig to capture test scripts, sequencing, faults, patches and remedial actions as a result of data related faultsLiaise with the configuration manager to preserve the integrity of the Data environments and supporting materials Requirements: 5+ years of managing Data Migration and Integration stage ERP projects.Full lifecycle SAP experience in an SAP manufacturing environment with specific understanding of manufacturing, supply chain, shop floor, commercial and finance processes and operationsCollege or University (IT /Business Degree or Equivalent)Certified Data Management Professional (CDMP) or equivalentSAP systems general architecture; Broad understanding of business functions. Specific knowledge of ETL methodology, tools and processesTechnical expertise in: Data Models, Database Design Oracle SQL or MS SQL, Access queries & report writingTechn.

Required skills: Bachelor's Degree in IT / Engineering 4+ years of relevant work experience Strong experience in SQL scripting Proficiency with ETL and ETL tools is required Proficiency in building visualization using Tableau Good experience working with Microsoft excel. Ability to work independently and with business stakeholders- Experience creating HR related reports (workday or similar) a big plus Working knowledge of Salesforce and/or Netsuite is nice to have Excellent communication (verbal and written) Strong team player and results-driven.What You Will Be Doing Develop and optimize data architecture to support the data needs of our rapidly-growingbusiness Mine data to create new Insights into improving Finance, Products, Engineering, Marketing andSales Operations and Process. Enhance Analytics automation and reduce the time taken to arrive at decision making analysis Creating high impact Tableau dashboards and data visualizations Manage Databases (including creating new Tables, Views, and Functions as required)Kind of questions they may ask on SQL:- Writing Sub-queries- Understanding of NULL values- Aggregates, group by and order by- Understand Rank functions- Understand Case/conditional statements- Joins

Data Engineer - Skills3+ years of relevant experience in the data engineering role, including data warehousing andbusiness intelligence tools, techniques and technology, or experience in analytics, business analysisor comparable consumer analytics solutionsStatistics experience preferredExperience in big data processing and using databases in a business environment with large-scale,complex datasets. (SQL, Hadoop, Spark, Flink, Beam etc)Knowledge and direct experience using business intelligence reporting tools. (Quicksight, Tableau,Splunk etc.)Extensive knowledge of SQL query design and tuning for performance and accuracyExperience with Python, R, or other data relevant scripting languages preferredExperience with Data Lake design and philosophyExperience in an Agile/Sprint working environment preferredProficient research skills to locate market information using numerous internal and external sourcesof data