Loan IQ SME / Senior Business Analyst

Tata Consultancy Services; India; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services seeks a Loan IQ SME / Senior Business Analyst to lead complex data migration, mapping, and QA for loan platforms. You will collaborate with Operations, Product, Technology, and QA teams to define requirements, write mappings, and validate migration outcomes.

You will analyze loan data models, create test scenarios, support SIT/UAT, and drive release readiness while leveraging AI tools to accelerate documentation and testing. Strong SQL and agile experience are essential.

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

Skills

Loan IQ SME

Business Analysis

SQL

Data mapping

Migration testing

Agile

Stakeholder management

Jira

Confluence

Vendor coordination

Data modeling

Communication

Tools

Jira

Confluence

Job description

Loan IQ SME / Senior Business Analyst

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.