Summary
Work History
Education
Skills
Timeline
Generic

SHAINA DAVITA

Chennai

Summary

Professional with over 3+ years of experience in SQL, ETL, and data management tools including Informatica PowerCenter, DB2, and Oracle Database. Proven ability to enhance data integrity and streamline workflows, resulting in improved processing efficiency. Strong analytical skills applied to solve complex business challenges effectively. Committed to delivering high-quality data solutions that drive organizational success.

Work History

Informatica Powercenter

TCS
  • Familiar with PowerCenter Designer, Workflow Manager, Workflow Monitor, and Repository Manager components.
  • Done designing, developing, and maintaining ETL workflows and mappings between source systems and warehouse components, with the help of various transformations for the migration of data from legacy systems to Guidewire via Snowflake.
  • Ability to optimize ETL processes for performance by tuning mappings, workflows, and PowerCenter session properties.
  • Documented to describe program development, logic, coding, testing, changes, and corrections.
  • Optimized SQL queries and database schemas for performance improvements in data retrieval operations.

Oracle SQL Developer

TCS
  • Extracted test data for source and target tables to support changes in the ETL process.
  • Strong SQL skills and familiarity with Oracle SQL developer. Ability to write complex SQL queries.
  • Validated data accuracy and consistency after informatica mapping changes through SQL based testing and analysis.

Service Account Migration and testing

TCS
  • Assisted in the migration of service accounts, ensuring proper access and authentication across applications and services.
  • Collaborated with the team to implement security measures during the migration process, minimizing downtime and ensuring data integrity.
  • Conducted thorough testing of Java-based applications, verifying functionality and performance after implementing changes to service account configurations.

Education

BE - ECE

Ramco Institute of Technology
Rajapalayam
04.2021

HSC -

Rose Mary Matric .Hr. Sec. School
Tirunelveli
04.2017

Skills

  • Informatica Powercenter
  • Performance tuning
  • Data validation
  • Oracle SQL Developer
  • ETL Development
  • Eclipse
  • Kibana Elastic
  • DB2
  • Java Basics
  • Unix
  • Putty
  • Guidewire Basics

Timeline

Informatica Powercenter

TCS

Oracle SQL Developer

TCS

Service Account Migration and testing

TCS

BE - ECE

Ramco Institute of Technology

HSC -

Rose Mary Matric .Hr. Sec. School

Similar Profiles

CREATE PROFILE
SHAINA DAVITA