Loan IQ SME / Senior Business Analyst

Location:
Mumbai, Delhi/Noida, Bengaluru, Hyderabad, Chennai, Kolkata, Pune, Bhubaneshwar, Kolkata

Key Responsibilities
• Serve as the Loan IQ functional SME across deals, facilities, borrowers, loans, fees, interest, servicing events, accounting touchpoints, operational workflows, and migration-related data flows.
• Lead business analysis activities for Loan IQ migration, conversion, implementation, onboarding, and platform enhancement initiatives.
• Work independently with Operations, Business, Product, Technology, QA, Automation, and Vendor stakeholders to gather requirements, analyze impacts, clarify open items, and drive decisions to closure.
• Create detailed source-to-target mappings, field-level mapping rules, transformation logic, validation criteria, business rules, and functional specifications.
• Use knowledge of the Loan IQ data model to support data discovery, gap analysis, reconciliation, defect triage, downstream impact analysis, and migration readiness activities.
• Write and execute SQL queries to analyze source and target data, validate mappings, reconcile migration results, investigate defects, and support mock conversion, dress rehearsal, and production migration events.
• Partner closely with developers and technical teams to explain requirements, review solution approaches, answer functional questions, validate technical outputs, and support defect resolution.
• Define test scenarios, test cases, expected results, data validation checks, reconciliation procedures, and UAT sign-off criteria.
• Support SIT, UAT, regression testing, migration testing, mock conversion testing, dress rehearsals, and production implementation validation.




• Collaborate with automation testing teams to identify regression candidates, define automation-ready scenarios, validate automated test coverage, and support reusable regression test assets.
• Use AI tools responsibly and write effective AI prompts to accelerate requirements analysis, documentation, mapping reviews, test case generation, defect summaries, meeting notes, and stakeholder communications.
• Participate in Agile ceremonies including backlog refinement, sprint planning, daily stand-ups, estimation, demos, retrospectives, defect triage, and release readiness discussions. Must-Have Skills
• 5+ years of Business Analysis, Product Analysis, Operations Analysis, or SME experience in commercial lending or banking technology programs.
• Solid hands-on functional experience with Loan IQ, including lending workflows, facility/deal structures, borrower relationships, servicing activities, fees, interest, and operational processes.
• Prior experience supporting Loan IQ migration, conversion, implementation, data onboarding, or platform transformation programs.
• Good understanding of the Loan IQ data model and the ability to analyze data relationships, dependencies, and downstream impacts.
• Strong SQL skills for data analysis, source-to-target validation, reconciliation, defect investigation, and migration support.




• Proven ability to create source-to-target mappings, mapping rules, functional specifications, business rules, and testable requirements.
• Ability to work independently with Operations, Business, Product, Technology, QA, Automation, and Vendor stakeholders.
• Experience supporting developers and technical teams by clarifying requirements, reviewing logic, validating outputs, and helping resolve functional and data issues.
• Strong experience with SIT, UAT, regression testing, migration testing, reconciliation, and defect triage.
• Familiarity with Agile delivery practices and tools such as Jira, Confluence, and similar SDLC platforms.
• Experience using AI tools and writing clear prompts to improve productivity, documentation quality, analysis, and testing support.
• Excellent communication, documentation, facilitation, problem-solving, and stakeholder management skills. Good-to-Have Skills
• Experience with ACBS to Loan IQ migration or other commercial lending platform conversion programs.
• Exposure to automated testing frameworks, regression automation, test data management, and automation-ready test case design.
• Understanding of ETL processes, data transformation, reconciliation frameworks, data quality checks, and migration execution controls.
• Familiarity with Loan IQ APIs, integrations, downstream lending applications, reporting platforms, and operational data feeds.
• Experience working in large global banking transformation programs with distributed business and technology stakeholders.
• Exposure to audit, controls, data governance, production readiness, and release management practices.

📌 Loan IQ SME (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru