Prepare for and practice interview questions from Ascendum Solutions.

Ascendum Solutions Interview Questions

Ascendum Solutions 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

Ascendum Solutions Salaries by Position

Location Requirement: Candidate MUST be in Cincinnati, OH, and be available to work in the downtown office on a hybrid schedule (on-site Mon, Tues, Weds, remote Thurs & Fri.) We are seeking a detail-oriented Data Analyst for a 6-month W-2 contract-to-hire position. You will play a critical role in maintaining and developing business reporting functions, transforming large datasets, and providing data-driven insights. Key Responsibilities:<ul><li>Assist with the maintenance of daily, weekly, monthly, and quarterly business reporting functions.</li><li>Gather Retail Operations data from multiple databases, platforms, stakeholders, and 3rd party vendors for analysis.</li><li>Transform large data sets through data wrangling, exploratory data analysis, and predictive modeling.</li><li>Leverage Power BI (and other data visualization tools) to build and maintain custom reports and dashboards to reveal trends and correlations.</li><li>Implement row-level security in Power BI (and other tools) for secured viewing of reports based on job levels and locations.</li><li>Identify opportunities to enhance reporting capabilities and improve processes.</li><li>Collaborate with cross-functional teams to understand data needs for executing strategic objectives and initiatives.</li><li>Identify and communicate data-related issues and recommendations to the business owner, manager, and team.</li><li>Provide data insights and solutions to leaders to drive decision-making.</li></ul>Requirements:<ul><li>Proficient in R (data cleaning, performing calculations on large datasets, performing exploratory data analysis) and occasional use of Python.</li><li>Strong expertise in Power BI, especially with DAX, Power Query, Dataflows, Row-Level Security (RLS), and writing measures with DAX.</li><li>A great eye for visualization and a focus on user experience—our team prioritizes making reports visually appealing and user-friendly.</li><li>Experience in standardizing and solidifying data processes and quality.</li><li>Ability to problem-solve and investigate issues while participating in system testing across multiple feature and component teams.</li><li>Experience in Agile Project Management, including completing estimates and work plans in Program Increments (PI) meetings.</li></ul>

Minimum Qualifications:<ul><li>Bachelor’s degree in computer science, Engineering, or a related field.</li><li>3+ years of experience in software development and quality assurance, with a focus on web testing.</li><li>Strong proficiency in programming languages such as JavaScript, TypeScript, or Python.</li><li>Hands-on experience with test automation tools like Playwright, Selenium, or Puppeteer.</li><li>Solid understanding of web technologies including HTML, CSS, JavaScript, and HTTP protocols.</li><li>Experience in testing web services, APIs, and microservices architecture.</li><li>Excellent problem-solving skills and attention to detail.</li><li>Strong communication and collaboration abilities with the ability to work effectively in a team environment.</li><li>Self-motivated with a passion for learning and continuous improvement.</li><li>Experience working in an Agile/Scrum development environment.</li><li>Familiarity with CI/CD pipelines and DevOps practices.</li><li>Knowledge of additional testing frameworks and tools such as Jest, Mocha, or Chai.</li><li>Previous experience in performance testing and security testing of web applications.</li></ul> Key Responsibilities<ol><li>Collaborate with cross-functional teams including developers, product managers, and quality assurance engineers to understand project requirements and develop comprehensive test plans.</li><li>Design and develop automated test scripts using Playwright to validate the functionality, performance, and security of web applications.</li><li>Implement and maintain test frameworks, libraries, and tools to streamline the testing process and improve efficiency.</li><li>Execute test cases, analyze test results, and report defects using appropriate bug tracking tools.</li><li>Participate in code reviews, sprint planning, and daily stand-up meetings to ensure alignment with project goals and timelines.</li><li>Identify opportunities for test automation and work towards achieving a high level of test coverage across all layers of the application.</li><li>Stay up-to-date with the latest industry trends and best practices in web testing and automation.</li></ol>

W2 candidates only, C2C candidates are not permitted. Full benefits/PTO available. Job Description<ul><li>We’re looking for a passionate and highly motivated Senior Developer to join Engineering team who is responsible for System design & architecture, developing high-quality functions paying attention to details making customer experience seamless and smooth. Additionally, provide technical leadership and vision in design, implementation, testing, and rolling out existing, and new services in a multi-region configuration. Design and development of REST application program interface (API) and Webservices</li><li>Design and create re-usable frameworks/components to help the needs of global delivery</li><li>Maintaining REST API documentation using swagger and doing design documentation</li><li>Document work and engage in quality testing/validation for changes or improved features before releasing to the customer</li><li>Troubleshoot issues and debug codebases</li><li>Working on AWS cloud platform including EKS</li><li>Maintain and improve existing codebases and peer review code changes</li><li>Adapt new technologies, tools, processes from the organization as needed</li><li>Ensuring the API layer aspects for security, monitoring, analytics, throttling</li><li>Work with Leads and team members to meet all project deliverables and milestone dates</li><li>Communicate well with team members and suppliers and work collaboratively</li></ul> Desired Skills:<ul><li>Prior Experience in Navigation systems for Automotive multimedia</li><li>Experience in implementing, validating platform technical specifications</li><li>Familiarity with Agile/Scrum methodology</li></ul> Requirements:<ul><li>Go Lang & Cloud (AWS) experience is must. Someone started his career with Java or any other language and then recent experience with Golang will also work.</li><li>Hybrid Role (3 days onsite). Looking for local candidates only.</li><li>Experience with Data structures, Designing, API Integration, Backend exposure, Server Integration, Business specifications.</li><li>8-10 years of Experience with one or more programming languages such as: Golang (must have min 4-6 years), Java, NodeJS.</li><li>Reasonable experience with cloud services (AWS/GCP/Azure), DevOps, cloud engineering, architecture, and software as a service</li><li>Proficient in clean architecture, API design, debugging, profiling and performance optimization.</li><li>Experience designing and implementing large scale distributed systems.</li><li>Very good problem-solving and analytical skills with knowledge of algorithms, data structures, and complexity analysis</li></ul>

Ascendum Solutions Interview Questions

Ascendum Solutions Interview Guides

Ascendum Solutions Interview Questions

Ascendum Solutions Salaries by Position

Ascendum Solutions Opening Jobs