ETL Tester with SQL

Location: Gdańsk, Gdynia, Łódź, Warsaw - minimum 1 day in the office per week

Rate: up to 120 pln net/h (B2B)

Industry: banking

Detailed description of work task to be carried out:

• Writing SQLs which will transform data from multiple tables and schemas and compare the output to development results based on documentation and Collateral business knowledge
• Managing database objects and privileges to ensure that data flows correctly
• Cooperating with developers, analysts and business to understand transformation process to be able to create testing SQLs
• Managing Test environment which includes recreating database from GIT repository, putting proper scripts on UNIX server, running DataStage jobs to run migration process
• Committing test cases changes into Git repository and managing them in Qtest
• Reporting bugs in JIRA and taking ownership of delivering a proper solution for it

Description of knowledge and experience:

• 3+ years of SQL / Oracle knowledge in writing queries that transform data from multiple tables and schemas
• 4+ years of testing knowledge
• 1+ Experienced with Extract-Transform-Load (ETL) process and tools
• Experience in Agile ways of working and JIRA
• Qtest, JIRA and GIT repository
• Fluent English

Nice to have:

• Knowledge of IBM DataStage or other similar tool (e.g. Informatica)
• Programming skillset
• Database. data modelling & data warehousing background
• Knowledge about collaterals, assets and loans