Required Skills

ETL Developer

Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 26th Jan 2023

JOB DETAIL

Must Have:

 

·Informatica REQUIRED

·Financial/Banking industry REQUIRED

·8-10 years experience minimum

 

RESPONSIBILITIES

 

Development:

 

·Gather, understand and analyze user requirements for reports that need to be developed

·IBM Cognos Datanet (Finastra version)

·Develop reports using Informatica which will connect to a Hadoop based Datawarehouse using SQL DBX for creating the SQL queries ensuring all reports are fully unit tested and follow our Agile standards.

·Implement, test, release and maintain/support for all Loan IQ reports in line with the agreed upon specifications

 

Support / maintenance:

 

Troubleshoot discrepancies with production reports

Assist users to understand any reporting discrepancies that need to be resolved.

Train users, colleagues and peers as needed on how the reports obtain and calculate the data displayed on the reports.

 

Other

 

·Report comprehensive status to manager and senior developer on a regular basis

·Write technical and functional documentation as needed

·Continue to develop technical skills and learn new technologies as needed

 

REQUIREMENTS:

 

Required education and/or experience

 

·Bachelor’s degree in computer science

·Minimum of 5 years of directly related experience

·Experience in financial services, specifically an international bank is highly preferred

 

Business Skills

 

·Knowledge of Commercial Lending business with an understanding of Loans, Facilities, Amortization, Interest, Principal and repayment schedules.

·Knowledge of Finastra LoanIQ is preferred and a huge plus

 

Technical Skills

 

·Deep knowledge of LoanIQ Datamodel

·Knowledge of Hadoop or similar Data tool

·Deep knowledge of Informatica

·Deep IT knowledge, the successful candidate must be able to review source code, write and execute SQL queries (Sybase, Oracle and SQL Server)

·Knowledge of Alteryx is preferred/nice to have

·Ability to analyze complex requirements, with strong attention to detail and ability to provide solutions to problems.

·Ability to prioritize and multi-task in a fast-paced environment on multiple applications.

 

 Soft skills

 

·Great written and verbal communication skills to interact with end users and project managers

·Must be able to work both independently and collaboratively with local and global teams

·Ability to juggle multiple high-priority tasks, in a fast-paced demanding environment. 

·Experience with Agile Méthodologies  (GIT, Jira, Jenkins, Confluence)

 

Company Information