Satyavathi R.

About Satyavathi R.

12+ Years of experience as Senior Data Engineer with designing and implementing robust…

Experience

1. Assistant Consultant

   Tata Consultancy Services

   Feb 2019 — Present · Plano, TX, US

   Architect, build and deploy scalable etl solutions both on premise and cloud platforms.• Worked in converting Informatica PowerCenter ETL code to IICS using PC to Cloud Conversion service.• Involved Performance tuning by optimizing the mappings and mapping tasks.• Developed a script using Run a job Cli utility to automate job execution and scheduled task flows using Control-M• Coordinate with offshore development team to identify priority and update scope and delivery schedule.• Involved in code migration process to higher environments and code validation after the code migration.• Hands on development using Informatica PowerCenter 10.5, SQL server, Oracle, Windows, and Linux based environments.• Develop database partitions and performance tuning mechanisms.• Tune ETL code for long running jobs using partitioning methods within PowerCenter.• Experience creating business services component with multiple operations and use the same within webservice transformation to call several types of webservice calls as part of data integration efforts between disparate sources systems. Participated in warranty service and production support in rotation basis.• Hands on with performance tuning techniques. Implemented and documented coding best practices for ETL and stored procedures. Proven problem-solving skills aimed to achieve optimal data load solutions.• Design and develop efficient error control and auditing mechanisms, data recovery strategies, generic code packages for reusability.• Conduct code review sessions and encourage peer to peer interaction in establishing efficient coding practices.• Upgraded Informatica PowerCenter from version 10.4.2 to 10.5.2. This involved backing up data, installing the new version, and importing existing configurations. After testing and resolving any issues, we transitioned to the updated system.