| Sr. Oracle PL SQL Developer || TX || F2F at Houston, Texas, USA |
| Email: [email protected] |
| From: Sakshi Tyagi, GVR INFOTEK LLC [email protected] Reply to: [email protected] Sr. Oracle PL SQL Developer Location: Downtown Houston, TX (Onsite) Duration: 24 + Month Interview: Initially Virtual (and final on-site interview with their team as a cultural fit) Must Have: Must HAVE LinkedIn profile Need Local to Houston candidate only ORACLE APPLICATIONS DEVELOPER: This will be a contract duration of 12-24 months and candidates MUST be willing to work ON-SITE Monday-Friday. Client has made it clear they need candidates who have current core development work with PL/SQL. Client will be looking for a candidate who can do the core development on applications and handle packages, procedures, etc. Candidates MUST be able to discuss where they have done Custom Development WITHOUT using Informatica, Cognos, etc. Please ask your proposed candidate : How long has it been since you did PL/SQL development in Oracle Give me some examples of where you recently did development with PL/SQL ( She added We are NOT interested in candidates that have only use reports or ETL work as part of this work experience). As they support Web-Based front-end applications , Developers submitted to this role need to have either XML, Python or JSON experience. They had provided us previously a Questionnaire they asked we apply to all prospective candidates. Here below is the Questions along with some of the answers expected. Get their true reply and do not coach them on the answers: 1. What are various Oracle database objects ANSWER: Table, View, Index, etc. 2. What is an integrity constraint ANSWER: The constraint is used to identify wrong data and generates an error , as to validate data accuracy. 3. What is the difference in a Primary Key and a Unique Key ANSWER: Primary: Can only have one Primary Key and it cannot store null values. Unique: You can have more than one Unique key in a Table, but it can accept Null values. 4. What are Analytical queries How they are different from aggregate functions ANSWER: Analytical queries use Analytical functions Aggregate do Group-By 1 row/ group Analytical Functions dont useGroup-By 5. Types of Partitions ANSWER: List, Range , Hash 6. What are ref cursors ANSWER : Type of Dynamic cursor used to return multiple rows , I refer to them as Explicit Cursors 7. What Web Apps Have You Supported 8. Give Example of Business Logic You Created to Invoke Web Applications 9. Give Example of Complex Batch Processes and Job Schedulers to Automate Data Processing Tasks You Created to Support the Web Apps Functionality 10. Give examples of Performance Tuning you do that Ensures Web Apps run Smoothly Contact at : [email protected] Keywords: information technology procedural language Texas Sr. Oracle PL SQL Developer || TX || F2F [email protected] |
| [email protected] View all |
| Tue Oct 08 18:58:00 UTC 2024 |