Informatica ETL Specialist

Informatica ETL Specialist

Job Duties and Responsibilities

  • Analyze, design, develop, test and document ETL programs from detailed and high level specifications, and assist in troubleshooting
  • Utilize SQL (DB2, Oracle), Korn shell, Perl, Java, C to perform tasks other than data transformation
  • Assist in the requirements analysis and subsequent developments
  • Conduct unit tests and assist in test preparations to ensure data integrity
  • Work closely with Designers, Business Analysts and other Developers
  • Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
  • Design and implement technical enhancements of Data Warehouse as required

Required Skills, Education, Knowledge and Experience

  • 3-5 years of experience working with Informatica .Will consider applicants who work with other ETL tools like Solid knowledge and experience with SQL, UNIX, Korn shell, C, RDMS (DB2, Oracle) and Data Warehousing
  • Understanding data warehouse architecture with a dimensional data model
  • Strong analytical skills
  • Good communication skills
  • Interest and ability to learn new ETL tools
  • Computer Science degree or diploma

Desirable Skills and Experience

  • Experience with any ETL tools such as Ab Initio, DataStage, MetaStage, SAP BusinessObjects Data Integrator; IBM InfoSphere DataStage; Ab Initio PowerCenter & Oracle Data Integrator (ODI)
  • Data modeling, ERWin
  • Java, C++
  • One or more of the following industry experience an asset: Financial Services, Telecommunications, Insurance, Health Care