Job Description :
Title: Informatica IDQ Developer
Location: Philadelphia PA
Duration: 6-12 month

Local Candidates Only - InPerson Interview Required

Mandatory Technical / Functional Skills:
Around 7+ years of experience in complete Software Development Life Cycle of Analysis, Design, Development, Testing and Implementation.
Extensively worked on Informatica Data Quality and Informatica Power center throughout complete Data Quality and MDM projects.
Implemented end-to-end tasks effectively throughout the project till its delivery to customer.
Very good proficiency in Informatica Data Quality 9.5.1/9.6.1 and Informatica Power Center 9.x/8.x/7.x
Extensively worked on Informatica Analyst tool 9.5.1/9.6.1 as initial phase.
Good knowledge on Informatica Data Quality Admin tasks as well.
Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
Good skills in analyzing trend charts from score cards to analyze the threshold which is to be considered in further development
Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
Extensively worked on Informatica Power center transformations as well like Expression, Joiner, Sorter, Filter, Router and other transformations as required.
Very strong knowledge on end to end process of Data Quality and MDM requirements and its implementation.
And good experience on Data Warehouse Concepts like Dimension Tables, Fact tables, slowly changing dimensions, Data marts and dimensional modeling schemas.
Dimensional modeling and E-R Modeling and OLTP AND OLAP in Data Analysis.
Very familiar with SCD1 and SCD2 in snowflake schema and star schema.
Strong expertise in relational database management system like Oracle, DB2, MS Access, Teradata, SQL server.
Experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power center components (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Informatica Administration Console
Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.
Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
Exposure to Big data technologies is good to have.