Shiwali Rathi Email and Phone Number

• Overall 8+ years of IT professional experience in Designing, Development, Documenting and Implementation of Data Warehouses & Data marts with Informatica Power center ETL tool along with reporting using various data visualization techniques.• Experienced in multiple projects across Banking, Retail, Insurance and Airlines domains.• Worked with business stakeholders to gather requirements and define business objectives. Produced useful reports to facilitate quick decision making.• Created and Managed Requirement Traceability Matrix (RTM) and Technical Design Documents.• Wrote detailed use cases including Business Rules, Supplementary Specification comprising both functional and non-functional requirement complementing with artifacts.• Comprehensively worked with complex mappings using different transformations like Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.• Skilled to Develop, Test, Tune and Debug the Mappings, Sessions and Monitor the system. • Experienced in writing design documents, mapping documents, validating requirement, perform code review, code tuning.• Performed data analysis and data profiling using SQL on various sources systems.• Experienced to identify the Bottlenecks of data load and tuned it for better performance. • Exposure to Relational and Dimensional Modeling techniques.• Experience with knowledge of writing complex SQL scripts and Adhoc queries for validating data.• Extensive experience working on scheduling tools as Control-m, Autosys• Expertise in developing and implementing best practices, standards, and methodologies for Data Governance. Collaborated with stakeholders to create and maintain an Enterprise Data Dictionary and Data Mapping documents.• Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.