Position: ETL Developer, Life Insurance Company
Company: DataArt
Experience required: 3y
Category: SQL
English level: upper
Published: 2021-10-01T00:00:00+03:00

About the vacancy

Our client is a multinational group of companies, operating as partnerships under a single brand. We are setting up a new team for a life insurance company that is a part of this group.

We are looking for engineers with Oracle DB and SSIS/SQL expertise to support data conversion. Oracle is the client’s data store for the DM application, so it's cloud-based. We move data (Flat CSV files) between environments via SFTP. The client has stored procedures that pick up our CSV from a landing zone.

The main goal of the project is to map sources to target data structures, build new data model scripts and conversion routines, and conduct ETL activities to move data from source to target databases. The team will work closely with clients software vendor partners to support this effort, however, experience with the application itself is optional due to the nature of this work.

Responsibilities
- Create, implement, and analyze test data scripts using ETL mapping artifacts
- Come up with strategies and test cases for applications on ETL components
- Perform data mining; analyze data from warehousing systems
- Introduce test plans to execute the delivery of data related projects
- Provide feedback, supporting the big data testing initiative
- Identify and follow quality assurance metrics like defects, defect counts, test results, and test status
- Locate issues and help resolve them

Must have
- 4+ years of experience testing backend with a focus on complex SQL queries
- Proficiency in data warehouse and database testing, excellent understanding of PL SQL and queries
- Working experience with testing Agile Development Projects
- Familiarity with the insurance domain
- Solid understanding of relational databases and database architecture
- Ability to interpret and understand data models and ER diagrams
- Ability to analyze ETL mapping documents
- Good English

Learn more about our policy of equal opportunities in employment