Juhi

• Having around 2 year hands on experience in using IDQ and knows the ETL concepts used in Power Center.

• Strong knowledge on IDQ Developer

• Extensive experience with IDQ tool in designing and developing Mappings, Mapplets, Transformations, Workflows, Applications and scheduling the Applications

• Experience in Extracting, Transforming and Loading (ETL) data from relational object and Flat file

• Extensively developed Complex mappings using various transformations such as Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Sorter, Normalizer, Joiner, Update Strategy, Union, Rank, Sequence Generator and more.

• Worked on IDQ parsing, IDQ Standardization, matching, IDQ web services.

• Experience on data profiling & various data quality rules development using Informatica Data Quality (IDQ).

• Worked with Informatica Data Quality(IDQ) 9.1 for data cleansing, data matching and data conversion

• Created PDOs, CDOs and LDOs

• Created reusable components, reusable transformations and mapplets

• Experience in using the Informatica command line utilities like infacmd to execute workflows and mappings

• Developed mappings for Type 1, Type 2 Slowly Changing Dimension (SCD).

• Worked with mapping Logs, Workflow Logs, Application logs and data viewer for Error Handling and Troubleshooting in all environments.

• Imported the mappings developed in data quality (IDQ) to Informatica designer

• Extensively used Informatica Data Quality transformations – Labeler, Parser, Standardizer, Key Generator, Match, Comparison, Association, Consolidation, Merge, Address Validator, Case Converter, and Exception

• Complete understanding of regular matching, fuzzy logic and dedupe limitations on IDQ suite

• Involved in Data Profiling using Informatica Data Quality (IDQ).

• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data

• Involved in deployment of jobs and code migration to the production environment.

• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them

• Created profiles and score cards for the users using IDQ

• Worked with SQL queries to create Tables, Views, CRUD operations and joins

• Strong analytical, problem-solving, communication, learning and team skills