Prepare for and practice interview questions from Lancesoft, Inc..

Lancesoft, Inc. Interview Questions

Lancesoft, Inc. Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

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?

Lancesoft, Inc. Salaries by Position

Title: Principal Software EngineerLocation: Phoenix AZ USA 85027 HYBRIDDuration: 6 months with possible extension based on project need Shift: Day 8-5, Hybrid schedule - 3 onsite and 2 remote per week. Prescreen Questions1. Can you describe your experience with embedded C++ development, particularly in systems like TCAS, ACAS, or ADS-B? 2. What is your experience with real-time embedded software engineering and standards such as ARINC 429, ARINC 735, and RTCA DO-178C? Designs, modifies, develops, writes and implements software programming applications/operating systems. Also, coordinates work teams. Provides technical leadership to project team members. Requires a bachelor's degree in area of specialty and at least 8+ years of experience in the field or in a related area. Demonstrates expertise in a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. May provide consultation on complex projects and is considered to be the top level contributor/specialist. A wide degree of creativity and latitude is expected. May report to an executive or a manager. Key Responsibilities • Technical lead for designing, developing, and integrating the TXD software that interfaces with the RF hardware. • Provide support for the software that interfaces with the RF hardware on legacy TCAS products such as TPA-100 and AESU. • Requirements and design • Software architecture and coding • Integration • Certification • Test • Customer Support • Ability to code in multiple languages • Analytical skills & software development skills REQUIRED EXPERIENCE:TCAS (Traffic Collision Avoidance System)ACAS (Airborne Collision Avoidance System)ADS-B (Automatic Dependent Surveillance – Broadcast)Extensive Transponder experience DESIRABLE EXPERIENCE: Real-Time Embedded Software Engineer (C/C++) ARINC 429 (A429) ARINC 735 (A735) ARINC 718 (A718) RTCA DO-178C Structured software development environment, Requirements, Code, Integration Test DOORS – Requirements development XPDR (Transponder) Mode-C/Mode-S RTCA DO-185 RTCA DO-181 RTCA DO-260 DO-300 TSO-C112 TSO-C119 TSO-C195 TSO-C166 Surveillance Avionics

Client- BNY MELLON Tital- Technology - IT Asset Analyst or Data Analyst Location- Onsite 2-3 days per week in either Pennington, NJ or Pittsburgh, PA Job Description: •2 roles (all activity will take place on this request) •Not a traditional SDLC BA role... an IT asset analyst or data analyst would be a better fit •Candidate must have a general understanding of technology •Strong Excel experience is required (Pivot Tables and VLOOKUPs) •Cloud access security broker (CASB) or Microsoft Defender for Cloud Apps •Strong SQL query skills are preferred •Receiving and ability to explain the reporting •1-2 rounds of interviews •HM is open to contract-only candidates... team cannot promise an extension into 2025 •Onsite 2-3 days per week in either Pennington, NJ or Pittsburgh, PA...

Hiring Data Engineer in Hartford CT. Below is the detailed job description: Job #: 24-112815 Position Title: Data Engineer Position Type: Full time Location: Hartford, CT Onsite Flexibility: Onsite Duration: 09/16/2024 to 12/31/2024 Pay Range: $67 -$78 Hourly Job Description: Strong proficiency in Java, with a focus on data applications. Experience with Kubernetes for container orchestration and management. Proficient in using Bazel for build automation and testing. Hands-on experience with Google Cloud Platform (GCP) services and tools. Experience in identifying, analyzing, and mitigating technical risks in data infrastructure. Understanding of security best practices and compliance requirements in data management. Experience with other cloud platforms (e.g., AWS, Azure). Knowledge of CI/CD pipelines and related tools (e.g., Jenkins, GitLab). Familiarity with microservices architecture and related technologies.

JOB DESCRIPTION Position: Senior Software Engineer- Salesforce Developer Profile: Senior Salesforce developer within complex and highly configured sales & service cloud instances (1000+ users) w/a variety of Integration patterns (cross-objects and across both sales and service features). Selected candidate will be a critical thinker with a problem-solving demeanor (eager to learn - solve). Technology NO Awareness of technology (0) LITTLE Awareness - read/heard of technology (1) EXPOSURE to technology in environment (2) SOME development in technology (3) Very COMFORTABLE developing in technology (4) EXPERTISE in technology i.e. could teach a class (5) Salesforce / Salesforce API X Salesforce Commerce Cloud X Aura, X Lightning Web Components X Apex X Visualforce X Process Builder X Flows X Cloudwatch X AWS Services X Gearset X Summary The Senior Software Engineer- Salesforce.com Developer is responsible for the design, configuration and development of the ***'s Saleforce.com Sales and Service Clouds and other CRM related applications/tools within the ***'s Corporate Systems Technology organization. The successful candidate will be a seasoned Salesforce.com software engineer with knowledge and experience in designing, building, testing, and documenting complex, highly scalable, and dependable capabilities and integrations on the Salesforce.com platform. The candidate will interact closely with project teams, scrum masters, other software engineers, business analysts, and test engineers to shape, identify, prioritize, and realize capability requirements in the delivery of business solutions. Successful candidates will have a comprehensive knowledge of Salesforce.com development tools, technologies, practices, and standards; proven ability to integrate large scale systems or third-party products; and a track record of delivering high-quality, solutions in a timely and effective manner. Responsibilities Builds, tests, deploys, and maintains production Salesforces.com capabilities using Aura, Lightning Web Components, Apex, Visualforce, Salesforce API, Process Builder, and other Salesforce technologies. Provides maintenance and enhancements for Salesforce B2B commerce sites. Follows established coding standards and other group procedures, both individually and at a team level. Must ensure proper code reviews are held for the assigned work. Contributes to the engineering team's culture of high code quality. Accountable for the quality of code that is delivered to QA and production and must ensure that appropriate code reviews and unit testing are adequately performed. Ensures that continuous integration is performed on the application source code and constantly seeks to enhance the continuous integration methods of the development team to ensure extremely high quality of code. Works closely with project and business team to thoroughly understand the system requirements and ensure they are properly implemented. Also, must seek ways to meet the underlying business requirements with low-cost, yet highly re-usable patterns and actively escalate requirements that may cause unnecessary risk or cost. Experience and in-depth knowledge of cloud-based infrastructure components Expert-level Object Oriented knowledge, with demonstrated complex implementations a must, e.g., custom API's, optimization techniques, and design patterns. Ensure that application code adheres to enterprise and industry standards and best practices, including performance and security standards. Gather feedback from design and technical staff on application development needs and patterns. Must be able to work with Enterprise Architecture group to propose and solicit approval of new architectural patterns including documentation and presentation of the architectural approach, benefits/limitations, and other considerations (e.g., re-usability, security, performance, maintainability, etc.). Responsible for support of and coordinating with other Engineers, Architects and teams including other technology teams such as a User Experience team or an infrastructure team. Assists scrum master in project planning and estimating of project score items. Reports hours daily to administration for billing purposes. Provide Tier 2 application support and support projects as needed. Qualifications Education Bachelor's degree required. At least 8 years of directly related work experience in a professional position in software development or a related field. Additional Requirements At least 7 years development experience, Salesforce.com Expert-level understanding of the Salesforce.com programming language, related optimization techniques, and design patterns including Lightning Web components. Must have strong knowledge in one or more of the following: Apex, Aura, Lightning Web Components, HTML, JavaScript, Preferred Experience with Salesforce Commerce Cloud. Experience using with Gearset. Preferred experience with AWS Services like Lambda, SNS/SQS, S3, IAM, CloudWatch, RDS & Fluency with CI/CD toolsets such as: CloudFormation, Bitbucket, Jenkins, Ansible a plus Experience or knowledge in deployment of cloud-based applications using AWS strongly preferred. Test-driven development and continuous integration experience is highly preferred. Experience working in an iterative DevOps environment (familiarity with Agile/Scrum required) Experience in adhering to software development guidelines and in performing code and design reviews. Effective communication skills are a must along with a strong customer orientation, and the ability to clearly discern client needs. Ability to effectively coordinate multiple responsibilities simultaneously, with fast, flexible work style. Knowledge of K-12 or Higher Education related software applications is a plus.

Job Description: Client is looking for several experienced Business Analysts to help drive requirements on high-visibility IT projects within the client and will interact with our growing team of 35 PMs and BAs, as well as various departments within the client. Essential Functions: Facilitate discussions with various City of Phoenix Department personnel to document requirements and specifications, including intended outcomes, features, and functionality. Develop and document functional specifications associated with system enhancements. Ensure clarity of documented requirements to prevent scope creep, gold plating, or non-value-added activities. Document business requirements according to industry best practices and City of Phoenix PMO processes. Document functional workflow diagrams to capture business goals and high-level scope. Demonstrate superior customer service, integrity, and commitment to innovation, efficiency, and fiscally responsible activity. Qualifications: Prior successful experience as a Business Analyst, with prior IT experience and knowledge of the software lifecycle (waterfall and/or agile). Ability to develop requirements based on professional standards (i.e., PMI or similar). Four-year degree or equivalent education in Information Technology, or related field, with minimum five years' experience as a business analyst working on IT projects. Ability to coordinate with cross-functional teams to ensure project alignment with business objectives and industry best practices. Ideal candidate has a blend of technical expertise, leadership, and business analysis skills. Professional and current certification in PMI is a PLUS (PMP, Agile, and/or similar certification).

Location: Montreal, QC (Onsite)<ul><li>As a Senior Embedded Software Developer, you will be required to design, develop and maintain firmware covering our various embedded system applications and this includes network protocols, core libraries as well as application development.</li><li>You will play a key role in defining systems architecture and mentoring junior developers.</li><li>You will design, implement, and test firmware to form optimal communications wireless networks using the extremely low power wireless transceivers developed by us.</li><li>This includes developing low power wireless sensor networks in point-to-point, star, and mesh configurations, as well as efficient point-to-point links for audio streaming applications.</li><li>The selected candidate will be responsible for developing efficient firmware to support these applications, as well as a graphical user interface for each system that allows users to control the flow of information in the wireless system.</li></ul>Your Responsibilities as a Senior Embedded Software Developer<ul><li>Design, implement, test and document embedded and application software.</li><li>Develop algorithms for communication system protocol layers and networking.</li><li>Provide architectural and detailed designs to meet the system requirements.</li><li>Provide technical direction and strategy to engineering development efforts for solving complex issues.</li><li>Outline and communicates the most appropriate technical approach for business development activities.</li><li>Maintain system software components including device drivers and applications.</li><li>Participate in the team’s testing processes by developing protocols for unit testing, integration/regression testing, and system-level testing.</li><li>Coach and mentor more junior Engineers.</li></ul>Your Qualifications:<ul><li>Bachelor in Electrical Engineering, Computer Engineering or equivalent.</li><li>10+ years of experience in embedded application development in C and C++.</li><li>7+ years of experience in low level C programming on microcontrollers / microprocessors, with advanced knowledge of MCU / CPU architectures and ecosystems.</li><li>Full-stack system-level understanding and ability to comprehend and affect an improvement to multi-disciplinary processes of RF/PHY/L1/L2.</li><li>Good understanding and debug capabilities of a mixed HW/FW multi-processor PHY/L1 implementation.</li><li>Proven grasp of complex wireless systems with strong capability to comprehend dependencies between system components and protocol layers and their interactions.</li><li>Extensive hands-on SW programming skills for modelling and simulation of sophisticated systems from RF/PHY layer signals and channel modelling. All the way to MAC protocol/networking simulations; corresponding proficiency with Matlab required.</li><li>Experience with and/or knowledge of industry standards such as Bluetooth, Ultra-Wideband, GPS, and/or other wireless protocols.</li><li>Ability to work efficiently with both Linux and Windows.</li><li>Experience with Visual Studio Code and Eclipse IDE.</li><li>Experience developing Board Support Packages, boot loaders, and component drivers.</li><li>Experience with virtualization and container technologies (VMware, KVM, Docker).</li><li>Experience with Git version control systems.</li><li>Experience with software development platform such as Gitlab and GitHub.</li><li>Understanding of communication protocols including I2C, SPI, UART and USB.</li><li>Experience in hands-on development and debug on embedded targets using in-circuit debuggers and electronic test equipment (oscilloscope, multimeter, logic analyser, etc).</li><li>Experience in modern software development processes (peer reviewing, unit testing, etc).</li><li>Familiar with networking architectures.</li><li>This role requires to work regularly with co-workers, subcontractors and customers located globally.</li><li>Ability to multi-task, set project priorities, establish task focused goals and objectives for self and show initiative.</li><li>Write clean, understandable, robust, and sustainable code tailored for embedded systems.</li></ul>

Enter Job Description...Senior Business Analysis - Partner with stakeholders and development teams to help elicit, analyze, and document business requirements and facilitate translation into technical requirements. Support the Program Managers with implementation projects in collaboration with vendor partner teams and business stakeholders. Effectively communicate requirements conflicts to project leads, assist with conflict resolution. Ensure that requirements are understood and approved by all stakeholders. Manage requirement traceability and changes throughout the project lifecycle. Ensure the test strategy and test plans adequately cover the requirements. Assist in defect resolution.Qualifications: 1. Minimum of 5 years of Business Analysis experience 2. Required experience: o Implementing and working with Salesforce Solutions o Utilizing a SAFe Agile framework o Working with vendor consultants Good experience in implementing continuous integration and continuous delivery (CI/CD), preferably Worked in a Salesforce implementation project. Experience in creating documents, such as Business Requirement Documents, Software Requirement Documents, Process workflows, RAIDQs, Project Plans, User guides/Training materials among others. Work with stakeholders to prioritize requirements effectively based on business value, risks and constraints. Understand the Project Management methodologies and practices to be able to work closely with a Program Manager and seamlessly move into the PM role on occasion. Experience with evaluating project risks and issues and assisting Program Manager/Portfolio Manager with prioritization and development of mitigation or resolution strategies. Ability to develop strong client/vendor relationships and develop strategies and solutions of high business value. Ability to apply business analysis experience and project management knowledge to real world scenarios. Agile Project Methodology and JIRA knowledge preferred. Experience in facilitating requirement analysis sessions with large and diverse stakeholder groups through requirements meetings, workshops, JAD sessions etc. Possess the ability to read, analyze and interpret general business documents and governmental regulations; to write clear and legible documents, business correspondence and meeting notes; create presentations to effectively convey information and respond to questions from managers, employees, vendors, and governmental agencies. Experience with analyzing inefficient business processes (manual entry, old technology, migrations, etc.) and working with business stakeholders and IT partners to create requirements for effective automated solutions. Experience in creating visual diagrams of the system by UML (Use case, Activity, Business Process Diagrams), and creating web page mock-ups. Proficient with MS Office; including Word, Excel, PowerPoint, Outlook, and Visio. Maintain confidentiality and able to work with all levels of employees in the organization. Bachelor's Degree or higher in Computer Science, Computer Engineering, Information Technology, or similar preferred Business Analyst Certification Preferred Salesforce Certification PreferredEEO EmployerLanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.

Title : Senior Business Analyst Location : El Segundo, CADuration : 9 months contractPay Range : $60.00 - $90.00 USD hourly on W2.Responsibility•ERP Business analyst (CW) will be part of Global ERP Business process owner team.•Ability to represent ERP BPO team in the site specific or Global ERP projects including Product launches, commercial expansion, Tech transfers, Plant Expansions, Clinical projects, System (ERP)enhancements or any other Tech- Ops projects or enhancement requested by the leadership.•Work directly with Kite business to gather business requirements and follow the Enhancement process to deliver the enhancements to the business.•Responsible for planning the user acceptance testing, organizing the user acceptance testing, and approving the user acceptance results.•Experienced with End-to-End Business Process and System process. (Order to Cash, Plan to Deliver)•Work directly with Change Owners to ensure changes are documented appropriately.•Work with IT to ensure system enhancement requests are developed and functional testing results as per the requirement. If required, responsible to provide the testing scenarios to the IT technical team.•Work with Quality Engineering to ensure all validation processes are followed for the system changes (enhancement/projects)•Accountable for Writing work instructions and performing periodic reviews of the work Instructions and update the WRK as required.•Represent BPO in the change control socialization meetings and provide Impact assessment for ERP Business system.•Work collaboratively and independently with Business Process Owners (BPO), IT, and Global business users from other departments.•Other miscellaneous duties as assigned by leadership.

Job Title: Business Analyst Job Description: <ul> <li>A Mid-level Business Analyst typically plays a key role in analyzing and documenting business processes and requirements for projects within an organization. Responsibilities may include:</li> <li>Gathering and documenting business requirements from stakeholders.</li> <li>Analyzing and documenting current business processes and workflows.</li> <li>Developing and maintaining business process models and documentation.</li> <li>Developing functional and technical specifications for system enhancements or new systems.</li> <li>Facilitating meetings and workshops to gather requirements and provide updates on project progress.</li> <li>Identifying and documenting project risks and issues.</li> <li>Collaborating with stakeholders to prioritize requirements and define project scope.</li> <li>Supporting the development and testing of new systems or enhancements.</li> <li>Providing training and support to users during system implementation and post-implementation.</li> <li>Participating in the evaluation and selection of software and systems.</li> <li>A Mid-level Business Analyst should have strong analytical, problem-solving, and communication skills. They should be able to work effectively with stakeholders at all levels of the organization. </li></ul> Location: Baltimore, MD (Onsite) Compensation: $50.00 - $52.00 per hour on W2. Benefits: At LanceSoft, full time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits: •Four options of medical Insurance •Dental and Vision Insurance •401k Contributions •Critical Illness Insurance •Voluntary Permanent Life Insurance •ccident Insurance •Other Employee Perks About LanceSoft LanceSoft is rated as one of the largest staffing firms in the US by SIA. Our mission is to establish global cross-culture human connections that further the careers of our employees and strengthen the businesses of our clients. We are driven to use the power of our global network to connect businesses with the right people, and people with the right businesses without bias. We provide Global Workforce Solutions with a human touch Equal Opportunity Statement: LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.

Hybrid Schedule-3 days a week The ideal candidate is expected to be a strong hands-on developer who can take ownership of projects. It's expected that they demonstrate a thorough and detailed approach with the ability to identify appropriate user/business solutions and have proven track record of working as part of a team to deliver software solutions to meet customer needs. Candidate does not need to have knowledge of Fixed Income but should demonstrate a desire and aptitude to learn the asset class. The current team is global, concentrated in Montreal, New York and India. Skills Required:<ul><li>7+ years experience in Java, Scala experience is preferred</li><li>Strong in Java, Spring frameworks, JDBC</li><li>Experience developing REST services deployed over Tomcat/Jetty/CXF</li><li>Experience in Spring boot, Microservices, Spring frameworks</li><li>OO fundamentals, design patterns, data structures and algorithms</li><li>Knowledge of SQL, relational databases and stored procedures.</li><li>Experience in databases such as MSSQL Server/Sybase </li><li>Experience in caching - Elastic Search, HazelCast or Redis</li><li>Bachelor’s or Master’s Degree in Computer Science or related field</li><li>Strong written and verbal communication skills</li></ul> Skills Desired: <ul><li>Scripting experience</li><li>A passion for Dev Ops and improving team efficiency</li><li>Familiarity with Agile development practices</li><li>Experience working with No sql databases such as Mongodb</li><li>Experience working with Apache Kafka, Spark, Streaming</li><li>Experience with both Angular and React</li></ul> Skills Proficiency: Intermediate to senior

Lancesoft, Inc. Interview Questions

Lancesoft, Inc. Interview Guides

Lancesoft, Inc. Interview Questions

Lancesoft, Inc. Salaries by Position

Lancesoft, Inc. Opening Jobs