The Salient Crgt Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Salient Crgt Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Salient Crgt? The Salient Crgt Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Salient Crgt Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Salient Crgt.</li>
<li>Practice real Salient Crgt Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Salient Crgt Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Salient Crgt? The Salient Crgt Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Salient Crgt Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Salient Crgt.
- Practice real Salient Crgt Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Salient Crgt Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Salient Crgt Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

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

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

<p><strong>Example:</strong></p>

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Salient Crgt Business Intelligence Interview Questions

Business Analyst 1 (Telecom Business Process Analyst)   Full-time
Salient CRGT is a leading provider of health, data analytics, cloud, agile software development, mobility, cyber security, and infrastructure solutions. We support these core capabilities with full lifecycle IT services and training—to help our customers meet critical goals for pivotal missions. We are purpose-built for IT transformation supporting federal civilian, defense, homeland, and intelligence agencies, as well as Fortune 1000 companies.
W2 only, no C2C or third party inquiries please
In this role you will:
Business Analyst will participate in the planning, tracking, analysis, and reporting of projects
Will have significant interface with Project Managers, Contract Management staff, Senior Technical Personnel, as well as other functional organizations.
Participates in the development of solutions to a variety of tasks moderate in scope and complexity.
Reports detailed information, analyze data in support of project cost/schedule status and follow established procedures while contributing to the completion of organizational projects and goals.
Ensure compliance with organizational requirements and business processes, including but not limited to, product life-cycle management, records management, and historical archiving and document development
Manage specified project objectives, project constraints (scope, schedule, cost, quality, etc.), project risk, and coordinate with project manager and other resources as needed.
Assist with the development of standard operating procedures to formalize processes and standards and analysis of IT business and information environment, activities and events.
Develop charts, Project Management Plans (PMP), and other forms of documentation to meet VA compliance requirements.
Support various data management requirements including proof read documents, develop response packages and other documents as needed. Perform document formatting and quality assurance activities
Provides support with monitoring and evaluating compliance with project management standards, policies, procedures, and templates through project audits
MANDATORY REQUIREMENTS:
Education / Experience:  Associates or 2-year technical school. 4 years of additional experience may be substituted for education
PWS Specified Certifications:  This position requires privileged system access. The applicant shall have six months to obtain an industry standard certification.
Miscellaneous:  Duties may require traveling, being on call periodically, and occasionally working outside normal working hours (evenings and weekends)
Background Investigation:  Must be able to pass a government Tier 4 High Background Investigation
Salient CRGT will not sponsor work visas for this opening.
MANDATORY REQUIREMENTS:
Education / Experience:  Associates or 2-year technical school. 4 years of additional experience may be substituted for education
PWS Specified Certifications:  This position requires privileged system access. The applicant shall have six months to obtain an industry standard certification.
Miscellaneous:  Duties may require traveling, being on call periodically, and occasionally working outside normal working hours (evenings and weekends)
Background Investigation:  Must be able to pass a government Tier 4 High Background Investigation
Salient CRGT will not sponsor work visas for this opening
DESIRED QUALIFICATIONS:    Competency:  complete assignments of moderate complexity on time within a fast-paced environment, learn new process tools, multi-task, analytical, communication and presentations skills, writing and communication skills
Knowledge:  business process and acquisition support
Problem Solving:  create courses of action and proactively solve problems by conducting research, conceiving and developing new and innovative ideas, theories, and/or solutions, and predicting possible outcomes. Possess ability to prepare and present "what-if" scenarios.
Supervision:  ability to operate independently
Education / Experience:  MS Office Software Word & Excel, SharePoint
Miscellaneous:  Experience within the VA and Government agencies supporting Program/Project Managers; VA infrastructure experience a plus
If you feel you are qualified for this position, express interest by clicking the Apply button below (if you are viewing this position on the Salient CRGT website). If you are viewing this job posting outside of the Salient CRGT website, please visit: www.salientcrgt.com/careers to express interest in this position through the Salient CRGT Careers page.
Salient CRGT is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, age, sex, sexual orientation, gender identity or expression, veteran status, disability, genetic information, or any other factor prohibited by applicable anti-discrimination laws.

#J-18808-Ljbffr

Business Analyst (Rockville, MD - Some Travel to D.C. Required)   Full-time
Salient CRGT is a leading provider of health, data analytics, cloud, agile software development, mobility, cyber security, and infrastructure solutions. We support these core capabilities with full lifecycle IT services and training—to help our customers meet critical goals for pivotal missions. We are purpose-built for IT transformation supporting federal civilian, defense, homeland, and intelligence agencies, as well as Fortune 1000 companies.
We are seeking a Business Analyst to join our project team to build a custom and COTS integration solution for our Government client. In this role you will collaborate with product owners, stakeholders and an Agile engineering team to solicit, elaborate, and document business and technical requirements. The ideal candidate will be a self-starter, have experience working on IT software infrastructure projects, and enjoy working in a collaborative team environment. Candidates must be able to obtain a Public Trust clearance.  The primary work location is in Rockville, MD with occasional client visits in Washington, D.C.
In this role you will:
Lead requirement discussions to document, analyze and translate functional and non-functional business requirements into project specifications, business process diagrams and workflows
Work with client Product Owners and other stakeholders to develop and validate user stories and priorities
Develop UI mockups using tools such as Balsamiq
Maintain requirements traceability and document change requests
Participate in Sprint Planning, Sprint Reviews, Scrum Meetings and other agile activities
Create or update project deliverables, artifacts and technical specifications in accordance with client requirements
Support the Quality Assurance Specialist to ensure thoroughness of test strategies and scenarios
Assist the team with troubleshooting problems and developing recommendations/solutions
Demonstrate ability to manage multiple tasks and adhere to project schedules
Mandatory Requirements:
(W2 only, no c2c or third party inquiries please)
Minimum of 5 years business analysis experience in a structured software development environment
Excellent understanding of the software development life cycle
Must have excellent written and oral communication skills
Ability to understand and document technical IT requirements
Must be able to attain a Public Trust clearance. Possessing an existing Public Trust clearance is a plus.Ability to obtain/maintain a Public Trust Clearance is required including for non-US Citizens residency in the United States a minimum of three (3) of the past five (5) years
Bachelor's Degree
Salient will not sponsor work visas for this opening
Desired Requirements:
Experience working on IT projects involving the integration of software applications including Identity and Access Management integration
Experience with business process modeling and SQL
Hands on experience with Agile projects
If you feel you are qualified for this position, express interest by clicking the Apply button below (if you are viewing this position on the Salient CRGT website). If you are viewing this job posting outside of the Salient CRGT website, please visit: www.salientcrgt.com/careers to express interest in this position through the Salient CRGT Careers page.
Salient CRGT is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, age, sex, sexual orientation, gender identity or expression, veteran status, disability, genetic information, or any other factor prohibited by applicable anti-discrimination laws.

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Salient Crgt Business Intelligence Interview Guide

Overview

Salient Crgt Business Intelligence Interview Process

Salient Crgt Business Intelligence Interview Questions

Salient Crgt Business Intelligence Jobs