The Connectedx Inc. Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Connectedx Inc. Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Connectedx Inc.? The Connectedx Inc. Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Connectedx Inc. Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Connectedx Inc..</li>
<li>Practice real Connectedx Inc. Business Intelligence interview questions.</li>
</ul>
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 Connectedx Inc. Business Intelligence interview.


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

- Know what skills are necessary for Connectedx Inc. Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Connectedx Inc..
- Practice real Connectedx Inc. 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 Connectedx Inc. Business Intelligence interview.
        

Overview

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

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

Connectedx Inc. Business Intelligence Interview Process

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.

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.

Clarification:

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

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

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

Example:

Input:

<code>employees</code> table

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

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

<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>
Output:

<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

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

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.

Example:

Input:

<code>players</code> table

<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>
Output:

<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

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.

Write a query to return the number repeated by one times its own value.

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

Example:

Input:

<code>tbl_numbers</code> table

<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>
Output:

<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

Connectedx Inc. Business Intelligence Interview Questions

Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from ConnectedX Inc.
I am passionate about connecting Job Seekers and landing them to their Work Destinations !!If you are in TEXAS or looking for a Job in TEXAS - Feel…   Job Title: Data Analyst
Location:  Plano, Texas (Locals Only)
Duration:  Long Term Contract
Company:  ConnectedX Inc.
Mode:  Onsite
Company Overview:
ConnectedX Inc. is a Dallas, Texas-based organization focused on Digital Transformation and Product Engineering Services. We enable clients to achieve their business, operating, and technology goals through innovative and consultative digital solutions. Our client list includes Fortune 1000 enterprises, and we are known for our strong delivery model and employee-centric approach.
Must-Have Experience:
Data Discovery:
Proficient in identifying and profiling data from multiple sources to assess quality, relevance, and completeness.
Data Analysis:
Significant hands-on experience with data mining, reporting, and deriving insights from complex datasets using advanced SQL and analytics tools.
Experience building conceptual, logical, and physical data models; knowledge of star/snowflake schemas, normalization/denormalization.
Identifying Business Use Cases:
Ability to understand and translate business needs into practical use cases and actionable data tasks.
Converting Business Requirements to Data Requirements:
Expertise in gathering requirements from stakeholders and converting them into detailed technical data specifications.
Technical Skills:
Strong command of  SQL  and experience in querying large, complex databases.
Experience with  data platforms and technologies  such as:
Snowflake
Oracle
SQL Server
Experience working with  reporting and BI tools  (e.g., Tableau, Power BI, Looker).
Familiarity with  ETL/data pipeline  development and maintenance.
Agile project delivery experience  including participation in sprint planning and daily scrums.
Preferred/Bonus Skills:
Advanced degree in  Computer Science, Finance, or Information Systems .
Experience in the  banking or financial services industry .
Exposure to  Web Authentication tools  (Centrify, Okta).
Understanding of  SSO and MFA  implementation, including connector server client deployment.
Education:
Bachelor’s degree or higher in Computer Science, Information Systems, or related field.
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Contract
Job function    Job function Information Technology
Referrals increase your chances of interviewing at ConnectedX Inc. by 2x
Sign in to set job alerts for “Data Analyst” roles.  Dallas, TX $80,000.00-$90,000.00 3 weeks ago
Plano, TX $70,000.00-$90,000.00 2 days ago
Dallas, TX $75,000.00-$120,000.00 2 weeks ago
Dallas, TX $75,000.00-$120,000.00 2 weeks ago
Data Analyst - SQL/Tableau/Snowflake - Dallas, TX  Dallas, TX $100,000.00-$120,000.00 3 days ago
Enterprise Data & Analytics Data Analysts x3  The Colony, TX $75,000.00-$90,000.00 3 weeks ago
Irving, TX $90,000.00-$100,000.00 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from ConnectedX Inc.
I am passionate about connecting Job Seekers and landing them to their Work Destinations !!If you are in TEXAS or looking for a Job in TEXAS - Feel…   Who we are:
ConnectedX is focused on Digital Transformation and Product Engineering Services, enabling clients achieve their business, operating and technology needs for the digital age. Our unique industry-based, consultative approach helps clients implement digital transformation initiatives. Headquartered in Dallas, Texas, U.S. ConnectedX is a preferred partner for leading Fortune 1000 enterprises and is consistently admired by the clients and employees across the globe.
Role: Data Scientist
Duration: 12+ Months Contract
What you bring:
• Strong experience manipulating data set and building statistical models, has master’s or Ph.D. in statistics, mathematics with focus on ML, NLP, machine learning or another quantitative field.
• Strong Knowledge and experience in statistical and data mining techniques – GLM/regression, Random Forest, Boosting, text and data mining.
• Experience querying database and using statistical computer languages : R , Python, SQL etc.
• Experience creating and using advanced machine learning algorithms and statistics: regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks, etc.
• Experience with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, , MySQL, etc.
• Experience visualizing/presenting data for stakeholders using: Tableau, Business Objects, D3,
• Exp with Prescriptive analysis, predictive analysis.
• Exp leveraging big data and search technologies (e.g., Spark, Elastic Search, Natural Language Processing, Web Crawling) .
• Knowledge of machine learning techniques and algorithms and be able to apply them in data driven natural language processing techniques.
• Ability to quickly prototype ideas / solutions and perform critical analysis and using creative approaches for solving complex problems.
• Exp with Automotive analytics a PLUS
• Excellent written and verbal communication skills
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Contract
Job function    Job function Analyst, Information Technology, and Science
Referrals increase your chances of interviewing at ConnectedX Inc. by 2x
Sign in to set job alerts for “Data Scientist” roles.  Frisco, TX $153,600.00-$264,000.00 1 week ago
Dallas, TX $100,000.00-$130,000.00 6 days ago
Plano, TX $112,000.00-$130,000.00 3 days ago
Irving, TX $80,000.00-$115,000.00 4 days ago
Lead Data Scientist With AI Exp - Hybrid - (Fulltime)  100% remote - Machine Learning Engineer (Hadoop, Spark, ML) - Immediate Interviews - Dallas, TX - Direct Client  Dallas, TX $110,000.00-$130,000.00 2 days ago
Plano, TX $110,000.00-$150,000.00 4 days ago
Plano, TX $99,461.00-$128,329.00 23 hours ago
Dallas, TX $132,000.00-$154,000.00 2 days ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Who we are: ConnectedX is focused on Digital Transformation and Product Engineering Services, enabling clients achieve their business, operating and technology needs for the digital age. Our unique industry-based, consultative approach helps clients implement digital transformation initiatives. Headquartered in Dallas, Texas, U.S. ConnectedX is a preferred partner for leading Fortune 1000 enterprises and is consistently admired by the clients and employees across the globe. Role: Data Scientist Plano, TX (Hybrid) Duration: 12+ Months Contract What you bring: • Strong experience manipulating data set and building statistical models, has master’s or Ph.D. in statistics, mathematics with focus on ML, NLP, machine learning or another quantitative field. • Strong Knowledge and experience in statistical and data mining techniques – GLM/regression, Random Forest, Boosting, text and data mining. • Experience querying database and using statistical computer languages : R , Python, SQL etc. • Experience creating and using advanced machine learning algorithms and statistics: regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks, etc. • Experience with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, , MySQL, etc. • Experience visualizing/presenting data for stakeholders using: Tableau, Business Objects, D3, • Exp with Prescriptive analysis, predictive analysis. • Exp leveraging big data and search technologies (e.g., Spark, Elastic Search, Natural Language Processing, Web Crawling) . • Knowledge of machine learning techniques and algorithms and be able to apply them in data driven natural language processing techniques. • Ability to quickly prototype ideas / solutions and perform critical analysis and using creative approaches for solving complex problems. • Exp with Automotive analytics a PLUS • Excellent written and verbal communication skills

We are looking for an experienced Data Engineer with 3+ years of expertise in Databricks, AWS, Scala, and Apache Spark to join our team. The ideal candidate will have a strong foundation in big data processing, cloud technologies, and performance tuning to enable efficient data management. You'll also collaborate with global teams, work with advanced cloud technologies, and contribute to a forward-thinking data ecosystem that powers the future of automotive engineering. Company profile: <a>ConnectedX: Empowering Tech Leaders with Tailored Solutions</a> Key Responsibilities:· Architect, design, and implement scalable ETL pipelines for large data processing.· Develop and optimize data solutions using Databricks, AWS, Scala, and Spark.· Ensure high-performance data processing with distributed computing techniques.· Implement best practices for data modeling, transformation, and governance.· Work closely with cross-functional teams to improve data reliability and efficiency.· Monitor and troubleshoot data pipelines for performance improvements. Required Skills & Qualifications:· Excellent communication and ability to handle direct Client interactions.· 3+ years of experience in Data Engineering.· Expertise in Databricks, AWS, Scala, and Apache Spark.· Strong knowledge of big data architecture, ETL processes, and cloud data solutions.· Ability to write optimized and scalable Spark jobs for distributed computing. Who Can Apply:<ul><li>Only candidates who can join immediately or within 2 weeks can apply.</li><li>Ideal for those seeking technical growth and work on a global project with cutting-edge technologies.</li><li>Best suited for professionals passionate about innovation and problem-solving</li></ul>

We are seeking a motivated Data Engineer with 1-2 years of experience to join our team. The ideal candidate will have hands-on experience in Databricks, AWS, Scala, and Spark and will be responsible for building, optimizing, and maintaining scalable data pipelines. You'll also collaborate with global teams, work with advanced cloud technologies, and contribute to a forward-thinking data ecosystem that powers the future of automotive engineering. Company profile: <a>ConnectedX: Empowering Tech Leaders with Tailored Solutions</a> Key Responsibilities:· Design, develop, and maintain robust ETL pipelines for data processing.· Work with Databricks to perform data transformations and analytics.· Develop scalable solutions using Scala and Apache Spark for big data processing.· Collaborate with teams to ensure efficient data flow and integration.· Optimize data storage and processing on AWS cloud infrastructure.· Monitor and troubleshoot performance issues in data pipelines. Required Skills & Qualifications:· Excellent communication and ability to work collaboratively in a fast-paced environment.· 1-2 years of experience in Data Engineering.· Proficiency in Databricks, AWS, Scala, and Spark.· Strong understanding of data modeling, ETL processes, and performance tuning.· Familiarity with SQL and database management systems Who Can Apply:<ul><li>Only candidates who can join immediately or within 2 weeks can apply.</li><li>Ideal for those seeking technical growth and work on a global project with cutting-edge technologies.</li><li>Best suited for professionals passionate about innovation and problem-solving</li></ul>

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

Connectedx Inc. Business Intelligence Interview Guide

Overview

Connectedx Inc. Business Intelligence Interview Process

Connectedx Inc. Business Intelligence Interview Questions

Connectedx Inc. Business Intelligence Jobs