Prepare for and practice interview questions from Agreeya Solutions.

Agreeya Solutions Interview Questions

Agreeya Solutions 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?

Agreeya Solutions Salaries by Position

Job Title: Marketing Analyst - II Location: Basking Ridge, NJ (In office 8x per month, Tues/Weds) Duration: Contract Job Description: Targeted Years of Experience: 3-5 years Responsibilities: •Management and evolution of action log and status updates that drives closure to executive marketing requests •Vendor management of all scope of work projects, and monthly, quarterly, and annual budget management •All Scope of Work creation for campaigns and new operational programs, overseeing CIDs along with processing invoices through various vendors •Executive Leadership Meeting support including the prioritization, preparation and curation of meeting materials and follow up when necessary •Support of weekly and monthly documentation/reporting •Tracking milestones of work process to support specific projects and initiatives •Marketing campaign management tracking with ROI measures to spend, creating and reading out leadership monthly readouts and supporting cross-functional employees and various vendors •Reconciling and maintaining all expense reports in accordance with guidelines including support of contractual payments to content vendors (onboarding, PO & invoices, reconciling) In addition to the above, this position is responsible for some administrative support, including but not limited to: •Managing schedule and appointment calendar(s) and maintaining sensitivity to changing priorities •Working with Executive Assistants to coordinate Executive schedules •Performing ad hoc project-related duties as requested, including but not limited to: •Team Culture/Team Engagement Support eg. Volunteer activities, team builders, team bulletin board MUST HAVE SKILLS: •The ability to manage multiple assignments at once •The ability to establish and maintain effective working relationships at all levels of the organization •The ability to ensure security and confidentiality of sensitive and protected information •Strong Project Management skills with the ability to establish, prioritize and maintain critical deadlines •Positive, optimistic attitude with a strong proactive initiative to work within the team for success •Strong organizational and time management skills •Strong verbal communication skills and polished written skills •Fluency in Google Workspace EDUCATION/CERTIFICATIONS: •Bachelor's degree or four or more years of work experience. •Six or more years of relevant work experience. REQUIRED SHIFT: •Standard 9-5, M-F •In this hybrid role, candidate will have a defined work location that includes work from home and assigned office days set by the manager. AgreeYa Solutions is a global systems integrator delivering technology-enabled business solutions to small, medium and global Fortune 1,000 organizations. It leverages leading-edge technology, consulting and outsourcing services to boost customer efficiency, productivity and deliver a competitive advantage. Through its consultative approach and utilization of a global delivery model, AgreeYa provides software, services and solutions that are cost-effective, achieve results and transform businesses. Founded in 1999 and headquartered in Folsom, Califonia, with a global footprint, AgreeYa is an SEI CMMI- and ISO 9001:2015-certified Microsoft Gold Partner, with multiple certifications, and operations with a team of over 1,800 employees across the world. Its extensive software portfolio includes AgreeYa Chatbot, BeatBlip, QuickApps, Site Administrator, Recovery Manager and Cogent. AgreeYa is a staffing industry leader, providing full-service staffing solutions to meet client workforce needs while driving business value. It also recently introduced a new intelligent automation and digital transformation suite to its existing technology stack to help organizations combat future crises and venture into the digital-first world with confidence. For more information, visit www.agreeya.com

Company: AgreeYa SolutionsPosition Title: M365 Business AnalystEmployment Type: Full-time, exemptPosition Description:Would you like to work for a software solutions company that has grown in triple digits in the last 5 years? Are you a self-starter always driving to execution? If you answered Yes to these questions, then we need to talk....We are looking for an M365 Business Analyst to be part of a close-knit, high-performing team. We are committed to creating an environment where all employees are valued and respected. We are interested in people who have a flair for working with people across cultures and time-zones, and the ability to collaboratively grow business.As an M365 Business Analyst, you will support our M365 clients across the United States, and drive revenue growth by identifying, pursuing, and closing opportunities offering a full range of Information Technology (IT) and staffing solutions. This role will be a part of the M365 Project Delivery Team and assist in implementing enterprise initiatives for our Microsoft clients.Duties and Responsibilities: Elicit, analyze, specify, and validate the business needs of client stakeholders; Collaborate with project team to determine project scope and vision; Conduct interviews to gather client requirements via workshops, questionnaires, surveys, site visits, workflow storyboards, use cases, scenarios, and other methods; Identify and establish scope and parameters of requirements analysis on a project-by-project basis to define project impact, outcome criteria, and metrics; Work with client stakeholders and project team to prioritize collected requirements; Assist in conducting research on products to meet agreed-upon requirements and to support project efforts; Analyze and verify requirements for completeness, consistency, comprehensibility, feasibility, and conformity to standards; Develop and utilize standard templates to write requirements specifications accurately and concisely; Create process models, diagrams, and charts to provide direction to developers and/or the project team; Manage and track the status of requirements throughout the project lifecycle; enforce and redefine as necessary; Communicate changes, enhancements, and modifications of business requirements verbally or through written documentation to project managers, sponsors, and other stakeholders so that issues and solutions are understood; Prepare training material (presentations, worksheets, etc.); Execute training sessions, webinars, workshops, etc. in groups or individually, and Draft business requirement documents along with training materials.Qualifications: Excellent Word, Excel, and PowerPoint skills; Detail-oriented with high caliber written, verbal, graphic communication skills, leadership, and interpersonal skills, andExcellent customer-facing skills, ideally gained in a consulting role or internal stakeholder-facing position.Experience: 8+ years of experience as a business analyst or in a related field; 8+ years of experience in Microsoft365 technologies such as 365 Office, OneDrive, Teams, SharePoint Online, etc.; 3+ years of experience with group facilitation, and Bachelor's or master's degree preferred.About AgreeYa:AgreeYa Solutions is a leading global provider of software, solutions, and services to small, medium, and global Fortune 100 organizations across various industries. Founded in 1999 and headquartered in Folsom, CA, AgreeYa has over 2,000+ professionals helping clients across US, India, EMEA and Mexico, in their digital journey. Leveraging our technology enabled, consultative approach, and diverse talent, AgreeYa offers modern workplace, smart analytics, intelligent automation, AI/ML, cloud transformation, mobility, and talent management solutions to deliver value of digital transformation for our clients. AgreeYa has received considerable recognition including certification like Microsoft Gold Partner and Cloud Solutions Provider; AICPA SOC 2 Type 2, SEI CMMI, and ISO 9001:2015; and awards including Dream Company to Work for, and Best Employer Brand.We offer competitive pay, excellent benefits, unlimited growth potential and cross-training opportunities, flexibility, and an unmatched collaborative and supportive team environment.If this sounds like the right fit for you, apply today! You can also learn more about our services and offerings by visiting our website at www.agreeya.com and follow AgreeYa on LinkedIn, Facebook and Twitter.Equal Opportunity:AgreeYa is an equal opportunity employer.We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website at www.agreeya.com/career-culture to learn about our Career & Culture.

Company: AgreeYa Solutions Position Title: M365 Business Analyst Employment Type: Full-time, exempt Position Description: Would you like to work for a software solutions company that has grown in triple digits in the last 5 years? Are you a self-starter always driving to execution? If you answered Yes to these questions, then we need to talk.... We are looking for an M365 Business Analyst to be part of a close-knit, high-performing team. We are committed to creating an environment where all employees are valued and respected. We are interested in people who have a flair for working with people across cultures and time-zones, and the ability to collaboratively grow business. As an M365 Business Analyst, you will support our M365 clients across the United States, and drive revenue growth by identifying, pursuing, and closing opportunities offering a full range of Information Technology (IT) and staffing solutions. This role will be a part of the M365 Project Delivery Team and assist in implementing enterprise initiatives for our Microsoft clients. Duties and Responsibilities: <ul><li> Elicit, analyze, specify, and validate the business needs of client stakeholders;</li><li> Collaborate with project team to determine project scope and vision;</li><li> Conduct interviews to gather client requirements via workshops, questionnaires, surveys, site visits, workflow storyboards, use cases, scenarios, and other methods;</li><li> Identify and establish scope and parameters of requirements analysis on a project-by-project basis to define project impact, outcome criteria, and metrics;</li><li> Work with client stakeholders and project team to prioritize collected requirements;</li><li> Assist in conducting research on products to meet agreed-upon requirements and to support project efforts;</li><li> Analyze and verify requirements for completeness, consistency, comprehensibility, feasibility, and conformity to standards;</li><li> Develop and utilize standard templates to write requirements specifications accurately and concisely;</li><li> Create process models, diagrams, and charts to provide direction to developers and/or the project team;</li><li> Manage and track the status of requirements throughout the project lifecycle; enforce and redefine as necessary;</li><li> Communicate changes, enhancements, and modifications of business requirements verbally or through written documentation to project managers, sponsors, and other stakeholders so that issues and solutions are understood;</li><li> Prepare training material (presentations, worksheets, etc.);</li><li> Execute training sessions, webinars, workshops, etc. in groups or individually, and</li><li> Draft business requirement documents along with training materials.</li></ul> Qualifications: <ul><li> Excellent Word, Excel, and PowerPoint skills;</li><li> Detail-oriented with high caliber written, verbal, graphic communication skills, leadership, and interpersonal skills, and</li><li>Excellent customer-facing skills, ideally gained in a consulting role or internal stakeholder-facing position.</li></ul> Experience: <ul><li> 8+ years of experience as a business analyst or in a related field;</li><li> 8+ years of experience in Microsoft365 technologies such as 365 Office, OneDrive, Teams, SharePoint Online, etc.;</li><li> 3+ years of experience with group facilitation, and</li><li> Bachelor's or master's degree preferred.</li></ul> About AgreeYa: AgreeYa Solutions is a leading global provider of software, solutions, and services to small, medium, and global Fortune 100 organizations across various industries. Founded in 1999 and headquartered in Folsom, CA, AgreeYa has over 2,000+ professionals helping clients across US, India, EMEA and Mexico, in their digital journey. Leveraging our technology enabled, consultative approach, and diverse talent, AgreeYa offers modern workplace, smart analytics, intelligent automation, AI/ML, cloud transformation, mobility, and talent management solutions to deliver value of digital transformation for our clients. AgreeYa has received considerable recognition including certification like Microsoft Gold Partner and Cloud Solutions Provider; AICPA SOC 2 Type 2, SEI CMMI, and ISO 9001:2015; and awards including Dream Company to Work for, and Best Employer Brand. We offer competitive pay, excellent benefits, unlimited growth potential and cross-training opportunities, flexibility, and an unmatched collaborative and supportive team environment. If this sounds like the right fit for you, apply today! You can also learn more about our services and offerings by visiting our website at www.agreeya.com and follow AgreeYa on LinkedIn, Facebook and Twitter. Equal Opportunity: AgreeYa is an equal opportunity employer.We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website at www.agreeya.com/career-culture to learn about our Career & Culture.

Agreeya Solutions Interview Questions

Agreeya Solutions Interview Guides

Agreeya Solutions Interview Questions

Agreeya Solutions Salaries by Position

Agreeya Solutions Opening Jobs