Position: Senior Data Engineer
Company: DataArt
Experience required: 5y
Category: SQL
English level: upper
Published: 2021-10-01T00:00:00+03:00

Our client is a multinational group of companies, operating as partnerships under the one brand. 

We are setting up a new team for a Life insurance company which is a part of this Group. 

The main goal of the project is to map source to target data structures, build new data model with conversion routines, and conduct ETL activities to move data from source to target databases.  The team  will work closely with Majesco insurance Data & Analytics Platform to support this effort. However experience with the platform  itself is optional due to the nature of this work.  


We are looking for Senior Data Engineers with Oracle DB, SSIS / SQL expertise to support data integration and conversion. We move data (Flat csv files) between environments via SFTP.  Majesco has stored procedures that pick up our csv from a landing zone.  

	
Responsibilities:  
•      Write test  data scripts, based on ETL mapping artifacts
•      Execute data scripts and detailed analysis on the scripts
•      Create strategies and test cases for applications that use ETL components
•      Data mining and detailed data analysis on data warehousing systems
•      Execute formal test plans to ensure the delivery of data related projects
•      Provide input and support big data testing initiative
•      Define and track quality assurance metrics such as defects, defect counts, test results and test status
•      Document all problems and assists in their resolution

Skills:
•      4-5  years of relevant work experience testing backend, focusing on complex SQL queries
•      Experience analyzing ETL mapping documents
•      Create SQL scripts based ETL mapping documents
•      Create and execute strategies and test cases for applications that use ETL components
•      Expert in Database testing with excellent PL SQL skills and queries
•      Data warehouse testing experience
•      Experience testing Agile Development Projects
•      Experience Insurance domain is a plus
•      Hands on experience in relational databases and database architecture
•      Hands on experience interpreting and understanding data models and ER diagrams