Position: ETL/BI Developer
Category: Data Engineer
English level: intermediate
Years of experience: 6

All projects where I was involved as ETL/BI developer(3 main and more than 7 additional), were successfully moved to production or were already in production and my responsibilities were supporting, fixing bugs, and implementing new functionality. Some of the projects were my own ideas based on the main project or like an additional improvement for the main project. I was a key developer or the only one developer in the team for those projects. Also, there were nearly 6-14 QA & Devs for the main projects. Due to it, I have no problems working alone or in a team, but prefer teamwork.
I am ETL/BI developer with relevant experience of more than 5 years.
I was involved in the development of projects for a big delivery client and projects for a company which processes and analyzes selling data in the fashion and beauty sphere.

- investigation, improvement, and implementation of DB schema for AWS Aurora, also have a good experience with databases like IBM DB2 and Vertica (creating indexes, tables, views);
- migration DB with using FlyWay, creating processes for migration data from Aurora to Elasticsearch and Redis Cache;
- implementation REST-based and event-driven approaches using ETL tool SnapLogic;
- using ETL tool Data Management console for creating a lot of different ETL logics to process and load the data from different sources: txt files, Excel merchant reports, EDI files, etc;
- creating different MySQL queries, like gathering all data for one user in JSON format(with objects, arrays...), or query for detecting anomalies in selling trends, etc;
- using Qlikview/Tableau/Excel/Spreadsheets for data visualization (creating graphs), analyzation issues and validation (a difference between a source and processed data);
- collaboration with customer(demos, usual scrum/kanban meetings), clients of the customer(testing API, discus technical requirements from their side);
- developing additional tools, smaller projects for the main project;
- checking, collecting, and analyzing logs, investigating issues, creating bugs reports, developing solutions of errors and optimizing existed processes;
- took part in performance testing, implementation specific logics;
- working with WebFocus environment for creating reports for validation a data by the production team and reports which were sent to clients.