Prepare for and practice interview questions from Zortech Solutions.

Zortech Solutions Interview Questions

Zortech Solutions Interview Guides

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>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.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

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?

Zortech Solutions Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><p>Role: Solution Data Architect </p></div><div><p>Location: Wilmington, NC (Hybrid) </p></div><div><p>Duration: 6+ Months </p></div><div><p>Job Description: </p></div><div><p>Highly skilled and experienced Solution Data Architect with 10+ years of experience in designing and implementing data solutions. </p></div><div><ul><li><p>Develop and implement scalable data architectures and solutions to meet business requirements. </p></li></ul></div><div><ul><li><p>Design and optimize data models, ETL processes, and data pipelines to ensure efficiency and performance. </p></li></ul></div><div><ul><li><p>Write and maintain high-quality code using Scala, PySpark, Shell scripting and SQL. </p></li></ul></div><div><ul><li><p>Optimize and troubleshoot complex SQL queries to improve performance and ensure data security. </p></li></ul></div><div><ul><li><p>Leverage Cloudera Platform/Azure Data Cloud <span class="long-word">Services/Databricks</span> to build and manage data solutions. </p></li></ul></div><div><ul><li><p>Implement data security best practices and ensure compliance with relevant regulations. </p></li></ul></div><div><ul><li><p>Oversee project timelines, resource allocation, and deliverables to ensure successful project completion. </p></li></ul></div><div><ul><li><p>Collaborate with stakeholders, business analysts, and IT teams to gather requirements and deliver data solutions. </p></li></ul></div><div><ul><li><p>Create and maintain comprehensive documentation for data architectures, processes, and solutions. </p></li></ul></div><div><ul><li><p>Stay current with industry trends and emerging technologies in data architecture and cloud services. </p></li></ul></div><div><ul><li><p>Propose and implement Data integration frameworks for data processes and technologies. </p></li></ul></div><div><ul><li><p>Strong leadership and team management capabilities. </p></li></ul></div><div><ul><li><p>Excellent problem-solving and analytical skills. </p></li></ul></div><div><ul><li><p>Effective communication and interpersonal skills. </p></li></ul></div></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Role: Business Analyst with CLM & CDM</b></p><p><b>Location: Bay Area, CA (Hybrid)</b></p><p><b>Duration: 12 Months</b></p><p><b>Job Description:</b></p><p>Try to look for the folks with Palantir experience despite it is good to have skill.</p><p>Business Analyst with a strong background in Contract Life Cycle Management (CLM) and Contract Decision Management (CDM)</p><p><b>Job Description</b>:</p><p><b>Position Summary</b>: We are seeking a Senior Business Analyst with a strong background in Contract Life Cycle Management (CLM) and Contract Decision Management (CDM) within the healthcare or pharmaceutical domain. The ideal candidate will have over 8-10 years of experience in the US healthcare sector and proven expertise in working with multi-vendor environments across different time zones. Palantir expertise is preferred but not mandatory.</p><p><b>Key Responsibilities</b>:</p><ul><li>Lead the implementation and optimization of Contract Life Cycle Management (CLM) and Contract Decision Management (CDM) solutions in healthcare or pharma projects.</li><li>Collaborate with stakeholders to gather and document business requirements, ensuring alignment with organizational goals and regulatory requirements.</li><li>Analyze, design, and implement effective business processes and workflows related to contract management.</li><li>Facilitate cross-functional team collaboration, including internal teams, external vendors, and stakeholders across multiple time zones.</li><li>Provide subject matter expertise in the US healthcare domain, ensuring that solutions are compliant with industry standards and regulations.</li><li>Conduct data analysis and reporting to support decision-making and continuous improvement initiatives.</li><li>Utilize Palantir tools and technologies to enhance data integration, analysis, and visualization (preferred).</li></ul><p><b>Qualifications</b>:</p><ul><li>Bachelor's degree in Information Technology, Healthcare Management or a related field. Master's degree preferred.</li><li>Minimum of 8-10 years of experience as a Business Analyst, specifically within the US healthcare domain.</li><li>Proven experience in Contract Life Cycle Management and Contract Decision Management implementation in healthcare or pharmaceutical settings.</li><li>Strong understanding of US healthcare regulations, compliance, and industry standards.</li><li>Experience working in a multi-vendor environment and managing cross-functional teams across different time zones.</li><li>Proficiency in business analysis tools and methodologies.</li><li>Excellent communication, interpersonal, and stakeholder management skills.</li><li>Strong analytical and problem-solving abilities.</li><li>Experience with Palantir technologies is highly desirable.</li></ul><p><b>General Expectations</b>:</p><ul><li>Ability to work independently and as part of a team in a fast-paced environment.</li><li>Strong organizational skills and attention to detail.</li><li>Ability to handle multiple projects simultaneously and meet deadlines.</li><li>Commitment to continuous learning and professional development.</li><li>Adaptability and flexibility in responding to changing business needs and priorities.</li></ul></div></div>

<p>Role: Sr Software Engineer with Azure cloud experience
Location: Remote/US
Duration: 6+ Months
Job Description
Primary Responsibilities: Research, evaluate, identify alternative approaches, recommend, design and code efficient and effective solutions for challenging problems ranging from small to large work efforts for low to high complexity problems.
Comply with standards and guidelines related to the design, construction, testing and deployment activities as established by departmental and organizational standards.
Demonstrate collaborative skills working within a project team of diverse skills and will bring communication skills including oral, written and presentation skills, creativity, and problem-solving skills to a challenging environment.
Partner with other competency leads/developers and support project planning, technical design, development and solution deployment functions.
Identify opportunities in business processes, system capabilities and delivery methodologies for continuous improvement as applicable.
Required Qualifications Bachelor's Degree
5+ years of hands-on software engineering, object-oriented and/or functional programming
5+ years of experience building enterprise level software using JAVA, J2EE technologies and Spring boot
2+ years of experience with Message Broker systems like Kafka or MQ
2+ years of experience working with data technologies such as SQL, Oracle or PostgreSQL
2+ years of experience in Azure cloud development
Experience in GitHub and Maven to manage source code and dependencies
Experience in Jenkins and configuring CICD pipelines.
Preferred Qualifications Bachelor's Degree in Computer Science, Software Engineering or MIS
3+ years of experience in developing in agile teams and building integrated tests
3+ years of experience integrating RESTful APIs or web services with user interfaces
1+ years of experience in UI development using Angular or React

#J-18808-Ljbffr</p>

<h3>Job Description</h3><div>Job Description<div><div><p>Role: Solution Data Architect </p></div><div><p>Location: Wilmington, NC (Hybrid) </p></div><div><p>Duration: 6+ Months </p></div><div><p>Job Description: </p></div><div><p>Highly skilled and experienced Solution Data Architect with 10+ years of experience in designing and implementing data solutions. </p></div><div><ul><li><p>Develop and implement scalable data architectures and solutions to meet business requirements. </p></li></ul></div><div><ul><li><p>Design and optimize data models, ETL processes, and data pipelines to ensure efficiency and performance. </p></li></ul></div><div><ul><li><p>Write and maintain high-quality code using Scala, PySpark, Shell scripting and SQL. </p></li></ul></div><div><ul><li><p>Optimize and troubleshoot complex SQL queries to improve performance and ensure data security. </p></li></ul></div><div><ul><li><p>Leverage Cloudera Platform/Azure Data Cloud <span class="long-word">Services/Databricks</span> to build and manage data solutions. </p></li></ul></div><div><ul><li><p>Implement data security best practices and ensure compliance with relevant regulations. </p></li></ul></div><div><ul><li><p>Oversee project timelines, resource allocation, and deliverables to ensure successful project completion. </p></li></ul></div><div><ul><li><p>Collaborate with stakeholders, business analysts, and IT teams to gather requirements and deliver data solutions. </p></li></ul></div><div><ul><li><p>Create and maintain comprehensive documentation for data architectures, processes, and solutions. </p></li></ul></div><div><ul><li><p>Stay current with industry trends and emerging technologies in data architecture and cloud services. </p></li></ul></div><div><ul><li><p>Propose and implement Data integration frameworks for data processes and technologies. </p></li></ul></div><div><ul><li><p>Strong leadership and team management capabilities. </p></li></ul></div><div><ul><li><p>Excellent problem-solving and analytical skills. </p></li></ul></div><div><ul><li><p>Effective communication and interpersonal skills.</p></li></ul></div></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Role: Business Analyst with RPA Expertise</b></p><p><b>Location: Allentown PA- Hybrid</b></p><p><b>Duration: 6+ Months</b></p><p><b>Job Description:</b></p><p>Job Description for Business Analyst with RPA Expertise:</p><p>The Business Analyst with RPA Expertise will be responsible for identifying, analyzing, and implementing RPA solutions to optimize business processes. This role involves working closely with various stakeholders to understand their needs, documenting requirements, and collaborating with the RPA development team to design and deploy effective automation solutions. The ideal candidate will have a strong background in business analysis, a deep understanding of RPA technologies, and the ability to drive continuous improvement initiatives.</p><p>Key Responsibilities:</p><ol><li>Requirements Gathering and Analysis: <ul><li>Collaborate with business stakeholders to understand and document their requirements for process automation.</li><li>Conduct thorough analysis of existing business processes to identify opportunities for automation and improvement.</li><li>Translate business requirements into functional and technical specifications for RPA solutions.</li></ul></li><li>Process Mapping and Documentation: <ul><li>Create detailed process maps and workflows to illustrate current and future state processes.</li><li>Develop comprehensive documentation, including business requirements, functional specifications, and test cases.</li></ul></li><li>RPA Solution Design and Development: <ul><li>Work closely with the RPA development team to design and develop automation solutions using leading RPA tools (e.g., UiPath, Blue Prism, Automation Anywhere).</li><li>Ensure that RPA solutions align with business objectives and comply with technical standards and best practices.</li><li>Participate in the testing and validation of RPA solutions to ensure accuracy and effectiveness.</li></ul></li><li>Project Management: <ul><li>Manage the end-to-end lifecycle of RPA projects, including planning, execution, monitoring, and reporting.</li><li>Coordinate with cross-functional teams to ensure timely delivery of RPA initiatives.</li><li>Track project progress, identify risks, and implement mitigation strategies as needed.</li></ul></li><li>Stakeholder Communication and Training: <ul><li>Serve as a liaison between business stakeholders and the RPA development team, ensuring clear and effective communication.</li><li>Provide training and support to end-users on newly implemented RPA solutions.</li><li>Gather feedback from stakeholders to continuously improve RPA solutions and processes.</li></ul></li><li>Continuous Improvement: <ul><li>Monitor the performance of deployed RPA solutions and identify areas for enhancement.</li><li>Stay up to date with the latest trends and advancements in RPA technology and recommend innovative solutions.</li><li>Drive continuous improvement initiatives to optimize business processes and achieve operational excellence.</li></ul></li></ol><p>Qualifications:</p><ul><li>Bachelor's degree in Business Administration, Information Technology, Computer Science, or a related field.</li><li>Proven experience as a Business Analyst with expertise in RPA, preferably in a similar industry.</li><li>Strong understanding of RPA technologies and tools (UiPath,).</li><li>Excellent analytical and problem-solving skills, with the ability to think critically and strategically.</li><li>Proficient in process mapping and documentation techniques.</li><li>Solid project management skills with a track record of successfully delivering RPA projects.</li><li>Strong communication and interpersonal skills, with the ability to work effectively with diverse stakeholders.</li><li>Ability to work independently and as part of a collaborative team.</li><li>Knowledge of programming languages (e.g., Python, Java, C#) is a plus.</li><li>Certification in RPA tools (e.g., UiPath Certified RPA Associate) is a plus.</li></ul><p></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Role: Databrick Data Architect-Mid-Senior level</b></p><p><b>Location: Berkeley Heights, NJ-Hybrid </b></p><p><b>Duration: 3 Months to start - Full-time</b></p><p><b>Skills:</b></p><ul><li><p><b>Architecture</b></p></li><li><p><b>Azure Databricks</b></p></li><li><p><b>Data Access</b></p></li><li><p><b>Data Architecture</b></p></li><li><p><b>Data Modeling</b></p></li><li><p><b>Data Models</b></p></li><li><p><b>Data Sharing</b></p></li><li><p><b>Data Vault</b></p></li><li><p><b>Data Warehousing</b></p></li><li><p><b>Extract, Transform, Load (ETL)</b></p></li></ul></div></div>

<p>Role: Healthcare Data Analyst

Location: Remote/Eden Prairie, MN/US

Duration: 6-12+ Months

Job Description

Minimum 10 Years of IT exp
Healthcare industry experience, particularly familiarity with Medicaid & Medicare claims, member data.
Experience with overseeing collection, storage and use of data, preparing data to share
Experience with Cloud technology, such as Snowflake, Databricks, ADF
Work history demonstrating excellent interpersonal, verbal, and written communication skills

#J-18808-Ljbffr</p>

<p>Role: Product Manager-RAO

Location: San Jose, CA-Hybrid–2 days working onsite

Duration: 6+ Months

Job Description:

Role Context: For Managing Downstream Reporting boy other Databases that consume data from HANA (today) / S4HANA (with the new release)

Mandatory Skills: SAP ECC FICO, S4HANA Finance/SD

Job Description:

As a Product Manager Finance, you are expected to work with SAP Finance business requirementsin SAP S4HANA to provide Reporting Requirements to the Engineering Teams.
Reporting Requirements will be delivered in SAP Hana Sidecar.
You will be responsible for creating business use cases for valiadtion of Hana Analytics based Reports and Dashboards.

Skills And Experience Should Include

SAP FICA, SAP SD, and SAP S4HANA.
Hands on experience in writing SQL Queries for data validations and reports validations is a must.
Experience in working with JIRA, Confluence/Altassian Wiki pages, writing Functional Product Requirement Documents, Test Scenrios, Basic Pwoer BI or Tableaue Reports will be an added advantange.
Experience in work with Financial KPRs/OKRs is added advantage. SAP ECC to S4HANA Migration Experience is and added Advantage

#J-18808-Ljbffr</p>

Zortech Solutions Interview Questions

Zortech Solutions Interview Guides

Zortech Solutions Interview Questions

Zortech Solutions Salaries by Position

Zortech Solutions Opening Jobs