| ONSITE as Sr. Oracle PL SQL Developer at Houston, Texas, USA |
| Email: [email protected] |
| From: Kartik Mahajan, GVR Infotek [email protected] Reply to: [email protected] Sr. Oracle PL/SQL Developer Client: EOG Location: Downtown Houston, TX (Onsite) Duration: 24 + Month Interview: Initially Virtual (and final on-site interview with their team as a cultural fit) Visa: USC/GC/H4EAD/GCEAD/OPTEAD/H1B 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 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 Thanks & Regards, Kartik Mahajan IT Recruiter GVR Infotek LLC: 13573 Tabasco Cat Trail, Frisco, TX 75035 Keywords: information technology green card procedural language Texas ONSITE as Sr. Oracle PL SQL Developer [email protected] |
| [email protected] View all |
| Tue Oct 08 18:47:00 UTC 2024 |