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