Prepare for and practice interview questions from Intellect Design Arena Ltd.

Intellect Design Arena Ltd Interview Questions

Intellect Design Arena Ltd 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

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?

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

Intellect Design Arena Ltd Salaries by Position

EXPERIENCE5+ years of relevant experience as a Business Analyst in a bank or FinTech in the Payments DomainCORE RESPONSIBILITIES1. Understand and review the business requirements and articulate the same into detailed functionalspecifications, business scenarios and process flows2. Liaise directly with business users from the bank and be responsible for end-to-end delivery ofthe solution scope3. Lead the Business Analyst stream for the project and provide support during various phases offunctional testing. Participate in defect triage, root-cause analysis and query resolution4. Showcase the product and impart training to project stakeholders5. Review design and testing deliverables to ensure completeness of requirementsPREFERRED SKILLSPAYMENTS DOMAIN – MUST HAVE1. Proven experience in end-to-end processing (outward and inward) of electronic payments(domestic and international) across various country/region specific payment schemes – (preferred: US, Canada OR Europe) for any of the below:a. High-value paymentsb. Low-value batch paymentsc. Real-Time / Instant paymentsd. Requests-to-Pay2. Proven product experience of having worked for at least 1 year on any of the below processingcomponentsa. Payment Initiation Channel - Internet, Mobile, API, Host-to-Hostb. Payment Processing - Pre-processor HUB, Payment Engine / Gateway3. Working knowledge of industry standard payment file / message formatsa. SWIFT MT - 1xx, 2xx, 9xxb. ISO20022 / SWIFT MX - pain.xxx, pacs.xxx, camt.xxx, remt.xxxc. Payment rail specific clearing formats BUSINESS ANALYSIS – MUST HAVE1. Experience ina. functional requirement elicitation and solution designb. documenting use cases/business requirements (BRD), user stories/functionalspecifications (FSD,FRD), process flow diagrams, interface mapping, UI wireframesc. product fitment, gap analysis, requirement traceabilityd. reviewing testcase scenarios2. Experience of working in a complete SDLC - Waterfall and/or Agile models3. Proven client interaction and direct participation in client requirement gathering, elicitation,functional solution design and defect triageSOFT SKILLS – MUST HAVE1. Excellent oral and written communication in English and good presentation/training skills2. Proficiency in Microsoft Office tools – Word, Excel, PowerPointOPTIONAL SKILLS – GOOD to HAVE1. Understanding of core banking systems and Basic technical knowledge of database, APIs, MQ2. Any industry-recognized BA certifications

POSITION: Salesforce Business AnalystEXPERIENCE (IN YEARS): 2-5 YearsLOCATION: Pune/Mumbai/Gurgaon/Chennai/Hyderabad ABOUT INTELLECT DESIGN ARENA LTD:Intellect Design Arena Limited is a global leader in Financial Technology for Banking, Insurance, and other Financial Services. With a rich suite of products across the organization, backed with over 30 years of deep domain expertise, we are an authority on vertical and integrated products that enable institutions to meet their ambition to be the principal service provider to their customers. Our commitment is to take banking into the future, anticipating and solving the needs of tomorrow’s businesses. WHAT WE DO:We create financial technologies that help banks lead businesses on the path to growth and success. Our solutions help move the banking world forward; because that’s what happens when the world knows it has financial institutions they can rely on. This is the philosophy that we at Intellect follow and our commitment to our customers’ success.A uniquely focused Products business, over $200 million Intellect Design Arena group has the soul of an agile start-up, with the maturity of an established specialist in designing advanced technology products for global financial platforms across Global Transaction Banking (GTB), Global Consumer Banking (GCB), Risk, Treasury & Markets (RTM), Insurance (Intellect SEEC) and e-Governance (GeM). OUR ACHIEVEMENTS:We are the world's No.1 Fintech company recognized by the global survey of IBS. We provide full spectrum, fully integrated products that run in over 250 financial institutions, across 90+ countries. With over 4500 solution architects, and domain and technology specialists, backed with over 30 years of deep domain expertise, Intellect is the brand on which progressive financial institutions rely on for transformation initiatives.Our aggressively customer-centric design philosophy has enabled the engineering of agile and holistic digital solutions, with full lifecycle enablement and industry-leading performance assurances.Explore more about us at: <a>www.intellectdesign.com</a> WHAT INTELLECT OFFERS YOU:FT 8012, the World’s First FinTech Design Center for Financial Institutions, Has a rich and truly diverse work environment that is bustling with creative energy and individual perspectives from 29 nationalities and 30 languages.LIVE YOUR DREAM - Intellect is India's most profitable unicorn. A pioneer in design thinking, it has helped shape the future of fintech with passion, and cutting-edge products. JOB DESCRIPTION: 1. Gather and document business requirements through stakeholder interviews, workshops and surveys.2. Analyze business processes and identify opportunities for improvement.3. Design and propose Salesforce solutions to meet business requirements.4. Configure and customize Salesforce applications, including workflows, approvals, and dashboards.5. Develop and maintain data management processes and data quality standards.6. Collaborate with stakeholders to ensure solutions meet business needs.7. Conduct training sessions for end-users.8. Provide ongoing support and maintenance for Salesforce applications.9. Stay up-to-date with Salesforce best practices and new features.10. Manage multiple projects simultaneously.

Greetings from Intellect Design Arena! Position : Senior Business Analyst (Transaction Banking, preferably Channel Banking (Online/Mobile Banking)Experience: 8- 18 YearsLocation: Chennai (Siruseri)- WFODomain: Banking and Fintech About Intellect: Intellect Design Arena Ltd is an enterprise-grade financial technology leader, providing composable and intelligent solutions for futuristic global financial institutions across 57 countries. Intellect’s revolutionary First Principles Thinking-based Enterprise Connected Intelligence Platform, eMACH.ai, is the most comprehensive, composable, and intelligent open finance platform in the world. With an impressive array of 329 microservices, 535 events, and over 1757 APIs, eMACH.ai enables financial institutions to design and deploy future-ready technology solutions that provide a significant global competitive edge. With three decades of domain expertise, Intellect offers a full spectrum of banking and insurance technology products through four lines of business: Global Consumer Banking (iGCB), Global Transaction Banking (iGTB), IntellectAI and Digital Technology for Commerce (iDTC). Intellect is a pioneer in applying Design Thinking and our 8012 FinTech Design Center, the world's first Design Center dedicated to Design Thinking Principles, underscores our commitment to continuous and impactful innovation, addressing the ever-growing need for digital transformation. We proudly serve over 325+ customers worldwide, supported by a diverse workforce of solution architects and domain and technology experts in major global financial hubs. For more information about Intellect, visit <a>https://www.intellectdesign.com/</a> Roles and Responsibilities <ol><li>Experience working in Banking/Financial Domain especially Transaction Banking and preferably Channel Banking (Online/Mobile Banking)</li><li>Domain Expertise in any of the verticals for payments, Collections, Trade Finance and supply chain finance operations</li><li>Good Design, Analysis, Documentation, Interpersonal and Communication skills.</li><li>Analyze business requirements, understand the application Architecture/specifications and ability to design solutions including logical Interfaces </li><li>Experience in writing User Stories and Interface specifications</li><li>Thorough understanding of software development lifecycle and methodologies especially Agile</li><li>Strong Verbal and written communication skills, should be able to work in a global development environment including support Pre-sales activities such as Product Demo, Responding to RFPs</li><li>Familiar with Tools such as JIRA and Confluence</li><li>Acts as a liaison between the Product Management and Product development group for the enhancement and creation of business features</li><li>Lead the business analysis team for the product / implementation and guide / mentor / support the team for BAU activities, functional & Integration testing, review solution design (functional / integration) having impact across multiple systems</li></ol> Domain specific Attributes / Experience: Payments > <ol><li>Hands-on experience in End-to-end processing of Outward / Inward Payments</li><li>Product / Implementation experience for at least 5 – 6 years for</li><li>Payment Initiation Channels (Internet / Mobile / API Banking / Host-to-Host)</li><li>Payment Processing (Pre-Processor HUB, Payment Engine / Payment Gateway)</li><li>Hands-on experience in Industry standard Payment file / Message formats for SWIFT MT, ISO 20022 / MX and payment rail specific clearing file formats</li></ol> Collections > <ol><li>Hands-on experience in handling corporate collections comprising of cash collection, cheque collection, Direct Debits (Mandates / Transactions), PDCs</li><li>Working Experience in handling Receivable products comprising of Invoice management, Payer management, Reconciliations (Manual / Rule Based), Credit Notes</li><li>Domain expertise in Virtual account management extending the scope to Payments and collections for POBO and COBO</li></ol> Digital Banking Experience > <ol><li>Product / Implementation experience for digital transaction banking including web / mobile channel / API Banking</li><li>Hands-on experience in end-to=end implementation cycle for channel banking engagement</li><li>Working experience of driving the integration solution for digital user journeys across different systems</li><li>Experience in handling integration between channel and Payment Gateways / Aggregators</li><li>Implementation experience in handling Security solutions viz. Hard Token / Soft Token Integration</li><li>Hands-on Experience in driving the mobile app solution as part of channel banking with scope of security / functional integration in picture.</li><li>Working Experience of wallet payment / bill payments / tax payments through integration with gateways / Regulatory sites</li></ol> Interested candidates, kindly share your updated resume to mageshwari.mariappan@intellectdesign.com. References are much appreciated! Regards,Mageshwari- TAGIntellect Design Arena

POSITION: Business Analyst (Banking - Supply-chain Finance)EXPERIENCE (IN YEARS): 5 to 15YrsROLE TYPE: Full time (Work from office)LOCATION: Mumbai, Goregaon ABOUT INTELLECT DESIGN ARENA LTD: <a>Intellect Design Arena Ltd</a> is an enterprise-grade financial technology leader, providing composable and intelligent solutions for futuristic global financial institutions across 57 countries. Intellect’s revolutionary First Principles Thinking-based Enterprise Connected Intelligence Platform, <a>eMACH.ai</a>, is the most comprehensive, composable, and intelligent open finance platform in the world. With an impressive array of 329 microservices, 535 events, and over 1757 APIs, <a>eMACH.ai</a> enables financial institutions to design and deploy future-ready technology solutions that provide a significant global competitive edge. With three decades of domain expertise, Intellect offers a full spectrum of banking and insurance technology products through four lines of business: Global Consumer Banking (iGCB), Global Transaction Banking (iGTB), IntellectAI and Digital Technology for Commerce (iDTC). Intellect is a pioneer in applying Design Thinking and our 8012 FinTech Design Center, the world's first Design Center dedicated to Design Thinking Principles, underscores our commitment to continuous and impactful innovation, addressing the ever-growing need for digital transformation. We proudly serve over 325+ customers worldwide, supported by a diverse workforce of solution architects and domain and technology experts in major global financial hubs. For more information about Intellect, visit <a>https://www.intellectdesign.com/</a> WHAT WE DO: We create financial technologies that help banks lead businesses on the path to growth and success. Our solutions help move the banking world forward; because that’s what happens when the world knows it has financial institutions they can rely on. This is the philosophy that we at Intellect follow and our commitment to our customers’ success. A uniquely focused Products business, over $200 million Intellect Design Arena group has the soul of an agile start up, with the maturity of an established specialist in designing advanced technology products for global financial platforms across Global Transaction Banking (GTB) , Global Consumer Banking (GCB), Risk, Treasury & Markets (RTM), Insurance (Intellect SEEC) and e- Governance (GeM). OUR ACHIEVEMENTS: We are the world's No.1 Fintech company recognized by the global survey of IBS. We provide full spectrum, fully integrated products that run in over 250 financial institutions, across 90+ countries. With over 4500 solution architects, domain and technology specialists, backed with over 30 years of deep domain expertise, Intellect is the brand on which progressive financial institutions rely on for transformation initiatives. Our aggressively customer-centric design philosophy has enabled the engineering of agile & holistic digital solutions, with full lifecycle enablement and industry-leading performance assurances. Explore more about us at: <a>www.intellectdesign.com</a> Requirement Gathering and Analysis: <ul><li>Collaborate with stakeholders to understand and document business requirements related to cash management processes and systems.</li><li>Conduct in-depth analysis of current Supply chain finance practices, identifying areas for improvement and optimization.</li><li>Translate business needs into clear and comprehensive requirement documents, user stories, and process flows.</li></ul> Solution Design and Implementation: <ul><li>Work closely with technical teams to design and implement cash management solutions, ensuring alignment with business objectives.</li><li>Facilitate the development of prototypes, proofs of concept (POCs), and functional specifications for cash management systems.</li><li>Support the testing and deployment of new cash management solutions, ensuring smooth integration and functionality.</li></ul> Process Improvement and Optimization: <ul><li>Identify opportunities to streamline Supply chain finance processes, enhance efficiency, and reduce operational risks.</li><li>Analyze data and metrics to provide insights and recommendations for optimizing cash flow, liquidity, and forecasting.</li></ul> Stakeholder Management and Communication: <ul><li>Collaborate with cross-functional teams, including finance, operations, IT, and external vendors, to drive Supply chain finance initiatives.</li><li>Communicate effectively with stakeholders at various levels to ensure alignment on project goals, timelines, and deliverables.</li><li>Provide guidance and support to business users, ensuring smooth adoption of new cash management solutions.</li></ul> REQUIREMENTS: <ul><li>Bachelor’s degree in Finance, Business Administration, Information Systems, or related field. Advanced degree or certification in Supply chain finance/Business Analysis is a plus.</li><li>5 to 16 years of experience as a Business Analyst or in Testing or in Operations, with a focus on Supply chain finance or Trade Finance area</li><li>Strong understanding of Supply-chain finance principles, trade finance and banking/payment systems.</li><li>Proficiency in gathering and documenting business requirements, creating process flows, and conducting gap analysis.</li><li>Experience in collaborating with technical teams and stakeholders to implement solutions.</li><li>Analytical mindset with the ability to interpret data and provide actionable insights.</li><li>Excellent communication skills, both verbal and written, to articulate complex concepts and solutions.</li></ul> WHAT INTELLECT OFFERS YOU: FT 8012, World’s First FinTech Design Center for Financial Institutions, We have a rich and truly diverse work environment that is bustling with creative energy and individual perspectives from 29 nationalities and 30 languages. LIVE YOUR DREAM - Intellect is India’s most profitable unicorn. A pioneer in design thinking, it has helped shape the future of fintech with passion, and cutting-edge products. Imagination <ul><li>Explore new possibilities at the epi-center of Design Thinking and cutting-edge technology</li><li>Unleash your true potential with mentor-led growth and development</li></ul> Learning <ul><li>Regular training sessions to develop personality traits</li><li>Full support on career and skills development to enhance your expertise to maximize your career aspirations.</li></ul> Execution Excellence <ul><li>Get an opportunity to work with the world’s strongest fintech leaders who designed and created a complex world class products</li><li>Be part of our dynamic team, to create world-class products for global marquee clients</li><li>A clear team vision with Future ready FinTech Platform</li></ul> Collaboration <ul><li>A diverse and inclusive community of belonging, where teammates are empowered to bring ideas to the table and act.</li></ul> Influencing <ul><li>We are agenda setters in the market by delivering compassable, contextual and hyper scalable Fintech solutions.</li></ul> BENEFITS <ul><li>Spot Awards & Chairman Excellence Awards to recognize exemplary performance</li><li>Medical Insurance</li><li>Excellent variable pay-outs.</li><li>No probation period, enjoy all company benefits from the day you join us.</li></ul>

EXPERIENCE (IN YEARS): 3 to 6 yearsROLE TYPE: Full timeLOCATION: MumbaiNotice Period: Only Immediate joiners ABOUT INTELLECT DESIGN ARENA LTD: <a>Intellect Design Arena Ltd</a> is an enterprise-grade financial technology leader, providing composable and intelligent solutions for futuristic global financial institutions across 57 countries. Intellect’s revolutionary First Principles Thinking-based Enterprise Connected Intelligence Platform, <a>eMACH.ai</a>, is the most comprehensive, composable, and intelligent open finance platform in the world. With an impressive array of 329 microservices, 535 events, and over 1757 APIs, <a>eMACH.ai</a> enables financial institutions to design and deploy future-ready technology solutions that provide a significant global competitive edge. With three decades of domain expertise, Intellect offers a full spectrum of banking and insurance technology products through four lines of business: Global Consumer Banking (iGCB), Global Transaction Banking (iGTB), IntellectAI and Digital Technology for Commerce (iDTC). Intellect is a pioneer in applying Design Thinking and our 8012 FinTech Design Center, the world's first Design Center dedicated to Design Thinking Principles, underscores our commitment to continuous and impactful innovation, addressing the ever-growing need for digital transformation. We proudly serve over 325+ customers worldwide, supported by a diverse workforce of solution architects and domain and technology experts in major global financial hubs. For more information about Intellect, visit <a>https://www.intellectdesign.com/</a> WHAT WE DO: We create financial technologies that help banks lead businesses on the path to growth and success. Our solutions help move the banking world forward; because that’s what happens when the world knows it has financial institutions they can rely on. This is the philosophy that we at Intellect follow and our commitment to our customers’ success. A uniquely focused Products business, over $200 million Intellect Design Arena group has the soul of an agile start up, with the maturity of an established specialist in designing advanced technology products for global financial platforms across Global Transaction Banking (GTB) , Global Consumer Banking (GCB), Risk, Treasury & Markets (RTM), Insurance (Intellect SEEC) and e- Governance (GeM). OUR ACHIEVEMENTS: We are the world's No.1 Fintech company recognized by the global survey of IBS. We provide full spectrum, fully integrated products that run in over 250 financial institutions, across 90+ countries. With over 4500 solution architects, domain and technology specialists, backed with over 30 years of deep domain expertise, Intellect is the brand on which progressive financial institutions rely on for transformation initiatives. Our aggressively customer-centric design philosophy has enabled the engineering of agile & holistic digital solutions, with full lifecycle enablement and industry-leading performance assurances. Explore more about us at: <a>www.intellectdesign.com</a> REQUIREMENTS: 1. Experience in Java-J2EE Development2. Hands-on experience in MVC architecture(Core Java, JSP, Servlets, EJB) framework.3. Hands-on experience in Oracle SQL, Procedures4. Should have knowledge on application servers like IBM WAS / Jboss / Web logic.5. Knowledge in SVN or any other version control is an added advantage.6. Knowledge in Build tools like ANT, Maven is an added advantage7. Hands on Javascript, JQuery knowledge. 8. Strong problem solving and analytical capabilities.9. Banking - domain expertise10. Good communication skills BENEFITS <ul><li>Spot Awards, Gem Awards & Chairman Excellence Awards to recognize exemplary performance</li><li>Medical Insurance</li><li>Excellent variable payouts.</li><li>No probation period, enjoy all company benefits from the day you join us.</li></ul>

Job Description: Role-Product Manager/BA – Commercial/SME-MSME LendingLocation: Goregaon-MumbaiMode of work-OfficeExp-10-18YearsGrade-Senior Manager/AVPMandatory-Exp in Commercial/SME-MSME Lending Summary:We are looking for a detail-oriented and strategic Commercial/SME-MSME Lending SME/Business Analyst to join our team. The successful candidate will play a vital role in analysing business processes, identifying opportunities for improvement, and supporting the development and implementation of Commercial/SME-MSME lending solutions. This position requires strong analytical skills, industry knowledge, and the ability to collaborate effectively with cross-functional teams.<ul><li>Possess extensive knowledge of commercial/SME - MSME lending practices, regulations, and products</li><li>Shall be able to guide, handhold and groom the team of Business Analyst throughout the project</li><li>Interact with business users and technical team for understanding of functional requirements</li><li>Document business requirements and process flows using different tools like JIRA, Confluence, Blue Works, Lucid Chart, MS Visio, etc.</li><li>Analyse and design solutions with the support of Solution Architects</li><li>Provide feedback on test cases and support to Quality Assurance for testing</li><li>Support in client UAT</li></ul> Responsibilities<ul><li>Lead the engagement with business users to define scope, understand business processes, problem statements and pain areas</li><li>Gather and document business requirements related to commercial/SME/MSME lending processes, systems, and products. Analyse current workflows and identify areas for enhancement.</li><li>Identify key stakeholders and construct stakeholder analysis i.e. how they are affected</li><li>Support the identification of risks and mitigation approaches</li><li>Lead the client requirement workshops and identify gaps together with high level proposals for their resolution (e.g. development workarounds or change in processes). Ensure any solutions proposed are realistic and within the agreed scope of the project.</li><li>Analyse client business requirements, liaise with clients / project teams and prepare business process documents like BRDs, User Stories, Discussion Logs, and Workflows etc. Be involved actively in the process till the sign-off is not obtained from the client.</li><li>Guide the business analysts in Solution design with the Design and Development team to ensure requirements are duly addressed. Ensure Requirement Traceability Matrix is updated to facilitate tracking of requirements coverage.</li><li>Make appropriate recommendations that will positively impact operational effectiveness, reduce cost and provide a better customer experience</li><li>Conduct relevant research to increase understanding in support of developing comprehensive solutions</li><li>Participate in final User Acceptance Testing for all major developments in the domain</li><li>Work closely with stakeholders, including bank business & IT users, compliance teams, and internal delivery team to ensure alignment of business needs with technology solutions.</li><li>Assist in the planning, execution, and monitoring of project, ensuring timely delivery and adherence to quality standards.</li><li>Assist in the production of various collaterals such as User Guide, SOP Documents, process flows etc</li><li>Provide training and support to end-users on new systems, tools, and processes, ensuring smooth adoption and effective utilization.</li></ul> Experience and skills required<ul><li>A strong background in Lending domain having good understanding of end-to-end lending lifecycle in areas such as loan management and servicing and delinquency handling</li><li>Should have good understanding SME lending products.</li><li>Design thinking, ability to manage multiple stakeholder expectations, communicate in a clear non-ambiguous manner, conduct requirements workshops, drive decision making</li><li>Experience in documenting business case, business process modelling, requirement elicitation through workshops</li><li>Manage projects from inception through design to delivery</li><li>An IT background with a solid grounding in technology</li><li>Experience of working in both Agile & waterfall SDLCs</li><li>Communication, group dynamics, collaboration and continuous improvement are core – being best practice driven</li><li>Pro-active, quick learner, ability to effectively work in multi-cultural and multi-national teams</li></ul> Positive attitude and ability to engage with different stakeholders managing scope and expectations skillfully About Intellect Design Arena Ltd.Intellect Design Arena Ltd is an enterprise-grade financial technology leader, providing composable and intelligent solutions for futuristic global financial institutions across 57 countries. Intellect’s revolutionary First Principles Thinking-based Enterprise Connected Intelligence Platform, eMACH.ai, is the most comprehensive, composable, and intelligent open finance platform in the world. With an impressive array of 329 microservices, 535 events, and over 1757 APIs, eMACH.ai enables financial institutions to design and deploy future-ready technology solutions that provide a significant global competitive edge. With three decades of domain expertise, Intellect offers a full spectrum of banking and insurance technology products through four lines of business: Global Consumer Banking (iGCB), Global Transaction Banking (iGTB), IntellectAI and Digital Technology for Commerce (iDTC). Intellect is a pioneer in applying Design Thinking and our 8012 FinTech Design Centre, the world's first Design Centre dedicated to Design Thinking Principles, underscores our commitment to continuous and impactful innovation, addressing the ever-growing need for digital transformation. We proudly serve over 270 customers worldwide, supported by a diverse workforce of solution architects and domain and technology experts in major global financial hubs. For more information about Intellect, visit <a>https://www.intellectdesign.com</a>

Intellect Design Arena Ltd Interview Questions

Intellect Design Arena Ltd Interview Guides

Intellect Design Arena Ltd Interview Questions

Intellect Design Arena Ltd Salaries by Position

Intellect Design Arena Ltd Opening Jobs