Position: Software Engineer
Category: Data Engineer
English level: upper
Years of experience: 10


DATABASE EXPERT
09/2022 – nowadays 
•	Making investigations and proposing possible solutions to improving the performance MS Sql Server
•	Direct communication with the customers’ project team;
•	Optimizations of SQL queries and data validation
•	Developing data archiving strategy 
ETL DEVELOPER
06/2022 – 09/2022
•	Direct communication/collaboration with the customers’ project team; clarification of requirements and expectations.
•	Making investigation and proposing possible solutions to improving performance Informatica ETL processes
•	Development and maintenance of ETL processes using Informatica Power Center 10.4
•	Optimizations of SQL queries 
•	Data validation and sanity checks
HEAD OF TECHNICAL SUPPORT DEPARTMENT
04/2014 – 05/2022
•	Support 2nd tier: all phases of Software lifecycle:  Core banking system B2, SAP ERP, SAP Collateral Management, Informatica PWC (9.5, 10.2), Oracle APEX, OBIEE, HADOOP, Tibco Data Virtualization.
•	Management of a team (5-8 members) to support complex solutions for automating the bank's business processes.
•	Teradata DBA tasks: User Management, Space Allocation, Access of Database Objects, System Performance, BAR operations (backup and restore), Stats Manager, DBQL, cnsrun utility, BTEQ scripting, Unix scripting, 
•	Informatica developer tasks: Create Informatica mappings (oracle, teradata, flat file, hdfs, hive, spark, ODBC); Create Informatica workflows, Unix scripting 
•	SQL Developer tasks: Creating views, functions and stored procedures, creating database triggers for use in automation, writing optimized complex SQL queries, designing database tables and structures, SQL performance optimization
•	SAP Basis Administrator tasks: user/role management, upgrade application, upgrade DB (Oracle 11->12->19) 
•	Other Data Domain tasks: install, investigate and provide testing of Informatica BDM (big data) for purpose of migrating data between Teradata and Hive (Hadoop). install, investigate Data Virtualization tool (Tibco) as one point of access to corporate data from different applications based on Oracle, Teradata, Hadoop, MSSql, Microsoft AD
I'm looking for a long-term project with an opportunity for professional growth, consolidation, and deepening my skills as Data/DB Engineer/Support Engineer, focusing on working with SQL, and ETL, that would help me to improve my knowledge of cloud technologies, Python