Venkat

Profile Summary:

Dedicated and motivated SQL Developer with proven ability to drive process efficiency and data integrity.

My Professional experience in IT industry spans around 9.0 years of developing database applications, writing the complex logics and information systems.

·        Completed the snowpro certification.

·        Around 3 years of extensive snowflake cloud data warehousing implementation using AWS.

·        Good experience in Snowpipe, Time Travel, Fail safe, Zero copy cloning ,data masking, data streams, materialized views and data share.

·        Experience in Snowflake virtual warehouse and building Snowpipe.

·        Developing transformation logic through snow pipeline.

·        Good experience in Extracting, Loading, and Transforming(ETL) data sources for medium and large enterprise data warehousing.

·        Expertise in preparing the ETL standards, writing ETL flow documentation and naming conventions.

·        Good knowledge in DBT tool .

·        Experience designing and developing data integration solutions using ETL tools such as dbt

·        Using DBT tool You can write custom business logic using SQL, automate data quality testing, deploy the code, and deliver trusted data with data documentation side-by-side with the code

·        In-depth understanding of Snowflake Schema, Database, Table structures , External tables and Stages.

·        Creating data ingestion framework in snowflake for both batch and Realtime data from different file format ( json) using snowflake stage and snowflake pipe.

·        Experience in using snowflake and time travel and different Types of tables snowflake.

·        Develop SQL queries in Snow SQL.

·        Develop transformation logic using snow pipeline.

·        Extensive expertise in designing and development of applications utilizing of oracle, SQL and UNIX Shell Scripting.

·        Working on List of AWS services like EC2, EMR, IAM, S3, Spectrum, Redshift Database, Glue, Athena.

·        Having knowledge on data warehouse concepts like star schema, snowflake, dimension and Fact tables.

·        Using Physical data model creating the technical design documents and solution architecture specifications.

·        Analyzing the Data dictionary applying the compression techniques, sort key and distribution key.

·        Having knowledge Amazon redshift database for implementing the SCD Type-1 and Type-2.

·        Worked on AWS SCT for migrating the object from one database to another database.

·        Worked on AWS S3 file loading using AWSCLI copy command and SDK.

·        Knowledge on Snowflake Data warehousing.

·        We used to schedule job using crontab scheduling tool.

·        Experienced in Data warehouse development working with extraction transforming loading using Informatica with data bases like Oracle, Teradata, Sysbase and Flat Files.

·        Designing various mappings using different transformations like joiner, lookup, router, aggregator etc.

·        Extensively used Informatica client tools like source analyzer, target designer, mapplet designer, mapping designer, task developer, workflow manager and workflow monitor.

·        Involved in unit testing which we develop the mapping to achieve the business logic and involved in Unit test case document.