Sai Sarath Kakani

Data Migration/Data Conversion Developer at CGI

Role
Senior Consultant at CGI
Location
Richmond, VA, US
LinkedIn followers
500 followers
Information TechnologyView LinkedIn profile

About Sai Sarath Kakani

Experienced IT professional with 14+ years of expertise in Data Migration, Data…

Experience

  1. Senior Consultant

    CGI

    Sep 2018 — Present · Richmond, VA, US

    Designed and built a core framework within Snowflake to standardize metrics collection and error logging, ensuring consistency and reusability across all team projects.•Coordinated with the business analysts to gather the mapping from Legacy sources such as DB2 and SQL Server to migrate to Snowflake, Salesforce. •Designed and implemented sophisticated Snowflake stored procedures to streamline and manage crucial data transformation and mapping tasks.•Developed and deployed DataStage ETL processes to extract and load data from DB2 and SQL Server into the centralized Snowflake Landing Zone.•Managed and executed all aspects of IBM Cloud administration, specifically creating and overseeing access groups to ensure precise and compliant user permission assignments.•Drove the implementation of the IBM Satellite Connector and deployed Podman/Docker containers to establish secure hybrid-cloud connectivity. This effort successfully integrated cloud services with on-premises databases like SQL Server and Db2.•Developed scripts to automatically format IBM Cloud activity logs, enabling their seamless forwarding and ingestion by Splunk for analysis.•Collaborated with the Okta team to successfully integrate IBM Cloud with SAML authentication, streamlining user sign-on processes.•Provided technical expertise and training to junior staff in the areas of Snowflake Stored Procedure development and DataStage flow design.•Managed communication with IBM support for the prompt identification and resolution of DataStage defects and system issues.•Understanding the system and functional specifications of the Legacy Child Welfare Application module to convert it to the new application specifications. •Supported the testing team for faster resolution of the defects.•Coordinated with MuleSoft team to migrate data from Snowflake to Salesforce.•Document the test case scenario steps followed for various tasks for specific module.

Find verified contacts for anyone on LinkedIn

Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.

Free plan included · No credit card required

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Sai Sarath Kakani — Senior Consultant at CGI in Richmond, VA, US | Unifers