Prepare for and practice interview questions from Bcforward.

Bcforward Interview Questions

Bcforward Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Statistics

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?

The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.

<ul>
<li>The attribution table logs a session visit for each row.</li>

<li>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</li>

<li>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</li>

<li>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</li>
</ul>

First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.

Calculate the first touch attribution for each <code>user_id</code> that converted. 

Example:

Input:

<code>attribution</code> table

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

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

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<code>user_sessions</code> table

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Example output:

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>

First Touch Attribution

*Presently we are unable to sponsor and request applicants to apply who are authorized to work without sponsorship* Below are the few details of the opportunity.Job Title: Amazon Connect EngineerLocation: Plano, TX 75024 - onsiteDuration: Contract to Hire Skills Required:<ul><li>Looking for a true Engineer</li><li>Hands-on experience with Terraform</li><li>Hands-on experience with Amazon Connect</li><li>Responsible for IVR flows and CI/CD pipelines</li><li>Knowledge of ServiceNow for integration will be great plus.</li><li>IAC, Terraform and Python are must haves</li><li>Experience with and Contact Center is required</li></ul>

Java + AWS Senior Engineer: This position requires 8+ years of strong experience in Java development, AWS cloud services, and microservices architecture. The role emphasizes designing scalable, performant, and cost-effective systems, along with leadership and technical mentoring responsibilities. 1. Java + Microservices (8+ years)<ul><li>Advanced Java development</li><li>Strong microservices architecture experience</li><li>Deep understanding of OOP, design patterns, architectural principles</li></ul>2. Strong AWS ExpertiseMust have hands-on experience specifically with:<ul><li>AWS ECS Fargate</li><li>API Gateway</li><li> Plus broader AWS service usage</li></ul>3. Solution Design & Architecture<ul><li>Scalable, high-performance system design</li><li>Cost optimization</li><li>Maintainability & reliability experience</li></ul>4. Technical Leadership<ul><li>Mentoring junior team members</li><li>Providing architectural & technical guidance</li><li>Strong communication skills</li></ul>5. Formal Computer Science background<ul><li>Certification or formal training</li><li>5+ years applied CS</li></ul>

*Presently we are unable to sponsor and request applicants to apply who are authorized to work without sponsorship* Below are the few details of the opportunity. Job Title: Core Java / Software EngineerLocation(s): Jersey City, NJ 07310 – on-siteDuration: Contract to Hire Skills:<ul><li>Formal training or certification on software engineering concepts and 5+ years’ applied experience </li><li>Hands-on practical experience in system design, application development, testing, and operational stability </li><li>Experience with Core Java, collections, Exception Handling, Generics & Multithreading, Spring boot, JavaScript </li><li>Strong understanding of data, data modeling and database methodologies and architecture disciplines </li><li>Advanced SQL and data management knowledge </li><li>Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages </li><li>Overall knowledge of the Software Development Life Cycle </li><li>Solid understanding of agile methodologies such as CI/CD, Applicant Resiliency, and Security </li><li>Demonstrated knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)</li></ul>

Job Title: Business AnalystDuration: 6 months with possibility to extension. Key Focus: Pharmaceutical Domain 5+ years and Data and commercials Analytics areas Overview : As a Business Analyst, you will play a pivotal role in bridging the gap between business needs and technical solutions within the life sciences commercial domain, specifically in the data analytics space. Your responsibilities will include analyzing and translating complex business requirements into actionable technical tasks for offshore teams, ensuring seamless integration of business models with technology solutions. Must Have Skills: 1. Domain Expertise: Demonstrate advanced proficiency in the Pharmaceutical domain, with a strong focus on data analytics and business processes. Leverage your expertise to assess business models and their integration with technology.2. LS commercial Data on 852, 857 datasets - 852 – Product Activity Data:This EDI (Electronic Data Interchange) transaction set provides detailed product activity information such as inventory levels, sales, and demand data. It’s typically sent from a retailer or distributor to a manufacturer or supplier to give visibility into product movement and stock levels. Key fields include:On-hand inventoryShipments and receiptsSales or usage by locationForecasted demand857 – Shipment and Billing Notice:This dataset (EDI 857) combines the functionality of a ship notice (ASN, 856) and an invoice (810). It communicates both shipment details and billing information in a single document. Used commonly in retail and logistics to streamline reconciliation and payment processes.Data Kitchen experience3. Requirements Analysis: Exhibit expert proficiency in gathering, synthesizing, and analyzing business requirements. Break down business tasks into technical terms and translate them into clear, actionable deliverables for offshore teams.4. Collaboration and Coordination: Collaborate effectively with Business Relationship Managers (BRMs), business stakeholders, vendors, and internal Accenture teams. Facilitate communication and alignment across diverse teams to drive key decisions and ensure project success.5. Stakeholder Engagement: Build strong relationships with client stakeholders and vendors, acting as a trusted advisor to guide discussions and decisions in the commercial area.6. Technical Translation: Translate business requirements into technical specifications, ensuring offshore teams have a clear understanding of deliverables and priorities.7. Business Process Analysis: Utilize advanced proficiency in business process analysis tools to identify opportunities for optimization and innovation within the commercial domain.8. Proficient in SQL Nice to Have Skills: 8. Technical Expertise: Demonstrate proficiency in 1. ETL/ Database2. AWS3. Red Shift4. Tableau Basic 5. Fivetran (Optional)6. Shellscript (Python, UNIX) (Optional) Detailed Role and Responsibilities : Roles:• Requirements Gathering:• Collect and document business requirements related to data analytics.• Ensure alignment with business objectives.• Data Interpretation:• Analyze data sets to inform technical design and decision-making.• Collaborate with data engineers to meet business needs.• Stakeholder Communication:• Act as a liaison between technical teams and non-technical stakeholders.• Facilitate alignment across teams.• Process Improvement:• Identify and recommend enhancements to business processes through data analytics. Responsibilities:• Analyzing Business Needs:• Translate business objectives into actionable data requirements.• Ensure solutions align with business goals.• Data Quality Assurance:• Ensure data accuracy and reliability for analysis.• Implement data quality standards.• Creating Documentation:• Develop user stories, use cases, and process documentation.• Maintain clear project records.• Testing and Validation:• Collaborate with QA teams to test and validate analytics solutions.• Ensure solutions are user-friendly and scalable.• Training and Support:• Provide training and support on analytics tools and insights.• Empower stakeholders to leverage data solutions.• Continuous Improvement:• Monitor project outcomes and recommend enhancements.• Stay updated on industry trends.• Collaboration:• Work closely with data engineers to align technical solutions with business needs.

*Presently we are unable to sponsor and request applicants to apply who are authorized to work without sponsorship* Position: Data EngineerLocation: Houston, TX & Wilmington, DEDuration: Contract to hire Looking for someone with Proficiency in languages Scala or Python, Platform Databricks or AWS framework (EMR Spark), and strong SQL skills & Terraform development. Position Description:<ul><li>5-7 + Years of experience in Data Engineering</li></ul> Must Have –<ul><li>Proficiency in languages Scala or Python </li><li>Platform Databricks or AWS framework (EMR Spark), </li><li>Strong SQL skills & Terraform development.</li></ul>

Minimum qualifications3+ years work experience with C/C++/C#3+ years work experience in AOSP development2+ years experience with Java (or Kotlin)Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience Preferred qualifications2+ years experience developing software for games, autonomous vehicles, robotics or other high performance real-time environmentsExperience with high-bandwidth communicationExperience with camera integrationExperience with low level firmware and RTOS

Software Engineer - Java BackendRequired qualifications, capabilities, and skills<ul><li>4-6 years of Hands-on practical experience in system design, application development, testing and operational stability</li><li>Proficient in coding in Java.</li><li>Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages</li><li>Overall knowledge of the Software Development Life Cycle</li><li>Understanding of agile methodologies such as CI/CD, Application Resiliency, and Security</li><li>Knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)</li></ul>Preferred qualifications, capabilities, and skills<ul><li>Familiarity with modern front-end technologies</li><li>Exposure to cloud technologies</li></ul>

6+ years of overall experience with minimum of 3 years as a Technical Product Manager with good understanding of architecture and technology- Good understanding of CI/CD, DevOps ecosystem, CDN and related technologies- Experience with deploying and managing services in public cloud such as AWS.- Good understanding of application development practices and methods- Understanding the infrastructure and application design to plan performance tests accordingly- Familiar and comfortable with agile/scrum development methodologies- Ability to communicate effectively with business as well as technical audiences. Able to write clear and concise documentation, excellent written and spoken communication skills

Required Qualifications, Capabilities, and Skills<ul><li>Strong hands-on experience in system design, application development, testing, and ensuring operational stability</li><li>Proficiency in Java programming</li><li>Experience in debugging, developing, and maintaining applications in large enterprise environments</li><li>Solid understanding of the Software Development Life Cycle (SDLC)</li><li>Familiarity with Agile methodologies, including CI/CD, application resiliency, and security best practices</li><li>Broad knowledge of modern software technologies such as cloud, AI/ML, or mobile platforms</li></ul>Preferred Qualifications, Capabilities, and Skills<ul><li>Knowledge of modern front-end technologies (e.g., React, Angular, or similar)</li><li>Exposure to cloud platforms and deployment models</li></ul>Nice to Have / Bonus Skills:<ul><li>Experience with AWS, Cassandra, Kafka, REST APIs, Terraform, Spring Boot, JMeter, LoadRunner, or Dynatrace</li></ul>

Greetings from BCforward, We have an immediate hiring for Java DeveloperExp: 4-12 YearsSkills: Java, Spring boot, MicroservicesRequired qualifications, capabilities, and skillsHands-on practical experience in system design, application development, testing and operational stabilityProficient in coding in Java languagesExperience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languagesOverall knowledge of the Software Development Life CycleUnderstanding of agile methodologies such as CI/CD, Application Resiliency, and SecurityKnowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)Preferred qualifications, capabilities, and skillsFamiliarity with modern front-end technologiesExposure to cloud technologiesType: Contract to HireMode: 5 days WFO, MumbaiNotice: Immediate / ServingNote: Coding test will be assignedIf interested for C2H role, please share resume on shraddha.r@bcforward.com Thanks,Rajput ShraddhaTalent Acquisition Specialist<a>http://www.bcforward.com</a>Sattva Knowledge Park, Raidurg, Hyderabad

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

Bcforward Interview Questions

Bcforward Interview Guides

Bcforward Interview Questions

Bcforward Opening Jobs