NAVYA KALAPALA
Summary
Results-driven Software Engineer with over 10 years of experience, specializing in end-to-end data warehousing and cloud migration. Expert in designing high-performance ETL pipelines using Snowflake. Proven ability to modernize data architectures, reducing query latency and optimizing costs. Skilled in leading teams, implementing data governance, and transforming complex raw data into actionable business intelligence.
Overview
10
10
years of professional experience
Work History
Data Engineer
Cognizant Technologies Solutions
02.2022 - Current
- Proficient with Snowflake's cloud data platform and its features, such as Snowpipe, Time Travel, Failsafe, Zero-Copy Cloning and Snowflake Cortex AI.
- Optimized complex SQL queries, enhancing Snowflake warehouse performance by 25%.
- Established data security policies using Role-Based Access Control (RBAC) and dynamic data masking.
- Designed and implemented scalable Snowflake data models reducing data processing time by 30%.
- Developed comprehensive ETL pipelines to ingest data from legacy Oracle systems into Snowflake, supporting large-scale cloud migration projects.
- Migrated on-premises data warehouse to Snowflake cloud platform, resulting in 3x performance improvement for core business reporting.
- Developed Snowflake UDFs to streamline complex transformations
Informatica Developer
Tata Consultancy Services
10.2015 - 01.2022
- ETL – Creating workflows as per requirement, maintaining historical data, data equivalence in ETL and MDM dbs, scheduling jobs, working with QA to resolve production issues, performance tuning for existing jobs
- Migrating informatica objects, parm files, scripts using Git Hub and Jenkins, Discussions with client for clarifications on requirements, Creating incidents on issues with Database or informatica tool
- Documenting user requirements, translating requirements into system solutions and developing implementation plan and schedule
- Extracting data from excel files, high volume of data sets from data files, Toad DB2 using informatica ETL Mappings/SQL and loaded to data store area
- Creating and monitoring batches and sessions using informatica Powercenter server
- Working with various transformations, like router, expression, SQL, lookup, normalizer, and aggregator, in building complex mapping.
- Extensively involved in writing SQL queries (sub queries and join conditions)
- Developed shell scripts for scheduling jobs in UNIX environment.
Education
Bachelor of Technology - Electrical and Electronics Engineering
UCEK, JNTU KAKINADA
Skills
- Snowflake
- AWS
- Python
- Informatica 1053
- SQL
- UNIX shell scripting
- Autosys
- GitHub
- Jenkins
Timeline
Data Engineer
Cognizant Technologies Solutions
02.2022 - Current
Informatica Developer
Tata Consultancy Services
10.2015 - 01.2022
Bachelor of Technology - Electrical and Electronics Engineering
UCEK, JNTU KAKINADA