Saradhi

About Saradhi

• 12 years of IT experience in the field of Data warehousing in tools like Informatica 8x, 9x, 10x Power Center ,Developer (IDQ),Analyst,BDM,AWS,Cloud, Oracle,Teradata,SQL Server and UNIX Shell Scripting. • Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse. • Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects. • Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data. • Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems. • Hands on Labeling, Standardization, validating address using Address doctor by Informatica Developer of IDQ. • Experience in designing error and exception handling procedures to identify, record and report errors. • Extensive Experience in developing and performance tuning of informatica mappings • Worked extensively in onsite (client location and having exposure of direct involvement with client).` • Created source to target mapping documents for input into ETL specifications by Identifying, analyzing data sources • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies. • Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules • Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner. • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting • Experience in testing the data using debugging mapping method. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations. • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions. • Proficient in Creation of re-usable mapplets, Transformations using various transformations of Informatica. • Notification of the session is implemented through the Emailing. • Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database. • Experience in developing Shell Scripts on UNIX and experience with UNIX command line. • Involved in Informatica Interview Panel and taken interviews to the external and internal resources. • Created unit test cases to test data loads and check whether the components adhere to the technical design • Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues. • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions. • Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.