Robert Half International Data Modeler in Philadelphia, Pennsylvania


Job Description: Title: Informatica IDQ Developer Mandatory Technical / Functional Skills:

Please email me at [email protected] if interested :)


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, Microsoft 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.

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 files

Excellent analytical, problem solving skills with strong technical background and interpersonal skills. Efficient team player with excellent communication skills and good interaction. Exposure to Big data technologies is good to have

Technology doesn't change the world. People do.

As a technology staffing firm, we can't think of a more fitting mantra. We're extreme believers in technology and the incredible things it can do. But we know that behind every smart piece of software, every powerful processor, and every brilliant line of code is an even more brilliant person.

Leader among IT staffing agencies

The intersection of technology and people — it's where we live. Backed by more than 65 years of experience, Robert Half Technology is a leader among IT staffing agencies. Whether you're looking to hire experienced technology talent or find the best technology jobs, we are your IT expert to call.

We understand not only the art of matching people, but also the science of technology. We use a proprietary matching tool that helps our staffing professionals connect just the right person to just the right job. And our network of industry connections and strategic partners remains unmatched.

Apply for this job now or contact our branch office at 888.490.4429 to learn more about this position.

All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.

© 2019 Robert Half Technology. An Equal Opportunity Employer M/F/Disability/Veterans.

By clicking 'Apply Now' you are agreeing to Robert Half Terms of Use.

Location: Philadelphia, PA

Date Posted: January 10, 2019

Employment Type: Contract

Job Reference: 04860-9501706640

Staffing Area: Technology & IT