Vyom Labs x OmnePresent Walk-In Round I

    1. Please enter the same mail ID which was used during registration.
    2. The test will be of 120 minutes.
    3. The question set is divided into two sections - Personal Details & Technical Hands-on
    4. The test will get auto disabled after 120 minutes, so be sure you submit on-time.

    *Required




    START YOUR RECORDING NOW

    Once your recording has started, go to the next section...


    Job Description

    Oracle & SQL Developers:
    Ready to learn new technologies like Snowflake.com and PowerBI.

    Job description:

    - Strong MS SQL Server experience
    - In-depth knowledge of logical/physical database design. (Good Knowledge of Oracle DB architecture)
    - Strong experience with Oracle SQL and PL/SQL.
    - At least 2 to 7 years experience in T-SQL (Queries, Views, Procedures).
    - Experience in T-SQL Optimization.
    - Experience in SSRS or SSMS 2016 and above.
    - Able to write and work with very complex stored procedures.
    - Experience in when to apply different levels of normalization and demoralization.
    - Experience with transferring data quickly between platforms by performing efficient delta refreshes.
    - Solid understanding of N-tier architectures and troubleshooting.


    Registration Form
















    About YourSelf...

    You need to CONTINUE recording your screen and yourself (with webcam) and voice (Mic) Verbally talking about this point


    Technical Questions

    - Explain your answer in detail.
    - Ensure your recording is ON.

    Answer The Questions Verbally While Recording Is On


    1. Scripting / Development Questions - Use Assumptions in case you're not clear

    - Code Database queries the answer section.
    - Explain the scripts and code WHILE you are typing.
    - Continue recording your screen, mic and webcam - they are mandatory

    HR Schema - --------------------START RECORDING [do NOT stop the recording]












    [CONTINUE RECORDING, DO NOT STOP]
    2. Scripting / Development Questions - Use Assumptions in case you're not clear

    - Code Database queries the answer section.
    - Explain the scripts and code WHILE you are typing.
    - Continue recording your screen, mic and webcam - they are mandatory







    CONTINUE RECORDING - DO NOT STOP
    MOVE TO THE NEXT SECTION - DO NOT SUBMIT UNLESS INSTRUCTED


    STOP RECORDING

    Share the video recording url here.



    Thank you!

    Thank you for attending our walk-in.
    I hope you loved the innovative way it was conducted.

    Our team will go through the results and contact the shortlisted candidates for final HR round.

    We wish you all the best!

    You can have a look at our company website for more details about us:
    https://omnepresent.com/