| Urgent Position --- ETL Developer --- New York, NY (Hybrid) at New York, New York, USA |
| Email: [email protected] |
| From: Akhilesh Kushwaha, Source Infotech [email protected] Reply to: [email protected] Hi, Hope you are doing good. I have following requirement, please reply me back with profile along with rate expectation ETL Developer Location - New York, NY (Hybrid) Visa - H4EAD, GCEAD, GC, USC About the job We are currently seeking an ETL Developer for an elite financial organization. This is a long-term contract position. This developer will mainly focus on stabilizing the data quality of the Loan IQ Reports which are needed from a regulatory, customer, and loan operations standpoint. This individual will help the bank ensure we can create more robust reports without relying on data from legacy systems such as ACBS. A key focus of the role will be to adapt to incoming regulatory requirements and generate these reports quickly so that the team can stay ahead of the external regulatory demands scheduled and unscheduled. The role of the ETL developer is to create reports as per the sponsors' and regulatory requirements. The sponsor can be a user, a department, or a project. Most reporting requests will come from Global Finance Operations. The delivered reports will need to be developed in Informatica using SQL DBX connecting to a Hadoop database. All reports will need to be properly versioned and documented following the firm's SDLC procedures. In compliance with the firm's software development policies, the Application Developer is providing software solutions that will allow the firm to increase its productivity and efficiency, streamline its processes, mitigate risk, remain compliant with the regulations of the changing market and in turn build up its competitive advantage. Development Gather, understand and analyze user requirements for reports that need to be developed IBM Cognos Data net (Finastra version) Develop reports using Informatica which will connect to a Hadoop-based Data warehouse 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 all Loan IQ reports in line with the agreed-upon specifications Support / maintenance: Troubleshoot discrepancies with production reports Assist users in understanding 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 Required education and/or experience Bachelors 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 Data model 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 Methodologies (GIT, Jira, Jenkins, Confluence) Thanks & Regards, Akhilesh Kushwaha Sr. Technical Recruiter Source InfoTech Inc. Direct: 609-934-3470 Ext :130 P.O. Box 577, EDISON, NJ 08818-0577 [email protected]| www.sourceinfotech.com https://www.linkedin.com/in/theakhil10/ Keywords: information technology green card New Jersey New York |
| [email protected] View all |
| Sat Jan 14 02:20:00 UTC 2023 |