Sneha Rao

Informatica Cloud Lead for an ETL module-based project, supervising 4-6 developers. Design and build multiple ETL interfaces with multiple interfaces . Implemented audit logging mechanism captures log details of executed Interfaces in Snowflake DB. Supporting successful deployment in a Production environment at an On-shore client location in the Netherlands. Interaction with Clients to understand business scenarios, translate them into technical requirements. The conception of high-level design.

• Supporting System Integration for merger of 2 SAP client systems at different geographical locations into a single system. • Development of mappings in Informatica PowerCenter as per design specifications. Enhanced performance of session by adopting session level partitioning. • Translating requirements into software detailed design documents, creating technical documents and unit test case documents. • Extensive use of Waterfall development model.

• Code development as per required business logic in mappings using various transformations in Informatica PowerCenter. • Automating workflow execution using Control M. • Implementing SQL for complex scenarios during Universe creation. • Report creation using SAP BOXI. Design and development of Universe and reports for each application. • Creation of Derived Tables to resolve Chasm trap in Universe.