Position: Data Engineer
Category: SQL
English level: fluent
Years of experience: 4


Migration Project for Life Sciences & Healthcare company from NA (role - Data Modeller):
_______________________________________________________________________________________________
• Performed bulk code refactoring and compiled dashboard source views when migrating from Teradata to Postgres
• Wrote Python data quality tests for checking data correctness returned by new versions of source views
• Analyzed data discrepancies and documentated compatibility issues between Teradata and Postgres
• Conducting POC analysis aiming at evaluaing options for deploying DWH read replica of main instance (Redshift, Aurora DB, RDS Postgres)

Environment:
• Postgres (RDS), Teradata
• PyCharm, DBeaver, Teradata Express Studio
• Postgres plpgsql, Teradata SQL, Git, Python

Enterprise Development for Payment Processing company from UAE (role - DB Developer):
_______________________________________________________________________________________________
• prepared SQL scripts for reports in accordance with incoming requirements
• developed new functionality in way4 manager (menu items related to extracts, scheduler jobs)
• fixed prod defects connected with performance problems and report data discrepancies
• documented reports logic and structure in Confluence
Environment:
• Oracle 11g
• way4 Manager, SQL Developer, Git Bash, Bamboo Automation, Bitbucket
• Oracle SQL/PLSql, Git,WAY4
Migration Project for Life Sciences & Healthcare company from NA (role - Developer):
___________________________________________________________________________________________
• Preparing Data Migration scripts for the upcoming platform release.
Environment:
• PostgreSQL 9.6.5
• DBeaver, Docker, Git Bash, pgAdmin