Prepare for and practice interview questions from Epitec.

Epitec Interview Questions

Epitec 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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Epitec Salaries by Position

Summary:The primary function of the Data Analyst is to provide business intelligence support through the creation and delivery of repeatable and ad-hoc reports (charts, graphs, tables, etc.), enabling informed business decisions across various areas. Key Responsibilities:<ul><li>Analyze Performance: Evaluate the performance of process activities, identify issues, and present findings through clear, concise charts, graphs, tables, or summaries.</li><li>Reporting and Tracking: Establish standardized methods for recording, tracking, and reporting on activities.</li><li>ETL Processes: Design, implement, automate, and maintain large-scale enterprise data ETL (Extract, Transform, Load) processes.</li><li>Database Management: Modify and maintain databases and database management systems. Direct programmers and analysts as needed to make changes.</li><li>Process Improvement: Assess activity trends to identify opportunities for process improvements and provide recommendations.</li><li>Research and Development: Conduct research on emerging products, services, and techniques in the field of data analysis.</li></ul> Skills Required:<ul><li>Strong interpersonal and consultative skills for translating and understanding reporting requirements.</li><li>Ability to work both independently and as part of a team.</li><li>Excellent written, verbal, and presentation communication skills.</li><li>Knowledge of key information service standards (e.g., SDLC, ITIL, QA/testing, Six Sigma).</li><li>Proficient in Microsoft SharePoint and strong PC skills.</li><li>Korean speaking is a big preference. </li></ul> Education & Experience:<ul><li>Bachelor's Degree in a technical field such as computer science, computer engineering, or a related discipline.</li><li>6+ years of relevant experience in data analysis or business intelligence roles.</li><li>Process certifications such as Six Sigma, CBPP, BPM, ISO 20000, ITIL, or CMMI are preferred.</li></ul> Additional Responsibilities:<ul><li>Administer analytics tools, including site tagging, configuration, audits, monitoring, custom dashboards, and user training.</li><li>Generate and improve both regularly scheduled and ad-hoc web analytics reports to provide impactful insights.</li><li>Develop and implement web analytics strategies, including custom tagging and tracking (e.g., JavaScript for events and triggers in Tag Manager).</li><li>Collaborate with cross-functional teams (Business, Category, Product, Merch, UX) to deliver analytics reporting and insights.</li><li>Utilize SQL to extract valuable insights from large data sets such as clickstream and transactional data.</li><li>Develop measurement frameworks and reports for non-technical audiences to improve digital marketing and customer conversion funnels.</li><li>Ensure data quality and integrity for key functions such as internal mapping, product hierarchy, and site taxonomy.</li><li>Coordinate and analyze experiments across digital channels (web, mobile, app), working closely with strategy teams, product managers, designers, developers, and marketers.</li><li>Maintain and optimize an A/B testing pipeline, from ideation to execution and analysis.</li><li>Define, prioritize, and communicate key hypotheses and metrics for testing, and provide actionable recommendations.</li><li>Stay current on trends and best practices in A/B testing, digital analytics, and UX</li></ul>

Position Description:Ford is seeking to hire a person with software development knowledge in embedded systems. The Body Control Software team develops software for vehicle features such as starting, locking, lighting, alarms, windows, powered enclosures, cabin climate control and seats. Employees in this job function are responsible for designing, developing, testing, and maintaining software applications and products to meet customer needs. They are involved in the entire software development lifecycle including designing software architecture, testing for quality, and deploying the software to meet customer requirements. Applicants should have detailed knowledge of functional specifications (software requirement development), conduct design reviews, help resolve vehicle/bread board issues, have 5+ years of engineering work experience and an understanding of embedded hardware and software design. Skills Required:<ul><li>Project Management experience </li><li>Understanding of embedded hardware and software design </li><li>Knowledge of control theory and algorithm design </li><li>Proficient in Microsoft Office products </li><li>Matlab Simulink , JIRA, JAMA, and Github experience required </li><li>Familiarity with CANalyzer, AutoSAR, and Functional Safety required </li><li>Working understanding of CAN and LIN vehicle networks </li><li>Familiarity with functional safety </li><li>Familiarity with cybersecurity and message authentication </li><li>Experience in working with, and / or for, an Electronic Control Manufacturer is desirable </li><li>5+ years of engineering work experience </li><li>Would consider less than five years of experience if the candidate has a demonstrated working knowledge of the subject matter.</li></ul> Experience Required:<ul><li>5+ years of engineering work experience </li><li>3+ years of experience in Algorithm Design for Embedded hardware and/or software design </li><li>3+ years of experience with control theory and algorithm design via truth tables and finite state machines </li><li>1+ years of vehicle network (CAN/LIN) experience </li><li>1+ years of experience in Matlab/Simulink</li></ul> Education Required:<ul><li>Bachelor's in electrical engineering or bachelor's in computer science/engineering or other engineering degree with required experience/skill set</li></ul> Education Preferred:<ul><li>Master’s degree in Electrical Engineering, Computer Engineering, Computer Science or a related field of study </li><li>7+ years of engineering work experience </li><li>5+ years of Algorithm Design for Embedded hardware and/or software design </li><li>5+ years of experience with control theory and algorithm design via truth tables and finite state machines </li><li>Familiarity with JAMA, JIRA, and Github </li><li>Familiarity with CANalyzer, AutoSAR, SOA and Functional Safety </li><li>Proficient in Microsoft Office Products </li><li>Experience in working with and/or for an electronics control manufacturer</li></ul>Additional Safety Training/Licensing/Personal Protection Requirements: Additional Information :<ul><li>***POSITION IS HYBRID***</li></ul>

Position: Supply Chain/Data AnalystLocation: 85 Challenger Rd., Ridgefield Park, NJ, USAWork Schedule: Fully On-SiteRole Type: Temporary 11 weeks with possibility for extension depending on workload.Rate: $24 per hour flat rate Key Skills:<ol><li>Advanced proficiency in MS Excel</li><li>Strong analytical abilities</li><li>Excellent communication skills</li></ol> Education and Experience:<ul><li>Bachelor’s degree in Business, Economics, Finance, or a related field</li><li>Minimum of 3 years of relevant experience</li></ul> Purpose of Position: The Supply Chain Data Analyst will play a crucial role in this leading consumer tech company's Supply Chain Team, ensuring product availability to meet forecasted demand. This position involves generating and tracking forecasts through collaboration with Sales, Marketing, and the Global Operations Center. The analyst will manage specific reports and projects, support SCM Planners, and produce reports for internal customers and executive management. Responsibilities:<ul><li>Enhance SCM Operations and Forecast Accuracy:</li><li>Provide monthly snapshots of demand forecasts and key SCM KPIs at both total and product levels.</li><li>Bridge the gap between planning and execution through weekly analytical reviews.</li><li>Identify root causes of operational failures and implement corrective actions.</li><li>Drive operational requirements for new technology segments within the Display product group.</li><li>Monitor Consumer Delivery Performance:</li><li>Track daily delivery performance and analyze each step, including Click to Delivery, Order Allocation Management, and NPS tracking.</li><li>Foster Consensus Among Teams:</li><li>Improve collaboration between Sales, SCM, Marketing, and Logistics to close target gaps.</li><li>Monitor and ensure progress on major SCM projects on a weekly basis.</li></ul> Required Knowledge, Education, and Experience:<ul><li>Bachelor’s degree in Business, Economics, Finance, or a related field.</li><li>At least 3 years of experience in forecasting, demand planning, metrics, or reporting.</li><li>High proficiency in Microsoft Excel, Outlook, and Office Suite.</li><li>Experience with SAP, Tableau, and Alteryx.</li><li>Excellent written and verbal communication skills.</li><li>Comfortable working in a multicultural business environment.</li><li>Willingness to work overtime as needed.</li></ul>

Visa sponsorship is not available, now or in the near future, for this position. Onsite role only Primary Job 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 Required Skills• 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 Skills that help stand out• 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 Description: Major Purpose: 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. Major Duties:<ul><li>Develops, codes, configures, and tests programs and systems. </li><li>Evaluates and implements enhancement design solutions to improve cost, quality, and performance of software applications. </li><li>Analyzes assignments and determines software specifications that must be fulfilled to achieve objectives. </li><li>Executes necessary documentation, as directed, or needed. </li><li>Collaborates with other relevant stakeholders and team members to ensure that features meet business needs. </li><li>Follows industry-standard agile software design methodology for development and documentation. </li></ul> Skills, Abilities, Knowledge: <ul><li>Ability to analyze, translate, and define business requirements into technical solutions. </li><li>Excellence in verbal and written communication forms with emphasis on persuasive communication, tact and negotiation. </li><li>Ability to apply engineering principles and concepts for designs. </li><li>Ability to manage many competing priorities/requests in a fast-paced environment </li></ul> Education: <ul><li>Degree in an Engineering/Technology discipline or equivalent experience. - University Degree (4 years or equivalent) </li><li>Degree in an Information Technology discipline or equivalent experience. - University Degree (4 years or equivalent) </li></ul> Work Experience: <ul><li>Previous experience in programming/software development. (1 - 3 years) </li><li>Participating in Agile Development (1 - 3 years)</li><li>Experience working in an Agile Environment (1 - 3 years)</li></ul>

Primary Job 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 Required Skills• 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 Skills that help stand out• 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

Position Description:Product Development uses design thinking & user experience methods to deliver breakthrough products and services that delight our customers. We bring innovative, exciting, and sustainable ideas to life. We have opportunities around the world for you to contribute to advancements in autonomy, electrification, smart mobility technologies, and more! Develop and utilize Design Thinking and User Experience methods for new car products and software features. Create HMI software including screens and widgets for SYNC infotainment system. Utilize C++/Web application layer software to develop interactive software features such vehicle settings and Software Update applications, etc. Implement graphical user-interfaces using QML/Qt Quick/Web technologies for SYNC infotainment system as well as perform integration support. Test the developed software for performance and document system design.Skills Required:<ul><li>Provide High Level Design and Low Level Designs for given features. </li><li>Implement graphical user-interfaces using QML/Qt Quick/Web technologies for SYNC infotainment system as well as perform integration support. </li><li>Develop unit and integration testing for the developed features. </li><li>Test the developed software for performance and document system design.</li><li>Debug customer/filed issues and fixing the bugs.</li></ul> Experience Required:<ul><li>5 years of experience in the position offered or 3 years of experience performing software development using C++, Web programming, CSS, JavaScript, HTML and JavaScript Frameworks. </li><li>Requires 3 years of experience developing user interface components using Qt/QML or JavaScript Frameworks and web technologies. </li><li>Also requires 2 year of experience: developing software in an Agile development environment and using Agile methodologies; and developing HMIs for infotainment, embedded systems, or mobile platforms. </li><li>Requires 3 year of experience with at least three of the following: utilizing QNX OS or RTLinux; validating code with unit-testing frameworks; performing software development involving inter-process communications; performing software development on multi-threaded software applications; or utilizing GNU debug tools. </li><li>Requires 2 year of experience in software development for embedded systems. </li><li>Experience in React.js and React Native is a plus </li><li>Position may work from home but must live within commuting distance of stated office.</li></ul> Experience Preferred:<ul><li>Expereince in embedded systems or Automotive ECUs</li></ul> Education Required:<ul><li>Requires a Bachelor’s or foreign equivalent degree in computer science, engineering or a related field</li></ul> Education Preferred:<ul><li>Masters degree and 3 years experience in software development</li></ul> <ul><li>***Hybrid (3days a week in Dearborn)***</li></ul>

Position Description:As a Software Engineer at Company working in the In-Vehicle Infotainment, you will have the responsibility of designing and developing Artificial Intelligence (AI) Systems for Software Quality and Warranty. In this role, you will lead the development and maintenance of AI and machine learning algorithms to measure and identify for the performance of Infotainment systems. You will own delivery of highly stable and high-quality product. Our infotainment systems must be equipped to handle the use cases of today and those of tomorrow. Our ambitions reach well beyond existing solutions, and we are in search of innovative individuals to join this team. Ideal candidates will have experience in artificial intelligence and machine learning and big data analytics and delivering such a trained system. Candidate should have excellent interpersonal and communications skills. Success in this role requires someone who is centered around product and engineering excellence with a bias for action; thrives in a fast-paced, dynamic environment; successfully partners with a wide group of people at multiple levels of the company; and embodies our practices for diverse teams. Skills Required:<ul><li>Bachelor’s degree in computer science, electrical engineering, mathematics, statistics, operations research, or related field</li><li>Experience with the complete software lifecycle for embedded systems</li><li>Strong technical writing and oral communication skills</li><li>Demonstrated contributions and expertise in two or more of the following domains:</li><li>Regression algo for interpolation and extrapolation (both linear / non-linear)</li><li>Time series analysis and statistics, autoregressive models, filtering algorithms</li><li>Gaussian processes and/or kernel methods, Bayesian statistics</li><li>Modeling with different neural network architectures: MLP, CNN, RNN</li><li>Quantitative model performance assessment using cross-validation, blind testing.</li><li>Physics-informed neural networks (ML for computational fluid dynamics or finite element analysis, point cloud or mesh-based neural networks, PDE surrogate modelling)</li><li>Uncertainty quantification and propagation for time series analysis and forecasting.</li></ul> Skills Preferred:<ul><li>Defines problem, devise solution and delivery roadmap across future milestones, including staging technologies; builds strategies that optimizes project resources against priorities.</li><li>Analyze source data and data flows, working with structured and unstructured data (text, audio, images, video, etc.)</li><li>Manipulate high-volume, high-dimensionality data from varying sources to expose and highlight patterns, anomalies, relationships, and trends.</li><li>Apply AI and Machine Learning technics to predict and solve complex, real-world problems.</li><li>Analyze and visualize diverse sources of data, interpret results in a business context and report results clearly and concisely.</li><li>Fulfill problem formulation and ML technique consulting requests in a timely manner.</li><li>Communicate and present analytical models to other teams and executive management.</li><li>Work collaboratively with different software stakeholders and be able to present results in a clear and concise manner.</li><li>Ensures delivery of stable software with the expected quality and stability managing the software development schedule and backlog.</li></ul> Experience Required:<ul><li>3+ years of experience with delivering and maintaining production software products.</li></ul> Education Required:<ul><li>Bachelor’s degree in computer science, electrical engineering, mathematics, statistics, operations research, or related field</li></ul> Education Preferred:<ul><li>Doctorate in computer science, mathematics, statistics, operations research, or related field AND 2+ year(s) data-science experience (e.g. managing structured and unstructured data, applying statistical techniques and reporting results)</li><li>OR Master’s degree in computer science, mathematics, statistics, operations research, or related field AND 3+ year(s) data-science</li><li>OR bachelor’s degree in computer science, mathematics, statistics, operations research, or related field AND 5+ year(s) data-science experience</li></ul> <ul><li>***POSITION IS HYBRID (3 days a week in Dearborn)***</li></ul>

Hybrid in Detroit, MI NO C2C Reporting Analyst for Medicare Business Performance - Business Process Management Top 3 required skills/experience:• Proven ability to translate stakeholder requirements into reporting deliverables while independently working with internal partners.• Proven ability to understand and utilize reporting system capabilities into educating and proposing innovative analytics to divisional leadership.• Identify, document and communicate system and process changes necessary to improve system and operational performance measures and reporting. Required skills/experience: • Five (5) years of relevant technical or business work experience required.• Must have the aptitude and desire to learn new competencies and skills.• Creative, responsive and adaptive in a dynamic environment.• Working knowledge of analysis and reporting tools.• Ability to frequently communicate orally, write, read, comprehend, reason, and perform basic mathematic calculations and analyze.• Proficiency in Microsoft Excel and Microsoft PowerPoint. Preferred skills/experience: • Proficiency in Microsoft Access• Working knowledge of Smartsheet application• Customer service background preferred Education/Certifications • Bachelor’s degree in related field required

*Local candidates only. Must be able to work 3 days per week in the office.**Technical assessment required for application that will cover C, C++, and Unix. OverviewThe candidate will work with cross-functional teams in developing highly scalable, reliable, maintainable, performant and secure applications. The ideal candidate should be passionate about software delivery, highly motivated, intellectually curious, analytical, and a strong team player. What you will do:<ul><li>Design and develop highly technical solutions to meet technical business requirements.</li><li>Responsible for the analysis, design, development, and delivery of software solutions. </li><li>Participate in planning, design, and estimation. Develop technical solutions to meet business requirements in accordance with MasterCard standards, processes, and best practices.</li><li>Write modular, extensible, readable, and performant code. </li></ul> Required technical skills?<ol><li> C (Intermediate to Advanced)</li><li> C++ (Intermediate to Advanced)</li><li>Unix/Linux</li><li>Agile</li></ol> Desired/nice to have technical skills?<ol><li> Pair Programming</li><li>Test Driven Development</li></ol>

Epitec Interview Questions

Epitec Interview Guides

Epitec Interview Questions

Epitec Salaries by Position

Epitec Opening Jobs