Worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, and Flat files.Strong experience in Data Warehousing and ETL using Informatica Power Center (9.6.1/10.2.8/10.5.1)Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.Responsible for all activities related to the development, implementation and support of ETL processes for large scale data warehouses using Informatica Power Center.Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.Extensive experience in ETL design, development and maintenance using Oracle SQL.Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.Well versed in UNIX shell scripting.Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files. Responsible for all activities related to the development, implementation and support of ETL processes for large scale data warehouses using Informatica Power Center.Proficiency in developing SQL with various relational databases like Oracle, SQL Server,Sybase,Netizza, Redshift and SQL workbench.Understand the business rules completely based on High Level document specifications andimplements the data transformation methodologies.Independently perform complex troubleshooting, root-cause analysis and solution development.Transformed, prepared, and cleaned data for analysis by using AWS GlueCreated many Python scripts as per the business requirementsCreated and monitored data pipelinesIdentified Changes in existing production Pyspark Scripts
-
Senior Specialist Data EngineerLtimindtree Oct 2024 - PresentBengaluru, Karnataka, IndiaAWS, Python, Terraform -
It AnalystTata Consultancy Services Nov 2020 - Nov 2024Bengaluru, Karnataka, IndiaProject : TataPlay DTH• ·Developed ETL programs using Informatica to implement the business requirements.• ·Created shell scripts to fine tune the ETL flow of the Informatica workflows.• ·Used Informatica file watch events to pole the FTP sites for the external mainframe files.• ·Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.• ·Designed workflows with many sessions with command task, event wait tasks, used informatica scheduler to schedule jobs.• ·Identified problems in existing production data and developed one time scripts to correct them.• Project : TataPlay Fiber• ·Transformed, prepared, and cleaned data for analysis by using AWS Glue.• ·Created many Python scripts as per the business requirements.• ·Identified Changes in existing production Pyspark Script. -
System EngineerTeamware Solutions A Division Of Quantum Leap Consulting Pvt. Ltd Apr 2016 - Nov 2020Bengaluru, Karnataka, India Developed ETL programs using Informatica to implement the business requirements. Communicated with business customers to discuss the issues and requirements. Created shell scripts to fine tune the ETL flow of the Informatica workflows. Used Informatica file watch events to pole the FTP sites for the external mainframe files. Production Support has been done to resolve the ongoing issues and troubleshoot theproblems. Performance tuning was done at the functional level and map level. Used relational SQLwherever possible to minimize the data transfer over the network. Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluatingtransformations. Effectively worked on Onsite and Offshore work model. Designed workflows with many sessions with command task, event wait tasks, usedinformatica scheduler to schedule jobs. Reviewed and analyzed functional requirements, mapping documents, problem solving andtrouble shooting. Identified problems in existing production data and developed one time scripts to correct them. Fixed the invalid mappings and troubleshoot the technical problems of the database. -
Technical Project CoordinatorInknowtech May 2015 - Mar 2016Bengaluru, Karnataka, India Work closely with project manager planning projects and preparing documents Prepare financial and progress reports and communicate information about these to relevantstaff Communicate requirements to relevant departments and employees to keep progress ontrack Created monthly and weekly progress reports and communicated results to appropriate staff Performed general office support and administrative tasks as requested, including answeringand directing phone calls Proficient in Microsoft Office – Excel, Word, PowerPoint -
Technical Support EngineerNebula Consulting Ltd Jul 2014 - Mar 2015Bengaluru, Karnataka, India● Measuring, monitoring and reporting on customer satisfaction and vendor performance andimplementing continuous improvement strategies● Monitor and report on the performance of vendors to ensure delivery in line with contractualobligations and performance metrics● Plan and conducts regular performance reviews with each major third-party provider alongwith relevant technology stakeholders● Conduct third party audits and manage the remediation of third party audit findings andmanagement responses● Identify improvement areas internally as well as perform closely with all internal stakeholdersto prepare solutions● Developing the strategic MIS reporting proposal to define the end state reports and obtainmanagement approval● Coordinate all vendor management tasks inclusive of working with external vendors andinternal employees
Kavya R Education Details
-
Apj Abdul Kalam UniversityA
Frequently Asked Questions about Kavya R
What company does Kavya R work for?
Kavya R works for Ltimindtree
What is Kavya R's role at the current company?
Kavya R's current role is Senior Specialist Data Engineer.
What schools did Kavya R attend?
Kavya R attended Apj Abdul Kalam University, Sri Venkateswara College.
Not the Kavya R you were looking for?
-
Kavya Shree
"Dynamic Mba Candidate With Expertise In Hrm, Finance, And Strong Communication, Adaptability, And Leadership Skills"Bengaluru
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial