Prepare for and practice interview questions from Mindlance.

Mindlance Interview Questions

Mindlance 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

Mindlance Salaries by Position

Job Title: Cognos Developer Duration: 24 Months Assignment Job Location: Rensselaer, NY 12144 Skills Required: 1. 84 Months of Experience in business requirement gathering, analysis and logical design; understanding and translating complex issues both in oral and written communication 2. 84 Months of Experience in creating and modifying Framework Manager models 3. 84 Months of Experience in creating and modifying reports using COGNOS tools 4. 84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries 5. 84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting complex data challenges to stakeholders 6. 84 Months of Experience working in social services or relating fields 7. Bachelor's Degree

Job Title: Business Analyst (Custody Operations) Duration: 07 Months+ (High Possibilities of Extension/Conversion) Location: Tampa, FL (Hybrid, 3 days onsite) -2+ years of business analysis experience. -2 years custody products experience needed - sentiment, cash affects, asset servicing (corporate action, income) and custody - needed -independent that can manager their experience -looking for business analysts - drafting requirements, can work with tech teams -testing background is great - they can also teach them BA experience JOB DESCRIPTION - Job Purpose: Senior Business Analyst for the core Custody application upgrades, lead phases of the project lifecycle for strategic, cross functional business initiatives. The main project will be around system implementation. Additional projects may involve: process optimization, risk mitigation, regulatory mandates and operating model re-engineering. Job Background/context: The Operational readiness team is the initial contact point for operational & Product development requests and business analysis. The team produces/reviews BRDs (Business Requirements Document) & FRDs (Functional Requirements Document), manages UAT (User Acceptance Testing) and coordinates implementation of new developments. The individual will have a strong project management and operational focus and will provide an integrated value-added service to our clients. The role will require the successful candidate to form effective working relationships with all stakeholders - Technology, Product, Market Management, Processing teams, Coverage teams, etc. ensuring that all key project deliverables are met. The successful candidate will be required to have a strong and detailed understanding of end-to-end operations and act as the client advocate. He/she may be required to interface with internal stakeholders at a senior level, acting as escalation point as well as a strategic business partner. Key Responsibilities: Play key role in project governance, organization, delivery, planning and control, and risk and issue management. Understanding the Operating Model to be able to advise all stakeholders on the impact of any change of the model. Assist the Project Manager with the co-ordination of release planning, execution and post-implementation review Working with technology and product colleagues to develop a robust, stable and scalable solution. Create Users Stories / Business Requirement Documents and support testing of solutions. Create Business Scenarios for testing through own knowledge and leveraging the knowledge of Operations specialists Leading BRD and FRD walkthroughs with multiple stakeholders Ensure testers have the requisite knowledge to execute testing and provide training where gaps exist Ensure all solutions are appropriately documented and communicated to impacted parties. Ensure that core Operations staff ready for the implementation. Work with the Project Manager to ensure all project documentation is in place, updated and in good order. Work with the Project Manager to communicate to stakeholders/senior management the status of a project. Development Value: High visibility role with exposure to people at all levels, including senior management interaction in various business areas Opportunity to develop a network and build relationships across the organization Involvement in Global strategic initiatives To further develop business analysis capabilities To develop project management capabilities To develop strategic planning and improved decision making skills Qualifications Knowledge/Experience: Strong knowledge of Custody products preferred Proven Business Analysis experience Extensive testing experience Skills: Business Analysis experience Analytical skills Good attention to detail, excellent organizational skills. Proven ability to operate and deliver to deadlines. Soft skills Qualifications: Primary Degree or Equivalent Advanced computer skills (MS office suite applications) Competencies: Innovative Team and Leadership Skills Ability to communicate effectively at all levels of the organization Self motivated Ability to establish credibility with senior managers. Excellent communication, interaction and influencing skills. Moderate presentation and facilitating skills. Ability to engage successfully in multiple initiatives simultaneously. Ability to successfully react/lead workload volatility Must be able to work under pressure; managing tight deadlines and conflicting priorities Exceptional candidates who do not meet these criteria may be considered for the role provided they have the necessary skills and experience. Valuing Diversity: Demonstrates an appreciation of a diverse workforce. Appreciates differences in style or perspective and uses differences to add value to decisions or actions and organization "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

PR:$34.82/hr Conducts basic to moderately complex operational analyses that supports informed decision making within the business unit, under the direction of a Sr. Bus. Analyst, Bus. Analyst I or immediate supervisor. Key responsibilities include medium to large special projects, quantitative and qualitative research, process design and modification, and report development. Applies standardized tools and techniques. Receives limited mentoring and guidance. 1 to 3 years related experience preferred. Bachelor's degree preferred. Key Responsibilities: <ul> <li> Perform comprehensive data integrity assessments across different datasets and systems.</li> <li> Conduct data cleaning activities to rectify inconsistencies, inaccuracies, and duplications.</li> <li> Direct outreach to colleagues requesting they address data issues.</li> <li> Develop and implement data quality rules, standards, and processes.</li> <li> Work collaboratively with data owners, IT, and other stakeholders to align on data governance practices.</li> <li> Utilize data analysis tools (i.e. PowerBI) and techniques to identify patterns and trends.</li> <li> Document data quality issues and remediation actions taken.</li> <li> Provide regular progress reports and data quality metrics to project leaders.</li> <li> Support the development of automated data cleaning and validation scripts.</li> </ul> Requirements: <ul> <li> Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.</li> <li> 1-3 years of experience in data analysis, data management, or a related role.</li> <li> Strong excel skills.</li> <li> Experience with data integrity and data cleaning processes.</li> <li> Proficient in SQL and at least one programming language such as Python or R.</li> <li> Familiarity with data visualization tools such as Tableau, Power BI, or similar.</li> <li> Strong understanding of data governance and data quality management principles.</li> <li> Excellent problem-solving skills and attention to detail.</li> <li> Experience managing multiple priorities.</li> <li> Experience handling conflict and difficult situations.</li> <li> Strong communication skills with the ability to convey complex data issues to non-technical stakeholders.</li> <li> Ability to work independently and as part of a team in a fast-paced environment.</li> <li> Passion for Data Integrity and Data Quality initiatives.</li> </ul> Preferred Skills: <ul> <li> Experience working in the energy sector or with energy-related data.</li> <li> Knowledge of big data frameworks and technologies.</li> <li> Certification in data management or data analysis (e.g., CDMP, CAP).</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."

Sr Business Analyst is needed to work on projects in the Data Exchange Program ON SITE: 2 days/week required/local candidates preferred No parking provided for contractors but there are monthly/weekly parking lots near by 2 Days ON SITE Required each week Local candidates preferred No parking provided for contractors but there are monthly/weekly parking lots near by ABOUT THE ROLE This position will be the business analyst for multiple component projects of the program. This position will coordinate extensively with partner stakeholders to gather requirements, analyze business needs, and collect and analyze data to be exchanged between the client and partners. Experience with healthcare data management, Electronic Health Record systems, and data integration projects is highly desirable. Position will be hybrid remote with 2 days minimum required on-site at office in Richmond. Parking will be in public lots with a daily rate. Some travel within VA may be required, most of which will be a single day (not overnight). EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

One of the key focus areas to enable this transformation is to ensure robust management of supply chain risk and assurance of supply to ensure demand for our world-leading products can be met optimally. As part of the transformation, we have initiated multiple IT system development projects to support strategic business initiatives in various business units. 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 Plans and conducts customer research to gather data and Client 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+ working experience years 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+ working experience years 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

Job Description: Employee Engagement/Impact Contractor Role Key Responsibilities: 1. Employee Impact Hub Management: o Support the day-to-day operations of the Employee Impact Hub. o Regularly update and create new resource documents to ensure content is current and relevant. o Handle site maintenance, including bug fixes and site updates. o Conduct grant and match reviews, ensuring compliance and accuracy. o Generate and analyze reports using Tableau to extract data, create visualizations, and identify program trends and insights 2. Inbox Management: o Manage and respond to inquiries and requests from the Gap Foundation inbox, ensuring timely and effective communication. 3. Employee Communication Support: o Draft and edit emails and other communication materials for employee-facing purposes. o Create and update content for internal newsletters and listervs. 4. Event Management: o Support the planning and execution of employee events, including design, material development, and day-of coordination. o Collaborate with team members to ensure events meet objectives and run smoothly. Qualifications: Experience: At least 3 years of experience in a similar role, with a proven track record in project management. Skills: o Strong organizational and multitasking abilities. o Fast learning agility o Excellent written and verbal communication skills. o Proficient in Microsoft Office Suite (Word, Excel, PowerPoint) and experience with content management systems. o Data Analysis - ideally skilled in using Tableau to generate and analyze reports o Software Proficiency - Experience with employee giving and volunteering software, including the ability to navigate, update, and manage various features and functionalities of the platform. o Ability to work independently and as part of a team. o Experience with event planning and execution. o Problem-solving skills and attention to detail. Additional Regions: EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Key Responsibilities: 1. Data Pipeline Development: Design, build, and maintain scalable and robust data pipelines on GCP using tools such as Apache Airflow, Cloud Composer, and Cloud Dataflow. Implement data integration solutions to ingest data from various sources, including cloud storage, and third-party APIs. 2. Data Warehousing: Develop and optimize data warehouse solutions using BigQuery and other GCP services. Ensure data accuracy, consistency, and security within the data warehouse environment. Monitor and troubleshoot data pipeline and warehouse issues to maintain system reliability. 3. Cloud Platform Expertise: Utilize GCP services such as Cloud Storage, Cloud Run, and Cloud Functions to build scalable and cost-effective data solutions. Implement best practices for cloud infrastructure management, including resource provisioning, monitoring, and cost optimization. 4. Collaboration and Communication: Work closely with data scientists, analysts, and business stakeholders to understand data requirements and deliver high-quality data solutions. Collaborate with cross-functional teams to design and implement data models, ETL processes, and reporting solutions. 5. Automation and Optimization: Develop automated workflows using Apache Airflow and Astronomer to streamline data processing and improve efficiency. Continuously optimize data pipelines for performance, scalability, and cost-effectiveness. 6. Documentation and Training: Create and maintain comprehensive documentation for data pipelines, data models, and infrastructure components. Provide training and support to team members and stakeholders on data engineering best practices and GCP services. Skills Required: Technical Skills: Proficiency in data pipeline tools and frameworks such as Apache Airflow, Cloud Composer, and Cloud Dataflow. Strong knowledge of GCP services, including BigQuery, Cloud Storage, Cloud Run, and Cloud Functions. Experience with SQL, Python, and other programming languages commonly used in data engineering. Familiarity with data modeling, ETL processes, and data integration techniques. Soft Skills: Excellent problem-solving and analytical skills. Strong communication and collaboration abilities. Ability to work independently and as part of a team in a fast-paced, dynamic environment. Experience Required: 5+ years in data warehouse and 2+ years in GCP

Senior/ Lead Data Engineer Duration: 12 months plus (possible extension or conversion) Location: HYBRID W/ ONSITE REQUIREMENT - 3 days onsite <ul> <li> Tampa, FL 33610 </li> </ul> Be a member of the senior leadership team as the Enterprise Risk Management Technology Senior Vice President, in Data Engineering team. This is a Senior Data Engineer level position responsible for accomplishing results through the management of leading teams to establish and implement new or and revised data engineering systems and programs in coordination with the Business, Architecture, and Technology Teams as part of our large digital transformation journey. The overall objective of this role is to design and implement drive next generation, state of the art data analysis systems. You will manage the quality of the engineering teams' quality of delivery, mentor the technical team, manage technical risk, and translate business needs into digital reality. Responsibilities: Manage multiple teams of professional data engineers inclusive of performance evaluations, hiring and disciplinary actions. Lead teams from across the system to analyze data from internal and external systems Provide expertise as a technical resource to solve complex business problems that translate into data integration and database systems designs Ensure all deliverables are of high quality by adhering to standards and participating in code reviews Mentor, support, and manage large teams. Bring data engineering principles, practices, and philosophies into all data engineering projects Create logical and physical data model architecture, data extract/transform/load processes, reporting and analytics solutions Provide strategic influence and exercise control over resources, budget management and planning while monitoring end results Influence and negotiate with senior leaders across functions, as well as communicate with external parties as necessary Assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding clients and assets Drive compliance with applicable laws, rules, and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency. Effectively supervise the activity of others and create accountability with those who fail to maintain these standards. Qualifications: 15+ years' experience in data engineering and end to end automation of data pipelines . Experience in data modeling and information architecture including experience with Big Data, Relational Databases such as Oracle, columnar data stores, real-time data analytics, streaming and batch processing. Experience with Java, data APIs, Data Lakes, open shift, reporting and analytics platforms Comfortable with streaming and big data concepts using design patterns with software like Spark, Flink, Kafka, HDFS, Airflow, Elastic Search, and Ignite Strong understanding of relational & NoSQL databases, data structures, data science and business intelligence workflows Experience with large-scale data warehousing and analytics projects, including using AWS and other technologies. Both technically deep and business savvy enough to interface with all levels and disciplines within the organization Experience with artificial intelligence and machine learning data toolkits Experience managing global technology teams. Working knowledge of industry practices and standards relative to data engineering Consistently demonstrates clear and concise written and verbal communication. Financial Industry experience in risk management is a plus. Education: Master's degree or higher in Computer Science or related field "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Title: Sr. Data Engineer Location: Charlotte, NC (Hybrid) Duration: Contract Job Description: Top Skill: -The data engineer has to work in LUMOS ISCM Data Engineering redesign, maintenance and daily business support and automation. -The Sr. Data Engineer should have experience in Hadoop (Hive and HBASE) , Postgres and strong in Big Data Concepts, Java , ETL and GCP or any other cloud experience. Key Responsibilities: -Translates complex cross-functional business requirements and functional specifications into logical program designs, code modules, stable application systems, and data solutions; partners with Product Team to understand business needs and functional specifications -Collaborates with cross-functional teams to ensure specifications are converted into flexible, scalable, and maintainable solution designs; evaluates project deliverables to ensure they meet specifications and architectural standards -Contributes in the design and build of complex data solutions and ensures the architecture blueprint, standards, target state architecture, and strategies are aligned with the requirements. -Coordinates, executes, and participates in component integration (CIT) scenarios, systems integration testing (SIT), and user acceptance testing (UAT) to identify application errors and to ensure quality software deployment -Participates in all software development end-to-end product lifecycle phases by applying and sharing an in-depth understanding of complex industry methodologies, policies, standards, and controls -Develops detailed architecture plans for large scale enterprise architecture projects and drives the plans to fruition -Solves complex architecture/design and business problems; solutions are extensible; works to simplify, optimize, remove bottlenecks, etc. Data Engineering Responsibilities -Executes the development, maintenance, and enhancements of data ingestion solutions of varying complexity levels across various data sources like DBMS, File systems (structured and unstructured), APIs and Streaming on on-prem and cloud infrastructure; demonstrates strong acumen in Data Ingestion toolsets and nurtures and grows junior members in this capability -Builds, tests and enhances data curation pipelines integration data from wide variety of sources like DBMS, File systems, APIs and streaming systems for various KPIs and metrics development with high data quality and integrity -Supports the development of feature / inputs for the data models in an Agile manner; Hosts Model Via Rest APIs; ensures non-functional requirements such as logging, authentication, error capturing, and concurrency management are accounted for when model hosting -Works with Data Science team to understand mathematical models and algorithms; recommends improvements to analytic methods, techniques, standards, policies and procedures -Works to ensure the manipulation and administration of data and systems are secure and in accordance with enterprise governance by staying compliant with industry best practices, enterprise standards, corporate policy and department procedures; handles the manipulation (extract, load, transform), data visualization, and administration of data and systems securely and in accordance with enterprise data governance standards -Maintains the health and monitoring of assigned data engineering capabilities that span analytic functions by triaging maintenance issues; ensures high availability of the platform; works with Infrastructure Engineering teams to maintain the data platform; serves as an SME of one or more application BI Engineering Responsibilities -Responsible for the development, maintenance, and enhancements of BI solutions of varying complexity levels across different data sources like DBMS, File systems (structured and unstructured) on-prem and cloud infrastructure; creates level metrics and other complex metrics; use custom groups, consolidations, drilling, and complex filters -Demonstrates database skill (Teradata/Oracle/Db2/Hadoop) by writing views for business requirements; uses freeform SQLs and pass-through functions; analyzes and finds errors from SQL generation; creates RSD and dashboard -Responsible for building, testing and enhancement of BI solutions from a wide variety of sources like Teradata, Hive, Hbase, Google Big Query and File systems; develops solutions with optimized data performance and data security -Works with business analysts to understand requirements and create dashboard/dossiers wireframes; makes use of widgets and Vitara charts to make the dashboard/dossiers visually appealing -Coordinates and takes necessary actions from DART side for application upgrades (e.g., Teradata, Workday), storage migration, and user management automation; supports such things as Cluster Management and Project Configuration settings Competencies: Technical Competencies -Agile Development -Big Data Management and Analytics -Cloud Computing -Database Design (Physical) -Release Management Qualifications Minimum Qualifications: -Bachelor's Degree in Engineering /Computer Science, CIS, or related field (or equivalent work experience in a related field) -5 years of experience in Data or BI Engineering, Data Warehousing/ETL, or Software Engineering -4 years of experience working on project(s) involving the implementation of solutions applying development life cycles (SDLC) 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 ScientistClient: Utility CompanyDuration: 12 monthsLocation: Atlanta, Georgia Job SummaryWe are seeking a talented Data Scientist to support AI exploration and implementation to enhance our business operations.The ideal candidate will be responsible for identifying potential use cases for AI and leading efforts to build solutions for these use cases by leveraging machine learning algorithms and AI tools. As part of our leading-edge advanced analytics team, you will help drive analytics across the organization to improve customer experience and optimize operations.This is an individual contributor role, providing autonomy in technical and analytical choices, including determining the appropriate modeling techniques and making design decisions. Key Responsibilities:• Identify and evaluate potential AI use cases to enhance business operations.• Lead the development and implementation of AI solutions for identified use cases.• Utilize machine learning algorithms and AI tools to build and deploy models.• Collaborate with cross-functional teams to integrate AI solutions into business processes.• Partners with IT to effectively migrate analytical models from prototype to production.• Conduct data analysis to uncover insights and support decision-making.• Ensure data quality and integrity throughout the AI solution development process.• Present findings and recommendations to stakeholders in a clear and concise manner.• Stay up-to-date with the latest advancements in AI and machine learning technologies.• Self-starter and a multi-tasker who can work independently under tight timelines Qualifications:• Bachelor’s or Master’s degree in Data Science, Computer Science, Statistics, Mathematics, or a related field.• Proven experience in data science, machine learning, and AI.• Strong programming skills in languages such as Python, R, or similar. Python is highly preferred.• Experience with machine learning frameworks and tools (e.g., Azure, Databricks, Google Cloud).• Experience with data visualization tools (e.g., Tableau, Power BI).• Experience with big data technologies (e.g., Hadoop, Spark) is a plus.• Excellent analytical and problem-solving skills.• Ability to work independently and make autonomous technical and analytical decisions.• Strong communication skills to effectively convey complex technical concepts to non-technical stakeholders. Why Join Us:• Be part of a cutting-edge advanced analytics team.• Opportunity to lead AI initiatives and make a significant impact on business operations.• Collaborative and innovative work environment. “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

Mindlance Interview Questions

Mindlance Interview Guides

Mindlance Interview Questions

Mindlance Salaries by Position

Mindlance Opening Jobs