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

Themesoft Business Intelligence Interview Guide

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


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

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

Overview

Themesoft 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.

Themesoft 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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</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>user_id</code></td>
<td>INTEGER</td>
</tr>

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

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>users</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>
</tbody>
</table>
 
Output:

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

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

Themesoft Business Intelligence Interview Questions

<ul><li>Job Title: BA with Wealth Mgmt</li><li>Location: New York/Charlotte (3 days working from office)</li><li>Overall 7+ years’ experience</li></ul> JD Responsibilities:<ul><li>Collaborate with stakeholders to understand their needs and gather detailed business requirements.</li><li>Analyze data to identify trends, patterns, and insights that inform business decisions.</li><li>Work closely with the client to define and optimize their roadmap.</li><li>Gather accurate requirements and create user stories, sharing information across internal and client teams.</li><li>Provide subject matter expertise on industry trends, regulations and best practices to inform recommendations and solutions.</li><li>Develop and document business process models to illustrate current and future states.</li><li>Propose and design technical and process solutions that meet business needs and objectives.</li><li>Communicate findings, recommendations, and project updates to stakeholders and executives.</li><li>Create detailed documentation of business requirements, processes, and solutions.</li><li>Participate in testing and validating new systems and processes to meet business requirements.</li><li>Identify opportunities for process improvements and contribute to ongoing optimization efforts.</li></ul> Qualifications:<ul><li>7+ years of experience in Business Analyst role.</li><li>3+ years of working experience in the Wealth Management projects.</li><li>Experience with creation of EPICs and writing of User Stories to align with the project plan and scope.</li><li>Independently leading sessions to gather information and requirements from key stakeholders.</li><li>Effective communicator - liaising between stakeholders and users.</li><li>Demonstrated ability to develop strong relationships with key stakeholders, as well as others across the team/department.</li><li>Agile methodology experience.</li><li>Knowledge of Banking and Financial domain.</li></ul>

Software Engineer/Data EngineerHybrid to Sunnyvale CA, twice a week Needs:LookerGCPData Engineering- Scala/SparkSoftware Engineering- Java/ springGood Client background Job Description:Will be doing Data Engineering work for a Marketing Technology Platform. The resource will be pulling data from structured and unstructures data sources. Then ETL the data using Scala, Python, JAva, utilize Spark . Everything is done in a GCP/ AZure environment with usage of Hive tables. 50 percent of the work is on looker virtualization and 50 percent is straight data engineering. RegardsVinay Svinay.s@themesoft.com

Role: Engineering Manager OMS
Location: Nashville, TN 5 days a week.
Long term Contract
JD:
Top 3 Must Have's
Strategic Planning and Project Management Skills
Technical Expertise and Problem-Solving Ability
Strong Leadership and Communication Skills
Experience with retail domain and OMS platforms, especially  Sterling OMS . Strong knowledge of system architecture, microservices and cloud platforms, especially Azure.
Job Descriptions
15+ years of experience in software engineering, with 5+ years in management role, ideally within order management or e-commerce systems.
Experience with OMS platforms, especially Sterling OMS and understanding of order processing, inventory management, and fulfillment workflows.
Strong knowledge of system architecture, microservices and cloud platforms, especially Azure.
Develop and implement the technical roadmap for the OMS platform, aligning with business goals and customer requirements.
Ensure scalability, reliability, and security of the OMS system to handle large volumes of transactions and data.
Drive technical decision-making on system architecture, integrations, and feature development that enhance order processing and fulfillment efficiency.
Lead architectural and solution discussions with client. Present solution options to the client and negotiate.
Maintain deep technical knowledge of the OMS platform to provide guidance and troubleshooting issues as needed.
Manage end-to-end project lifecycle for OMS-related projects, from planning and design through to implementation and maintenance.
Coordinate with cross-functional teams (e.g., product management, inventory, and logistics) to ensure alignment on requirements, timelines, and deliverables.
Implement and oversee Agile processes (e.g., sprint planning, code reviews) to ensure timely and quality delivery of projects.
Optimize workflows and streamline order processing by implementing best practices, including automation and process improvements.
Collaborate with business stakeholders to translate business needs into technical requirements and ensure OMS capabilities align with business objectives.
Serve as the primary technical contact for OMS-related inquiries, communicating status, risks, and timelines to both technical and non-technical stakeholders.
Deliver regular updates on team performance, project milestones, and system health to senior management.
Lead, mentor, and manage a team of software engineers, fostering a collaborative and high-performance culture.
Excellent communication skills for cross-functional collaboration and stakeholder engagement
Regards,
_______________________
Parthasarathy K
Lead Recruiter
Work:  972-474-8787  Ext: 306,Direct: 972-737-8607
Partha.k@
Themesoft Inc | Themesoft Jobs

Job DescriptionStaff Software EngineerFulltimeBentonville, AR What you'll do:Associate Experience is a group within the Intelligent Store Tech (IST) org within Client. This hands-on role requires exceptional coding skills, a passion for technology and engineering excellence, and the ability to guide and mentor multiple teams of engineers. You will play a pivotal role in defining and maintaining our technical architecture, ensuring alignment with business goals and scalability requirements. About Team:The Associate Experience group focuses on building products that enable our Associates to serve Customers during the Checkout process. We use open-source tech to build software that stands on top of a foundational Platform architecture which is being built from the ground up. Your team will leverage React JS, React Native, Java, Spring, Kubernetes, NoSQL, Kafka and other such tools/frameworks. What you’ll do:<ul><li>Provides technical leadership and mentorship to engineers, fostering a culture of continuous improvement and innovation in solution design, architecture and development.</li><li>Lead the creation and maintenance of technical design, aligning it with business goals and scalability requirements. </li><li>Design complex software systems, ensuring performance, security, and scalability needs are met. </li><li>Guide engineers to adopt engineering best practices, conduct/lead design & code reviews, and ensure alignment with the IST Architecture vision.</li><li>Foster a culture of learning and innovation through hands-on technical guidance and mentorship.</li><li>Uphold high standards in quality and operational excellence.</li><li>Develop comprehensive technical documentation and presentations to clearly communicate architectural decisions and design options. </li><li>Work closely with Program, Product, Business, and Design partners to plan work (by sprint and by quarter) and ensuring that engineering tech priorities are also included.</li><li>Directs root cause analysis of critical business and production issues.</li><li>Drive Implementation of telemetry features by determining data/metrics requirement within the domain.</li><li>Monitor and evaluate the performance of the application by tracking and analyzing appropriate metrics.</li><li>Conduct reviews of software design & code to ensure quality is built into product.</li><li>Monitor and evaluate the progress of the projects against approved milestones and timelines.</li><li>Provides supervision and development opportunities for associates by selecting and training; mentoring; assigning duties; building a team-based work environment; establishing performance expectations and conducting regular performance evaluations; providing recognition and rewards; coaching for success and improvement; and ensuring diversity awareness.</li><li>Promotes and supports company policies, procedures, mission, values, and standards of ethics and integrity by training and providing direction to others in their use and application; ensuring compliance with them; and utilizing and supporting the Open Door Policy.</li></ul> What you’ll bring"<ul><li>8+ years of relevant experience in software development and solution architecture focusing on building large scale complex distributed systems.</li><li>Must have experience leading teams in a solution architect role building complex microservices and frontends.</li><li>Strong hands-on experience working with mobile tech stack – React, React Native, Java, Nodejs, iOS/Android, etc.</li><li>Experience with monitoring tech – Firebase, DynaTrace, Splunk, Google Analytics, APM, etc.</li><li>Advanced knowledge of complex software design, distributed system design, design patterns, data structures, and algorithms.</li><li>Excellent decision-making skills with the ability to balance conflicting interests in a complex and fast-paced environment.</li><li>Passion for staying current with mobile tech industry trends and emerging technologies, with a commitment to continuous learning and professional growth.</li><li>Strong collaboration and communication skills, with the ability to work effectively with cross-functional teams and stakeholders.</li></ul> Regards, Purnima PobbathyTechnical Recruiterpurnima@themesoft.comThemesoft INC.

Job Title: GCP Data ArchitectLocation: Dallas, TX(Hybrid)Duration: 6+ Months Job Description:1. 8+ years of experience in data engineering or data architecture, with at least 2 years in a GCP environment.2. Data Integration: Develop and implement ETLELT processes to ingest data from various sources into BigQuery, ensuring data quality and integrity.3. GCP Expertise: Strong knowledge of Google Cloud services, especially BigQuery, Dataflow, Cloud Storage, and PubSub.SQL4. Proficiency: Proficient in SQL and experience with optimizing complex queries in BigQuery.5. Data Modeling: Experience in data modeling techniques and best practices for data warehousing.6. IRIS: 2+ years of hands on experience in solutioning IRIS IntegrationsProgramming Skills: Proficiency in programming languages such as Python, Java, or Scala for data manipulation and automation.

Themesoft Business Intelligence Interview Guide

Overview

Themesoft Business Intelligence Salary

Themesoft Business Intelligence Interview Process

Themesoft Business Intelligence Interview Questions

Themesoft Business Intelligence Jobs