Snowflake Developer
Location : Jaipur, India
Experience : 10 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Siva – 9+ Years – Snowflake Developer
PROFESSIONAL SUMMARY:
9+ years of experience in full life cycle of software project development in various areas like Analysis, Design, Development, Testing and Implementation of business application systems for Banking & Financial Services in AS400, Snowflake and Matillion.
Worked extensively in DB2/400, CL/400, RPG/400, COBOL/400, SQL400, RPG ILE and COBOL ILE programming languages.
Extensive experience in ETL methodology for performing Data Extraction, Transformation and Loading using Talend and designed data conversions from variety of source systems including Oracle, DB2 and non - relational sources like flat files, XLS and CSV files.
Experience in Matillion ETL solution to develop pipeline that extract and transform data from multiple sources and loading to Snowflake.
Migrating the existing data from SQL Server to Snowflake DWH using Matillion Orchestration Jobs.
Experience with Snowflake Multi-Cluster Warehouses and Snowflake Virtual Warehouses and creating Materialized views in Snowflake and by using Matillion objects.
Knowledge on Data sharing in Snowflake. Hands on Snowflake database, Schema and Table structures, and experience in using Snowflake Clone and Time Travel.
Experience on using Amazon S3 services in Matillion job flows.
Hands on experience in creating Matillion Orchestration Jobs by using components which related to Input, output, update, metadata, Python and Calculator.
Expertise in creating interactive dashboards by using Marks, Actions, Filters and Parameter
Experience in creating Normal filters, Quick filters, Context Quick filters and Cascading Filters
Experience in sets, Joins, bins, hierarchies, sorting, grouping, actions, table Calculations, calculated measures and parameters
Hands on experience in developing Dashboards, Reports using Tableau Visualizations
Experience in designing visualizations using Tableau software and Publishing and Presenting dashboards to Tableau server
PROFESSIONAL EXPERIENCE:
Working as a Specialist Software Engineer from Sep 2019 to Till Date.
Worked from Dec 2012 to Sep 2019
TECHNICAL SKILL SET:
Operating Systems Windows XP, Windows 7 and OS/400
Database DB2/400, Oracle
Programming
Languages
CL/400, RPG/400, COBOL/400, CLLE, SQL400, RPG ILE and Oracle(PL/SQL)
Utilities/Tools SEU, RLU, SDA
Version Control Tool Implementer and Aldon
ETL Tools Talend and Matillion
Data Warehouse Snowflake
Reporting Tool Tableau
ACADEMIC QUALIFICATION:
MCA (2007-2010) with 75%.
BSC Computers with 60%.
CERTIFICATIONS & AWARDS:
Received APEX(PEGASUS) award for Q3 FY2015
Received APPLAUD for Tableau Report
Received Several Appreciation mails from the Client for committed and hard working
towards deliverables.
Received many appreciation mails from client
PROJECT DETAILS:
Project #1
Project Name: OneMain Financial
Data Base: DB2/400
Languages: CL/400, RPG/400, COBOL/400, CL ILE, RPG ILE, COBOL ILE.
ETL Tool: Matillion
Data warehouse: Snowflake
OneMain Holdings, Inc. is an American financial services holding company headquartered in Evansville, Indiana, with central offices throughout the United States. The company wholly owns Springleaf Finance Corporation and its subsidiaries, through which it operates in the consumer finance and insurance industries as OneMain Financial. Its business primarily focuses on providing personal loans and optional insurance products to customers with limited access to traditional lenders, such as banks and credit card companies.
Roles & Responsibilities:
Study the functionality of the application and understand the requirements
Coding of DB2/400, CL/400, RPG/400, CLLE and RPGLE Programs
Analyse requirement, preparing detailed technical specifications and coding for the same
Coding, Unit Testing and Integration testing.
Involving preparing Business requirement documents
Involving in preparation of Unit Test Plan and Unit Test Results
Involving in preparation of implementation log and Source Compares
Involving in Code and Test Results reviewing
Involving in Integrated System Testing and Supporting BAT and UAT
Used temporary and transient tables on different datasets in snowflake.
Created snow pipe
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
