Kotimareddy Rajesh
Senior Engineering Lead @ Persistent Systems Limited - Snowflake | Oracle | SQL | PL/SQL | Performance Tuning | Data Warehousing
- Role
- Senior Engineering Lead at Persistent Systems
- Location
- Hyderabad, TG, IN
- LinkedIn followers
- 500 followers
About Kotimareddy Rajesh
Software Development Engineer with 7.7 years of experience in IT industry, specializing in Database programming and Data warehouse technologies with SDLC (Waterfall, Agile) Methodologies.• Passionate about improving database performance and transitioning into data engineering by leveraging cloud technologies and modern data platforms to build high-performance and scalable data solutions.• Experienced Database Engineer with 5.8 years in Oracle Database development and around 2 years in Snowflake data warehouse technologies.• Proficient in writing UDFs, UDTFs and Procedures in Snowflake using Snow SQL.• Ability to use AWS cloud technologies (EC2, S3, Lambda) to integrate with Snowflake for efficient data ingestion, transformation and storage.• Capable of monitoring and managing the Airflow DAGs for orchestrating ETL/ELT workflows both in Stream and Batch processing.• Good in using Streams and Tasks to automate incremental data processing and to implement Change Data Capture (CDC).• Have good understanding of snowflake features such as Snow pipe, Time Travel, Zero Copy Cloning and Dynamic Tables.• Adept in writing SQL queries in Oracle 12c/18c/19c based on business requirement.• Clear understanding of SQL analytical processing capabilities (OLAP Features) and analytical functions.• Strong knowledge on performance optimization techniques including Indexes, Materialized Views, Query Optimization and Performance Tuning.• Proficient in database programming using Stored Procedures, Stored Functions, Packages, Cursors and Triggers with advanced PLSQL concepts.• Extensively worked on Dynamic SQL by creating complex PLSQL objects.• Expertise in debugging the code to find the RCA and good at handling exceptions in PLSQL blocks.• Able to do efficient data manipulation and high-performance processing using advanced PLSQL concepts such as Collections, Records, Bulk Collect and FOR ALL operations.
Experience
Senior Engineering Lead
May 2025 — Present · Hyderabad, IN
Education
Andhra University
Master of Science - MS, Physics
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.