Prepare for and practice interview questions from CTG.

CTG Interview Questions

CTG Interview Guides

<h1>CTG Company Interview Guide</h1>
Welcome to the CTG Company Interview Guide! Here, you'll find essential information to help you ace your interview at CTG.
<h2>Overview</h2>
CTG is a dynamic and innovative company dedicated to pushing the boundaries in technology and services. We're constantly on the lookout for talent that shares our passion for excellence and innovation.
<h2>Inside This Guide</h2>
<ul>
<li>What We Look For: Key qualifications and traits CTG values in candidates.</li>
<li>Interview Process: Detailed breakdown of each stage, from initial screenings to final interviews.</li>
<li>Job Salaries: Competitive salary ranges for various positions within CTG.</li>
</ul>
Prepare yourself with this guide to increase your chances of success in landing a rewarding career at CTG. Good luck!

# CTG Company Interview Guide

Welcome to the CTG Company Interview Guide! Here, you'll find essential information to help you ace your interview at CTG.

## Overview
CTG is a dynamic and innovative company dedicated to pushing the boundaries in technology and services. We're constantly on the lookout for talent that shares our passion for excellence and innovation.

## Inside This Guide
- **What We Look For:** Key qualifications and traits CTG values in candidates.
- **Interview Process:** Detailed breakdown of each stage, from initial screenings to final interviews.
- **Job Salaries:** Competitive salary ranges for various positions within CTG.

Prepare yourself with this guide to increase your chances of success in landing a rewarding career at CTG. Good luck!

Overview

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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

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?

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

CTG Salaries by Position

CTG is seeking to fill a Business Analyst - Business Process Mapping opening for our client in Anchorage, AK.
Location: Anchorage, AK
Duration: 9 months
The Business Analyst will work with the organization to map different processes and identify areas of improvement. Assist the business in boosting their performance, ensuring higher revenues, and developing relevant strategies to enable the organization to remain competitive in the industry.
Able to conduct thorough data analysis and process mapping to identify obstacles, inefficiencies, and opportunities for improvement. Develop and implement relevant processes and technologies to optimize the organization's internal operations.
Able to outline every activity, role, and business entity involved in the business process. The goal of a process map is to document, understand, and improve business processes. With the use of symbols and flowcharts, a process map simplifies the understanding, interpretation, and workflow of a process.
Skills Excellent knowledge of fit gap analysis, process documentation, documenting functional requirements, testing documentation and execution, and data conversion.
Ability to anticipate risks and devise solutions in the moment, prioritize work, and meet deadlines.
Ability to work across different organization levels and different functional teams, adjusting the communication style as appropriate to VPs, management, and team members.
Strong interpersonal skills, including the ability to communicate technical concepts to non-technical clients and proven ability to work effectively with all organizational levels.
Hands-on style, with an aptitude and inclination to dig into details, but also able to summarize in a managerial context.
Excellent written and verbal communication skills, including facilitation, presentation, and collaboration.
Experience Must have 2 years experience as a business analyst/technical writer, participating in functional design sessions, creating process flows, documenting functional requirements, creating test related documentation, and escalating risks and issues as appropriate.
Must have business analyst/technical writer experience as part of at least 2 software implementations, preferably Customer Information Systems (customer management, utility billing, etc.) related applications.
Prefer experience with Cayenta Customer Information System (CIS) software, Invoice Cloud, MyMeter, and SmartWorks or similar applications.
Previous HR and/or Payroll background, experienced in testing new software, understanding basic requirements of an HR system (hire to retire), payroll and time entry system.
Education Bachelor’s degree in computer science, information technology or equivalent preferred.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.
To Apply
To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Rebecca Olan at 716-887-7371 or Rebecca.Olan@ctg.com . Kindly forward this to any other interested parties. Thank you!
About CTG CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions.
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity and Affirmative Action Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law.

#J-18808-Ljbffr

CTG is seeking business analyst professionals who can deliver exceptional results, driving projects from inception through to successful completion, ensuring alignment with organizational goals, timely delivery of project milestones, and the achievement of defined outcomes. **Nice to have experiences:** + Healthcare Implementation + Continuity of Care (nursing and inpatient workflow needed) + AI; Infrastructure (networking, hardware deployment); Interfaces and 3rd party **Job Description:** + Have at least five years of experience in providing PPM (Project and Portfolio Management) Services to clients in the healthcare, research, or technology sectors. + Have a proven history of delivering successful and measurable results for similar projects and campaigns. + Have a team of qualified and skilled professionals that have supported other healthcare clients. + Have proficiency in relevant tools, platforms, and resources. + Articulate and execute transparent pricing structure and billing method, and provide receipts itemized for bill of goods for the timeline of the RFP active status. Proposals will be financed out based on the deliverables and the completion based on respondents execution strategy to deliver the bill of goods. + Has ability to provide information on the availability of resources and the typical lead time for assigning new resources to projects. + Can describe the providers standard onboarding process, including steps from contract signing to resource deployment. + Describes how the provider manages urgent or expedited onboarding requests and the mechanisms in place for quick resource allocation. + Has fallback procedures and contingency plans in case of delays or issues during onboarding. + Have experience with resolving any onboarding issues that arise, including timelines for addressing and resolving these issues. + Planning, executing, monitoring, controlling, and closing the projects according to the agreed scope, schedule, budget, and quality standards. + Identifying, analyzing, and managing the project risks, issues, dependencies, and changes + Preparing and maintaining the project documentation, such as project charter, project plan, status reports, risk register, change log, etc. + Facilitating the communication and collaboration among the project team, clients, vendors, and other stakeholders + Gathering, eliciting, analyzing, validating, and documenting the business requirements and specifications + Conducting the business process mapping, modeling, and improvement + Performing the gap analysis, feasibility study, cost-benefit analysis, and business case development + Assisting the testing, training, and implementation of the project deliverables + Evaluating the project outcomes and benefits realization The expected base salary for this position ranges from $90,000 to $130,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered. **About CTG** CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com . Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work Certified company across many of our global operations. CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws. CTG is an Equal Opportunity and Affirmative Action Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. Our Affirmative Action program serves to promote occupational equality and diversity through good faith efforts. CTG is fully committed to promoting employment opportunities for members of protected classes.

CTG is seeking to fill a Data Analyst III position for our client in Anchorage, AK. **Location:** Anchorage, AK **Duration:** 12 months **Duties:** + Provide quality data to businesses and functions to support critical decision-making. + Support, promote, and document all Data Management processes and procedures. + Develop workflows and tools to automate data loading processes, ensuring data quality and integrity. + Ensure the quality, consistency, and integrity of data in a timely, effective, and reliable manner. + Receive, archive, distribute, load, and dispose of technical data according to established policies, standards, and procedures. **Skills:** + Strong analytical and problem-solving skills. + Proficiency in data management tools and software. + Ability to communicate complex information clearly and concisely. + Strong attention to detail and organizational skills. + Ability to work independently and collaboratively within a team. **Experience:** + Typically 5-7 years of experience in data management or a related field. + Demonstrated understanding of data management principles and best practices. + Experience in developing and implementing data workflows and automation tools. **Education:** + Bachelors degree in a related field preferred. Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required. CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role. **To Apply:** To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Recruiter Rebecca Olan at rebecca.olan@ctg.com . Kindly forward this to any other interested parties. Thank you! **About CTG** CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com . Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work Certified company across many of our global operations. CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws. CTG is an Equal Opportunity and Affirmative Action Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. Our Affirmative Action program serves to promote occupational equality and diversity through good faith efforts. CTG is fully committed to promoting employment opportunities for members of protected classes.

CTG Interview Questions

CTG Interview Guides

Overview

CTG Company Interview Guide

Overview

Inside This Guide

CTG Interview Questions

CTG Salaries by Position

CTG Opening Jobs