Previous Job
Informatica MDM Consultant
Ref No.: 18-63597
Location: Philadelphia, Pennsylvania
Position Type:Contract
Start Date: 08/30/2018
Around 5+ 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.xExtensively 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 developmentHave 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, Datamarts and dimensional modeling schemas.Expertise in data modeling, development and enhancement.Very strong in Bill Inmon and Ralph Kimball methodologiesStrong experience in Data modeling 1. 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.Familiar about SDLC (Software Development Life Cycle) Requirements, Analysis, Design, Testing, Deployment of Informatica Power Center.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.Design and develop applications using informatica, UNIX scripting, SQL and Autosys.Highly proficient in UNIX shell scripting and administering job scheduler using UC4, Autosys UNIX machines.In-depth knowledge in dealing with Flat files, Cobol and XML filesExcellent analytical, problem solving skills with strong technical background and interpersonal skills.Efficient team player with excellent communication skills and good interaction.Good experience in working as Lead managing small and also large teams as well. "