Loan IQ SME Consultant

*Job Title : Loan IQ SME Consultant * *Location : Southington, CT (Onsite from Day 1)* *Duration : 12+ Months * *JD*: Loan IQ Data Conversion SME with Techno functional Conversion experience on Finastra Loan IQ – Commercial Lending platform applications.
The Loan IQ Conversion SME is responsible to establish migration activities between Loan IQ and the firm’s proprietary technologies (Mainly from ACBS, AFS, Flexcube, etc.
and other lending applications).
The key responsibilities are writing and maintaining Translation logic, code based on mapping, Configure Data Conversion Tool (DCT), Reconciliation, iteration testing and other conversion life cycle activities.
The successful candidate will have expertise in Loan IQ and experience in a software development role and be able to create batch and real time functionality in and around Loan IQ application.
*Role Designation* – As a consultant, you will be a key player working closely within a data focused team predominantly responsible for migrating/converting 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.
*Qualifications* – * Bachelor’s degree or foreign equivalent required from an accredited institution.
* At least 7 years of experience with Information Technology.
* Minimum of 2 to 4 years of hands-on 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 * Location for this position is Southington, CT.
Candidate must be located within commuting distance or be willing to relocate to the area.
This position may require travel to project locations.
* U.
S.
citizens and those authorized to work in the U.
S.
are encouraged to apply.
We are unable to sponsor currently.
*Preferred Experiences*: Migration of Syndication lending products portfolio from ACBS / AFS to Loan IQ using Finastra DCT tool within the migration window in an iterative format.
Each iteration will include a pre-defined transaction volume: * Manage DCT Extraction, Transformation and Loading of loans data into Loan IQ using Finastra DCT as a migration utility.
* Validation of data loaded into Loan IQ against the source data in DCT staging Database (DB) * Configure DCT tool as finalized requirements provided by the Wells Fargo Business SME team.
* Replicate source database into Finastra Loan IQ DCT tool.
* Establish DCT database and API connectivity with Loan IQ application.
* Monitor transformation and extraction processes in DCT * Perform loading of Loans data in DCT tool * Report findings of the DCT load in the context of Loan IQ API validations * Share conversion statistics of each DCT load with # of successes and failures.
*Job Responsibilities.
* The position is expected to manage receipt of data from multiple data sources using ETL tools, develop complex, efficient, and reusable code from different data base engines like SQL Teradata, Oracle code meant for improvement, manipulation, and analysis of data, review code in SQL, Teradata, Oracle, etc.
data base engines.
We are looking for an innovative and forward-thinking team player that will smoothly transition our customer’s data from legacy system into Loan IQ products.
The Data Conversion Specialist will work directly with our customers and is responsible for executing previous management systems (Like AFS, ACBS, FlexCube, etc.
) to Loan IQ commercial management system.
* 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.
* Thorough understanding of donor system data mode and correlate with Loa IQ API template and perform accurate field level and template level mapping based on conversion scope.
* Design and develop extract, transform, load (ETL) procedures to successfully convert data from our customers legacy system(s) to Loan IQ * Detailed functional mapping document and detailed translation logic explanation and prepare project documentation based on the organization quality standards.
* Work with data owners, Application Managers, Business and operations stakeholders to verify and obtain approval that any transformed data retains its accuracy.
* 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.
* Clear understanding of Migration Design standards, Organization security and entitlement standards and make sure conversion activities are in sync with required standards.
* Good understanding of Infrastructure Management aspects and overseeing technical and aspects of server, DCT management and their configurations.
Excellent working knowledge of security, and conversion Performance aspects.
Should be able to perform capacity planning and performance management in-line with conversion scope.
* Previous experience operating and delivering in multiple SDLC methodologies (including Agile, Waterfall) * Must have strong problem-solving abilities, self-starter, sound team player.
* Must have excellent organizational skills and be able to handle multiple tasks to meet tight deadlines.
* Strong ability to communicate effectively and influence decisions to achieve results.
Planning and Co-ordination skills Job Type: Contract Benefits: * 401(k) * Dental insurance * Health insurance Schedule: * Monday to Friday Ability to Commute: * Southington, CT 06489 (Preferred) Ability to Relocate: * Southington, CT 06489: Relocate before starting work (Preferred) Work Location: In person