Data Engineer

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