RESPONSIBILITIESThe ETL Developer will work to understand client data files and use defined mappings to build Talend jobs that translate these files into a standard structure. The source files will come in a variety of formats including CSV and XML and may be sent to us or require retrieval from an exposed client API. The jobs themselves will require file manipulation as well as calling web services and interaction with a database, mainly through stored procedures.
The ETL Developer should have a good working knowledge of database technology as he or she may be required to write stored procedures or complex queries to retrieve data within the job.
The jobs will need to perform well and be scalable. They will also need to contain effective error handling and alerting to ensure issues can be resolved quickly and limit the effect on client applications.
The ETL Developer may also be required to support production jobs so strong problem solving and issue identification skills are crucial.
This role will require independent work as well as collaboration with teams located across the globe. Effective communication and attention to detail will be critical to be successful in this role.
Should have a minimum of 3 years’ hands-on experience developing ETL jobs – Talend is preferred, but other ETL tools will be considered.
Should be able to understand high level technical design & translate to low level design/ data mapping in Talend.
Should have knowledge of SQL relating to one of the following databases:
Should have knowledge of one of the following programming languages:
Knowledge of XML and (or) JSON
Should be able to review code/design.
Should be able to write/review test cases for Unit testing/Integration testing.
Should be able to support code promotion to different environments.
Experience of working within an Agile Environment.
Previous knowledge of Linux or any other Unix flavors is an advantage but not a requirement.
Previous experience in the financial sector is an advantage but not a requirement.
Confident and assertive communicator(Oral and Written) with good presentation skills.
Highly motivated individual with a proven ability to drive projects to a successful and timely conclusion.
Ability to be flexible/adaptable in exercising judgment in a dynamic, matrix environment and to manage competing priorities.
Bachelors or Master’s Degree from a recognized university relating to Information Technology / Information Systems / Computer Science
3-4 years experience