Saikrishna Mamidishetty
Pune,Maharashtra
Summary
Solutions-oriented Technical Architect with a proven track record, specializing in Snowflake Datawarehouse and ETL Operations. Expert in leveraging AWS and Azure Cloud Technologies to drive data governance and efficiency. Demonstrates leadership by effectively managing teams and fostering client relationships, ensuring project success and innovative solutions.
Overview
15
15
years of professional experience
1
1
Certification
1
1
Language
Work History
Technical Architect
Xoriant Technologies
Pune
03.2024 - Current
- FoundryCo (Domain: Media, Data and Marketing)
- Designed and Implemented Common Data Model
- Implemented CI/CD pipeline via Bitbucket and Liquibase
- Deciding the size of Virtual warehouse in Snowflake for non-production and production environments
- Defining data governance policies for data warehouses
- Creation of Databases and Schemas
- Implemented SSO via Azure AD
- Creation of roles and users and granting the same to various objects within Snowflake
- Implementing Snowpipe for data extraction and loading using internal and external stages
- Regular client interactions for understanding the business use case and provide the solution accordingly
- Co-ordinate with QA Team on testing the changes.
Lead Consultant / Architect
Compusolutions, Illumina Inc
Pune
06.2023 - 02.2024
- BioTech)
- Regular client interactions for understanding the business use case and provide the solution accordingly
- Co-ordinate with Business users on testing the changes
- Solution Architect for Data platform to provide on-cloud (Snowflake) data warehouse
- End to end design of Data platform which includes connection of source systems through integration, storage and ETL layers till data warehouse
- Deciding the size of Virtual warehouse in Snowflake for non-production and production environments
- Defining data governance policies on data warehouses
- Creation of Databases and Schemas
- Loading the structured, semi structured data
- Creation of roles and users and granting the same to various objects within Snowflake
- Implementing Snowpipe for data extraction and loading using internal and external stages
- Defining data masking policies in snowflake
Sr Technical Specialist, Snowflake Dev / Architect, ETL Developer
Zensar Technologies
Basingstoke, Pune
12.2018 - 06.2023
- The AA (Domain: Insurance)
- Provide guidance to development team & provide input for periodic performance evaluation
- Managing and leading a team of 4 Developers
- Regular client interactions for understanding the business use case and provide the solution accordingly
- Preparing the understanding document which can be used by developer to understand the business requirements
- Co-ordinate with Business users on testing the changes
- Solution Architect for Data platform to provide with on-cloud (Snowflake) data warehouse
- End to end design of Data platform which includes connection of source systems through integration, storage and ETL layers till data warehouse
- Deciding the size of Virtual warehouse in Snowflake for non-production and production environments
- Loading the structured, semi structured data
- Implementing Snowpipe for data extraction and loading using internal and external stages
- Use of SnowSQL for creating user defined functions
- Defining data masking policies in snowflake
- Promoting code from lower environment to higher environment
Technical Lead
KPIT Technologies, Cummins Inc
Pune
04.2016 - 11.2018
- (Domain: Manufacturing)
- Contributed in Extraction, Transformation, Loading of the data using Informatica tool
- Oracle and Flat files are used as sources, Target-Oracle
- Installing, maintaining, and taking repository backups for Informatica
- Created sessions, database connections and batches using Informatica Workflow Manager
- Involved in unit testing for data consistency and quality
- Used pmcmd command to run workflows from command prompt
- Created Worklets and Workflows
- Analyze enhancement mappings and modify those mappings
- Extensively worked in the performance tuning of the Informatica mappings
- Used tasks like Session, Email, and Command etc
- Cummins is one of the biggest manufacturers of diesel engine across the globe
- This project deals with inventory, sales and finance for 17 distributors across US and Canada
Software Engineer/Technical Lead
KPIT Technologies, Cummins Inc
Pune
10.2009 - 04.2016
- (Domain: Manufacturing)
- Cummins is one of the biggest manufacturers of diesel engine across the globe
- Monitoring the incident from BMS Distributor business users and distributing them across the team member as per their knowledge and availability
- Provide expert solutions to complex and urgent customer problems with highest accuracy in brisk manner
- Routing the Incidents to specific groups which are not under the scope
- Addressing the customer issues/problems using Incident Management tool - Remedy by acknowledging the incident
- Conducting the meeting with customer to understand the issue/problem in detail to provide the best resolution
- Cooperating with team members for quicker query resolution of customer queries with first attempt
- Working with the third-party vendors which have interfaces with BMS application
- Analysis, Integration and Testing of BMS application enhancement or bug fix releases
- Conducting the client meetings for requirement gathering of new functionality or new application
- Preparing the understanding document which can be used by developer to understand the customer requirements
- Cummins is one of the biggest manufacturers of diesel engine across the globe
Education
B.E - Computer
Skills
- Snowflake Datawarehouse
- ETL Operations
- AWS
- Azure Cloud
- Informatica Powercenter
- DBT
- Oracle SQL, PL/SQL
- Unix
- Git
- Liquibase
- Hindi:
- Advanced
- Marathi:
Certification
- Snowpro Core Certified (COF-C02)
- AWS Solutions Architect (SAA-C03)
- Microsoft Certified Azure Fundamentals (AZ-900) TRAINING:
- Preparing for Snowpro Advanced Architect Certification
Timeline
Technical Architect
Xoriant Technologies
03.2024 - Current
Lead Consultant / Architect
Compusolutions, Illumina Inc
06.2023 - 02.2024
Sr Technical Specialist, Snowflake Dev / Architect, ETL Developer
Zensar Technologies
12.2018 - 06.2023
Technical Lead
KPIT Technologies, Cummins Inc
04.2016 - 11.2018
Software Engineer/Technical Lead
KPIT Technologies, Cummins Inc
10.2009 - 04.2016
B.E - Computer
Similar Profiles
SHIVANI GULBHAMWARSHIVANI GULBHAMWAR
Software Developer at XoriantSoftware Developer at Xoriant
Shubham CholkeShubham Cholke
Software Engineer at Xoriant SolutionsSoftware Engineer at Xoriant Solutions
Neha SNeha S
Role: Senior Software Engineer | Domain: Banking at Xoriant Pvt LtdRole: Senior Software Engineer | Domain: Banking at Xoriant Pvt Ltd
ASHISH BANAITASHISH BANAIT
ENO-3 / Subject Matter Expert at Credit SuisseENO-3 / Subject Matter Expert at Credit Suisse
Shyam KhamkarShyam Khamkar
Unit Manager - Data Science and Analytics at Bajaj FinservUnit Manager - Data Science and Analytics at Bajaj Finserv