Prepare for and practice interview questions from Tech Tammina Llc.

Tech Tammina Llc Interview Questions

Tech Tammina Llc 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 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

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

Tech Tammina Llc Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Role: HR Data Analyst 3 (Workday)Location: Warren, MI (100% remote) Duration: Long term Rate: MarketThe Role: You will support multiple business processes and work streams related to recruiting and HR-applicable tools as well as serve as a liaison between GTA and our IT and HCM partners for system design and integrations. Responsibilities: Understand how Recruitment Business Processes function within Workday Ability to facilitate discussions with technical and business partners to translate and convey business needs, as well as system impacts or limitation Identify business requirements for technology partner portfolio planning, stakeholder impact and assist in prioritizing business change requests Liaise with IT and HCM and technology partners on daily recruitment operational items including change requests, defect and incident remediation, defining configuration requirements, other issues and concerns to ensure proper and timely solution delivery Guide UAT requirements; creation of test scripts, and follow up with technology partners to ensure accuracy to needs Assist in the development of training materials for system users Aide in development of a coordinated delivery approach, dependencies, resource requirements and schedule for multiple workstreams with the overall program and launch scheduleRequired Qualifications: Minimum 3 years Recruitment experience 5+ years' experience supporting implementation Human Resources (HR) technologies and knowledge of HR-related systems and integrations (HRIS, background check vendors, assessment vendors, employee referral add-ons, CRM) 3 years' experience working in Workday, including experience in handling change requests, defects, incidents, and customer concerns Ability to work in a fast-paced environment with shifting prioritiesTop must-have hard skills: Workday Recruitment business process experience Previous experiences with creating technical requirements</div></div>

<h3>Job Description</h3><div>Job Description<div>Role: Senior Data Analyst Location: Atlanta, GA- Hybrid Duration: Long term Rate: MarketOnly USC/GCTop Skills:5+ years of experience<ul><li>Strong Tableau Skills</li><li>Strong analytical thinking and skills</li><li>Strong cross-functional collaboration skills</li><li>Strong Understanding of digital analytics</li><li>Working knowledge of AWS data tools</li></ul>JD:<ul><li>Serves as a contact for customers or client groups, internal and external to the department, for data research, document, spreadsheet and report compilation and design</li><li>Reviews report usage and requirements with client groups to ensure relevance and alignment with customer needs and documents report enhancements</li><li>Understands taxonomy of Knowledge Management and related systems.</li><li>Maintains, reviews and/or analyzes data files, tables and reports for inconsistencies, troubles shoots data integrity issues and develops cleanup strategy if needed</li><li>Compiles or imports data from various databases into specialized software, databases or tools in order to generate reports to support various departments</li><li>Provides and conducts trend analysis to support business operations; may include budget modeling.</li><li>Writes reports, creates charts, presentations and timelines in support of department or business operations.</li><li>Identifies, researches, and resolves discrepancies in analytical procedure or cross-functional methods.</li><li>Interprets operational requirements for inclusion in studies and analysis.</li><li>Provides recommendations for operational efficiencies and process improvements and assists in policy development to support change initiatives</li><li>May write code to automate reports and templates and consolidate data into reports and knowledge.</li><li>Demonstrates working knowledge of applied mathematics, assessment Instrument design & performance assessments</li><li>Displays working knowledge of applied survey sampling and statistics for all modes of social science data collection for such statistical methodologies as: univariate and multivariate distributions, data modeling using regression, analysis of variance, and the generalized linear model.</li><li>Conducts business impact analyses and validation studies and market research through all stages: concept formulation, definition of metrics, determination of appropriate statistical methodology, research evaluation, and final research report.</li><li>Performs estimation of variances, the calculation of standard errors, and imputation</li><li>Appropriately applies weighting of various sampling and data collection designs</li><li>Applies quantitative methods of social science data analysis 18-Utilizes survey research literature, methods, and processes</li><li>Uses and may program statistical analysis software</li><li>Supports capability development within the delivery organization; including reviews, gap assessments and work to source and deliver strategies.</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div>Role: IT Data Analyst Location: Warren, MI (Day one onsite, Hybrid) Duration: Long term Rate: MarketNeed a USC/ GC as per client requestJob Description: The energy at our company is contagious. We're driven by our immense passion, as we constantly seek out challenges and identify new opportunities. We work hard to connect with our customers and earn their loyalty for life. Bring your talent to our company our opportunities for growth span the globe. We will give you the training and opportunities to unleash your ambition. Must have 4+ years of actual experience, not looking for new graduates Must be Michigan local to go onsite for collaboration Video SSV expected, will be reviewing resumes as they are submitted QUALITY, well formatted, and ensuring there are little to no grammatical errors Very SHARP technical skills IMMACULATE communication and presentation skills Auto industry preferred, not required R can be very helpful, but python experience is required Math background can also be very nice to haveKey Responsibilities/Accountabilities Work as an integral member within the client's Innovations and Analytics team to provide key data science components to support the development of retail strategy. Support Strategic Innovations and Analytics Manager by developing analytical solutions to improve business results. Pursues problem identification and impact across large vehicle populations, leveraging data mining, predictive modeling, simulation and visualization techniques to further enhance insight and internal performance optimization Perform hands-on analysis, search pattern design, mining automation development and data reduction execution Mentors others to develop analytical skill sets throughout the organization Maintain the latest knowledge in software and hardware products or services, trends, and identify best solutions to meet business requirements Establish strong working relationship with peer teams to review requirements/problem areas and establish the appropriate statistical techniques to apply on available data Drive the collection of new data and the refinement of existing data sources Develop best practices for instrumentation and experimentation and communicate those to peer teams Analytics that support Complex Event Processing and Real-Time Event Processing in the context of Big Data Acts as the subject matter expert for Data Analytics as it pertains both Predictive and Prescriptive analysis and ensure alignment with industry best practicesBasic Requirements 4 +years of experience using data to solve problems, answer questions, and create visualizations 4 +years of experience in data quality analysis and data architecture 4 +years of professional development experience 4 +years of experience in Big Data technologies in Hadoop/Hive/Spark platform using Python/Scala Master's degree in Statistics, Mathematics, Operations Research, Economics, Physics, Computer Science or other STEM fields preferred but will take bachelor's degree.</div></div>

Tech Tammina Llc Interview Questions

Tech Tammina Llc Interview Guides

Tech Tammina Llc Interview Questions

Tech Tammina Llc Salaries by Position

Tech Tammina Llc Opening Jobs