Oracle Developer (807268)/In-person interview

Sr. Oracle SQL Analyst (807268)/In-person interview

Atlanta, GA

Duration: Long term

Skill

Required / Desired

Amount

of Experience

Oracle SQL development against transactional databases

Required

5

Years

Writing complex SQL (joins, CTEs, subqueries, CASE, aggregate and analytic functions)

Required

5

Years

Normalized relational database design and table relationships

Required

5

Years

Oracle PL/SQL (procedures, functions, packages, views)

Highly desired

3

Years

SQL job scheduling and automated database processes

Required

3

Years

SQL troubleshooting, query optimization, and data validation

Highly desired

5

Years

Translating business requirements into SQL solutions

Required

3

Years

Operational reporting and data analysis

Required

3

Years

Tableau or other data visualization software

Highly desired

Criminal justice or other large transactional database environments

Highly desired

Questions

Description

Question 1

Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?

Question 2

Please list candidate''''s email address that will be used when submitting E-RTR.

Question 3

ON-SITE INTERVIEWS ONLY! Do you and your candidate accept this requirement?

Question 4

Client DOES NOT SHIP EQUIPMENT. The chosen candidate will be required ON-SITE Day 1 to pick up equipment and take a Drug Test. Do you and your candidate accept this requirement?

Question 5

In what City and State is your candidate located?