Role: Abinitio DeveloperLocation: 100% remoteDuration: 12 months
Description:Resource is for the credit directive (CBD) - before the industry adopts to the new credit scores, they bring in all this data, run analytics on it, let the industry know what these will do, prepare the market to start absolving these new credit scores, already have a team here but they want to speed up the process a bit, alleviate the capacity on the team, trying to bring in timelines.Last year - brought in 10 years' worth of data from the 3 credit bureaus, vetting to the marketing and analytics team, to the market, and to the FHFA, done that to the scores, but now it's about doing that for the entire credit reports.Initiative is to get the data from three different bureaus and get it loaded to our system, receiving files and the data will be loaded to Oracle RDS data base - need to deliver this project by the end of this year to FHFA.
Skills required:Worked on Abinitio for 8-10 years.ETL Developer background.Basic underlying foundational skillset is that they come from a data background with SQL experience - have to be very strong in this - Have to have worked in data environments, working in large databases, have complex SQL skillset.If they have AWS / Python that will also be helpful - everything is in AWS, everything is new development so they will be coding python from scratch, they also may be modifying existing python code as well.AutoSys scheduler is preference.Shell scripts - working on unix server, running jobs, automating.PL/SQL - Good to have as the existing code runs on it.