Srinivas Pothula
Snowflake Migration Expert
Hire this person
Send a job offer directly to this candidate
About
Over 23+ year/(s) of IT industry experience, Led a max of 20+ team member teams, worked in projects of Business Intelligence, Data warehousing including Cloud migration projects. Involved in software life cycle phases of data warehouse projects like Initiation, Study, Design, Develop, Test, Change & Configuration management in all SDLC phases. Good exposure to BFSI, Oracle ERP, Customer data profile, Data Quality frameworks and Insurance Analytics.
Experience
Software Projects – Architect - Wipro Ltd - Bangalore
(2019-05)
Clients/Consultancy: CapitalOne, Ciena Corp & Apple Corp, Medtronics, MPG Global, NT Finance, Belron Optum USA Insurance. Type of Company: Information Technology Services. Roles Playing/Played: Designer, Certification SME, Senior Migration Analyst, Senior Data Analyst/Sr. Developer.
- Analyze customer requirements, Design customer approve, Implement ETL data Ingestion model for ingestion of different source systems data for the purpose of cost save.
- Migration and Re-Engineer project from different source systems like Teradata, Oracle & SQL Server to Snowflake(SF) Computing database on AWS.
- Replication of data using Informatica Intelligent Cloud Services (IICS) from above said source systems.
- Written batch scripts to rename csv source files (IICS has a limitation to keep one source file name) and archive the data.
- Analysis, Design, Development & Testing of existing on-Premise Informatica mappings and design/conversion of mappings/Workflows to Incremental Views and subsequent loading of data using Snowflake Tasks (MERGE/DELETE) scripts as requested by client.
- Written SF stored procedures with error handling capabilities.
- Written re-usable UDTF functions in snowflake.
- Used JIRA application for tracking issues to resolution.
- Attend daily scrum discussions and team gather discussions.
Education
Snowflake certified Core certification - Snowflake Computing Inc (2020-05 - 2020-05)
Executive MBA - Information Systems - Manipal University (2014 - 2014)
Four year full-time Bachelor of Engineering - Civil - Rajasthan University, Malaviya Regional Engineering College (1995 - 1995)
Corporate course on NCR Teradata V2R3 Factory - NCR (2001-07 - 2001-07)