ETL Developer

Company Description

For the last 20 years, Talan has been advising companies and administrations, supporting them and implementing their transformation projects in France and abroad. With a presence on four continents, Talan has more than 4,500 consultants and aims to exceed $1B in revenue by 2024.

Talan leverages innovation and operates in areas related to technological changes such as Big Data, Cryptocurrency, and Artificial Intelligence.

We rely on both technological leverage and the strength of our DNA based on collective intelligence, agility, and a taste for entrepreneurship.

Talan has been operating in the US since 2006, advising major companies in the Finance and Luxury Goods industries.

Job Description

We are looking for an ETL Developer to enhance our client data lake and reporting/data analysis solution. This developer will have a main focus on stabilizing the data quality of the Loan IQ Reports, creating more robust reports without relying on data from legacy systems such as ACBS and adapting them to new regulatory requirements (regulatory, customer, and loan operation statements). 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.

Essential duties and 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 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 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

Qualifications

Education and experience

• Bachelor’s degree in computer science
• + 3 years of directly related experience
• Experience in financial services, specifically an international bank is highly preferred

Required skills

• Deep knowledge of LoanIQ Data model
• Knowledge of Hadoop or similar Data tool
• Deep knowledge of Informatica
• Knowledge of Commercial Lending business with an understanding of Loans, Facilities, Amortization, Interest, Principal, and repayment schedules.
• With deep IT knowledge, the successful candidate must be able to review source code, write and execute SQL queries (Sybase, Oracle and SQL Server)
• 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.
• 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)

Desired skills

• Knowledge of Alteryx is preferred/nice to have
• Knowledge of Finastra LoanIQ is preferred and a huge plus

Company’s Benefits

• At Talan, we invest in our employees' well-being and empower them with benefits, including:

• 💵 Competitive salary
• 💸401(k) retirement plan with company matching
• 🌴15 days of paid vacation per year at hire and up to 27 according to seniority (annual untaken vacation days are cashed out)
• 📴8 paid holidays + 5 sick days + 2 personal days per year
• ❤️‍🩹Company health, dental, and vision insurance plans + FSA
• 🦺Voluntary STD and LTD
• 🚍 Commuter/transit benefits

The salary range for this role is US$110,000 - US$135,000

All your information will be kept confidential according to EEO guidelines.

Additional Information

ETL, Loan IQ, Informatica