Swarnalatha Ponnuru

Responsibilities:

• Designed, developed, validated, and deployed the ETL Mappings using the Informatica Informatica CDI.
• Developed various Data quality and Data Validation rule.
• Worked on Error handling mechanism after applying data quality and data validation rules.
• Worked on mapping to load data in B360 with the help of Ingress job.
• Responsible for monitoring all the session that are running, scheduled, completed, failed and debugged the mapping of the failed session.
• Extracted data from multiple operational sources and loading into Staging Area, Data Warehouse and Data Marts using CDC (Power Exchange).
• Worked in Agile methodology.

Responsibilities:

• Analysing Client data by Profiling, and Preparing presentation for business understanding.
• Implemented Data validation rules and Data Quality rules using CDI mappings.
• Worked on transformations like router, expression, filter, lookup, joins, aggregator to load date in B360
• Perform Ingress job to load date in B360 using CDI mappings and Business360.
• Worked on Task Flow for Performing Delta load and scheduling them with Notification mechanism.
• Wrote and optimized in-application SQL statements.

Responsibilities :

• Analyze the source data coming from different sources and working with business users and develop the DW
• Model
• Implemented the DW tables in a flexible way to cater the future business needs
• Project release support and fixing postproduction issues
• Testing and coordinating effort for any Hardware or Software Upgrades
• Maintaining Databases Space and Estimate Capacity Growth for REM
• Developed ETL scripts using Teradata Utilities like BTEQ, Mload, Fastexport, Fastload
• Performance optimization for Teradata ETL queries and User queries by reviewing the Indexes, Statistics, joins and explain plans.