Prepare for and practice interview questions from Primus.

Primus Interview Questions

Primus Interview Guides

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

Primus Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><b>Position: Data Business Analyst <br /> Location: Lisle, Illinois(Onsite)<br /> Duration: 6+ Months </b><br><br><b>Job Description</b>:<br /> Participate in UAT, SIT Testing activities<br /> Create comprehensive BRD, FRD<br /> Knowledge of MDM, STIBO is a big plus<br /> Work cross-departmentally on data-driven strategies that improve business processes and decision-making<br /> Operate independently in client environment.</div><div></div><div><p>Thanks & regards,</p><p>Suryansh Singh</p><p>Sr. Technical Recruiter</p><p><b>PRIMUS Global Services</b><br /> Direct (972) 829 4883<br /> Desk (972) 753-6500 x 261<br /><span class="long-word">ssingh@primusglobal.com</span><br /><span class="long-word">www.primusglobal.com</span></p></div></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>SQL Data Analyst - 60307</b></p><p>We have an immediate long-term opportunity with one of our prime clients for a position of <b>SQL Data Analyst to work in Juno Beach, FL on Hybrid basis.</b></p><div></div><div><b>Pay Rate: $40-$45/hr.</b></div><div><b>Skills</b></div><ul><li>Excellent SQL skills.</li><li>Problem-solving skills.</li><li>Analytical and quantitative skills.</li><li>Ability to work in a team as well as, independently.</li><li>Excellent communication skills, both written and oral.</li><li>Good story telling and presentation skills.</li><li>Good leadership skills to be able to manage other BAs in EDP and conduct BA/DA community-of-practice sessions.</li><li>Curious and persistent by nature, with a bias for action.</li></ul><div><b>Nice to haves</b></div><ul><li>SAP knowledge</li><li>Salesforce knowledge</li><li>Corporate finance data</li><li>AWS Redshift knowledge</li><li>Basic understanding of data management and governance frameworks</li></ul><div>The enterprise data analyst is a technical professional who will work as a liaison between EIT and business units to understand the BU's data goals, requirements, processes, and objectives in an EDP engagement. They use a business analysis approach to understand existing business processes and related data and, data analysis skills to showcase business value of an enterprise data portfolio and tell stories with data. An enterprise business analysist can help break down silos and support the development of overarching business strategies leveraging enterprise data. <br><br><b>Key Expectations:</b></div><ul><li>The Data Analyst will learn the existing data portfolio and evolve into an SME with deep understanding of the group's enterprise data model, data products, data ownership and access control configurations.</li><li>Help internal and external technical and non-technical teams with information on our data portfolio.</li><li>Gather and analyze data and business processes for new projects in our project intake pipeline.</li><li>General understanding of data catalog and data discovery tool and help with their upkeep. <ul><li>Keeping knowledge articles and data dictionaries current <ol><li> Review and refine existing articles</li><li>Create new content when needed</li></ol></li></ul><ol><li>Identify trends in usage of these tools and recommend improvements.</li></ol></li><li>Overall understanding of data quality of various datasets and data products available for consumption and provide recommendations to improve data quality when there is a gap.</li><li>Collaborate with various business units and/or development teams to understand their data needs and provide analytical support.</li><li>Communicate, recommend, and implement business process improvements based on data analysis findings, when needed.</li><li>Ability to identify and interpret trends, patterns, and anomalies within datasets.</li><li>Will utilize basic understanding of performance optimization techniques to compose performant SQL queries.</li><li>Utilize data modeling tools such ERwin to understand the relationships between datasets and share knowledge with others.</li><li>Utilize data analysis tools such as Power BI, Amazon Quicksight, or similar for creating visualizations and dashboards.</li><li>Test business processes, help identify data issues, help with UAT, and document findings.</li><li>Build relationships with business product owners and practitioners, as well as executive leadership teams.</li></ul><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W2**</b></p><p>For immediate consideration, please contact:</p><p><b>AISHWARYA<br /> PRIMUS Global Services</b><br /> Direct - (972) 798-2408<br /> Desk - (972) 753-6500 Ext. 215<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p><p></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Business Analyst - AWS Cloud - REMOTE WORK - 60297</b></p><div>We have an immediate long-term opportunity with one of our prime clients for a position of <b>Business Analyst AWS Cloud to work on remote basis.</b></div><div></div><div><b>Pay Rate: $35-$37/hr.</b></div><p></p><p><b>Seeking an experienced IT Project Lead with a background supporting data center operations projects and on-prem data center migrations to AWS cloud services. The Project Lead will play a pivotal role in leading and executing complex technical projects, ensuring their successful delivery within scope, schedule, and budget. This role requires a deep understanding of Agile principles, exceptional project management skills, leadership capabilities, and effective communication to collaborate with cross-functional teams and stakeholders. </b></p><p></p><p><b>CANDIDATE SKILLS AND QUALIFICATIONS</b></p><p><b>Minimum Requirements:</b><br /> Candidates that do not meet or exceed the <b>minimum</b> stated requirements <span class="long-word">(skills/experience)</span> will be displayed to customers but may not be chosen for this opportunity.</p><p>Years</p><p>Required/Preferred</p><p>Experience</p><p>7</p><p>Required</p><p>Extensive experience performing all aspects of IT project management duties in large data center environments, ensuring they are completed on time and within budget.</p><p>6</p><p>Required</p><p>Possess a strong understanding of the technical aspects of the projects being managed within an Agile context and possess an understanding of data flows in an enterprise.</p><p>6</p><p>Required</p><p>Solid working knowledge of MS Office suite of applications including Project.</p><p>6</p><p>Required</p><p>Excellent written and verbal communication skills and ability to facilitate effective communication between team members and stakeholders.</p><p>6</p><p>Required</p><p>Excellent at monitoring project deliverables and milestones to ensure they are met according to the project plan.</p><p>5</p><p>Required</p><p>Define project scope, objectives, and deliverables in collaboration with stakeholders, breaking them down into manageable iterations. Develop and maintain a well-defined product backlog and ensure Timely delivery of prioritized features.</p><p>5</p><p>Required</p><p>Solid working with IT procurements, budget, forecasts and analysis for the different projects.</p><p>5</p><p>Required</p><p>Experience working closely with internal and external vendors and/or service providers to ensure our operations requirements are appropriately provisioned.</p><p>5</p><p>Required</p><p>Solid experience migrating an on-premises data center to Cloud Services (AWS preferred).</p><p>5</p><p>Required</p><p>Expert level planning, documenting and identifying project goals and tasks to ensure on-time delivery.</p><p>5</p><p>Required</p><p>Effective leadership, organization and time management skills.</p><p>5</p><p>Required</p><p>Expert at communicating with stakeholders to eliminate blockers and potential risks.</p><p>5</p><p>Required</p><p>Champion Agile principles and practices throughout the project lifecycle. Lead Agile ceremonies, including daily stand-ups, sprint planning, reviews, and retrospectives. Guide the team in adopting and adhering to Agile methodologies.</p><p>3</p><p>Preferred</p><p>Experience working on government fiscal and budget management supporting data centers.</p><p>3</p><p>Preferred</p><p>Experience with senior level leadership reporting and communication. Familiar with various levels of reporting tools.</p><p>2</p><p>Preferred</p><p>Experience using Remedy, ITSM, PPM, Archer, Jira and ServiceNow.</p><p>2</p><p>Preferred</p><p>Experience preparing and tracking security exemption requests.</p><p></p><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W-2**</b></p><p>For immediate consideration, please contact:</p><p>Neetu Chaudhary<br /><b>PRIMUS Global Services</b><br /> Direct: 972-914-2329<br /> Phone No: 972-753-6500 Ext: 419<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Sr. SQL Data Analyst - REMOTE WORK - 60226</b></p><div></div><div>We have an immediate long-term opportunity with one of our prime clients for a position of <b>Sr. SQL Data Analyst to work on Remote basis.</b></div><div></div><div></div><div><b>Required Skills and Experience:</b></div><ul><li>Strong business analysis skills with a focus on data.</li><li>Experience in marketing Data OR healthcare data OR Adobe platforms. - Anyone</li><li>Proficiency in SQL for writing queries from scratch.</li><li>Experience with data validation and quality assurance.</li><li>Ability to work with raw data and understand data migration and warehousing.</li><li>Comfortable working with developers on data ingestion and transformation.</li><li>Self-starter with the ability to work in ambiguous environments and ask questions proactively.</li></ul><div></div><div><b>Project Overview:</b></div><ul><li>Consolidating OptumHealth consumer communications into a central platform.</li><li>Supporting a legacy environment within marketing operations (analytics & reporting).</li><li>Migrating communication engines to Adobe Experience Platform (AEP).</li><li>Rebuilding systems from scratch and redefining processes.</li><li>The project is in a transformational state, redefining marketing operations with a new MarTech system from the ground up.</li></ul><div></div><div><b>Role Responsibilities:</b></div><ul><li>Support either the legacy system or the AEP/AJO side, depending on the candidate's skills. <ul><li>AEP side is still being defined as operations move over.</li><li>Understanding new capabilities in AEP and rebuilding previous systems.</li><li>Redefining marketing operations from the ground up.</li></ul></li><li>Strong business analyst with data skills preferred.</li><li>Testing: Building test cases and testing against those cases.</li><li>Defining technical specifications for the development team to handle data ingestion and transformation.</li></ul><div></div><div><b>Preferred Experience:</b></div><ul><li>Adobe Modules: <ul><li>AEP is the primary focus.</li><li>Some Customer Journey Analytics (CJA) for data validation.</li></ul></li><li>Marketing Experience: <ul><li>Healthcare data.</li><li>Adobe tools.</li></ul></li><li>QA/UAT: <ul><li>Extensive data validation.</li><li>Experience building and executing test cases, documenting, and tracking them.</li><li>Strong SQL skills writing queries from scratch against raw data (scale of 1-10, need to be at least 6/7).</li></ul></li><li>Technical Skills: <ul><li>Reading JSON is helpful (query tool outputs results in JSON).</li><li>No ETL experience needed.</li><li>Azure experience is a plus (platform sits on Azure).</li><li>Experience with raw data, data migration, and data warehousing.</li><li>Collaborating with developers on data ingestion and transformation.</li><li>Not a report analyst role.</li></ul></li></ul><div></div><div><b>Team Collaboration:</b></div><ul><li>Will work with the marketing evolution program team, delivery leads, marketers, product owners, and the legacy OC platform team.</li><li>Must be comfortable with ambiguity, a self-starter, and not afraid to ask questions.</li></ul><div>Good problem solvers and able to self-serve.</div><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W-2**</b></p><p>For immediate consideration, please contact:<br /></p><p>Ujjal Das<br /><b>PRIMUS Global Services</b><br /> Phone: Direct (972) 645-5262/ 972 753 6500 ext. 268<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p><p></p><p></p><p></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Data Analyst - 60214</b></p><div><b>We have an immediate long-term opportunity with one of our prime clients for a position of Data Analyst to work in San Bruno, CA Hybrid basis.</b></div><div></div><div><b>Pay Rate : $40 - $42/hr.</b></div><p><b>Requirements: </b></p><ul><li>At least 6 years of analytics experience. Client will not consider candidates with fewer YOE. </li><li>Data analyst role, not data scientist level</li><li>Advanced SQL </li><li>Power BI must have Power BI (Tableau as a replacement will not work)</li><li>Ecommerce, retail, or experience working with consumer insights or supply chain data </li><li>Need strong communication skills </li></ul><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W-2**</b></p><p>For immediate consideration, please contact:</p><p>Neetu Chaudhary<br /><b>PRIMUS Global Services</b><br /> Direct: 972-914-2329<br /> Phone No: 972-753-6500 Ext: 419<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p><p></p><p></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Financial Business Analyst - REMOTE WORK - 60156</b></p><p><b>Pay Range - $32 - $35/hr</b></p><p>We have an immediate long-term opportunity with one of our prime clients for a position <b>Financial Business Analyst </b>to work in Remote basis.</p><p></p><p><b>Qualifications: </b></p><p>Client is looking for a Business Analyst that has experience managing Finance and Accounting projects. This person will be working specifically on shipboard projects and will be meeting with the business and understanding the processes. This person will be reporting into the Sr BA. This person will be working specifically on onboard applications, POS systems, everything related to Finance onboard. Their in-house PMS system is called Latitude, which is similar to Oracles Fidelio or SAP. Their POS is also in house but is similar to Oracle's Micros, but still very customized to Carnival's needs. Financial projects that lean toward accounting, 30% accounting, 70% general financial accounting. Shipboard payment systems, reporting, etc.<br><br> They need to talk to purchasing, accounting, revenue, treasury, etc. They need to know what each team is responsible for, but they don't need to know how they complete it. "What does treasury need to know for me to create the tasks that they need to complete"<br><br><b>Day to Day:</b><br /> This person will be the liaison between the business and IT teams, and will be doing basic BA duties, while knowing the language of the shipboard world. This person will be more functional vs technical.</p><p></p><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W2**</b></p><p></p><p>For immediate consideration, please contact:<br /></p><p>Pavan<br /><b>PRIMUS Global Services</b><br /> Direct 972-798-2661<br /> Desk: (972) 753-6500 x 203<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Business Analyst - 60157</b></p><div></div><div>We have an immediate long-term opportunity with one of our prime clients for a position of <b>Business Analyst to work in Dayton, OH on Onsite basis.</b></div><p><b>Pay Rate : $35-$40/hr.</b></p><p>It is a very straight forward role; <b>we need someone with great communication/soft skills and strong documentation of system processes.</b></p><p><b>Position Purpose</b></p><p>Gather, analyze, and document business requirements for internal customers. Ensure technology solutions align with business needs and strategic goals. Design, document, test and leverage solutions.</p><p></p><p><b>Major Tasks, Responsibilities, and Key Accountabilities</b></p><p> Interfaces with Business Stakeholders and IT infrastructure teams to define, gather, and document business processes and needs, and translate into detailed functional specifications for development. Performs business systems and process analysis of existing systems/processes. Conducts interviews and requirements gathering workshops. Ensures sign-off of all artifacts.</p><p> Coordinates requirements for new and existing applications. Assists in testing, training plan development and training, support for users, and developing user documentation (i.e. web manuals, reference guides, etc.). Participates in QA process; identifies test cases; explains complex processes; aids in developing test plans.</p><p> Develops detailed business cases, ROI calculations, value definition, cost assessments (expense/capital), benefits, and risk analyses.</p><p> Coordinates project tasks and project life cycle phases for small to mid-size projects (i.e. defining requirements, documentation, and process flows, etc.) to meet customer goals and requirements.</p><p> Coordinates communication with the client and prioritizes delivery of IT services.</p><p> Conducts root cause analysis using knowledge of applications, interfaces, and technology for defect resolution.</p><p> Assists with scope definition and implementation of a solution.</p><p></p><p><b>Preferred Qualifications</b></p><p><b> </b>Experience in a distributed team environment preferred.</p><p><b> </b>Database experience (SQL, Data Warehousing, Oracle, Informix, etc.) preferred.</p><p><b> </b>Experience creating diagrams, flowcharts, and other visual representations to communicate information to stakeholders. (Visio preferred)</p><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W2**</b></p><p>For immediate consideration, please contact</p><p><b>Vaibhav Sahu<br /> PRIMUS Global Services</b><br /> Desk (972) 753-6500 Ext.415<br /> Direct: (972) 914-2829<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p><p></p><p></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>PowerBI SQL Data Analyst - 59943</b></p><div><b>We have an immediate long-term opportunity with one of our prime clients for a position of PowerBI SQL Data Analyst to work in Montgomery, AL on Hybrid basis.</b></div><div></div><div><b>Pay Rate : $40 -$45/hr</b></div><p><b>Must-Haves (Concepts & Tools):</b></p><p><b> </b> SQL expertise</p><ul><li>Power BI</li><li>Medicaid - strong hands on experience working with Medicaid data </li><li>Excellent communication skills to work directly with the client/user AKA the State Agencies </li></ul><p></p><p><b>Project Scope:</b></p><ul><li>AL EDS is the new Alabama Medicaid Data warehouse, these two position will support the State Agency in the roll out and usage of it</li></ul><p></p><p><b>Team Size & Breakdown: - stand up time</b></p><ul><li>These two openings will work directly under the Analytics Manager</li></ul><p></p><p><b>High-Level Individual Duties:</b></p><p><b> </b>Perform data analytics on state data using SQL</p><ul><li>Create reports/data visualization using PowerBI</li><li>Provide support to state agency analytic staff - "help desk" data analysts</li></ul><p></p><p><b>Nice-to-Haves:</b></p><p><b> </b>Snowflake</p><p><b>**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W2**</b></p><p>For immediate consideration, please contact:</p><p>Tejaswini<br /><b>PRIMUS Global Services Inc</b><br /> Direct (972) 798-2662<br /> Desk (972) 753-6500 x204<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Fixed Income Data Product Analyst </b></p><p><b>Pay Range - $55 - $70/hr</b></p><p>We have an immediate long-term opportunity with one of our prime clients for a position <b>Fixed Income Data Product Analyst </b>to work in Baltimore, MD on Hybrid basis.</p><p></p><p><b>Must Haves:</b></p><ul><li>Must have experience with Bloomberg PORT or any of the tools listed above ((Keywords outside of Bloomberg Port: Yield Book, FactSet, MSCI, MSCI RiskMetrics, Intex and Bloomberg YAS (Basically all these tools help you look at things like Securities and Fixed income products to help portfolio managers and traders make investment decisions))</li><li>Must have experience in an Investment Banking environment.</li><li>Must have experience with Fixed Income Products.</li></ul><p></p><p><b>About the Role:</b></p><p>We are looking for a Fixed Income Analyst to enhance our business facing data operational team which is responsible for generating and delivering high quality security analytics to our enterprise platform. You will support and manage the foundational data sets used by the Global Fixed Income Portfolio Management, Quant and Credit Research teams. You will be a hands-on analyst who understands Fixed Income portfolio and risk analytics and will help run best in class enterprise level solutions within our Fixed Income Front Office technology team. You will directly support the production Bloomberg PORT environment and our firms applications in this domain. Our company has made a big investment in the future of our technology and data. We have a big vision of what we can achieve and have ambitious plans to get there. We at our firm hold collaboration as a core tenet of how we accomplish our goals. You should be interested in a team-oriented approach; curious and enthusiastic learners will be amongst their tribe here. We are a group of diverse thinkers, all working together with different perspectives to create optimal solutions to continue to propel our firm to great heights. You should be excited about working with Front Office staff - Analysts, Investment Liaisons, Portfolio Managers & Traders. The Fixed Income Analytics team is responsible for the acquisition, validation, and delivery of analytics and benchmark data to the portfolio management team, as well internal and external clients. You will be expected to analyze and validate data from a variety of sources, including Bloomberg PORT. You will work closely with a variety of global investment business desks and technology teams daily.</p><p></p><p><b>Core Competencies and Responsibilities:</b></p><ul><li>Excellent problem-solving skills demonstrated ability to employ fact-based decision-making to resolve complex problems, by applying logic analysis, experience, and business knowledge.</li><li>Follow good operational practices with the team and stakeholders to ensure there is full transparency around our daily deliveries.</li><li>Support mission critical software and data to meet daily delivery SLAs.</li><li>Support several leading vendor provided applications.</li><li>Ensure the validity and accuracy of security-level analytics and risk exposures within the portfolio management systems and overseeing audit processes.</li><li>Develop and sustain relationships with software engineers, Portfolio Managers, Quants and Investment Analysts on a global basis and supporting their ongoing data requirements.</li><li>High energy, results driven person with strong interpersonal skills with the ability to work well with global teams, including time-zone flexibility. ? Must be a self-starter with ability to build working relationships and work effectively in a global organization.</li><li>Make <span class="long-word">independent/educated</span> judgments regarding appropriate resolutions of data anomalies</li><li>Must be able to independently "troubleshoot" functional and/or quantitative problems.</li></ul><p></p><p><b>Qualifications: Minimum:</b></p><p><b>Along with the responsibilities and competencies specified above, we are looking for an individual who possesses a positive, action-oriented attitude and understands the importance of taking initiative within a team environment.</b></p><ul><li>Strong academic record in Finance, Mathematics, Physics or similar discipline. ? Must have Fixed Income Experience and Understanding</li><li>Must have operational & BAU experience</li><li>Experience working with and analyzing data</li><li>Technical Data tool skills (SQL database queries, Excel, jupyter/python etc.)</li><li>Working knowledge of Fixed Income analytics ideally on an industry standard vendor platform (i.e. Bloomberg PORT, FTSE/Citi Yield Book, IDC, Risk Metrics, etc.)</li></ul><p></p><p><b>Preferred:</b></p><ul><li>3 6 years industry experience</li><li>Demonstrated experience with various global Fixed Income instruments (e.g. bonds, derivatives, securitized, etc.) as well as working knowledge of portfolio accounting systems or commercial market data and analytics tools</li><li>Experience following and writing procedures and suggesting changes.</li><li>General <span class="long-word">knowledge/awareness</span> of macro financial markets and more specifically, the buyside/asset management industry</li></ul><p></p><p>For immediate consideration, please contact:<br /></p><p>Pavan<br /><b>PRIMUS Global Services</b><br /> Direct 972-798-2661<br /> Desk: (972) 753-6500 Ext. 203<br /> Email: <span class="long-word">jobs@primusglobal.com</span></p></div></div>

Primus Interview Questions

Primus Interview Guides

Primus Interview Questions

Primus Salaries by Position

Primus Opening Jobs