Consultant with over **+ years of experience in Snowflake database, AWS cloud computing services along with ETL tools (AB Initio and Informatica Power center /MDM).
In-Depth understanding of core concepts for Public/Private/Hybrid clouds AWS & GCP.
Experience working with Technical Support Group, Database Administration Group, Product Development Group, and Professional Services Group to drive most optimal solution architecture within each client implementation
Good Understanding of storage systems, Linux kernel, UNIX kernel, UNIX file system, and Windows infrastructure
Possesses adequate working hands-on knowledge on AB Initio, Informatica power center, Teradata and snowflake Utilities.
Expert knowledge in implementing snowflake service like cloning, data sharing, stages, RBAC controls and warehouse re-sizing.
Expert knowledge in snowflake data modeling, ELT using snow Sql and data migration from on premises warehouse to snowflake warehouse.
Expert knowledge of integrating snowflake with Hive, loading and unloading data to and from snowflake using ETL tools with Ab initio and Informatica and external sources like AWS Data Lake.
Expert knowledge in snowflake utilities like snow-pipe, workflow and stream for continuous data loading.
Good understanding and working knowledge in AWS Cloud computing services like (data lake, CRC, Rehydration, ec2, SNS, SQS, Athena, glue, Lambda and ELK)
Strong hands on experience in Python.
Possesses adequate and working knowledge on Hadoop batch integration on HDFS, Hive and Sqoop.
Sound understanding of Spark and Scala.
A good working knowledge on Informatica MDM.
Good understanding on Automic and Tivoli scheduler.
Gained exposure in working on BFSI Domain.
Oracle 10g, Teradata, Snowflake, SQL
ETL Tools & Utilities
AB Initio,Informatica power center9 & 10, Informatica MDM, Informatica Cloud
HDFS, Pig, Hive, Sqoop, Oozie, Scala,
Amazon Web Service (S3,EC2, SNS, SQS,DATA PIPELINE, ATHENA,EMR)
Managing requirement gathering, system analysis and finalization of technical / functional specifications.
Defining best practices intended for project support and documentation.
Designing, developing, testing, troubleshooting and debugging of the applications using different technologies.
Conducting smooth implementation and testing of application at client location.
Providing post-implementation, application maintenance and enhancement warranty support to the client.
Cooperating & communicating with other team members for efficient project work.
Clients: PNC Bank
Role: Snowflake and ETL Senior Developer, September 2018 to Current
Description: PNC Bank is in process to migrate on premises infrastructure including applications to Amazon web services along with adopting new cloud technologies.
Migration of Teradata and DB2 to Snowflake database using AWS.
Loading data to AWS S3 bucket.
Loading data from AWS S3 bucket to Snowflake database using snow-pipe.
Continuous data loading into snowflake using snow-pipe, capturing CDC using stream.
Ab initio code changes to read and write data to and from S3 bucket.
Ab initio & Informatica code migration to Spark and Scala.
Informatica code migration to AB initio.
AB Initio, Informatica Power Centre
Teradata,Oracle, Snowflake database
AWS Cloud computing
Roles & Responsibility:
Converting HLD into LLD and providing solution.
Snowflake Data modeling and implementing the star and snowflake schema.
Migrating data from existing warehouse from Teradata to snowflake warehouse.
Snowflake data warehouse management using various services and utilities like (snow-pipe, stream, cloning, data sharing, ware house resizing)
Responsible to configuring various cloud services like (IAM users & role, policies, Bucket, Athena, Glue and EMR, ELK).
Configuration of File gateway using services (S3, SNS, SQS, Lambda and CRC).
Looking into performance issues of Ab initio on cloud.
Creation and configuration of S3 buckets and directories.
Rehydration process for ec2 instances.
Data Lake management.
Lift and shift Ab initio ETL processes on AWS EC2 service.
Responsible for end-to-end code migration.
Interacting with business to understand requirement.
Clients: Option Clearing Corporation
Role: Senior Developer, July 2015 to August 2018
Description: The Option Clearing Corporation is under process to migrate various Option application from on premise to AWS cloud using lift and shift process with a technology migration from Informatica to Ab initio and (Teradata and Oracle ) to Snowflake database.
MDA Citi (Remortgage, Purchase, Further Advance)
MDA alerts application
MDA Data Lake in Hadoop
KYC (Know your customer)
Informatica to AB initio migration
Informatica, AB Initio
AWS Cloud Services
Oracle, SQL Server,Teradata and snowflake Utilities
Shell and Python Scripting
Roles & Responsibilities:
Data model design and implementation using snowflake.
Co-Ordination with Business users and collecting requirements.
Code migration from Informatica to AB Initio.
Data loading from oracle and Teradata to AWS Data Lake and snowflake data warehouse using ETL tool AB initio and Python.
Providing ETL Designs and technical solutions
Snowflake Cost and Effort estimation.
Responsible for code review.
Review of schedules and jobs creation on Tivoli.
Helping team in test case preparation.
Impact analysis for enhancement.
Project Documents preparation.
Responsible for deliverables.
Clients: Wells Fargo
Role: Senior ETL Developer, January 2013 – June 2015
Description: Wells Fargo is in the process to decommission of their EDW system called prime for Germany and Spain country and implementing the new vision plus card system integrating with 6 other applications in place of prime. Prime contains around 13 years of data which is to be migrated from Oracle database to Teradata database. Project involves below activities
History Migration (13 years of Legacy data from Oracle to Teradata).
AnP (Acquire and Publish of vision Plus files after files validation)
CDC (Change data capture)
Data Extraction (3rd party)
Data Transfer over network (HTTP)
Roles & Responsibility:
worked as a Module lead
Doing Impact Analysis for any change in the code.
Code review developed by the peers.
Informatica workflows Schedules and Jobs creation in Tivoli.
Assigning work task among team members.
Converting HLD (high level design) into mapping document for code development
Responsible to create the LLD document.
Knowledge transfer to support team.
Providing warranty support to client on developed modules.
Coordination with other team members for (SIT, OAT, VPT, and PROD) code implementation.
AB Initio, Teradata, Oracle, Linux, MQ, Tivoli Scheduler
Clients: Provident Bank
Role: Developer, March 2010 to Dec 2012
LAS, DC Monitoring system, HRMS Training tracking system, Fraud Alert System, Payment Collection, GPPS, projects done in Pl / Sql & Java /J2EE Technology
Team Size:- 20
Responsibility: Application Development, Requirement gathering, Single Point of Contact, Responsible for module
Technology: - Oracle Pl /sql, Informatica 8.6, J2EE
Anil Vakkalanka (US Citizen)
Email ID- firstname.lastname@example.org / Ph:773-***-****