Vacancy expired!
- Act as the primary ETL technical liaison working with technical infrastructureteams to resolve problems and implement solutions to technical issues impactingapplication performance
- Manage and administers ETL solutions for medium to large scale OLTP and OLAPprojects
- Monitor daily ETL jobs and processes that identify load and performance issuesand determine the resolution and revise the incorrect operational processes
- Communicate and coordinate with members of the development team to work acrossmultiple projects
- Explore, actively support and work on new technology initiatives that may be ofinterest to the organization
- Actively participate in troubleshooting any technical issues that the program may have
- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer
- More than (7) years of experience in analysis,design, development, testing and implementation of data integration solutionsusing PL/SQL & relational databases
- Five or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality
- Seven years or more of hands-on experience usingETL tools like Informatica PowerCenter to migrate data from various sources andtargets including databases, flat files, and XML files, UNIX shell scripts
- Seven or more years of experience developingcomplex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures,triggers, packages, materialized view and using Oracle supplied utilitiesincluding: SQL Loader, external tables, and Oracle built in packages to migratedata
- Five or more years of experience with DataQuality processes, approaches, measurement techniques and business cases fordata profiling, data cleansing, standardization, match and merge functionalityusing tools such as Informatica Data Quality
- Seven years or more experience in implementingconcepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture(CDC) functionality in both an OLTP (Relational Modeling) and OLAP (DimensionalModeling) environments
- Seven or more years of experience writingcomplex UNIX scripts to validate and ftp files, and for scheduling / automatingETL processes
- Seven years or more of experience in performancetuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers,packages, tables, views and indexes
- Experience with implementing ETL solutions formedium to large scale OLTP and OLAP projects
- Experience in writing technical specificationsincluding ETL source to target mapping documents, ETL design documents,implementation documents
- Experience with Health & Human servicesapplications