Prepare for and practice interview questions from Idexcel.

Idexcel Interview Questions

Idexcel Interview Guides

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

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

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?

Idexcel Salaries by Position

Title: Business Analyst –Commercial Real Estate (CRE), Construction Lending & Commercial LendingLocation : Herndon VA Currently seeking a Business Analyst with System Analysis expertise in the banking industry. Lending Skills & Experience Industry & solutions experience in one or more of the following segments: Commercial Lending / Leasing, Small Business Administration (SBA) Lending, Commercial Real Estate (CRE), Construction Lending & Equipment Finance. Experience with one or more of the following Competencies: Business Architecture, Business Process Mapping, Business Requirements Development / Gap Analysis, Business Strategy Development and Execution, Change Management, Digitization / Imaging, Program / Project Management (PMO), Quality Assurance, Regulatory Compliance, Risk Management, Software Development Lifecycle (SDLC) Experience, System Implementation / Integration, Testing, Training, Use Case Methodology (Waterfall, Agile) Experience with industry-leading Core Loan/Lending platforms including Fidelity, Fiserv, and/or Jack Henry desired Experience with industry-leading Commercial Loan Origination Systems (LOS) and spreading systems including nCino, Abrigo, Moody's’ creditlens, Built, Capitalstream, CreditQuest, and/or Sageworks desired Qualifications Bachelor’s degree in Engineering or equivalent experience required At least 3-5+ combined years of Financial Services industry and professional services consulting experience including Client delivery3+ years of experience in business systems analysis, configuration, or designDeep knowledge and understanding of operation workflows/processesDeep knowledge and understanding of governance and compliance expected from providing solutions in systems and technology domainsStrong functional understanding of commercial lending process a big plusStrong entrepreneurial spirit

Hello Connections ,Job Title : product Manger Location : Hyderabad, BangaloreWork mode : Work from Office (From Day one onwards ) Experience : 8+ Years Company : Idexcel TechnologiesMode of Hiring : Full time Notice Period : ( Immediate / 15 Days ) Job Description :Strong communication skills and demonstrated initiative to drive change and results in a professional setting· 2+ years of experience building and delivering successful SaaS products via a Product Management or Program Management preferred.· Some experience working across engineering and design to deliver new features that drive impact for end users· Passion for customer success and seeking a deep understanding of end-user problems as well as competitive and market trends in the construction space· Experience defining user stories, structured requirements and specifications, and managing success metrics ideal· Ability to work collaboratively across the organization with other product teams and stakeholders to collect feedback and influence

Dear Candidate, Greetings from Idexcel !! We are Hiring for Sr. Business Analyst Role for Hyderabad & Bangalore Location, Please find below attached Job Description & Qualification details, JOB Description : Idexcel is currently seeking a Senior Business Analyst with System Analysis and Configuration expertise in the banking industry. Lending Skills And Experience : Industry & solutions experience in one or more of the following segments: Commercial Lending / Leasing, Small Business Administration (SBA) Lending, Equipment Finance, Alternative Business Lending, Consumer Lending / Leasing, Mortgage / Home Equity, Commercial Banking Experience with one or more of the following Competencies: Anti-Money Laundering (AML), Business Architecture, Business Process Mapping, Business Requirements Development / Gap Analysis, Business Strategy Development and Execution, Change Management, Digitization / Imaging, Program / Project Management (PMO), Quality Assurance, Regulatory Compliance, Risk Management, Software Development Lifecycle (SDLC) Experience, System Implementation / Integration, Testing, Training, Use Case Methodology (Waterfall, Agile), Vendor Analysis / Selection. Experience with industry-leading Core Loan/Lending platforms including Fidelity, Fiserv, and/or Jack Henry desired Experience with industry-leading Commercial Loan Origination Systems (LOS) including nCino, Capitalstream, CreditQuest, WebEquity, and/or Sageworks desired Experience with industry-leading Customer Relationship Management (CRM) systems including Salesforce, Microsoft Dynamics, NetSuite, Oracle, etc. desired Experience working to support a Financial Services Firm going through a Core Conversion, and/or Ancillary System Implementations and Integration. Qualifications : Bachelor’s degree in Engineering or equivalent experience required At least 3-5+ combined years of Financial Services industry and professional services consulting experience including Client delivery 5+ years of experience in business systems analysis, configuration, or design Deep knowledge and understanding of operation workflows/processes Deep knowledge and understanding of governance and compliance expected from providing solutions in systems and technology domains Strong functional understanding of commercial lending process a big plus Salesforce experience a big plus Strong entrepreneurial spiri NOTE : If interested please share your updated CV and details to following mail id : blikhith@idexcel.com Thanks & Regards,Likhith Kalyan | Idexcel 7416893263

Job Title: Business AnalystLocation: Ridgefield Park, NJ (Onsite)Duration: 12+ Months Overview:We are seeking an experienced Business Analyst to join Digital Business Division. The successful candidate will be responsible for supporting growth initiatives services with a focus on Gen AI and CRM. This role requires strong knowledge and hands-on experience in CRM, email marketing, and/or Gen AI, as well as a track record of success in program management or business development, analyst roles.Responsibilities:Identifying new business opportunities and developing strategies and proposalsCollaborating with cross-functional teams to develop and execute go-to-market motionsCoordinate, support proof-of-concept efforts to convert to ongoing engagementsEngaging clients on regular basis to identify needs, gather requirements, manage issues Requirements:Bachelor's degree in business, marketing, analytics or related fieldAt least 2 years of working experience in CRM, marketing and/or Gen AI in business development or business analyst or other operational rolesClient facing experienceExcellent communication and presentation skills, with the ability to present findings to both technical and non-technical audiencesExperience with CRM platforms and tools such as Salesforce, Marketo, Eloqua, Adobe Campaign, etc.Knowledge of Gen AI technologies and their applications in the digital landscape is a plusAbility to work collaboratively in a fast-paced, dynamic environmentProven track record of driving results and contributing to business growth.

Job Title: Data Engineer (Pyspark)Location: McLean, VA / Richmond, VA / Plano, TX/Chicago, Il (only locals)Duration: Contract Work is Python to Pyspark migration Top Skills:Python, Pyspark, SQL, AWS, Snowflake, Data Bricks, ETL, Kafka, Unix (Command/Shell Script) and ETL/DWH concepts

Sr Data EngineerLocation: McLean, VA and plano, TxDuration: Long term Basic Qualifications:Bachelor's DegreeAt least 6 years of software development experienceAt least 2 years of experience in Spark and ,Python AND Pyspark And scalaAt least 2 years of experience in AWS Cloud technologies: AWS

Idexcel Interview Questions

Idexcel Interview Guides

Idexcel Interview Questions

Idexcel Salaries by Position

Idexcel Opening Jobs