Prepare for and practice interview questions from Themesoft.

Themesoft Interview Questions

Themesoft Interview Guides

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.

What factors could have biased this result, and what would you look into?

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

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?

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

Themesoft Salaries by Position

Business Analyst - Retail Branch and Teller OperationsCleveland, OH-OnsiteLong term Contract Influences a cross-functional team in optimization of application capabilities & business processes.<ul><li>Provide Business Analysis and Project/Product support for the development, enhancement, quality assessment, and on-going support of the relevant lines of business (LOBs).</li><li>Utilize industry trends to influence requirements for new application features and enhancements that are consistent with strategic priorities.</li><li>Identify the business needs of the users, outline potential solutions, and translate business requirements to an appropriate format for requirements including user stories/acceptance criteria, process flows, data mapping (source to target mappings), functional and non-functional requirements to convey with appropriate level of detail to the development team.</li><li>Responsible for maintaining requirements documentation in standard formats and repositories ensuring traceability between scope, feature, functional requirements</li><li>Collaborates with users, vendor, and development team members to deliver the best technical solution which meets the business requirements​.</li><li>Liaison to obtain clarification for development and testing teams on intended functionality / user stories.</li><li>Significantly contributes to the design process to ensure it supports business requirements and an optimized user experience.</li><li>Capture requirements for a highly complex system and/or multiple systems across multiple stakeholders; understands and applies the SDLC to the execution of deliverables.</li><li>Translate business requirements into technical requirements considering multiple users, risks, and/or impact scenarios and convey with appropriate level of detail to the development team.</li><li>Apply expertise of the business and its trajectory and work with technical and business teams to support business objectives and align to the roadmap.</li><li>Work with QAS to develop project testing strategy.</li><li>Support and/or participate in user acceptance testing to ensure quality in application releases and user experience.</li><li>Advises on security, risk management, and IT process principles and escalate to appropriate team(s) as needed.</li><li>Partners effectively with security and risk teams to ensure tech portfolio changes adhere to standards.</li><li>Active participation in Agile squad ceremonies, utilize Agile principles, and tools (Confluence, JIRA).</li><li>Actively contributes and leads BA Center of Excellence efforts in evolving requirements analysis and management practices</li></ul> Required Skills:<ul><li>10+ years of experience working as a Business System Analyst or related IT roles</li><li>Min 3 years of Operations experience as Teller using Argo Teller21 platform, OLDs or equivalent exposure to retail branch Teller operations and systems</li><li>Familiarity with Alogent Front Counter or other check processing and GL reconciliation processes for Retail Branches</li><li>Excellent analytical skills</li><li>Must be able to familiarize with and be hands on with the software application platform(s) supported by the squad</li><li>Must be able to familiarize and understand technical implementation of the software application platform(s) and bridge the gap between business and technology</li><li>Ability to work in a group/team setting.</li><li>Ability to work independently with minimal direction.</li><li>Takes accountability/responsibility for tasks and actions</li><li>Excellent written and verbal communication skills</li><li>Strong collaboration skills and team player with positive attitude</li><li>Familiar with Agile, Scaled Agile Framework and Waterfall concepts</li><li>Experience working in agile squads</li><li>MS Suite proficiency Word, Excel, PPT</li><li>Experience with Agile methodology</li><li>Experience using JIRA and Confluence</li><li>Business Analysis deliverable in the form of use cases, process flows, data mapping documentation</li><li>Ability to break down complex concepts into simple and digestible requirements</li><li>Execute Design thinking, Systems thinking when developing requirements artifacts</li><li>Must be driven to deliver quality and have attention to detail</li><li>Familiarity with mainframe, batch and real time (REST, Kafka or other)</li></ul>Preferred Skills:<ul><li>Bachelor’s degree preferably in IT / Computer Science</li><li>Experience in Retail Branch and Teller Operations</li><li>Certifications (CBAP, agile certifications)</li></ul> Regards, _______________________Parthasarathy KLead RecruiterWork: 972-474-8787 Ext: 306,Direct: 972-737-8607Partha.k@themesoft.comThemesoft Inc |<a>Themesoft Jobs</a>

⦁ BA - Retail Branch and Teller Operations⦁ Location : Cleveland⦁ Rate : $55/hr on W2 or $65/hr on C2C T21 Sr BA - Local Candidates ONLY - Cleveland based (Contract to hire)⦁ Influences a cross-functional team in optimization of application capabilities & business processes.⦁ Provide Business Analysis and Project/Product support for the development, enhancement, quality assessment, and on-going support of the relevant lines of business (LOBs).⦁ Utilize industry trends to influence requirements for new application features and enhancements that are consistent with strategic priorities.⦁ Identify the business needs of the users, outline potential solutions, and translate business requirements to an appropriate format for requirements including user stories/acceptance criteria, process flows, data mapping (source to target mappings), functional and non-functional requirements to convey with appropriate level of detail to the development team.⦁ Responsible for maintaining requirements documentation in standard formats and repositories ensuring traceability between scope, feature, functional requirements⦁ Collaborates with users, vendor, and development team members to deliver the best technical solution which meets the business requirements​.⦁ Liaison to obtain clarification for development and testing teams on intended functionality / user stories.⦁ Significantly contributes to the design process to ensure it supports business requirements and an optimized user experience.⦁ Capture requirements for a highly complex system and/or multiple systems across multiple stakeholders; understands and applies the SDLC to the execution of deliverables.⦁ Translate business requirements into technical requirements considering multiple users, risks, and/or impact scenarios and convey with appropriate level of detail to the development team.⦁ Apply expertise of the business and its trajectory and work with technical and business teams to support business objectives and align to the roadmap.⦁ Work with QAS to develop project testing strategy. ⦁ Support and/or participate in user acceptance testing to ensure quality in application releases and user experience.⦁ Advises on security, risk management, and IT process principles and escalate to appropriate team(s) as needed. ⦁ Partners effectively with security and risk teams to ensure tech portfolio changes adhere to standards.⦁ Active participation in Agile squad ceremonies, utilize Agile principles, and tools (Confluence, JIRA).⦁ Actively contributes and leads BA Center of Excellence efforts in evolving requirements analysis and management practices Required Skills:⦁ 10+ years of experience working as a Business System Analyst or related IT roles⦁ Min 3 years of Operations experience as Teller using Argo Teller21 platform, OLDs or equivalent exposure to retail branch Teller operations and systems⦁ Familiarity with Alogent Front Counter or other check processing and GL reconciliation processes for Retail Branches⦁ Excellent analytical skills⦁ Must be able to familiarize with and be hands on with the software application platform(s) supported by the squad⦁ Must be able to familiarize and understand technical implementation of the software application platform(s) and bridge the gap between business and technology⦁ Ability to work in a group/team setting.⦁ Ability to work independently with minimal direction.⦁ Takes accountability/responsibility for tasks and actions⦁ Excellent written and verbal communication skills⦁ Strong collaboration skills and team player with positive attitude⦁ Familiar with Agile, Scaled Agile Framework and Waterfall concepts⦁ Experience working in agile squads⦁ MS Suite proficiency Word, Excel, PPT⦁ Experience with Agile methodology⦁ Experience using JIRA and Confluence⦁ Business Analysis deliverable in the form of use cases, process flows, data mapping documentation⦁ Ability to break down complex concepts into simple and digestible requirements⦁ Execute Design thinking, Systems thinking when developing requirements artifacts⦁ Must be driven to deliver quality and have attention to detail⦁ Familiarity with mainframe, batch and real time (REST, Kafka or other)Preferred Skills:⦁ Bachelor’s degree preferably in IT / Computer Science⦁ Experience in Retail Branch and Teller Operations⦁ Certifications (CBAP, agile certifications)

<ul><li>Job Title- Technical Product Manager</li><li>Location- Atlanta, GA or Frisco, TX</li><li>Customer is looking for strong and recent experience in-</li></ul>1. Digital customer experiencea. Frontend Designb. CDN ( Content Delivery Network)c. Page performanced. Web Security2. Product Owner Experience in Front End Web Development a. Product Vision b. Roadmaps c. Product Breakdown and lead implementation coordinating with multiple teams Technical Product Manager, Domain Management - Digital and WebMandatory hands-on experience and ability to navigate current tools is required. Overview<ul><li>The technical product manager for digital and web is responsible for leading the web platforms domain management product vision, operations, strategy, and roadmap for the digital and web platforms that deliver engaging and seamless user experiences across multiple channels and devices; and other application services including T-Life, Benefits Hub and T-Mobile Tuesdays.</li><li>The technical product manager for digital and web collaborates with cross-functional teams, including cyber, other technology and product groups, network, engineering, design, marketing, sales, and customer success, to define and deliver innovative and scalable solutions that meet the needs and expectations of the customers and stakeholders.</li><li>The technical product manager for digital and web also oversees the product lifecycle, from ideation to launch and beyond, and ensures that the products and releases are aligned with the team’s, organization’s, company's goals and values.</li><li>The technical product manager shall maintain roadmaps, goals, OKRs and metrics that align to overall operations health and DevOps lifecycle of all aspects of the release process, from planning, product management, product engineering to release management and monitoring, alerting.</li><li>Key Responsibilities</li><li>Develop and communicate the product vision, product operations, product strategy, and roadmap for the domain management, digital and web platforms, ensuring alignment with the company's mission, objectives, and priorities.</li><li>Research and analyze the market/partner+ trends, customer and external feedback, user behavior, and competitive landscape to identify and validate the product opportunities and requirements.</li><li>Define and prioritize the product features and specifications, and collaborate with the engineering team to deliver high-quality and user-centric solutions, through the use of enterprise and self-assigned tools, including Planview, JIRA and other forms of resource, product and financial tracking measures.</li><li>Manage the product backlog and release planning, and coordinate the product launch and post-launch activities, including testing, documentation, training, and support.</li><li>Establish and track the product performance metrics and KPIs, and leverage data and insights to optimize the product functionality and usability. Formulate data driven reporting and operations for leadership and team members to derive data-driven decision making actions.</li><li>Lead and mentor the engineering, testing and other product team(s), and foster a culture of collaboration, innovation, and customer focus, while obsession with 3S – stability, security and scalability.</li></ul> Required Qualifications and Skills<ul><li>Bachelor's degree in computer science, engineering, or related field, or equivalent work experience.</li><li>At least 10 years of product management, product engineering experience in the digital and web domain, mandatory in a B2B or B2C environment.</li><li>Proven track record of delivering successful and impactful digital and digital, app, cyber and web products, from ideation to launch and beyond. Working beyond inheriting operations and a version 1.0 product.</li><li>Strong knowledge and experience in AWS Cloud, Akamai +Other CDN and WAF, and other relevant technologies and tools. Ability to adapt and apply the same concepts and functions from one service to another, i.e., Imperva to Akamai.</li><li>Excellent and clear ability for communication, presentation, and interpersonal skills, with the ability to articulate and advocate the product vision and value proposition to various audiences at all levels, from technical resources to leadership, business focused resources.</li><li>Exceptional analytical, problem-solving, and decision-making skills, with the ability to handle ambiguity and complexity.</li><li>Customer-centric and user-oriented mindset, with a passion for creating delightful and engaging user experiences.</li><li>Agile and lean product development methodologies, and best practices.</li></ul>

Job Title: Data EngineerLocation: - Jersey City , NJ Duration: Contract Job Description: The ETL Data Engineer supports data collection, transformation, and loading efforts across the center, including data deriving from and transferred to statistical as well as geographic information system workflows. This involves establishing ETL workflows to support projects across the center; identifying and evaluating data sources for quality, reliability, and appropriateness; and migrating and integrating datasets as needed for analysis.Department Specific Responsibilities<ul><li>Develops, tests, and integrates ETL routines (including those for geospatial data) using ETL tools and external programming/scripting languages as necessary.</li><li>Automates GIS analysis tasks using Python, ModelBuilder, FME, T-SQL and/or SSIS.</li><li>Creates and maintains the organization data dictionary as well as technical documentation for source-to-target mapping.</li><li>Assists in production support by resolving source data issues and refining transformation rules to align with center objectives.</li><li>Ensures accuracy and integrity of data through analysis of application coding deliverables, ensuring adequate documentation and problem resolution.</li><li>Reviews and approves analysis and translation of functional specifications and change requests into technical specifications.</li><li>Oversees project document management of ETL technical system specifications, processes flows, unit tests and results.</li><li>Ensures staff’s support of all ETL jobs for schedules and maintains compliance in development for effective project life cycle.</li><li>Manages internal resources to ensure that individuals assigned to projects have the specific skills necessary to run established workflows.</li><li>Assists in the design of data collection and analysis efforts with a focus on preventing redundancies, improving quality, and developing systems to support longitudinal data collection and analysis.</li></ul>General Responsibilities<ul><li>Performs data management tasks, including experienced data modeling, conversion, de-duplication, migration, and identification and repair of data quality issues.</li><li>Designs, develops, and implements custom data systems and reconciliation tools, processes, rules, solutions etc. to validate data, match/merge, and upload batch lists.</li><li>Creates and tunes complex stored procedures and queries for data management and extraction.</li><li>Designs and builds out technical software mechanisms to accommodate multiple integrations accurately based on complex rules and custom solutions.</li><li>Ensures documentation and security standards/protocols are recognized and followed.</li><li>Provides experienced troubleshooting and problem analysis/resolution for data related issues; performs experienced scripting and modifications of application and products for corrective action.</li></ul>Researches and stays up-to-date with data engineering best practices and approaches; stays abreast of latest security threats and risks to proactively address potential exposures.

Role: Business AnalystLocation: West Sacramento, California Responsibilities: <ul><li>Facilitate collaborative workshops and interviews with key stakeholders to gather and document comprehensive business requirements, ensuring alignment with organizational goals and objectives. </li><li>Conduct in-depth analysis of existing processes and workflows, identifying pain points, bottlenecks, and areas for improvement. </li><li>Identify critical workflows and ensure the workflows fit within the normal configuration and features of ServiceNow. </li><li>Lead prioritization of workflows as needed for the effort’s prioritized phased approach. </li><li>Lead and develop detailed process maps, flowcharts, use cases, user stories, customer journeys, and other visual aids to illustrate current and future state process designs, fostering a clear understanding among stakeholders. </li><li>Collaborate closely with the ITSM/ITAM tool vendor to configure solutions that meet the organization's unique requirements, ensuring seamless integration with existing systems and workflows. </li><li>Provide expert guidance and recommendations on industry best practices, and standards related to ITSM and ITAM domains, leveraging previous implementation experience and lessons learned.</li><li>Serve as a liaison between business stakeholders, IT teams, and implementation vendor throughout the project lifecycle, facilitating effective communication, collaboration, and decision-making.</li><li>Provide assistance with post implementation validation</li></ul> Mandatory Skills: <ul><li>Experience within the last ten (10) years working as a Business Analyst with large organizations, leading or participating in the technical implementation of ITSM and ITAM solutions such as ServiceNow automating complex business processes, performing all the following activities: </li><li>Creating and maintaining requirement management plan </li><li>Assessment of analysis scope and tasks </li><li>Planning business analysis tasks </li><li>Facilitating joint application design (JAD) and/or collaborative design sessions </li><li>Elicitation, definitions and documentation of various business, user, and system requirements </li><li>Analysis for business process improvement, application design and workflow automation </li><li>Modeling and documenting new functional requirements; use case development. </li><li>Leading and working within cross-functional teams that include business subject matter experts, application architects, developers, and testers</li><li>Work closely with the ServiceNow implementation vendor team </li><li>At least seven (7) years of experience within the last ten (10) years producing business analysis deliverables shown in the following list: (CalSTRS may request deliverable related work samples during Phase 4, Interviews, of the Comparison Process) </li><li>Business requirements, business rules, and business process model </li><li>Use cases, functional requirements and/or functional specifications </li><li>Non-functional requirements </li><li>Stakeholder requests </li><li>Procurement documentation </li><li>Transition plans and/or implementation requirements </li><li>Traceability matrices </li></ul> Desirable Skills: <ul><li>Experience as a Business Analyst with the State or Federal government. </li><li>Experience as a Business Analyst leading or participating in the technical implementation of ITSM and ITAM solutions, such as ServiceNow, including, but not limited to the following areas of focus: </li><li>Incident Management </li><li>Change Management </li><li>Problem Management </li><li>Configuration Management </li><li>Hardware Asset Management </li><li>Software Asset Management </li><li>Cloud SaaS Cost Management </li><li>Request Management – Service Catalog </li><li>End User Experience </li><li>Service Portfolio </li><li>Asset Discovery </li><li>Service Level Management </li></ul> <ul><li>IIBA Certified Business Analysis Professional (CBAP or CCBA). CalSTRS may request a copy of Certification. </li><li>Experience in Agile project management methodology or Scaled Agile Framework. </li><li>Experience in the ITIL Framework</li></ul> RegardsPraveen Kumar Talent Acquisition Group – Strategic Recruitment Manager

Role: Business Analyst Location Details: Atlanta, GA and Raleigh, NC (4 days working from office) Long term Contract Job Description: <ul> <li>Min 8 years of experience. </li> <li>Strong communication. </li> <li>Good client stakeholder management. </li> <li>Good experience in writing user stories and articulate the requirements very well. </li> <li>Experience in Banking & Financial domain. </li><li>Must have Commercial Banking knowledge experience. </li></ul> Regards, _______________________ Parthasarathy K Lead Recruiter Work: 972-474-8787 Ext: 306,Direct: 972-737-8607 Partha.k@themesoft.com Themesoft Inc |Themesoft Jobs

Role: Business AnalystLocation Details: Atlanta, GA and Raleigh, NC (4 days working from office)Long term ContractJob Description: <ul><li>Min 8 years of experience. </li><li>Strong communication. </li><li>Good client stakeholder management. </li><li>Good experience in writing user stories and articulate the requirements very well. </li><li>Experience in Banking & Financial domain.</li><li>Must have Commercial Banking knowledge experience.</li></ul> Regards, _______________________Parthasarathy KLead RecruiterWork: 972-474-8787 Ext: 306,Direct: 972-737-8607Partha.k@themesoft.comThemesoft Inc |<a>Themesoft Jobs</a>

Job Title: Data ArchitectLocation: - Los Angeles, CADuration: Contract Additional Information: • Candidate MUST have at least 5-8 years of total IT experience Project Scope:The Los Angeles Unified School District (LAUSD) seeks qualified proposers to provide Data Architect on behalf of the Information Technology Services. LAUSD intends to use the results of this solicitation process to award a contract to the responsive/responsible proposer. Selected candidates will be interacting with subject matter experts and other technicaland/or functional experts, as well as end users, to comprehend and ensure all aspects of the technical and business requirements are delivered as intended. Roles/Responsibilities:Design and implement data pipeline in a multi-cloud environment.Create secure interfaces both internally and externally to support analytics and machine learning.Guide developers on CI/CD processes as they pertain to analytics software.Participate in technical discussion, product demonstrations and provide guidance on data pipeline subject matter expertise on compliance to business needs and technical requirements.Interact with stakeholders to ensure design, integration, quality, and deployment expectations are being met, exceeded or non-compliance.Work closely with technical teams to ensure solutions are well-architected and can be successfully delivered.Coordinate and lead internal solution design review processes.Act as a technical liaison with third-party vendors to understand integration requirements and implement custom solutions.Learning and understanding of new and cutting-edge technologies for utilization within product development and lifecycles.Define and implement technical roadmap and strategies for migrating on-prem data platforms to cloud.Architect secure and scalable data analytics platform including data integrations, data models, data transformations, B2B data shares, and user interface.<ul><li>Transfer knowledge to LAUSD Personnel.</li></ul> Mandatory Skills:Experience with various software development tools and other related methodologies.Technical knowledge and experience in analytics tool and applications of data pipelines in a multi-cloud environment.Experience with CI/CD processes as they pertain to analytics tools.Experience working with analytics and machine learning teams, supporting them with secure delivery of data to perform their jobs.Experience in defining and implementing data governance, data integration, data privacy and data integrity policies.Expertise in architecting cloud-native data warehouses, data pipelines, data transformation, data models, analytics and reporting platforms.<ol><li>Experience in Snowflake, dbt, Power BI, ML/AI modeling is highly preferred.</li></ol>

Title: Sr Business analyst with Healthcare Location- Hackensack, NJ(ONSITE)TYPE : CONTRACT Mandatory : Hospital domain industry JOB DETAILS:<ul><li>Need someone with Doctor degree.</li><li>5+ years of Experience as BA managing multi product roadmap.</li><li>Experience with Hospital Domain Industry is must.</li><li>Experience in Jira is Must.</li><li>Experience in Stakeholder management.</li><li>Experience in User story generation and requirement analysis for product enhancement.</li><li>User acceptance testing (UAT). Project management. (project formulation and planning, implementation, tracking and documentation) Training and development.</li></ul> RegardsAmarnathamarnath@themesoft.com

Themesoft Interview Questions

Themesoft Interview Guides

Themesoft Interview Questions

Themesoft Salaries by Position

Themesoft Opening Jobs