Prepare for and practice interview questions from Irvine Technology Corporation.

Irvine Technology Corporation Interview Questions

Irvine Technology Corporation Interview Guides

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

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

Irvine Technology Corporation Salaries by Position

IT Business Analyst (Healthcare)We have an immediate need for an IT Business Analyst (Healthcare) to join a healthcare company for a direct hire position. The Business Analyst translates business and system needs into requirements for Designers, developers, and Testers to consume and uses requirements, analysis, specification verification techniques for the purpose. Location: Hybrid, 2 days onsite in Phoenix, AZThis job expects to pay about $60,000-75,000 plus benefits What You Will Do:<ul><li>Plays a vital role in determining the scope and requirements of each IT project. In this aspect of the role, the IT business analyst works with both the IT department and business leaders to prepare reports that outline the project specifications, requirements and scope and ensure that they align with the overall project goals.</li><li>Develops and utilizes standard templates to write requirements and specifications accurately and concisely. Translates conceptual customer requirements into functional requirements in a clear manner that is comprehensible to developers/project team</li><li>Plays an active role in system and project testing procedures. Oversee periodic system testing to ensure that it continually meets functional requirements, oversee usability and user acceptance testing throughout the organization both before and after deployment, and gather user data to make recommendations to improve functionality or reliability.</li><li>Creates process models, specifications, diagrams, and charts to provide direction to developers and/or the project team. Creates technical and project documentation, including user guides.</li><li>Assist in the development and assists in peer reviews of the business requirements to ensure that requirement specifications are correctly interpreted.</li><li>Determines and designs end user training and curriculum for applications and systems. Facilitates the initial rollout and ongoing training of the user community.</li></ul>What Gets You The Job: <ul><li>Experience and proficiency with knowledgebase, defect tracking, and requirements related software systems (such as ServiceNow)</li><li>Three (3) years’ experience in SDLC methodologies, (such as Agile, Lean or Six Sigma)</li><li>Experience with business and technical requirements analysis, modeling, verification and methodology development</li><li>Knowledge of system testing and software quality assurance best practices and methodologies</li><li>Experience in the healthcare industry.</li><li>Bachelor’s Degree in Business Administration, Computer Science, Finance, Education, or Information Systems ; or equivalent combination of education and relevant experience</li></ul> Please send your resume to Hannah Xu, Senior Technical Recruiter for immediate consideration Irvine Technology Corporation (ITC) is a leading provider of technology and staffing solutions for IT, Security, Engineering, and Interactive Design disciplines servicing startups to enterprise clients, nationally. We pride ourselves in the ability to introduce you to our intimate network of business and technology leaders – bringing you opportunity coupled with personal growth, and professional development! Join us. Let us catapult your career! Irvine Technology Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Irvine Technology Corporation complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.

Machine Learning Engineer (Cyber Security Data) 100% Remote Well branded industry leader is seeking a Machine Learning/Advanced Analytics Engineer to create ML models which will provide insights into present and future cyber threats to create a more secure operation. What you will do:<ul><li>ETL Data from security logs into AWS Security Data Lake.</li><li>Create ML models</li><li>Design advanced analytics</li></ul> What gets you the job:<ul><li>4-6 years of ML model experience</li><li>4-6 years of Python and PySpark experience</li><li>2-3 years of AWS SageMaker</li><li>2-3 years of Azure DB</li><li>Knowledge of Cyber Security Data is a must</li><li>Cribl ETL is a nice to have</li></ul>

JD Edwards Business Systems Analyst Well branded industry leader is seeking a JDE BA who will be accountable for delivering quality, comprehensive systems design, business requirements and business cases to the IT organization that will help to improve business efficiency and productivity once implemented. JDE Modules are finance setups and processes, sales orders to cash, procurement to payables processes, and working knowledge WMS (Warehouse Management Systems) in a distribution environment is helpful. Systems used, but not limited to: ERP- JD Edwards, WMS – JDA/BlueYonder. Experience with these systems is a requirement for the role. What you will do:Business Requirements<ul><li>Follow a standard, structured process for the gathering and prioritizing business requirements.</li><li>Interview business users and SMEs to determine business requirements.</li><li>Analyze business unit existing systems and flows of data.</li><li>Develop and maintain information and documentation related to developing and modifying business processes and systems.</li><li>Engage in data modeling, technical analysis, and research alternatives for development of business requirements.</li><li>Translate requirements into highly specified project briefs or requirements packages.</li></ul> Business Solutions Design<ul><li>Identify options for potential solutions and assess them for both technical and business suitability.</li><li>Create logical and innovative solutions to complex problems.</li></ul>Business Solutions Testing<ul><li>Develop the testing schedule and plan for the solution.</li></ul>User Training and Support Day to Day Operations<ul><li>Develop user training manuals and other aids to streamline the uptake of the new system or changes.</li></ul>Resource Management<ul><li>Coordinate the work efforts, scheduling, and prioritization for cross-team resources.</li><li>Effectively transition knowledge to other members of the team to help grow the organization.</li><li>Train and mentor other team members in team standards, processes, and methodologies as appropriate.</li></ul> What gets you the job:Education/Certification<ul><li>Two-year college required or applicable trade school or commensurate work experience, four-year college preferred.</li></ul>Qualifications/Experience<ul><li>8+ years of systems design and test experience with some related leadership experience.</li><li>Experience working in JD Edwards Enterprise One core distribution business processes such as: Sales to Cash, Procure to Pay, Accounting (AP/AR), and Warehouse Management</li><li>Ability to understand, communicate, interpret client business processes and requirements.</li><li>Ability to configure and test with the users.</li></ul>

Position: Sr. Data Scientist (100% Remote on PST)Location: Scottsdale, AZ (100% Remote on PST)Duration: Permanent Full Time, Direct HireSalary Range: 150k to 175k + Excellent Benefits Program Responsibilities:<ul><li>Builds and validates predictive models of an ambiguous issue with no initial solution, utilizing large scale data from multiple data sources and ensures adoption of the model. Drives continuous improvement to existing models and reviews other Data Scientists' models.</li><li>Uses machine learning techniques to create data-driven solutions for various business use-cases</li><li>Understands complex business needs and identifies potential use cases in more than one business unit. Works with external partners to develop a minimal viable product to meet those needs while resolving any issues that may arise.</li><li>Leads the analysis and mining of very large quantities of data using a deep knowledge of a specific domain to find patterns and insights utilizing statistical software</li><li>Writes code for the scope of work being done. Assists in development of data science standards for the department.</li><li>Identifies data that is necessary to complete the analysis and improve the validity, predictability, and accuracy of models. Advises technology partners on new data sources and assists in integrating new internal or external data into the data stack.</li><li>Interprets, communicates, and presents analytic results to C-Level executives and below</li><li>Consistently collaborates with fellow data scientists and frequently interacts with business partners, project managers, cross-functional teams, key stakeholders, and other domains to build analytics capabilities and drive business value.</li><li>Mentors and assists in technically supervising less experienced Data Scientists. Continually strengthens knowledge of analytical methods, vendors, and tools and shares knowledge by participating in best practice sharing opportunities</li></ul> What Gets You The Job:<ul><li>6-9 years of data science experience</li><li>Experience applying statistical techniques in 3+ business units or domains (marketing, pricing, supply chain, operations, etc.)</li><li>Extensive Experience in Machine Learning</li><li>6 years of programming experience in statistical software (for example Python, R, or SAS) and able to demonstrate proficiency at an advanced level. Python expertise is preferred.</li><li>Ability to work with large data sets from multiple data sources.</li><li>Ability to communicate complex analytics concepts and techniques to C-Level executives and below</li><li>Ability to work collaboratively with other data scientists and multiple stakeholders across business unit(s) and with external partners.</li><li>Intellectual curiosity, a passion for data and a results orientation.</li></ul> Educational Requirements:Master's degree in a quantitative field including but not limited to data science, analytics, and statistics. Please send your resume to Dave Lim, Senior Technical Recruiter for immediate consideration. Irvine Technology Corporation (ITC) is a leading provider of technology and staffing solutions for IT, Security, Engineering, and Interactive Design disciplines servicing startups to enterprise clients, nationally. We pride ourselves in the ability to introduce you to our intimate network of business and technology leaders – bringing you opportunity coupled with personal growth, and professional development! Join us. Let us catapult your career! Irvine Technology Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Irvine Technology Corporation complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.

Irvine Technology Corporation Interview Questions

Irvine Technology Corporation Interview Guides

Irvine Technology Corporation Interview Questions

Irvine Technology Corporation Salaries by Position

Irvine Technology Corporation Opening Jobs