ETL & MDM Specialist

Job Duties and Responsibilities

  • Analyze, design, develop, test and document ETL, Data Quality (DQ) and Master Data Management (MDM) 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 or data quality
  • Assist in the requirements analysis and subsequent developments
  • Conduct unit tests and assist in test preparations to ensure data integrity, data quality and program quality
  • 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, Data quality management or MDM solutions as required

Required Skills, Education, Knowledge and Experience

  • 3-5 years of experience working with Informatica Power Center or IBM Data Stage. Will consider applicants who work with other ETL tools like Ab Initio or SAP BusinessObjects Data Services.
  • 3-5 years of experience working with Informatica Data Quality, IBM Quality Stage, Informatica MDM Hub, IBM InfoSphere MDM Server, Ataccama Data Quality Center, Ataccama Master Data Center. Will consider applicants who work with other DQ/MDM tools like SAP BusinessObjects Data Quality or SAS DataFlux.
  • Solid knowledge and experience with SQL, UNIX, Korn shell, C, RDMS (DB2, Oracle)
  • Solid knowledge and experience with Data Warehousing, DQ Management and MDM
  • 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/DQ/MDM tools such as Ab Initio, SAP BusinessObjects Data Services/Data Quality; IBM InfoSphere DataStage/QualityStage/MetaStage; Informatica PowerCenter/IDQ/MDM, Ataccama DQC/MDC, 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
  • Certification in ETL, DQ or MDM technology