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?
Never miss an opportunity! Create an alert based on the job you applied for.
