Hiring Informatica Developer in Markham Ontario

Artech Information Systems View all jobs

  • Markham, ON
  • Contract
  • Full-time
  • 29 days ago
Job Title: Informatica DeveloperLocation: Markham OntarioDuration : 12 MonthsIntroductionWe are seeking a skilled Informatica Developer to join our team. The ideal candidate will have extensive experience in data warehousing and ETL concepts, with a strong understanding of Informatica tools and Oracle databases. This role will involve working with Hadoop systems and developing complex mappings and workflows.Required Skills & Qualifications
  • Proficiency in Informatica (Designer, Workflow Manager, Monitor)
  • Knowledge of Oracle Database (SQL, PLSQL)
  • At least 4 years of hands-on experience with BDM
  • Experience working with Hadoop systems (Hive and Impala)
  • Experience in developing mappings involving slowly changing dimensions (Type 1, Type 2, Type 3)
  • Strong communication skills
  • Experience in performance tuning both ETL components and database level
  • Experience in two complete SDLCs using Informatica
  • Experience in Unix
  • Knowledge of Teradata database and PostgreSQL utilities
  • Ability to independently manage discussions with Business Analyst and Senior System Analyst
  • Prior work experience at client or in client's industry
Preferred Skills & Qualifications
  • Experience with Informatica Powercentre
  • Experience with Informatica BDM
  • Experience with IDR
Day-to-Day Responsibilities
  • Develop and maintain ETL workflows and mappings
  • Collaborate with business analysts and system analysts to gather requirements
  • Optimize ETL processes for performance and scalability
Company Benefits & Culture
  • Comprehensive health and dental insurance
  • Flexible work hours and remote work options
  • Opportunities for professional development and career growth
For immediate consideration please click APPLY to begin the screening process with Alex.

Artech Information Systems