ETL Developer (Informatica)
i360 - Saint Paul, MN

This job posting is no longer available on i360. Find similar jobs:ETL Developer jobs

ETL Developers (Informatica) Job Description

Extensive hands-on ETL development experience with Informatica

Strong database skills with Oracle (teradata a plus).

Logical and physical data modeling skills, preferably using Erwin

Experienced with Unix Shell scripting

Experience in financial services/banking domain

Onsite-offshore business model experience

Excellent communication skills

Demonstrated experience installing, configuring and tuning Informatica’s Data Quality Tool (preferably 9.x software

Demonstrated experience implementing Informatica’s Data Quality applications for both business and technology users across a full development life-cycle.

Knowledge of DQ standard, guidelines and best practices

Knowledge of Data Profiling guide lines and best practices.

Knowledge of best practices on Process Sequence, Dictionaries, DQ Lifecycles, Naming Convention, Version Control

Matching Component Selection Guidelines

Must be both hands-on as well as have the ability to define and explain complex concepts and solution/design to technical and business audiences.

Data Profiling

Column Profiling (Base Column, Sub Level Column)

Cross Join Profiling (profiling on joined tables, Integrity Profiling)

Comparative Profiling pattern

Profiling summary reports for evaluation.

Creating Quick Profiles

Creating Custom Profiles, Run the Profile, Drill Down on Profile Results

Create a Scorecard from the Profile Results

Derived Quality Index pattern

Score Carding design & design patterns, Develop confidence factor scoring system, Run the Scorecard, Edit the Scorecard, Configure Thresholds

Creating Expression Rules, Creating and Running Scorecards

Profiling Report (General profiling report setup and design)

Medium to complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL, ELT and Real-Time consideration.

Demonstrated experience scaling the tool to profile / assess rules against 50 to 70 million records w/ 50+ attributes (or something close to this in size / scale).

Knowledge of Informatica components required to operate Data Quality (ex: is PowerCenter required)

Deep knowledge of data quality processes, approaches, measurement techniques, and business cases including Profiling, cleansing, standardization and Match/Merge

Demonstrated experience implementing Informatica’s Data Quality as a service in a SOA or Web Services architecture where it is called from one or more production applications to perform DQ services and return back and/or display results.

Excellent inter-personal and written and verbal communication skills