Job Title

Role: Loan IQ Business Analyst.Locations : Hartford, CT Southington, CT (Onsite)Fulltime role (USCGCEAD Canadian Citizen can apply)Candidate from Canada can apply who are willing to join onsite at Hartford, CT Seeking a Loan IQ Business Analyst. As a Lead consultant, you will be a key player working closely within a data focused team predominantly responsible for migratingconverting data from legacy databases into our core application database. Part of this function involves ensuring as part of the data migration that data quality, integrity and completeness is maintained or improved and that duplicate entities are consolidated. You will create detailed design, architecture and process artifacts and implement the deployment plan. You will also support knowledge transfer with the objective of providing value-adding consulting solutions that enable our clients to meet the changing needs of the global landscape.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. functionaloperational, 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)