Post Job Free

Resume

Sign in

Data Engineer Oracle Pl

Location:
Georgetown, TX
Posted:
April 11, 2024

Contact this candidate

Resume:

Tim Tarasenko

Sr Data Engineer / ETL Engineer / DataWarehouse Developer

Georgetown, TX 78628

ad4x3o@r.postjobfree.com

+1-512-***-****

Skills:

SQL (Oracle, Oracle PL/SQL, Hive, Impala, Snowflake, Google BigQuery, Amazon Athena) Python

ETLs

NoSQL(Goolge BigTable)

Apache Spark, Kafka

Airflow

GCP, AWS GitLab CI/CD, Docker, Terraform

Denodo

Authorized to work in the US for any employer

Work Experience

Senior Data Engineer

wargaming.com

April 2014 to Present

Gradually developing the DWH platform's ongoing business requirements, including RDBMS Oracle and Snowflake parts, Hadoop parts, reference data systems, and reporting. Technically, it is a multi-terabyte

(100Tb+) DWH system on the Oracle Big Data Appliance platform and Snowflake, with 500+ source systems integrated using bespoke integration frameworks. Data modeling and developing ETL processes using Python, Google Composer(Airflow), SQL, BigQuery, and Google Bigtable.

Migration from Oracle Exadata to Snowflake and Amazon Athena using Python, Oracle PL/SQL, Kafka, GitLab CI/CD

Developing REST API services using Denodo, Python(FastAPI) Oracle part:

• Analyzing and working out solutions for business objectives in PL/SQL (development of stored procedures/functions/packages/etc.);

• Performance tuning of ETL processes and Ad Hoc reports;

• Designing the structure of the data warehouse (focus on performance gains: choose the partition strategy, data load strategy, etc.);

Hadoop part:

• Developing ETL processes for a batch layer using Spark(Python, Scala), Hive, Impala;

• Developing ETL processes using ODI 12 for Big Data;

• Testing data using Python;

BI part:

• Creating dashboards in Tableau Desktop for World of Tanks Blitz, World of Tanks, World of Warplanes, World of Warships, and for some inner projects;

• Deploying, configuring, and administering the Tableau Server; Ruby developer

www.webls.eu/en/

March 2016 to February 2017

• Creating dashboard to store and analyze phone call info for internal CRM System using Ruby, Ruby on Rails, RSpec, PostgreSQL 9;

• Creating web application for holding corporate games in the format of a quiz using Ruby, Ruby on Rails, RSpec, PostgreSQL 9;

Lead engineer

www.rw.by/en/

January 2010 to April 2014

• Writing SQL Ad-Hoc queries for IBM DB2 database;

• Writing procedures/functions/triggers/packages using DB2 PL/SQL;

• Analysing and working out solutions for business objectives;

• Creating dashboards in SAP Business Objects XI for all business areas of the company;

• Writing system for the analysis of proposals for renting railway carriages using Java, Groovy, PostgreSQL

• Writing different components for Redmine using Ruby; Education

B.S. in Engineering and Economic Faculty

Belarusian State University of Informatics and Radioelectronics - Minsk, BY September 2007 to June 2013

Links

https://github.com/rubonz

Certifications and Licenses

Astronomer Certification for Apache Airflow Fundamentals September 2023 to Present

https://www.credly.com/badges/79009533-b8a7-4cdb-a7dc-17b3c13fe1a6/public_url



Contact this candidate