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.
- Strong 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.
- Positive 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 / Senior Business Analyst (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru