Prepare for and practice interview questions from Epitec.

Epitec Interview Questions

Epitec 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

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

Epitec Salaries by Position

Position Description:This position will provide a unique and challenging engineering experience combining electrical, software, vehicle level system performance and program management. You will:<ul><li>Engineer electronic control module software</li><li>Evaluate program definition by working with platform systems and feature teams to determine content and market variations</li><li>Lead Statement of Work/RFQ package completion in conjunction with Hardware engineer.</li><li>Communicate with Electrical team to support program increment software development and program milestone delivery.</li><li>Lead product development milestone deliveries for software.</li><li>Work in an Agile environment. Support PI planning. Manage software releases and content.</li><li>Manage JIRA Epics and Stories to support Sagas and program increment deliveries</li><li>Manage JIRA stories status and progress through the sprint board</li><li>Manage software interface definition between suppliers and requirements in JAMA</li><li>Conduct design reviews with interfacing activities and supplier engineering</li><li>Lead program specific software Failure Mode Avoidance (DFMEA)</li><li>Lead traceability evidence from suppliers to demonstrate linkage of specifications, requirements breakdown and test cases to DFMEA controls for safety related items.</li><li>Lead software release process and software change management</li><li>Manage Engineering changes via JIRA, DCR’s, cost approval, and software release in JFROG.</li><li>Provide vehicle build support (e.g. Software Release Package, configurations, BreadBoards, HIL, Development builds, Pilot builds, etc.)</li><li>Lead supplier activities to diagnose bugs, determine root cause, resolution, and verification.</li><li>Identify and escalate critical delivery gaps (expose in JIRA)</li><li>Perform Customer Acceptance Testing</li><li>Lead software quality/warranty analysis and corrective actions</li></ul> Skills Required:<ul><li>Project management</li><li>Embedded hardware and software design</li><li>Proficient in Microsoft Office products</li><li>Experience with JIRA, JAMA, JFROG, SharePoint</li><li>Familiar with CANalyzer, AutoSAR, Cybersecurity, and Functional Safety</li><li>Working understanding of CAN and LIN networks</li><li>Experience with bench and vehicle testing</li></ul> Skills Preferred:<ul><li>Ability to assess, discuss, and collaborate real time.</li><li>Ability to clearly communicate with management and convey action plans in real time.</li></ul> Experience Required:<ul><li>3+ years of experience in the automotive industry.</li><li>3+ years of experience developing electronic control module</li></ul> Experience Preferred:<ul><li>5+ years of module development and launch.</li></ul> Education Required:<ul><li>Bachelor’s degree in Electrical engineering, Computer engineering, or related field.</li></ul>

Role Mandate:The main function of an algorithm developer is to design and implement compute vision and machine learning algorithms for the company's wearable product. The typical developer will be able to test the effectiveness of routines against requirements. The focus of this role will be on device model and algorithm development. Role Responsibilities (including, but not limited to):• Develop and apply advanced methods, theories, and research techniques of algorithms• Designs, implements, and tests algorithms for a variety of signal processing and conditioning tasks• Develop distribution ML training and evaluation pipeline w/ clusters• Design efficient compute vision and machine learning algorithms for classification, detection, and image enhancement.• Synthesize algorithm needs and designs for customer requirements.• Identify, troubleshoot, and resolve issues found with software• Improve software performance. Candidate Value Proposition:The ideal candidate will gain experience and the opportunity to work with problems that include large language models. The individual will be working with experts on state-of-the-art AR and computer systems, there is potential for publication and be exposed to features involved in the latest smart glasses products. Must-Have Skills:• Strong Linux experience• Python, PyTorch, and video processing is required• Development and deployment of machine learning training platforms experience• Familiarity with shell script• Experience with algorithm development• Experience with object-oriented programming in C# and C++ or other languages• Experience with machine learning toolkits and platforms• 5+ years of experience. Nice-to-Have Skills:• Experience in UI design and development for big data visualization. Soft Skills:• Ability to manage projects autonomously Educational Requirements:• Bachelor’s degree in computer science, mathematics, or related field preferred• Masters or Ph D

Epitec POSITION:Senior Software Engineer JOB TYPE:W2, Contract, FT LOCATION:Dearborn, MI JOB SUMMARY FOR SENIOR SOFTWARE ENGINEER: <ul><li>Seeking enthusiastic, experienced Full-stack Software Engineers to build elegant and scalable solutions to power a seamless, frictionless electric vehicle charging experience. We are the technical core of the Electrification Platform, maintaining a strong engineering culture that encourages innovation, growth, learning and development.</li><li>Position will be hybrid in Dearborn, MI.</li><li>Pay: $67 - $74/hr</li></ul> RESPONSIBILITIES FOR SENIOR SOFTWARE ENGINEER: <ul><li>Leverage modern frameworks, open-source tools, and cloud technologies to develop software effectively through paired programming and other methodologies like test-driven development, continuous integration, and deployment.</li><li>Use modern techniques and processes such as agile and LEAN to eliminate waste and maximize value by optimizing the entire software development process.</li><li>Implement distributed, service-oriented, cloud micro service-based architectures.</li></ul> REQUIRED EXPERIENCE FOR SENIOR SOFTWARE ENGINEER: <ul><li>6 years of experience: developing object-oriented software and/or web applications using an object-oriented language like Java and using testing frameworks such as Junit and delivering software applications in an Agile, CI/CD environment 5 years of experience: managing deployments in cloud environments, preferably GCP.</li><li>4 years of experience: conducting system integration, validation, verification, and automation testing.</li><li>4 years of experience: designing and developing DevOps CI/CD.</li><li>Bachelor’s in computer science, engineering, or a related field or foreign equivalency degree, or a combination of equivalent experience and education.</li></ul> SKILLS AND QUALIFICATIONS FOR SENIOR SOFTWARE ENGINEER: <ul><li>6 years of experience: developing object-oriented software and/or web applications using an object-oriented language like Java and using testing frameworks such as Junit and delivering software applications in an Agile, CI/CD environment</li></ul> Why should you choose Epitec?We started Epitec with a single focus, “Placing People First.” Knowing every good endeavor begins with listening and understanding, we’ve set about challenging every part of the employment process. Bringing the proper connections together for the perfect fit. How is Epitec different?Epitec gets to know our prospective employees, using these insights to locate the perfect placement for you. We are there, every step of the way. Providing a best-in-class compensation package combined with the opportunity to grow financially and personally through your work. What is the result?Epitec represents the world’s top companies and works to fill their open jobs with the world’s best talent. That’s led to Epitec servicing an impressive list of Fortune 100 companies. We've also won many awards, including one of Crain’s Detroit Business “Cool Places to Work,” and 101 Best & Brightest – local, national and elite winner. And that’s just the beginning, as we work to innovate the way the world thinks about employment.

Epitec POSITION:Data Analyst JOB TYPE:W2, Contract, FT LOCATION:Dearborn, MI JOB SUMMARY: <ul><li>Data Analyst opportunity in the Dearborn, MI area. Fully onsite role. Candidates need to have previous experience in the automotive industry, as well as a Bachelor's degree. They need to be familiar with coding and database development with a data-oriented mindset.</li><li>Location: Onsite in Dearborn, MI</li><li>Pay: $40-46/hr</li></ul> RESPONSIBILITIES: <ul><li>Responsible for managing the development of various dashboards and tasks for all of Field Service Actions (FSA).</li><li>Implementing processes to assist dealers and activities regarding FSA related concerns.</li><li>Develop Recall/ASO/PSL Recall Program Dashboard within Qlik</li><li>Develop Recall Metrics within Qlik</li><li>Complete System Development for Closing Recalls for OTA (Over The Air) Updates</li><li>Creation of the Field Review Committee Summary Debriefs after every FRC Meeting</li><li>Creation of Recall Reporting in GCAMP</li></ul> REQUIRED EXPERIENCE: <ul><li>Bachelor's Degree and/or 5+ years of experience in the automotive industry.</li></ul> SKILLS AND QUALIFICATIONS FOR PROCESS ENGINEER: <ul><li>Analytical</li><li>Data Oriented</li><li>Familiar with Coding and Database Development</li><li>Self Starter</li><li>Organized</li><li>Ambitious</li></ul> Why should you choose Epitec?We started Epitec with a single focus, “Placing People First.” Knowing every good endeavor begins with listening and understanding, we’ve set about challenging every part of the employment process. Bringing the proper connections together for the perfect fit. How is Epitec different?Epitec gets to know our prospective employees, using these insights to locate the perfect placement for you. We are there, every step of the way. Providing a best-in-class compensation package combined with the opportunity to grow financially and personally through your work. What is the result?Epitec represents the world’s top companies and works to fill their open jobs with the world’s best talent. That’s led to Epitec servicing an impressive list of Fortune 100 companies. We've also won many awards, including one of Crain’s Detroit Business “Cool Places to Work,” and 101 Best & Brightest – local, national and elite winner. And that’s just the beginning, as we work to innovate the way the world thinks about employment.

**Local candidates will be considered first, however this position is open to remote candidates as well.*There is a technical assessment required for this position and it will cover Jmeter, Karate Framework, Microservices, Postman Kafka, Sprinboot, CICD.* About the Role:- Ensure quality of one or more application codebases and alignment with development standards.- Provides input into design of automation for full infrastructure deployment; manages review of and tests for compatibility and integration processes needed to connect with other devices- Automates large scale systems spanning multiple locations and environments.- Writes code automating public cloud, private cloud, and bare metal.- Automates common tasks, deploy with an IaaS model, utilizing chef, ansible, or similar- Ability to write moderately complex scripts and programs for automation, tools, frameworks (using karate), BDD dashboards, alarms. (common uses: Python, Perl, PHP, JavaScript, Go).- Orchestrates the deployment/maintenance of complex applications.- Responsible for performance engineering of the enterprise software architecture.- Significant code development, commitment of code/review of pull-requests, and modest day-to-day support duties. Top 3 Required Skills:<ul><li>Strong Experience in Performance Engineering for Cloud-native applications using Agile methodologies, acceptance and integration test automation scripts, integrating with other tools.</li><li>Experience in Jmeter, Micro Services, Kafka, Karate framework, Springboot, Postman, deployment via CI/CD</li><li>Experience testing RESTful APIs, running tests leveraging Spring boot, Expertise in Java, Spring Boot, Containers (PAAS)</li></ul> Desired/nice to have technical skills:<ul><li>Experience with high volume, low latency transaction processing systems, Automation experience</li><li>Experience with various coding languages Java, Go, C/C++,ESQL, etc. would be desired, financial industry desired</li></ul> About You:-Engineering experience, preferably in high volume, low latency transaction processing systems (such as payments transaction switching, high frequency trading systems or global real-time event streaming systems etc.)-Experience in CI/CD pipeline creation via Jenkins.-Delivered scalable products through a CI/CD pipeline deploying on-prem or in a public cloud infrastructure.-Ensure quality across the full stack via rigorous CI/CD practices in all aspects of the SDLC (Builds, Test, and Deploy).-Excellent troubleshooting skills-Strong writing and verbal communication skills

Epitec Job Title: Marketing Analyst Work Location: Ridgefield Park, NJ (Hybrid) Job Type: W2 Contract Summary:We are currently seeking a Marketing Analyst. They are an individual contributor, responsible for managing core processes that support TV Product Marketing organization and is the focal point for all operational activities. Responsibilities include, but are not limited to, market sizing and analysis at geographic level, scenario planning for business risks, reporting on Key Performance Indicators, P&L Analysis, etc. This position works closely with Sales, Product Marketing, Supply Chain and Finance, to advance corporate objectives.<ul><li>Schedule: Hybrid- 4 days in office (M-Th), 1 day remote (F)</li><li>Pay Rate: $44 - 48/hourly with optional benefits packages including PTO, holiday pay, medical insurance, and more.</li></ul> Role & Responsibilities:<ul><li>Maintain and improve data models to size the US TV Market. Forecast Samsung’s overall market position and across the key segments, leveraging internal and external data with focus on geographic action planning.</li><li>Lead quarterly scenario planning process, identifying opportunities & risks to our target plan. Develop specific action plan within each scenario and monitor progress to trigger scenario plans as needed.</li><li>Manage Promotional Roadmap, including but not limited to proposing data driven promotional prices, improving processes, managing changes and communicating to stakeholders.</li><li>Analyze and interpret KPIs to inform leadership on drivers of leading indicators and deliver recommended actions plans. Monitor key priorities and market trends, sensing competitive risks before they occur.</li><li>Develop, standardize and deploy tools and processes that support the achievement of corporate objectives. Closely monitor key performance indicators to ensure executives and decisions makers are in an informed position to maximize revenue, share and profit.</li><li>Develop and maintain lift and cost simulation tools to maximize ROI and enable swift decision making on promotional activities and programs.</li><li>Aggregate daily field reports, monitor SKU level performance and recommend actions to improve trends.</li><li>Facilitate the flow of information across internal partners. Close collaboration with Product Managers to ensure key channel, market and segment insights are gathered and leveraged across all processes.</li><li>Anticipate future business requirements; perpetually measure the pulse of the organization and their department objectives to ensure cohesion of strategic priorities.</li></ul> Required Education and Experience:<ul><li>Bachelor's Degree with 3-5 years of directly related experience is required. Prior operational experience in technology, business development and/or OEMs Sales and Marketing required.</li><li>Advanced user of Microsoft Excel and Power Point.</li><li>Proficiency in business systems (SAP, Tableau, BI).</li></ul> Required Skills and Qualifications:<ul><li>Must have strong analytical and problem-solving skills with ability to schedule, prioritize and communicate actions and results as needed.</li><li>Must be able to work well under the pressure of timelines and demonstrate a sense of urgency when driving for results.</li><li>Track record of delivering maximum output, working independently, and managing one’s time.</li><li>Must deploy diplomatic approach to solving complex problems </li><li>Excellent written and oral communication skills; Experience developing presentations and communicating with internal as well as the customer’s executive management team is a necessity.</li><li>Strong teamwork skills with the ability to effectively participate and motivate others working within a team environment.</li><li>Prior experience with consumer electronic products preferred.</li></ul> Why should you choose Epitec?We started Epitec with a single focus, “Placing People First.” Knowing every good endeavor begins with listening and understanding, we’ve set about challenging every part of the employment process. Bringing the proper connections together for the perfect fit. How is Epitec different?Epitec gets to know our prospective employees, using these insights to locate the perfect placement for you. We are there, every step of the way. Providing a best-in-class compensation package combined with the opportunity to grow financially and personally through your work. What is the result?Epitec represents the world’s top companies and works to fill their open jobs with the world’s best talent. That’s led to Epitec servicing an impressive list of Fortune 100 companies. We've also won many awards, including one of Crain’s Detroit Business “Cool Places to Work,” and 101 Best & Brightest – local, national and elite winner. And that’s just the beginning, as we work to innovate the way the world thinks about employment.

We are looking for a Business Analyst to design and develop product concepts and specifications that reflect the customer’s needs aligning with technical and business requirements.
Responsibilities: Plans and conducts customer research to gather data and discover problems through user and stakeholder interviews.
Validates researched data to bring leading indicators in focus, allowing the team to actively analyze, synthesize and determine valuable product/service options.
Iteratively hypothesizes and discovers new opportunities for the customer’s needs/desires, aligning with business objectives and technical standards.
Seeks continuous feedback, emphasizing the importance of research-driven product decisions.
Engages with the Product Owner and team to prioritize and define product strategy and roadmaps.
Collaborate with vendors to design, develop, document, and maintain software prototypes.
Collaborate with external and internal technical peers (Product Managers, Product Designers, Software Engineers, Architects, and vendors) to design and validate technical approaches and designs.
Contribute to maintaining a readied backlog and enable the team to go further with effective usage of Rally/Jira.
Collaborates with Business Customers, Product Owners, Product Managers and document the Features, User Stories, Test Cases, etc.
Utilize and advocate the use of agile methodologies to meet stakeholder requirements.
Skills Required: Bachelor's Degree in Information Systems, Computer Science, Computer Engineering, or a related field.
5+ years of gathering and analyzing requirements and designing software prototypes to support product development.
2+ years of working experience with cross-functional teams where you utilized good communication and collaboration skills.
You have produced research assets (journey maps, affinity walls, empathy maps, storyboards, personas, etc.) to capture learning and communicate the immersive customer experience with the team and other stakeholders.
Conveys design requirements and specification details to the team.
Ability to document detailed features and user stories with acceptance criteria.
Ability to create test cases including edge cases based on user stories.
Skills Preferred: Ability to operate in an ambiguous environment with a curiosity towards new technologies and a strong desire to learn so that the team may benefit.
Understands design principles and tools.
Uses UI/UX design practices to advocate for the customer and help the team evolve the product.
Engages in and provides a design perspective for cross-product integrated experiences.
Ensures a cohesive design within product groups and platforms by adhering to the Design System running usability tests, creating open feedback forums, etc.
Communicates how the design incorporates both customer and business value.
Experience with business domains Purchasing, MP&L, and Product Development will be considered a plus.
High degree of initiative, self-motivation, and ability to work autonomously.
Knowledge about API design standards, patterns, and best practices to create robustly and performing integrated systems.
Good team player and encourages team learning opportunities like Design Thinking.
Experience in cloud platforms like GCP, Azure, AWS.
Experience Required: 5+ years of gathering and analyzing requirements and designing software prototypes to support product development.
2+ years of working experience with cross-functional teams where you utilized good communication and collaboration skills.
Education Required: Bachelor's Degree in Information Systems, Computer Science, Computer Engineering, or a related field.

#J-18808-Ljbffr

We’re seeking a WebFocus developer who has experience building data products on a cloud analytics platform. You will work on data extraction, data transformation, data loading into GCP & WebFocus Integration to support the Enterprise in the Data Factory on Google Cloud Platform (GCP). Experience with WebFocus, QlikSense & Alteryx is a must. You will: <ul><li>Work in collaborative environment that leverages paired programming. </li><li>Work on a small agile team to deliver Enterprise Modernization of migrating data to GCP. </li><li>Work effectively with fellow software engineers, product owners, data champions and other technical experts. </li><li>Demonstrate technical knowledge and communication skills with the ability to advocate for well-designed solutions.</li></ul> Skills Required:<ul><li>10+ years of overall IT experience, 5+ years’ experience developing in WebFocus Environment, 5+ years’ experience developing QlikSense dashboards, 5+ years’ experience developing Alteryx workflows. </li><li>Excellent communication, analytical, problem-solving, and planning skills. </li><li>Able to function well as a team member, as well as work independently on assignments. </li><li>Motivated professional (results oriented and self-starter)</li><li>Experience with Agile practices</li></ul> Experience Required:<ul><li>10+ years of overall IT experience, </li><li>5+ years experience developing in WebFocus Environment. </li><li>5+ years experience developing QlikSense dashboards.</li><li>5+ years experience developing Alteryx workflows.</li></ul> Education Required:<ul><li>BS in Computer Science or related field</li></ul>

POSITION:Technical Business Analyst JOB TYPE:W2, Contract, 12 Months LOCATION:Ridgefield Park, NJ JOB SUMMARY: <ul><li>Looking for a Business Analyst to support eCommerce fulfillment operations by developing data tables, creating forecasts, driving process improvements, and collaborating with IT/Data teams. Requires strong analytical skills, BI expertise, and experience with supply chain metrics.</li><li>Work schedule: 4 days onsite, 1 day remote</li></ul> RESPONSIBILITIES FOR BUSINESS ANALYST: <ul><li>Monitor and support the execution of fulfillment orders across the eCommerce/omni-channel network.</li><li>Develop and create data tables to support day-to-day store fulfillment operations.</li><li>Create forecasting for fulfillment based on current plans and metrics in conjunction with Finance.</li><li>Engage and collaborate with the IT/Data Engineering Team to align programs/projects in support of supply chain business objectives and strategies.</li><li>Identify, recommend, and implement improvement opportunities in work methods, procedures, or equipment to increase throughput and/or quality.</li><li>Monitor and analyze identified and established key operating metrics; assist in the development and maintenance of an accurate measurement system.</li><li>Leverage reporting and dashboards to drive process improvements resulting in reduced costs and improved service.</li><li>Lead or participate in process improvement teams; prepare project reports for management.</li><li>Monitor and maintain information related to fulfillment throughputs across all stages.</li><li>Act as a Subject Matter Expert on reporting capabilities and performance monitoring tools.</li><li>Work independently to support time-critical fulfillment operations, including decision-making for monitoring and triaging major system issues, escalation, resolution, and communication to maintain/restore fulfillment operations.</li></ul> REQUIRED EXPERIENCE: <ul><li>Minimum 5+ years of experience in Business Intelligence/Analytics.</li><li>Business analysis and business process management skills.</li><li>Project management and team management skills.</li><li>Understanding of order management, distribution, and transportation processes.</li><li>Experience with fulfillment/eCommerce domains.</li><li>Experience with supply chain metrics and their use to drive process improvements.</li><li>Proven process improvement experience.</li><li>Effective communication skills with the ability to influence others to accomplish team objectives.</li><li>Experience in creating, modifying, and maintaining distribution of reports using multiple data inputs, systems, and tools.</li></ul> SKILLS AND QUALIFICATIONS: <ul><li>Strong analytical skills.</li><li>Keen attention to detail and technical acumen.</li><li>Advanced Excel skills.</li><li>Advanced SQL skills with at least 2 years of experience in developing advanced SQL.</li><li>Experience with BI reporting tools (Tableau).</li><li>Experience in Elastic Search/Kibana.</li><li>Good understanding of MPP/Distributed Database systems.</li></ul>

Job Description: Support quarterly tactical planning and non-standard infrastructure planning. You’ll handle operational overhead, planning, and analyses. This role involves delivering one of the world’s largest data center infrastructures in a fast-paced environment with an incredible team. It’s a great learning experience for those interested in analytics and the data center domain. Day-to-Day Responsibilities: <ul><li>Collaborate with the SP team to support quarterly tactical planning sessions.</li><li>Analyze data to forecast infrastructure needs and plan accordingly.</li><li>Assist in planning and implementing non-standard infrastructure projects.</li><li>Ensure these projects align with overall strategic goals.</li><li>Manage and reduce operational overhead through efficient planning and analysis.</li><li>Identify areas for improvement and implement solutions.</li><li>Handle large datasets to extract meaningful insights.</li><li>Provide detailed reports and analyses to support decision-making.</li><li>Oversee various projects, ensuring they are completed on time and within budget.</li><li>Coordinate with different teams and stakeholders to ensure smooth project execution.</li><li>Work closely with team members and other departments to ensure alignment and effective communication.</li><li>Present findings and recommendations to senior management.</li><li>Continuously learn about new trends and technologies in the data center domain.</li><li>Apply new knowledge to improve processes and strategies.</li></ul> Educational Background:<ul><li>At least a Bachelor’s degree in fields such as Computer Science, Information Technology, Data Analytics, or a related discipline.</li></ul> Professional Experience:<ul><li>2-5 years of experience in roles related to data centers, infrastructure planning, or analytics.</li><li>Previous experience in a tech role, preferably within the data center space.</li></ul> Skills and Competencies:<ul><li>Strong project management skills, ideally with a Project Management Professional (PMP) certification.</li><li>Ability to handle ambiguity and adapt to a fast-paced work environment.</li><li>Detail-oriented with the capability to manage and analyze large amounts of data.</li><li>Self-starter with initiative and drive.</li><li>Familiarity with data center operations and infrastructure.</li><li>Proficiency in data analysis tools and software.</li><li>Excellent communication and collaboration skills to work effectively with the SP team and other stakeholders.</li><li>Problem-solving skills and the ability to think critically and strategically.</li></ul>

Epitec Interview Questions

Epitec Interview Guides

Epitec Interview Questions

Epitec Salaries by Position

Epitec Opening Jobs