Position: data engineer/ etl developer
Category: SQL
English level: intermediate
Years of experience: 10


Experience
•	5+ years of outsource experience in software development (including Regulatory Reporting Projects and Reference Data Services)
	10+ years experience in the IT industry
•	Maintenance  and implementation of ETL processes (data extraction, transformation, loading, cleaning, validation) .
•	Development with experience and knowledge in all stages of project life cycle.
•	Experience in Database Architecture and Data Modelling
EMPLOYMENT

Oracle/ETL Developer, Jun 2013 - currently Luxoft, Ukraine.
 
	Projects: Client onboarding, Regulatory and Control, Reporting system
Description: The project mission is creation of a unified system for client onboarding.Migration from legacy systems.Loading regulatory client information. Creation of a reporting system.
Duties:
o	Development of the real-time and batch ETL processes according to the specifications:
 		on Informatica side (mappings/workflows);
 		on database side (packages/procedures/functions etc.);
o	Integration with external system using Informatica ,(external source –Oracle DB, SQL Server DB, Salesforce, SOAP and REST WS, files in different formats;
o	Data modeling including the design and development of Oracle and ETL processes;
o	Non-PROD environments testing support;
o	Performance tuning;
o	Incident and defect analysis and fixing;
o	Environments setup and synchronization (sanity and smoke checks);
o	PROD rollout preparation and  support;
o	Creation of the Control-M jobs/packages for workflow scheduling;
o	Communication with local and remote/distributed teams (UK, US, India).


Oracle Developer, Oct 2012 - Jun 2013 Miratech
Ukraine

	Duties:
o	Design, develop, maintain billing system ;
o	Create a logical database structure, scripts, queries, packages, views, jobs,
Tuning of SQL queries
o	ETL development using PL/SQL;
o	Communication with technical and analytical specialists from customer side;
o	Ad-hoc reporting;
o	Technical support of L3 and L2 services, technical customer support


   Oracle Developer, Jul 2008 - Sep 2012  Internal Revenue Service

	Duties:
o	developing of applications framework for Tax Accounting and Reporting Department (Visual FoxPro, Oracle);
o	developing a server-side software for data aggregation and data selection (PHP, Oracle);
o	Tax system support.