Description: Role Descriptions: LoanIQ Application Support Analyst

Experience Required: 6+ years

Location - Chennai/Mumbai/Pune

Technical Skills-

•Finastra Loan IQ application support & functional knowledge Mandatory 25%

•Incident/Problem management & major incident handling Mandatory 20%

•SQL (MS SQL) & data investigation/reconciliation Mandatory 15%

•Oracle/DB & batch/interface troubleshooting Mandatory 15%

•Change management, release/deployment validation Mandatory 15%

•Debugging / ability to read code; ServiceNow/ITIL exposure Non-mandatory 10%

Job Requirements*

•6 years of overall experience in application/production support (target range 5-7 years).

•Working experience supporting Finastra Loan IQ (must have).

•Robust troubleshooting and analytical skills across workflow behavior, performance, user experience, and environment issues.

•Hands-on with databases: Oracle and MS SQL; ability to investigate data and reconcile issues.

•Ability to read code and debug (required).

•Good communication (oral, verbal, written); ability to work under pressure.

Key Responsibilities*

•Provide day-to-day support of Loan IQ, partnering with Business Support to resolve issues in Loan IQ and the broader setting.

•Perform technical troubleshooting across interfaces (batch & real-time), reporting, system performance, and environment stability.

•Respond to queries from interfacing systems (internal/external), resolving data, connectivity, and reconciliation issues.

•Handle incident and problem management; lead/participate in major incident resolution in time-sensitive situations.

•Support change management: ensure production changes are tested/verified; participate in deployment planning discussions.





•Investigate and develop fixes for small bugs or functionality issues.

•Ensure Loan IQ batches complete within timelines and the system is ready by the next business day.

•Monitor maintenance and capacity (DB sizing, file system sizing, archiving/retention/cleanup, server resources).

•Complete internal/external audit requests within agreed timelines.

•Contribute to Loan IQ project work while prioritizing production integrity.

Sample Questions for Training Model

Technical

1.Walk through how you would troubleshoot a Loan IQ issue reported by business users: what logs/data would you check first?

2.Explain the difference between Incident vs Problem management. What artifacts would you capture during a major incident?

3.How do you troubleshoot batch failures vs real-time interface issues? What are common causes and mitigations?

4.Given a reconciliation mismatch between Loan IQ and an interfacing system, how would you identify the root cause?

5.Describe your approach to validating a production change before and after deployment.

SQL / Debugging

1.Write a SQL query to find duplicate records by a business key and list counts per key.

2.How would you diagnose a slow-running query and what steps would you take to improve performance?

3.You have a stack trace/exception from an interface job. What steps do you take to isolate whether the issue is data, connectivity, or code?

Custom Fields

Name: Type of Asset

Value: None

Name: Business Vertical

Value: CL-BFSI-UK-EMEA-APAC

Name: Work Location CDF

Value: ~Ken-A Unit I,Powai~SahyadriPark SEZ - I~Siruseri-Chennai-CDC~

Name: Parent

Value: IS-BFSI-APAC-Parent

Name: Child

Value: IS-BFSI-APAC 1.2-Group2

Name: Assets

Value: None

Name: Requisition ID

Value: 10872168

Name: Work Assignment Location

Value: Onsite

📌 IND_Developer (Mumbai)
🏢 Artech Infosystems
📍 Mumbai