Prepare for and practice interview questions from Abarca.

Abarca Interview Questions

Abarca 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 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?

Abarca Salaries by Position

What you'll do In a few words... Abarca is igniting a revolution in healthcare. We built our company on the belief that with smarter technology we are redefining pharmacy benefits, but this is just the beginning... As an Associate Data Engineer, you will be responsible for basic designs and the development and delivery of data solutions between operational systems and databases, Data Warehouse, downstream Data Marts as well as files. You will implement optimized designs to meet the operational performance requirements for our solutions and products, which may include the implementation of architecture, following development standards. The fundamentals for the job... <ul><li>Actively participate in the design, development and delivery of solutions using modern technologies, which will be used to move and transform as needed, large amounts of data from multiple sources into multiple destinations.</li><li>Perform peer code reviews and make recommendations.</li><li>Challenge and express your opinion of existing solutions and find "Better Ways" that will result in quality, improved and scalable solutions.</li><li>Serve as data engineering support, maintenance and escalation point for data exchange and data warehouse related services and incidents.</li><li>Align with technical teams on suitable technical, application, or configuration solutions to incoming incidents and issues.</li><li>Maintain frequent communication with peers and IT teams to maintain awareness of issues or changing processes.</li><li>Understand the business implications of technical solutions and assist in defining and documenting technological solutions.</li><li>Escalates and collaborates in major incidents with teams in: Technical Areas, Issue Management, Client Services, Operations, among others.</li><li>Ensure ticket and work item documentation remains current, correct, and relevant including updates to users on status, user-provided input, investigation results, next steps, and estimated delivery time (ETAs) for resolutions.</li><li>Maintain high operational and written standards throughout ticket documentation and management. </li><li>Coordinate, and at times, lead meetings when needed for issue resolution.</li><li>Identify repetitive open known issues for their centralization in a single work item and escalations to development cells for enhancements and bug fixes.</li></ul> What we expect of you The bold requirements... <ul><li>Associate's or Bachelor's in Computer Engineering, Computer Science, Technology, or related field. (In lieu of a degree, equivalent relevant work experience may be considered.)</li><li>1+ years of hands-on expertise operating high volume repeatable ETL/ELT processes in a Large Data Volume environment with complex data transformations.</li><li>1+ years of experience in database development, data modeling, and query optimization.</li><li>Experience working with any major RDMS such as MSSQL, Oracle, Postgres, MySQL, etc.</li><li>Experience using customer service skills to deliver quality and satisfactory service to internal and external clients using tech platforms.</li><li>Experience in using analytical skills and root cause analysis regarding technological solutions, issues, incidents, and problems.</li><li>Excellent oral and written communication skills.</li><li>We are proud to offer a flexible hybrid work model which will require certain on-site workdays (Puerto Rico Location Only).</li><li>This position requires availability to work in a specified time zone or working schedule, accommodating the business needs of our clients and team members.</li><li>This position may require availability for on-call hours, including evenings, weekends, and holidays, to promptly address emergent issues or provide necessary support as dictated by operational demands (if applicable).</li></ul> Nice to haves... <ul><li>Experience with ETL and data tools such as: SSIS, dbt, Matillion, Azure Data Factory, Informatica, Talend, Hadoop, Pentaho and AWS Glue.</li><li>Experience in the healthcare industry and familiarity with its terminology.</li></ul> Physical requirements... <ul><li>Must be able to access and navigate each department at the organization's facilities.</li><li>Sedentary work that primarily involves sitting/standing.</li></ul> At Abarca we value and celebrate diversity. Diversity, equity, inclusion, and belonging are guiding principles of Abarca and ensure Abarca's workforce reflects the communities it serves. We are proud to provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, medical condition, genetic information, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Abarca Health LLC is an equal employment opportunity employer and participates in E-Verify. "Abarca Health LLC does not sponsor employment visas at this time" The above description is not intended to limit the scope of the job or to exclude other duties not mentioned. It is not a final set of specifications for the position. It's simply meant to give readers an idea of what the role entails. #LI-REMOTE #LI-BM1

Abarca Interview Questions

Abarca Interview Guides

Abarca Interview Questions

Abarca Salaries by Position

Abarca Opening Jobs