Position: ETL Developer for a US banking project
Company: Sonalake
Category: Data Science
Experience required: 5y
English level: upper
Published: 2020-10-01T00:00:00+03:00

We are looking for 2 ETL developers to support our client, an international bank, with building the jobs to bring the data from the files coming from a smaller bank and other bank application mastering data.

Data types to migrate: collateral data. i.e. everything about the collateralized asset, its owners, valuation, the legally enforceable document and connections to exposures and borrowers. Mostly for household customers.

The stack of the project:

1. Java – integration is partially based on Java

2. C# - is used for Test automation

3. Visual Basic – is corelated with the client's core system

4. Dax/ Power BI – reporting tools

Requirements:

•	Skill in working in ETL tool (Informatica Power Center, IBM DataStage, 
        Talend) – Preferably Datastage (including IBM InfoSphere other 
         products)
•	Strong SQL skills (as we use Oracle SQL developer to do analysis and 
        reporting purposes)
•	PL/SQL skills (At least Beginner Knowledge)
•	Unix/Linux scripting (At least medium level knowledge)
•	Databases: Oracle, MS Sql-Server, ETL tools etc.
•	Agile Software Development
•	Jira: Story/Defect tracking


Nice to have:

Performance testing
Data Analysis