Srilatha Potnuru

Worked with ETL tools. Troubleshooting skills including installation and configuration of Informatica. Worked with Informatica PowerCenter client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager. Developed and maintained ETL mappings to transfer data from source systems to staging areas and then into the data warehouse. Designed data mappings between source systems and warehouse components using Mapping Designer. Used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Union, etc. Performed performance tuning of slowly running ETLs in production by identifying bottlenecks and resolving problems. Used ETL to load data from flat files (fixed width and delimited) and relational databases. Strong knowledge of SQL scripting, including queries, stored procedures and data transformations. Unix concepts: Familiarity with Unix commands, shell scripting, and basic system operations. Proficient with Git and Jenkins.

Worked with ETL tools and gained experience in installation and configuration of Informatica. Used Informatica PowerCenter client tools including Designer, Workflow Manager, Workflow Monitor, and Repository Manager. Developed and maintained ETL mappings to transfer data from source systems to staging areas and then into the data warehouse, and designed data mappings between source systems and warehouse components using Mapping Designer. Employed common transformations such as Source Qualifier, Aggregator, Expression, Lookup, and Union, and built ETL workflows to extract, transform, and load data for analytics. Performed performance tuning for slowly running ETLs by identifying bottlenecks across sources, targets, mappings, and sessions, and resolving problems. Loaded data from flat files (fixed width and delimited) and from relational databases. Relied on SQL scripting including queries and stored procedures, and used Unix shell commands. Gained experience with Git and Jenkins in produ