Hi Partner, Please share some matching resume.
*SAP HANA Modeler* *Title: Sr. SAP HANA modeler* *Location: Fremont, CA* *Required:* • Minimum 2-3 years of SAP HANA experience. • Experience on HANA modeling required. • Should have hands on experience on relation DBs like SQL Server • Experience with HANA modeling (Enterprise/Stand Alone/Native HANA/BW on HANA) • Very strong on SQL Scripting on HANA • Should have built and Deployed HANA in recent project. • Needs to know how is HANA used in DW • Should have worked in onsite/offshore model. · *How many years of HANA experience.* o Candidate should have at least 2 -3 Years of experience on HANA · *How many years of HANA projects have you implemented?* o Atleast 2 projects · *Mention what is the role of the persistence layer in SAP HANA?* o SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile. · *Mention what is the advantage of SLT replication?* o SAP SLT works on trigger based approach; such approach has no measurable performance impact in the source system o It enables real-time data replication, replicating only related data into HANA from non-SAP and SAP source systems o Replication from several source systems to one HANA system is allowed, also from one source system to multiple HANA systems is allowed. · *Mention what is modeling studio?* o Modeling studio in HANA performs multiple task like o Declares which tables are stored in HANA, first part is to get the meta-data and then schedule data replication jobs o Manage Data Services to enter the data from SAP Business Warehouse and other systems o Manage ERP instances connection, the current release does not support connecting to several ERP instances · *What is the difference between a user defined function and a Stored procedure?* o Stored procedure needs to be invoked whereas a UDF can be used like any other statement. Or o A stored procedure maintains the security of data base where as user defined function not. · *Does storing of data in stored procedures increase the access time? Explain?* o Data stored in stored procedures can be retrieved much faster than the data stored in SQL database. Data can be precompiled and stored in Stored procedures. This reduces the time gap between query and compiling as the data has been precompiled and stored in the procedure. To avoid repetitive nature of the data base statement caches are used. · *What is SET in SQL* o SET command changes the system variables affecting the report environment. · *What is SQL Synonyms?* o Synonyms is the alias name for table, views, sequences & procedures and are created for reasons of Security and Convenience. o Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention. · *What is the difference between normalization and DE normalization.* o We do normalization to remove redundant data and easy managing of data. o De-normalization is done when database performance is slow. o Redundancy is the repetition of same data in different tables, for ex, if address is save in more than one table then this is redundant data. *Thanks & Regards* *Amit Kumar* *Next Level Business Inc.* *Staffing|Consulting|Outsourcing* *Phone: **904-371-2917**| Fax: +1 (608) 646 - 8326* *Email: [email protected] <[email protected]> | GTalk: recruiter.amitk* *Web: www.nlbservices.com <http://www.nlbservices.com/>* *An ISO 27001 and 20000-1 Certified & Minority Business Enterprise (CMBE)* CONFIDENTIALITY NOTICE: This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to which it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. -------------------------- Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with "remove" and include your "original email address/addresses" in the subject heading. Include complete address/addresses and/or domain to be removed. We will immediately update it accordingly. We apologize for the inconvenience if any caused. -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
