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

Apexon Business Intelligence Interview Guide

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


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

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

Overview

Apexon Business Intelligence Salary

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.

Apexon Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

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

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

What are the logistic and softmax functions? What is the difference between the two?

What makes them useful for use in logistic regression?

In logistic regression, how is the predicted class determined based on the logistic function?

In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

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

Manager Team Sizes

Apexon Business Intelligence Interview Questions

Title: Senior JAVA Software EngineerLocation: Mississauga, Canada [Hybrid]Type : Full time You’ll be responsible for (Responsibilities):You will write high-quality, scalable, supportable, and extensible code for software applications.Ensure seamless integration of the software stack with our existing CI pipeline, contributing to continuous improvements.Design, plan, and deliver high-quality software independently, maintaining excellence in execution.Amplify our culture by embodying our values of technical excellence, integrity, support, and compassion for individuals.Actively contribute to the ongoing improvement of processes and operations, ensuring the highest standards in software development. Required Experience:Bachelor’s degree in Computer Science or a related technical disciplineYou have over 8 years of hands-on experience in designing, developing, and deploying scalable web applications and services, with proficiency in Java, Spring Boot, and JPA.Proven leadership skills to guide the team towards successful project execution and collaboration with software architects on deployment architecture for optimal stability, performance, and security.Expertise in crafting relational data models, REST APIs, and implementing message broker-based distributed architectures (e.g., RabbitMQ and Spring AMQP), along with experience in both relational (PostgreSQL, MySQL) and NoSQL databases.Ability to understand sophisticated workflows and effectively work with globally distributed teams. Preferred:Master’s degreeExperience developing regulated products under design controlExperience with virtualization, containers, and orchestration platforms (Dockers, Kubernetes)Curiosity in bioinformatics analysis and computational pipelinesExperience with GitHub actionsFamiliarity with DevOps automation tools like Jenkins, Terraform, Ansible etc.Experience developing and deploying production software using public cloud infrastructure, preferably AWSPassionate for continuous improvement in software development processes & framework

About the job Software Engineer Are you self-motivated with an innovative mind, a passion for technology, and a good understanding of object orientated development? Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation. Apexon brings together distinct core competencies – in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences – to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence. We are seeking a skilled and motivated Scripting Developer with a strong background in Perl, Shell/Korn Shell, and JavaScript to join our dynamic team. This role involves working on a variety of projects that require robust programming skills, a keen eye for debugging, and experience with distributed storage systems. You'll be responsible for:<ul><li>Develop, test, and maintain scripts using Perl, Shell/Korn Shell, and JavaScript to automate tasks and processes across various projects.</li><li>Write and debug code, ensuring high performance and responsiveness of the scripts developed.</li><li>Collaborate with cross-functional teams to integrate scripts into existing systems and workflows.</li><li>Leverage experience with distributed storage systems, including DB2, Sybase/Sybase IQ, and MongoDB, to optimize data handling and storage solutions.</li><li>Participate in the design and implementation of CI/CD pipelines, with a focus on automating code deployment using Git and related tools.</li><li>Work closely with the DevOps team to ensure smooth deployment and integration of scripts within Unix/Linux environments.</li><li>Continuously improve existing codebases, ensuring best practices in coding and deployment are followed.</li></ul> You’ll have:<ul><li>3+ years of relevant work experience in a team-focused environment</li><li>A Bachelor or Master degree in a computational field (Computer Science, Applied Mathematics, Engineering, or in a related quantitative discipline)</li><li>Strong programming skills in Perl, Shell/Korn Shell, and JavaScript.</li><li>Hands-on experience with writing, testing, and debugging scripts for various applications.</li><li>Familiarity with distributed storage systems such as DB2, Sybase/Sybase IQ, and MongoDB.</li><li>Working knowledge of CI/CD pipelines, with specific experience using Git for version control and deployment.</li><li>Solid experience working in Unix/Linux environments.</li></ul> It would be great if you have:<ul><li>Experience in automating large-scale systems and managing distributed storage.</li><li>Strong analytical and problem-solving skills, with an ability to troubleshoot complex systems.</li><li>Ability to work independently as well as collaboratively in a team environment.</li><li>Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.</li></ul> We’re committed to providing our people with a great environment to work in. You can expect ongoing skills-based development, career progression as well as health & well-being benefits and support. You’ll work within a friendly and supportive team, working on a variety of projects and the chance to obtain relevant certifications along the way! We also offer:<ul><li>Up to 10% bonus (based on company and personal performance).</li><li>An employer pension scheme</li><li>25 days holiday + 8 bank holidays, with the option to carry forward or 'cash-in' 5 days each year</li><li>Access to YuLife wellness platform, subscription to Meditopia App, premium subscription to Fiit, life coaching & emotional wellbeing sessions, 24 / 7 virtual GP Access, Employee Assistance Programme</li><li>Life Insurance & Income protection</li><li>Enhanced Maternity Pay & Paternity Pay</li><li>Cycle to work scheme</li><li>Travel loan scheme</li><li>A Tech Scheme which lets you choose from over 5000 tech products at up to a 12% discount</li><li>Free unlimited Udemy account for every employee to support their continuous learning and improvement</li><li>Support in obtaining relevant certifications</li></ul>

Are you a Data Engineer looking to work with the latest data and analytics technologies within an environment that actively encourages continuous learning? Do you want to help enable clients to unlock their data potential and value? About us: Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation. Apexon brings together distinct core competencies – in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences – to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centres) across four continents. We are currently looking to hire a Data Engineer to join our growing team in Sunderland. You’ll be responsible for: <ul><li>Translating business requirements into technical specifications to ultimately deliver data solutions including integrations, data transformations, warehousing and business intelligence reporting. </li><li>The design and implementation of data ETL pipelines to extract, transform and load data from client and third-party data sources. </li><li>Implementing and enforcing data governance policies and processes to ensure data is of the highest quality. </li><li>Developing and maintaining documentation related to data integration processes, data flows, and data quality. </li><li>Participating in code reviews with other team members. </li><li>Creating unit tests for test automation. </li><li>Balancing pragmatic solutions with best practice and delivery </li></ul> You’ll have: <ul><li>Proven experience as a Data Engineer with a focus on Azure cloud data services (e.g. Azure Data Factory, Data Lake, etc). </li><li>Experience working with databases (MS SQL Server, MySQL, PostgreSQL, MongoDB, Cassandra or similar) </li><li>Excellent SQL skills. </li><li>Strong programming skills, ideally in Python. </li><li>Hands-on, practical skills in dealing with large amounts of data. </li><li>ETL pipeline development experience for data sources integration and data transformations. </li><li>Experience of data wrangling, ideally including data quality profiling and monitoring against set KPIs. </li><li>Experience of data modelling to describe the data landscape, entities and relationships. </li><li>Proficient in the development of Power BI dashboards. </li><li>Strong communication and teamwork skills to collaborate with cross-functional teams effectively. </li></ul> It would be great if you have: <ul><li>Knowledge of metadata management ideally with experience of creating and managing data catalogues, dictionaries and glossaries. </li><li>An Azure certification, e.g. DP-900, AZ-900. </li></ul> We’re committed to providing our people with a great environment to work in. You can expect ongoing skills-based development, career progression as well as health & well-being benefits and support. You’ll work within a friendly and supportive team, working on a variety of projects and you’ll have the chance to obtain relevant certifications along the way! We also offer: <ul><li>Up to 10% bonus (based on company and personal performance). </li><li>An employer pension scheme </li><li>25 days holiday + 8 bank holidays, with the option to carry forward or 'cash-in' 5 days each year </li><li>Access to YuLife wellness platform, subscription to Meditopia App, premium subscription to Fiit, life coaching & emotional wellbeing sessions, 24 / 7 virtual GP Access, Employee Assistance Programme </li><li>Life Insurance & Income protection </li><li>Enhanced Maternity Pay & Paternity Pay </li><li>Cycle to work scheme </li><li>Travel loan scheme </li><li>A Tech Scheme which lets you choose from over 5000 tech products at up to a 12% discount </li><li>Free unlimited Udemy account for every employee to support their continuous learning and improvement </li><li>Support in obtaining relevant certifications </li></ul> Don’t tick all the boxes? Don’t worry about it: we still want to hear from you if you think you’re the right person for the job.

Description Position at Apexon Company Description Apexon is a digital-first technology services firm backed by Goldman Sachs Asset Management and Everstone Capital. We specialize in accelerating business transformation and delivering human-centric digital experiences. For over 17 years, Apexon has been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation. Responsibilities The Business Analyst conducts interviews with the business users and subject matter experts to collect and document business requirements and present them in standard templates. The ideal candidate should have prior experience as a Business Analyst for AMANDA enterprise permit and licensing application from Granicus (formerly Calytera). Responsibilities Prepare for business requirement meetings
Prepare participants with information for the purpose of requirement analysis meeting
Explain AMANDA by Granicus features and capabilities.
Assist with AMANDA by Granicus software configuration and workflow capabilities.
Conduct interviews and detailed requirement gatherings during the meetings with the Business Offices.
Gather requirements in standard templates
Document template and reporting capabilities within AMANDA by Granicus software
Present demo of configured AMANDA by Granicus application
Document pre-condition and post-action event rules in AMANDA by Granicus software
Standardize and document various processes in AMANDA by Granicus software.
Assess and review the business capabilities with each Business Office
Assist in the documentation and analysis of business scope, standardization, requirements, user stories, test cases, success criteria, etc.
Prepare process flow documentation
Review and validate requirements with the technical team
Conduct requirement reviews with Business Offices for signoff
Provide input to the Solutions Architect and development team for implementation
Provide support to the QA team during the testing phases of the project
Assist in the UAT and User Training activities.
General Skills Ability to generate insights from information for standardization
Experience working in AGILE with understanding of Scrum processes
Experience working with Microsoft Vizio to depict Business process Flows
Good documentation skills and being able to articulate business requirements in an understandable form including documenting Functional Specifications
Good presentation skills and be able to demonstrate to business users
Expertise in translating business requirements to technical requirements
Work with business teams as well as technical team
Experience in Requirements management tool like JIRA, Azure DevOps.
AMANDA By Granicus Skills Configuration
Workflow capabilities
Personalization features
Job scheduler features
Document template capabilities
Reporting capabilities
Ability to demo a configured application
Auto cycle
Renewal cycle
Fees configuration and GL accounts
Ability to document pre-condition and post-action events rules
Standardization of various processes
Various features of people and folders
Disclaimer If you feel that this is a good match for your skillsets, please submit a current word version of your resume along with a cover letter describing your skills, experience and salary expectations. We are an Equal Opportunity Employer (EOE).
#J-18808-Ljbffr

Apexon Business Intelligence Interview Guide

Overview

Apexon Business Intelligence Salary

Apexon Business Intelligence Interview Process

Apexon Business Intelligence Interview Questions

Apexon Business Intelligence Jobs