Tik Europos Sąjungoje
Laisvas(-a) šiuo metu (
A result oriented technocrat with IT experience of around 7 years who is always willing to learn and grow together. Profound knowledge about Software Development Environment substantial talent in achieving critical solutions.
Extensive experience with analysis, design, development and implementation of Business Applications using Snowflake, Oracle RDBMS, PLSQL, MSSQL, TSQL, SSIS, ETL(Extract, Transform, Load) and proficient in SQL.
Hands on Experience in Slowly change dimension (SCD2) with history change data capture (CDC) and stream, tasks.
Created Row Level Security in huge data loading from Aws/azure/GCP cloud to snowflake with help of snow pipe and gathered knowledge of data fail safe recovery, time travel, cloning, sharing etc.
Working Experience in writing and tuning complex queries, views, constraints, sequences, stored procedures, functions & triggers and also developed PL/SQL programs which were meant to retrieve bulk data/sometimes unknown volume data with Exception Handling. Proficient in analyzing and translating business requirements to technical requirements and architecture and manage end to end complex data migration, data transformation and data modeling with strong debugging capabilities and client handling skills and proven experience.
Experience in handling the full life cycle of Microsoft SQL Server Integration Services (SSIS) projects and
Microsoft SQL Server Agent Job server & SSIS DB Catalog (deployment, scheduling, monitoring).
Troubleshooting & bug fixing of SSIS packages & jobs.
Worked as part of Agile Organization. Working experience with Test Driven Development and also worked with waterfall methodology.
Provided KT to junior team members, assign them work and assist them to complete their assignments.
Technology Stack :
Data Warehouse: Snowflake
Databases: MS SQL, Oracle PLSQL
ETL Tool: SSIS
Programming Language: Core Java
API : REST API
Cloud: Basic knowledge on AWS, Azure, GCP
Version Control : Git, Filezilla
Ticketing Tool: Jira, Trello
Operating System: Windows, Linux.
IDE: Visual Studio, IntelliJ
CI-CD Tool: Docker
Domains: Insurance, Reinsurance, Tourism and Education