Kiran Bethamcherla

Around 18 years of experience in the areas of finance, royalty, credit cards, retail, and investment domains.

Expertise in data modeling, data analysis, data integration, star schema, snowflake schema, dimensions, and fact tables. Worked extensively with all Informatica components, including IDQ, Power Exchange, Power Center, IICS, and MDM implementations. Implemented data ingestion strategies in Snowflake using Python and DBT models and macros. Solid experience and understanding of implementing large-scale data warehousing programs and end-to-end data integration solutions on Snowflake Cloud, Azure Databricks, and Informatica PowerCenter integrated with multiple relational databases (MySQL, Postgres, Oracle, Sybase, SQL Server, DB2). Experience in data migration from DB2, Postgres DB, to Snowflake cloud data warehouse, and Azure SQL database. Experience in using Snowflake features: zero-copy cloning, data sharing, bulk loading, external tables, partitioning, and ETL workflows. Knowledge and experience in S3 AWS services, and managed policies for S3 buckets. Used S3 bucket and Glacier for storage and backup on AWS. Experience in granting permissions, managing resources, and providing permissions to users in AWS IAM. Experience in Python programming for data processing and handling data integration between on-prem and cloud databases or data warehouses. Designed Apache Kafka streaming to read data from various sources, and send it to data pipelines. Had knowledge of open-source Kafka by creating topics using consumers and producers to ingest data into applications. Experience in working with Unix Shell, Perl, and Python scripts. Proficient in using Python libraries, such as Pandas and NumPy, for data analysis. Experience in designing and building data architecture on Azure, and using its services like Azure Data Lake, Azure Databricks, and Azure SQL Data Warehouse. I used OpenAI to prepare business need statements based on keywords used in search optimization and ranking. Working on an AI model to create applications and APIs for vendors, reducing the workforce and time by more than 50%. Load tested the applications with virtual users ranging from 25,000 to almost 1 million. Designed the system architecture, implementation, and integration of microservices for real-time, customer-facing applications.