Prepare for and practice interview questions from Pri Technology.

Pri Technology Interview Questions

Pri Technology Interview Guides

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

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?

Pri Technology Salaries by Position

Data Engineer My name is Bill Stevens, and I have a new full time Data Engineer opportunity available for a major firm located in Raleigh, North Carolina that could be of interest to you, please review my specification below and I am available at any time to speak with you so please feel free to call me. The work schedule will be hybrid, three days a week in the office and two days remote. The ideal candidate should also possess a green card or be of citizenship. Due to client confidentiality please call me for the salary, bonus structure and benefits information. The firms US team is looking for a Data Engineer to support the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. The ideal Data Engineer will lead the engineering work to align with the approved solution architecture and the firms digital roadmap to comply with the firms internal technical standards. This individual will provide expertise as a technical resource to solve complex business issues translating data integration and database systems design as well as provide support and services on new initiatives. Responsibilities:Prepare high-level and detailed technical specifications for the projects in accordance with security, and architecture documentation objectivesDevelop detailed plans and accurate estimates for the completion of the build, system testing, and implementation phases of a projectRunning and optimizing SQL queries on RDBMS such as MS SQL server, MySQL and MariaDBArchitect, design, and implement solutions that meet the stakeholder’s needsParticipate actively in requirements gathering, data modeling, and design sessionsDevelop, code, document, and execute unit tests, systems, integration and acceptance tests, and testing tools for functions of high complexityTest, and maintain detailed programs according to specifications given by computer software engineers and systems analysts of the firm Requirements:Minimum of five years of experience in software engineering or analytics in creating enterprise data architectures, distributed and microservice software architectures and design patternsMore than two years of application development experience in Hadoop, NoSQL databases such as MongoDB, Cassandra, or HBaseBachelor’s degree in Information Technology, Computer Science or relevant experienceCore SQL database concepts, including creating DDL, DML scripts, normalization, running, and optimizing SQL queries on RDBMS such as MS SQL serverWorking knowledge of Hadoop Data lake tools, specially HIVE or DataMeer and SnowflakePrior experience with Liquibase, Git code repos such as GitHub Pluses for this role:Knowledge of the following: Python, Java, Bash and shell scriptingWorking knowledge of MapReduce or SparkExperience using Stone Branch or Tableau The interview process will include an initial telephone or Zoom screening. Please let me know your interest for this position, availability to interview and start for this position along with a copy of your recent resume or please feel free to call me at any time with any questions. RegardsBill StevensSenior Technical RecruiterPRI TechnologyDenville, New Jersey 07834973-354-2799Bill.Stevens@PRITechnology.com<a>www.PriTechnology.com</a>

<h3>Job Description</h3><div>Job Description<div>Product Analyst Consumer Packaged Goods Experience My name is Bill Stevens, and I have a new twelve month plus Product Analyst opportunity available for a major firm located in Saint Charles, Missouri that could be of interest to you, please review my specification below. The work schedule will be hybrid, three days a week in the office and two days remote. This position pays $60.00 - $64.00 per hour on a w-2 hourly basis. No Visa entanglements and no submittals from H1-B holding companies. Overview: The firms Order Management System (OMS) is in the center of the business. All orders and many departments operate within this system. Efficiencies within the business generally come from the OMS and this role will be a big part of gathering those future roadmap requirements The ideal candidate must have the ability to take a request and run with it without constant hand holding. 2 existing team members have a large repository of training material as well as manage 1 on 1 sessions to onboard resources. Learn ways of working in the current OMS landscape as well as build relationships. Business Acumen in a new business to be able to translate what the business needs into relevant requirements Deliver Transformational Supply Projects, deliver value add Continuous improvement items. Need someone that can meet with the Business Teams to collect solid requirements and deliver requirements to Product and Technical Teams. The ideal candidate should also possess a green card or be of citizenship. Required Experience: ● Ability to collect Business Requirements from stakeholders ● Ability to translate Business Requirements to Product/Technical Requirements ● 3+ years of Business Analysis experience ● Experience working CPG (Consumer Packaged Goods) company ● Knowledge in Supply Chain and Logistics ● Experience working in the pet food and/or health industry ● Experience creating flowcharts, entity relationship and business diagrams using Microsoft Visio ● Clear understanding of Agile Methodology ● Experience working within a SaaS platform ● Knowledge of Source Control Systems ● Knowledge of Change Management Practices Required Skills: ● Needs to be able to take a task and complete it without hand holding ● Must not be afraid to ask questions ● Strong communication skills both written and verbal ● Process oriented and results driven ● Understanding of highly integrated digital platforms ● Knowledge of Salesforce or other CRM tools (Administrative or Object specific experience a plus) ● Knowledge of continuous integration and continuous delivery ● Ability to use design thinking and end-to-end solution-based approaches when solving business problems ● Possess a broad understanding of business and technology strategies and business processes that impact and enhance profitability ● Clear understanding of Agile Methodology ● Experience working within a SaaS platform ● Knowledge of Source Control Systems ● Knowledge of Change Management Practices Nice to have (Any of the following.): ECBA (Entry Certificate in Business Analysis) PMI-PBA (Professional in Business Analysis) CCBA (Certification of Capability in Business Analysis) BCS Certificate in Business Analysis Practice. CBAP (Certified Business Analysis Professional) The interview process will include an initial telephone or Zoom screening. Please let me know your interest for this position, availability to interview and start for this position along with a copy of your recent resume.</div></div>

I have a full time opportunity for an IT Business Analyst in Providence Rhode Island. I need someone familiar with the whole SDLC and who can work proactively with the business users.
This role will be onsite 3 days and 2 days remote.
Responsibilities Works multiple concurrent project initiatives of various scale and priority levels across multiple lines of business.
Elicit requirements from business and technical stakeholders via interviews/workshops to develop workflow storyboards, use case scenarios, and a formal statement of work.
Analyzes and translates functional requirements into a complete, consistent, and comprehensible manner for technical teams and project stakeholders.
Conduct peer reviews and collaborate with necessary business stakeholders and technical resources to finalize requirements, develop project level of efforts, and present cost models for approval from project sponsor(s).
Under the supervision of a project manager, adheres to project plan key milestones and planned task start/stop dates to ensure the project stays on time and within budget.
Develops test cases and develops roadmap features into user stories to validate requirements against project scope and design.
Executes test cases and documents the results; works with the development team to remediate identified defects.
Manages, tracks, and reports project progress, issues & risks to different levels of management using SDLC project lifecycle methodologies.
Participates in project implementations following all necessary change control and audit procedural steps.
Performs a post-implementation review to ensure that all project goals were met, and all activities completed.
Performs project close-out activities to ensure approvals and documentation is archived.
Facilitates and documents postproduction lesson learned sessions.
Participates in research/resolution of day-to-day production support items that arise as part of the normal course of day-to-day business.
Coordinates with different departmental teams to identify improvements and provide sound recommendations to ensure excellence for all business areas.
Researches new technologies, processes, software & automation opportunities with solutions for new trends, demands, and concepts.
Qualifications Bachelor's degree or Associate's degree plus equivalent experience, required.
Proficient in MS Office and MS Project or equivalent.
Accomplished organizational, communication (written and verbal), interpersonal, and leadership skills at all levels.
Ability to work with Information Technology, Development, and Business users as part of a team in a fast-paced environment.

#J-18808-Ljbffr

<h3>Job Description</h3><div>Job Description<div>I have a full time opportunity for a Senior Data Engineer proficient in Snowflake development. This role is 3 days onsite, 2 days remote with one of our leading investment management firms in Midtown Manhattan.In this role you will work with the Global Data Manager to build high-performing cloud data platforms to meet our analytical and BI reporting needs. This role will work as a key member of a data management team to drive development, delivery, and continuous improvement of the enterprise data warehouse architecture in support of our cloud data strategy.The role requires solid development experience in cloud data warehousing and modern data engineering technologies. The successful candidate will have experience in building a scalable cloud data platform using best practices and data warehouse principles. This person must understand business requirements and work closely with stakeholders to convert business requirements into technical solutions. This is a hands-on engineering role requiring extensive data engineering and advanced data analytical skills, as well as the ability to provide mentorship and guidance to junior resources.Responsibilities:<ul><li>Translate business requirements into data model design and technical solutions.</li><li>Mentor and guide the work of junior database developers and analysts.</li><li>Develop high-performing, secure ELT/ETL processes to transform and integrate source data from internal and external systems to the cloud data warehouse.</li><li>Maintain data warehouse and data pipeline processes, including troubleshooting issues, performance tuning, and implementing data quality improvements.</li><li>Develop a framework for data validation rules and reports to ensure data quality and control.</li><li>Automate standard code deployment and production release processes, adhering to change management processes.</li><li>Create high-quality technical documentation, including data mapping, data processes, and operational support guides.</li><li>Provide guidance on effective use of the data warehouse platform and facilitate BI reporting and data science model development.</li><li>Troubleshoot process and data issues, investigate user questions, and identify solutions to resolve issues.</li><li>Work in a fast-paced, dynamic environment and perform effectively in an agile development environment.</li></ul>Qualifications: <ul><li>Hands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.</li><li>Experience in data modeling tools (e.g. Erwin, ER/Studio, etc.) and data modeling methodologies such as data vault and dimensional data models.</li><li>Strong technical experience in building scalable data pipelines to integrate structured and unstructured data in both cloud and on-premise environments.</li><li>Solid overall experience in data warehousing, advanced database design, SQL, stored procedures, views, performance tuning and optimization, database indexing techniques, and database maintenance.</li><li>Understanding of data security and cloud security methodologies, and experience in configuration and management of data security to meet compliance and IT security requirements.</li><li>Experience using Airflow or similar tools for developing scheduling and monitoring batch-oriented workflows.</li><li>Working knowledge of Microsoft Power BI and Tableau.</li><li>Experience with SDLC processes, agile development, and source code repositories (e.g. Git or Bitbucket).</li><li>Excellent communication, organization, and problem-solving skills.</li><li>Significant experience data engineering and data warehouse engineering in cloud environment.</li><li>Experience with Snowflake needed.</li><li>Experience with agile development is a plus.</li><li>Domain expertise with financial services is a plus.</li><li>Bachelor’s degree in computer science, data science, or related field.</li></ul> Lori SklarskiSenior Technical Recruiter PRI Technology P: 973.732.5454 x27 C: 973.432.9968F: 973.732.5456Lori.sklarski@pritechnology.comwww.pritechnology.com </div></div>

Business Analyst CPG Consumer Packaged Goods My name is Bill Stevens, and I have a new twelve month plus Business Analyst opportunity available for a major firm located in Saint Charles, Missouri that could be of interest to you, please review my specification below and I am available at any time to speak with you so please feel free to call me. The work schedule will be hybrid, three days a week in the office and two days remote. This position pays $60.00 - $64.00 per hour on a w-2 hourly basis. No Visa entanglements and no H1-B holding companies. Overview:The firms Order Management System (OMS) is in the center of the business. All orders and many departments operate within this system. Efficiencies within the business generally come from the OMS and this role will be a big part of gathering those future roadmap requirements The ideal candidate must have the ability to take a request and run with it without constant hand holding.2 existing team members have a large repository of training material as well as manage 1 on 1 sessions to onboard resources.Learn ways of working in the current OMS landscape as well as build relationships.Business Acumen in a new business to be able to translate what the business needs into relevant requirements Deliver Transformational Supply Projects, deliver value add Continuous improvement items.Need someone that can meet with the Business Teams to collect solid requirements and deliver requirements to Product and Technical Teams.The ideal candidate should also possess a green card or be of citizenship. Required Experience:● Ability to collect Business Requirements from stakeholders● Ability to translate Business Requirements to Product/Technical Requirements● 3+ years of Business Analysis experience● Experience working CPG (Consumer Packaged Goods) company● Knowledge in Supply Chain and Logistics● Experience working in the pet food and/or health industry● Experience creating flowcharts, entity relationship and business diagrams using Microsoft Visio● Clear understanding of Agile Methodology● Experience working within a SaaS platform● Knowledge of Source Control Systems● Knowledge of Change Management Practices Required Skills:● Needs to be able to take a task and complete it without hand holding● Must not be afraid to ask questions● Strong communication skills both written and verbal● Process oriented and results driven● Understanding of highly integrated digital platforms● Knowledge of Salesforce or other CRM tools (Administrative or Object specific experience a plus)● Knowledge of continuous integration and continuous delivery● Ability to use design thinking and end-to-end solution-based approaches when solving business problems● Possess a broad understanding of business and technology strategies and business processes that impact and enhance profitability● Clear understanding of Agile Methodology● Experience working within a SaaS platform● Knowledge of Source Control Systems● Knowledge of Change Management Practices Nice to have (Any of the following.):ECBA (Entry Certificate in Business Analysis)PMI-PBA (Professional in Business Analysis)CCBA (Certification of Capability in Business Analysis)BCS Certificate in Business Analysis Practice.CBAP (Certified Business Analysis Professional) The interview process will include an initial telephone or Zoom screening. Please let me know your interest for this position, availability to interview and start for this position along with a copy of your recent resume or please feel free to call me at any time with any questions. RegardsBill StevensSenior Technical RecruiterPRI TechnologyDenville, New Jersey 07834973-354-2799Bill.Stevens@PRITechnology.com<a>www.PriTechnology.com</a>

Pri Technology Interview Questions

Pri Technology Interview Guides

Pri Technology Interview Questions

Pri Technology Salaries by Position

Pri Technology Opening Jobs