Prepare for and practice interview questions from Us Tech Solutions.

Us Tech Solutions Interview Questions

Us Tech Solutions Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

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?

Us Tech Solutions Salaries by Position

Duration: 6 months contract Job Description:<ul><li>The ideal candidate will work in developing and maintaining data models, pipelines, and SQL scripts to assist in the visualization, analysis, interpretation of data.</li></ul> Responsibilities:<ul><li>Operate a robust, stable infrastructure, working closely with Engineering teams and partners to continuously drive process improvements across various cross functional partners.</li><li>Perform data analysis and profiling using relevant tools, leveraging the data infrastructure, and existing data models with minimal guidance. </li><li>Work with clients to identify their needs and clarify requirements and enable data-driven decision-making by collecting, transforming, and publishing data.</li><li>Follow and improve upon the technical best practices, including making data discoverable, thinking about the lifecycle of data, and managing master data well.</li></ul> Experience:<ul><li>3 years of experience in data engineering.</li><li>Experience with analyzing data, database query (e.g. SQL), and creating dashboards/reports.</li><li>Experience with design data pipelines and model data, for sync and async system integration, and implementation. </li></ul> Skills:<ul><li>Ability to manage multiple projects with varying priorities.</li><li>Strong communication and presentation skills to deliver findings of analysis.</li><li>Organizational and project management skills.</li><li>Familiarity with Ads products.</li><li>Knowledge of Data Visualization and dashboard tool - PLX, Tableau, PowerBI, Looker.</li></ul> Education:<ul><li>Bachelor's degree with quantitative focus or equivalent practical experience.</li></ul> About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Recruiter Details:Name: DhavalEmail: dhaval@ustechsolutionsinc.comInternal Id: 24-20544

Duration: 24 months contract Job Description:Works on a product team and supports product design by planning its work, coordinating with others, and writing and testing code to deliver moderately complex functionality on a complete product or significant portion of a product it supports. This level develops simple designs to solve well-defined problems with guidance from more senior team members. May assign, coordinate and review portions of the work to support personnel; Makes decisions within established guidelines subject to review by supervisors; Executes high level applications to more complex problems. Responsibilities:Perform embedded software engineering tasking including requirements analysis, operational concept development, software system design/architecture, component integration, design reviews, integration testing and problem solving Develop embedded operating system software for vehicle controllers in C Assign, coordinate, and review work from other engineers and support personnel. Collaborate with fellow engineers within the team on embedded software work. Execute unit and integration testing of software in multiple environments (virtual and lab) Analyze issues and drive for resolution of issues found during testing Skills & Experience:Demonstrated technical skills in the areas of embedded software development, hardware integration, and electrical systems. Strong communication and teamwork skills Robust problem-solving skills Ability to work in a self-directed environment Nice to Have Skills:Technical experience relating to design and diagnostics of mechanical/electrical/hydraulic systems Experience developing low level and middleware drivers for hardware peripherals Experience with software test and verification in various environments (Hardware in the Loop, Software in the Loop, on Vehicle) Technical experience relating to design and diagnostics of electronic test stands especially using National Instrument modules. Familiarity of GitHub, GitHub actions and Jenkins continuous integration workflows Experience with CAN communications protocols such as the J1939 and ISO 14229 standards Education:Bachelors in Electronics or Computer Science About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Recruiter Details:Name: LalitEmail: lalit.g@ustechsolutionsinc.comInternal Id: 24-20557

Duration: 3+ months Temp to perm Job Description:This role will provide support for organization change by defining needs, recommending solutions and supporting project management activities for initiatives. Responsibilities:<ul><li>Oversee project elements of the business case, eliciting requirements, requirements analysis, communication, testing and training. </li><li>Assist in development and implementation of strategic and support plans.</li><li>Assist with request for proposal (RFP) activities to deliver functional requirements, vendor scorecards, criteria & scoring results, demo scenarios & scoring results</li><li>Facilitate the collection and delivery of requirements, business/use cases, documentation, and test plans, cases, scripts, management and approval.</li><li>Support the execution of process improvement initiatives, creating process flow charts, value stream mapping and related documentation</li><li>Assist in the creation and use of measurement activities required to report on project effectiveness, return on investment (ROI) and other success metrics.</li><li>Assist in the project documentation management based on the needs of each project.</li><li>Collaborate with stakeholders and project team members to improve the quality of project and program delivery.</li><li>Assist in the education and promotion of related methodologies and processes to stakeholders across the institute.</li><li>Perform on-going learning and training related to business analysis, project management and stakeholder activities</li></ul> Experience:Three (3) years business analysis experience REQUIRED.Health care industry experience PREFFERED. Skills:Business analysis, process improvement and process mapping, eliciting requirements, requirements analysis, communication, testing. Education:Bachelor’s degree REQUIRED.Business Analyst Certification REQUIRED. About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Recruiter Details:Name: DavidEmail: Team.david@ustechsolutions.comInternal Id: 24-20331

Note:<ul> <li>Remote</li> <li>Position is highly likely to extend</li> <li>Web application development with React and Node.js.</li></ul>Job Description:<ul> <li>Develops web applications in the Operations Center, primarily using Java Script and React</li> <li>Works with a team of developers to implement, test, and support features in a production environment</li> <li>Collaborates with Product Managers, User Experience, and other support roles to Client and define product requirements</li> <li>Follows industry-standard agile software design methodology and techniques</li></ul>Required Skills:<ul> <li>Strong experience in JavaScript, HTML, CSS, React, Node JS</li> <li>Experience with using and designing REST APIs</li> <li>Experience with Test Driven Development, test automation, CI/CD</li> <li>Strong communication and collaboration skills within a cross functional team</li> <li>Understanding of Agile and XP practices</li> <li>Knowledge of Typescript</li></ul>About US Tech Solutions: US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Duration: 12 months Job Description:<ul><li>Analyzes current operational functions and offers and implements improvements. </li><li>Maintains databases and extracts data for analysis. Runs and reviews reports, analyzing results in support of operational functions. </li><li>Extracts data from multiple systems and departments using various data manipulation and extraction techniques for regular, cyclical, and ad hoc reporting. </li><li>Performs research, analyzes reports, and creates statistical models for presentation/review. Summarizes findings and communicates results to management. </li><li> Identifies operational inadequacies and uses various skills and resources to retool processes. Communicates with other areas regarding outcomes and reporting.</li></ul> Responsibilities:<ul><li>This person will work in ICD and Service Now integration. </li><li>They will be following up on work orders, working with customers to schedule work, providing oversight of deployment level. Soft Skills Customer communication/Service, flexible, adaptable </li><li>About The Team: This team handles all the workstation deployments across the organization. They will provide scheduling and analysis on these deployments. They will research issues in the inventory system and will use this knowledge to help integrate current work into the Service Now platform.</li></ul> Experience:2 Years-Related research and analysis experience Skills:<ul><li>Required Technologies: Service Now, Excel, IBM/ICD, Outlook Day to Day.</li><li>Skills : Good organizational, customer service, communications, and analytical skills. Ability to use complex mathematical calculations and understand mathematical and statistical concepts. </li><li>Knowledge of relevant computer support systems. </li><li>Required Software and Tools: Microsoft Office. Ability to acquire programming skills across various software platforms. </li><li>Work Environment: Typical office environment. Some travel between buildings and out of town</li></ul> Education:Bachelor's degree Statistics, Computer Science, Mathematics, Business, Healthcare, or other related field About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Recruiter Details:Name: PreronaEmail: prerona.m@ustechsolutionsinc.comInternal Id: 24-20121

Job Details: Title: Research Scientist IVDuration: 12 months contractLocation: Burlingame, CAPay Rate: $75 to $84/hr on W2 (Without benefits) Summary:We are seeking a highly skilled and motivated Software/ML Engineer to join human-computer interaction (HCI) team. The successful candidate will have experience in prototyping, debugging, and integrating specialty hardware and software to run experiments. The ideal candidate will have experience working as part of small multidisciplinary teams (e.g., startups) building necessary pipelines and infrastructure for collecting CV and time series datasets, performing quality control, preprocessing and modeling. Additionally, they would have experience implementing and debugging machine learning methods Minimum qualifications:<ul><li>MS with 3+ years of experience in Computer Science, Electrical Engineering, Robotics, Statistics, Machine/Deep Learning, or a related area</li><li>Proficiency in Python, PyTorch, JavaScript, and software best practices (code reviews, version control)</li><li>Experience integrating, bringing-up, and debugging prototype hardware, firmware/drivers, and frontend/backend software to create full-stack software-hardware systems</li><li>Experience implementing Deep Learning pipelines and deploying models</li></ul>Responsibilities<ul><li>Leading data collection efforts with both established and prototype hardware, including device bring up, developing and testing of the user study frontend and backend software, and end to end integration testing</li><li>Providing support to Research Assistants during data collection campaigns</li><li>Performing data quality control, dataset clean up, preprocessing and featurization</li><li>Collaborating with other research engineers and scientists on building software platforms for data analysis and real-time human-system interactions</li><li>Developing robust benchmarking workflows and pipelines for offline and online model performance evaluation</li><li>Developing online learning algorithms to improve model accuracy in real-time</li><li>Developing, applying, and tuning state-of-the-art deep learning algorithms to train and evaluate models</li><li>Regularly reporting on project status, delivering high-quality code with thorough documentation, and effectively communicating updates through presentations and written reports</li></ul>Preferred qualifications<ul><li>PhD in Computer Science, Electrical Engineering, Robotics, Statistics, Machine Learning, or a related area</li><li>Experience with online and offline signal processing of biological time series data and sensor-fusion techniques</li><li>Experience with applying state-of-the-art self-supervised learning algorithms to train and evaluate encoder-decoder models</li><li>Familiarity with AR/VR and ML/CV technologies and literature</li><li>Experience with multi-task learning, few-shot learning, semi-supervised learning</li><li>Experience applying machine learning or other signal processing techniques to noisy sensor data in real-time, interactive applications (e.g., IMU, cameras, EMG)</li></ul> About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit <a>www.ustechsolutions.com</a>. US Tech Solutions is an Equal Opportunity Employer.All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity,national origin, disability, or status as a protected veteran. Recruiter Details:Name: Shalini LEmail: Shalini@UStechsolutionsinc.comInternal ID: 24-20179

Duration: 2+ Months Contract Job Description:<ul><li>Global Product Leads work with sales organizations around the world to translate their needs into requirements for development teams that support them.</li></ul> Responsibilities:<ul><li>Clearly define and prioritize project goals, ensuring alignment with the overall product vision and team's objectives.</li><li>Establish and maintain open communication channels with all stakeholders.</li><li>Proactively identify and manage potential risks and dependencies, developing contingency plans and mitigating issues as they arise.</li><li>Foster a collaborative and productive team environment, facilitating effective communication, resolving conflicts, and encouraging knowledge sharing.</li><li>Continuously track project progress, analyze performance data, and make informed decisions to keep the project on schedule and within budget.</li></ul> Experience:<ul><li>5+ years of experience in Product management.</li><li>Experience in Requirements gathering.</li><li>Stakeholder management.</li></ul> Skills:<ul><li>Requirements gathering</li><li>Data analysis (including basic SQL)</li><li>Communication</li><li>Influence</li><li>Problem Solving</li><li>Strong Technical Knowledge (better for communication with Eng)-Nice to have</li><li>Agile & Scrum Methodologies</li></ul> Education:<ul><li>Bachelor's Degree.</li></ul> About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Recruiter Details:Name: AshikEmail: ashik.a@ustechsolutionsinc.comInternal Id: 24-20053

Duration: 6 months contract Job Description:<ul><li>We have multiple openings for individuals with a minimum of 6 years of professional experience in verification testing of real-time, embedded software.</li><li>This experience might be gained in a test role within a software development organization or gained within a Software Quality Assurance organization, depending upon how the organization is structured.</li><li>In either case, the successful candidate will have experience performing requirements-based software verification of embedded software.</li></ul> Responsibilities:<ul><li>The Senior Software Test Engineer plans and performs a variety of tasks across the areas of software requirements analysis, documentation, hardware-software integration, troubleshooting, problem solving, and software verification testing. The Senior Software Engineer:</li><li>Has knowledge of the full software development lifecycle.</li><li>Has experience working on programs involving the development, maintenance, upgrade and porting of embedded product software and/or product support software to enhance, implement and support project/system functionality for the assigned technical effort.</li><li>Mentors less experienced software test engineers to help develop their software test capabilities and troubleshooting and problem-solving skills.</li><li>Collaborates across other engineering disciplines such as Mechanical, Electrical, Controls, and Systems.</li><li>Ensures that technical approach is consistent with established engineering principles and practices.</li><li>Ensures that product outcomes meet customer needs and that customer and company technical, system, performance, process, and quality requirements are met.</li></ul> Experience:<ul><li>Experience developing, analyzing, and/or reviewing requirements for safety critical real-time embedded software.</li><li>Experience with Computer Networks (switches, VLAN, protocols).</li><li>Experience building and maintaining software and hardware integration testbeds (cabling, power supply)</li><li>Testing and troubleshooting Communication protocol software (CAN, Serial, Ethernet).</li><li>Experience developing tests using NI Software (TestStand, VeriStand, and/or LabView).</li><li>Experience working with software architecture and design information captured in models (using tools such as Magic Draw, Enterprise Architect, or similar model-based engineering tool).</li><li>Familiarity with combat vehicle functionality and capability.</li><li>Experience using Atlassian (Bitbucket, Jira, Bamboo) tools.</li></ul> Skills:<ul><li>Develop, debug, and execute automated and manual requirements-based software verification testing.</li><li>Use version control and issue tracking tools.</li><li>Integrating and testing software with various real-time operating systems such as Linux/Unix derivatives.</li><li>Good programming skills (C++, Python, BASH).</li><li>Traceability across software requirements, design, and verification artifacts.</li></ul> Education:Bachelor's degree in computer engineering, Software Engineering, Electrical Engineering or Computer Science About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Recruiter Details:Name: ShakirEmail: Shakir.a@ustechsolutionsinc.comInternal Id: 24-20082

Us Tech Solutions Interview Questions

Us Tech Solutions Interview Guides

Us Tech Solutions Interview Questions

Us Tech Solutions Salaries by Position

Us Tech Solutions Opening Jobs