Prepare for and practice interview questions from Mindlance.

Mindlance Interview Questions

Mindlance Interview Guides

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

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?

Mindlance Salaries by Position

Position: Product Manager IIIWork Location: Reston, VA (Hybrid)Duration: 12+ Months (Possible Extensions) Job Description:• Create features, user stories, acceptance criteria and participate in scrum ceremonies.• Work closely with stakeholders to understand and maintain focus on their analytics needs and deliver actionable insights to relevant decision-makers.• Present information and/or ideas to an audience in a way that is engaging and easy to understand.• Liaise with the product team and technology team to deliver requirements.• Develop communication and outreach materials for internal and external audiences.• Product Development including designing products, developing product roadmaps, translating design requirements, prototyping, etc.• Product Management including managing demand, releases, and backlog.• Identify opportunities for product improvements, as well as collect feedback from team and provide recommendations.• Ensure product strategy is in alignment with business objectives.• Create Product dashboard and other executive reports to showcase product development activities and status• Maintains product backlog and perform product demos• Influencing including negotiating, persuading others, facilitating meetings, and resolving conflict.• Relationship Management including managing and engaging stakeholders, customers, and vendors etc.• Experience in triaging issues and data mapping. Minimum Required Experience:• Experience managing the product development process.• Experience with database modeling, mapping and system interface documents• Experience writing and understanding data rules• Experience performing user acceptance, Integration testing and story acceptance• Experience gathering accurate information to explain concepts and answer critical questions• Working with people with different functional expertise respectfully and cooperatively to work toward a common goal• Good collaboration and relationship management skills to effectively work with the product team to understand requirements and deliver the work• At least 7-8 years of experience working in a Product owner/analyst role• Strong verbal and written communication skills• Strong Excel skills and SQL knowledge• Experience using JIRA, SharePoint and Confluence Preferred Experience:• Multifamily knowledge is good to have. “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”

Job Description:Experience in data analysis, data extraction/manipulation and loading routines using SQL, Teradata, database structures and data warehousesHighly effective communication skillset: ability to convey results, concepts, and issues/challenges with us and partners / peers and non-technical marketing/business audience through executive ready presentations. Experience with statistics and basic statistical modeling techniques (i.e., regression, decision tree, random forest, clustering, segmentation etc.)Good Story telling competencies to create new and Client analytics approach or data visualizations to deliver Insights to target audience.Good knowledge of building strategic analysis using customer profiling, business segmentation, heuristics, inferential statistics, RFM analysis Experience of working with Machine learning techniques – Segmentation, Regression, Decision Trees, Forecasting, Clustering Technical Skills:<ul><li>Teradata</li><li>5+ years of experience working with SQL</li><li>Advanced SQL query writing</li><li>Data Analytics</li><li>Data Science</li><li>Data Structures</li><li>Data Warehouse</li><li>Power BI</li><li>Python</li><li>Python Libraries</li></ul> EEO: “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”

Senior Software Engineer working on "Product Definition/Offer/Configuration" group of applications. Resource would work on new solutions and enhancements in the product group across CaaS and cloud platforms. Resource would contribute on an agile team with two week iterations. Position Duties: Full stack developer position in a cloud environment (GCP/PCF) to support business processes . Core Java development consisting of Java Collections Framework, REST API, JPA and Junit . Presentation layer coding from wireframes. Angular/REACT . Advocate proper usability and maintainability while working on projects . Advocate the use of agile and software engineering leading practices . Adopt Copilot Resource would also partially help support the product group's DevOps pipeline. Skills Required: 1. Core Java/J2EE skills 5 years 2. Springboot 3 years 3. Github/Jenkins/Gradle 2years 4. REST webservices 2 years 5. AI/Client & CoPilot 1 year Skills Preferred: Python DevOps Angular/React Experience Required: 5 years of Java Development experience with some DevOps knowledge 2 years of Cloud experience, preferably Google Cloud Platform 1 years of AI/Client and CoPilot Experience Preferred: Google Vertex AI Education Required: College degree in an information technology related discipline EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Job Title: Data Scientist - Advanced Metering Infrastructure (AMI) AnalyticsLocation: Forest Park, GA and GPC Headquarters (241) Job Summary:The Data Scientist will contribute to APC Power Delivery’s AMI Analytics team, using data science to improve operational efficiency. This role involves identifying AI/ML use cases, developing models, optimizing algorithms, and implementing MLOps practices for cloud deployment.Key Responsibilities:<ul><li>Identify and develop AI/ML use cases aligned with business goals</li><li>Optimize machine learning models and algorithms</li><li>Implement MLOps for continuous model deployment</li><li>Collaborate with cross-functional teams and mentor colleagues</li><li>Document results and communicate insights</li></ul>Requirements:<ul><li>Master’s degree in Data Science, AI, or related field</li><li>5+ years of experience in a data-driven environment</li><li>Proficiency in Python, R, Spark, Azure cloud tools</li><li>Strong problem-solving, communication, and leadership skills</li></ul>Behavioral Attributes:<ul><li>Results-oriented, innovative, and strategic thinker</li><li>Committed to continuous learning and team development</li><li>Strong collaboration and decision-making abilities</li></ul> “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.” If you are inclined, I would be happy to set up some time to chat more about your background and career interests to see if there could be a possible match. Please feel free to call me on 732-955-4050 or send me email on vivekb@mindlance.com RegardsVivek Bhargava

We are looking for an experienced and highly motivated Data Engineer to join our team. In this role, you will play a key part in designing, implementing, and optimizing data pipelines and infrastructure for efficient data management and analysis. This role requires deep expertise in data engineering concepts, cloud-based technologies, and a commitment to quality through automated testing. You will work closely with data scientists, analysts, and other engineering teams to ensure seamless integration and processing of data across the organization. Responsibilities:<ul><li>Design, build, and maintain scalable data pipelines using Python, PySpark, and AWS Glue to support data ingestion, transformation, and loading (ETL/ELT) processes.</li><li>Develop and manage data processing workflows on AWS services, including Lambdas for event-driven data processing.</li><li>Implement automated testing frameworks to ensure data quality and reliability throughout the data pipeline lifecycle.</li><li>Monitor, troubleshoot, and optimize data pipelines and jobs to ensure efficient and reliable operation of data systems.</li></ul> Required Qualifications:<ul><li>8+ years of professional experience in Data Engineering or a related field.</li><li>Strong proficiency in Python and PySpark for data processing and transformations.</li><li>Experience with AWS services (e.g., Glue, Lambda, S3, and others) for data management and cloud infrastructure.</li><li>Experience with the Behave framework for automated testing within a data engineering context.</li><li>Proven ability in automated testing of data workflows, including unit testing and integration testing, to ensure data accuracy and pipeline reliability.</li><li>Familiarity with distributed data processing concepts and the ability to work with large datasets.</li></ul> Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”

Qualifications & Experience Senior Software Development and Engineering role<ol><li>11+ years of experience as a Business Analyst with track record of delivering business value - Experience with Municipal bond trading and portfolio management is highly desirable. -</li><li>Experience with Investortools Perform is highly desirable. -</li><li>Experience with Fixed Income Separately managed accounts ( SMA) business process is highly desirable.</li><li>Solid experience with and understanding of Agile in developing epics, themes, user stories, supplementary requirements, and business rules is essential.</li><li>Experience with Separately Managed Accounts or Fixed Income asset management is preferred -</li><li>Prior data analysis and data mapping experiences with strong SQL skill is a must</li><li>Good interpersonal, analytical, problem-solving skills and excellent written and verbal communication skills</li></ol> Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

Mindlance Interview Questions

Mindlance Interview Guides

Mindlance Interview Questions

Mindlance Salaries by Position

Mindlance Opening Jobs