Loan IQ SME / Senior Business Analyst

Tata Consultancy Services; Bengaluru; On-site; INR 2,200,000 - 3,800,000; Full time

Job summary

Tata Consultancy Services in Bengaluru is seeking a Senior Business Analyst with deep Loan IQ expertise to lead migration, data mapping, and requirements analysis. You will partner with Operations, Product, Technology, QA, and Vendors to deliver end-to-end solutions.

The role emphasizes data model understanding, SQL validation, and testing across SIT, UAT, and production migrations, with a focus on automation readiness and Agile ceremonies.

Qualifications

• 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.
• 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.

Responsibilities

• Serve as the Loan IQ functional SME across deals, facilities, borrowers, loans, fees, interest, servicing events, accounting touchpoints, 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.

Skills

Loan IQ

SQL proficiency

Data analysis

Requirements gathering

Functional specs

Stakeholder management

Agile methodologies

UAT/SIT testing

Automation testing

AI prompt writing

Tools

Jira

Confluence

SDLC tools

Job description

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.
• 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.