Prepare for and practice interview questions from Zillion Technologies, Inc..

Zillion Technologies, Inc. Interview Questions

Zillion Technologies, Inc. Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Zillion Technologies, Inc. Salaries by Position

*****BEST BILL RATE ***** THIS IS A DIRECT BANKING CLIENT REQUIREMENT !Those authorized to work without sponsorship are encouraged to apply please.Reach Shaily Sharma - 9084874334Email: shaily(at)zilliontechnologies(dot)com // 9084874334 US citizens / GC Holders / GC EAD's ONLY Sr. Data ScientistLocation : Remote and Onsite Twice a Week ( Vienna, VA )Duration : Longterm ongoing with no end date. Job Description: Top 3 Required Skills:• Python• SQL• Data warehouse usage Top 3 Desired Skills:• Machine Learning• Data Science• Statistics Provide analytical insights by extracting data through machine learning, programming, data modeling, and advanced mathematics to recognize complex patterns and identify opportunities to drive impact across the organization. Developing an understanding of business needs and objectives through the use of basic descriptive, predictive, and prescriptive models. Perform routine assignments with increasing scope and complexity. Work under close supervision with some latitude for problem solving within existing data platforms and tools. Developing professional with basic skill set and proficiency. Qualifications• 2-3 years of experience in exploratory data analysis• Statistics• Programming, data modeling, simulation, and mathematics• SQL, R, Python, Hadoop, SAS, SPSS, Scala, AWS• Model lifecycle execution• Technical writing• Data storytelling and technical presentation skills• Research Skills• Interpersonal Skills• Model Development• Communication• Critical Thinking• Collaborate and Build Relationships• Initiative with sound judgement• Technical (Big Data Analysis, Coding, Project Management, Technical Writing, etc.)• Problem Solving (Responds as problems and issues are identified) • Bachelor's Degree in Data Science, Statistics, Mathematics, Computers Science, Engineering, or degrees in similar quantitative fields • Desired : Master's Degree in Data Science, Statistics, Mathematics, Computer Science, or Engineering Please send qualified resumes directly to : shaily(at)zilliontechnologies(dot)com // 9084874334 Thanks,Shaily SharmaZillion Technologies Inc.Asst. Director - Talent Acquisition9084874334Email: shaily(at)zilliontechnologies(dot)com // 9084874334

Position-Data Analyst Senior ( Must be local to VA or MD or DC) Location: McLean, VA ( Hybrid)Assignment Type:3 months possible conversion or extension Must Haves: SQL, Excel, Presentation Skills, Jira, Written and verbal skills, Able to write Features, Strong Data Analyst skills, writing stories, UAT Testing, Agile environment.Preferred- Salesforce Data Analyst Senior ● Proactively bring ideas to the table to increase value to our customers, recognizing roadblocksearly, and presenting ideas and options to key partners ● Troubleshoot product questions and technical challengesFacilitate meetings to bring tech and non-tech partners together to innovate and problemsolve ● Demo solution options, existing functionality, and new functionality in various businesssettings ● Understand and proactively utilize Modern Delivery practices ● Actively participate in all agile ceremonies ● Use applications including Jira, Teams, Salesforce configuration workbook, Confluence,Excel, Word, PowerPoint, Visio ● Understand and quickly learn Salesforce technology and value ● Understand and quickly learn business use cases and needsQualifications: ● Bachelor's Degree or equivalent work experience ● In depth understanding of Freddie Mac system functionality highly desirable ● Agile product delivery experience, including requirements capturing, writing user stories, andusing Jira technology (preferred) ● Salesforce knowledge preferred Keys to Success in this Role: ● Outstanding interpersonal, technical, and organizational skills ● Ability to work independently in a fast-paced environment and flexibility to manage multiple ● requests and tasks against tight timelines ● Strong Excel and data comparison experience ● SQL and data analysis skills ● Excellent verbal and written communication skills, technical awareness and leadershipabilities ● Passion for driving value to customers!

Zillion Technologies, Inc. Interview Questions

Zillion Technologies, Inc. Interview Guides

Zillion Technologies, Inc. Interview Questions

Zillion Technologies, Inc. Salaries by Position

Zillion Technologies, Inc. Opening Jobs