I applied through university. The process took 1 week. I interviewed at Acistek Corporation (Arlington, VA) in Mar 2015
Interview
First off, I got a phone Screen speaking with HR. The questions are very much like the other post here on glassdoor. Next, they sent a web developer online test link, which contains SQL, Cold Fusion cfm coding problems. If you pass the online test, there will be a onsite interview.
Interview questions [5]
Question 1
1. Testing your understanding of reading and intepreting the files.
Interpret the attached file and provide a brief description below.
2. Testing your basic SQL statements in Oracle
Account_Info
Account_Info_ID auto number
Account_Info_Name varchar2(100)
Account_Removal
Account_Removal_ID auto number
Account_Removal_Name varchar2(100)
Account_Potential
Account_Potential_ID auto number
Account_Potential_Name varchar2(100)
Please write a SQL Statement to retrieve all records from all of the tables above.
3.
Account_Info
Account_Info_ID auto number
Account_Info_Name varchar2(100)
Account_Removal
Account_Removal_ID auto number
Account_Info_ID number
Account_Removal_Name varchar2(100)
Account_Info contains all records in the system
Account_Removal contains all removed records in the system
Please write a SQL statement to retrieve only records that are not in the Account_Removal table
4. Testing the integration between SQL and JSP/ColdFusion
Using any of the sql statement in Q2,Q3, please output the records in JSP/ColdFusion and HTML
5. Testing the integration between SQL, JSP/ColdFusion and Javascript
Using any of the sql statement in Q2,Q3, please prompt a Javascript alert where the ID is an even number in the HTML HEAD section and display records where ID is odd number in JSP/ColdFusion in the HTML BODY section.
