Bookmark and Share

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
  •