Required Qualifications: • Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education • At least 7 years of experience with Information Technology. • Experience in end-to-end Loan IQ migration work stream. • Strong knowledge of database schema design, data types, and SQL best practices. SQL server & access database management experience.
Preferred Experiences: • At least 8 years of technical experience in LoanIQ. • At least 8 years of experience in LoanIQ API and data model. • Migration of Syndication lending products portfolio from ACBS / AFS to Loan IQ using Finastra DCT tool within the migration window in an iterative format. • Loan IQ Migration consultant will act as the Subject Matter Expert (SME) and possess an excellent. functional/operational, Database, DCT ETL Tool knowledge of the activities performed by the various teams. • Candidate must have experience in the areas of migrating Data and portfolios from one platform onto Loan IQ. They are consolidating loan data from the donor applications like ACBS, AFS and other lending application onto Loan IQ. • Design and develop extract, transform, load (ETL) procedures to successfully convert data from our customers legacy system(s) to Loan IQ • Create conversion scripts based on data mapping documentation. Development of conversion related documentation including data mapping documents and conversion strategy documents. • Work with Project Managers and Application Managers to plan data conversion process by developing project scope, objectives, specifications, and critical path actions identifying possible areas of concern periodically. Work closely with respective stakeholders and Managers to resolve the issues. • Previous experience operating and delivering in multiple SDLC methodologies (including Agile, Waterfall)