Job Order #2941

Email this Job to a Friend
Posted Date: 1/15/2018
Job Category:
Position Title: Int/Snr Informatica Developer
Salary Range:
Location: Toronto, Ontario, Canada
Desired Skills:
Description:

OVERVIEW
A Toronto based BI/DW boutique consulting firm is looking to grow their team. Travel outside the GTA is not required

JOB DESCRIPTION
• Design, develop and implement moderate to complex data transformation processes using Informatica that will migrate data from the existing data warehouse, and other enterprise data sources.
• Author technical documents (ETL Architecture, ETL Standards, ETL Design Specifications, ETL Work Flow, System Architecture)
• Work with the Architect to develop solutions to technical issues and design issues
• Follow established SDLC processes as well as enterprise policies and guidelines for software development
• Development of SQL scripts and stored procedures to augment the ETL process
• Develop Unix scripts to support the ETL processes
• Work closely with the business systems analyst to develop the source to target data mappings
• Play a lead role in the development of the ETL design document and transformation rules
• Conduct user interviews to validate the transformation rules.
• Play a lead role in the development of the design/technical specifications for the PowerCentre configuration.
• Work with the ETL Architect input into technical issues and design solutions
• Participate in design walk-throughs and code walk-throughs
• Design the ETL workflows processes
• Prepare and schedule the ETL workflows, using scripting where necessary
• Evaluate the data quality and provide written feedback to the client
• Assist in complex sizing, resource estimates, scope and requirements for a variety of projects.
• Prepare and execute test cases for unit and system integration testing.
• Assist in designing logical and physical dimensional datamart models
• Develop and execute the implementation plan
• Install and configure PowerCentre
• Troubleshoot code issues and provide timely resolution
• Performance tuning of ETL mapping and load processes, as required

QUALIFICATIONS
• 3-5 years experience as an Informatica developer
• Extensive knowledge of general warehousing theories and OLAP reporting
• Extensive knowledge of Ralph Kimball and Bill Inmon design theories
• Strong knowledge of dimensional and relational data modeling techniques
• Working knowledge of the UNIX operating system.
• Experience with SQL and PL/SQL
• Experience with Unix shell scripting
• Practical experience with ERWin
• Strong knowledge of dimensional modeling techniques
• experience with testing tools (ie: Test Director)
• experience with testing strategies and concepts
• Experience with complex PowerCentre implementations
• Understanding of the PowerCentre product on the UNIX environment
• Proven project management/project lead skills
• Proficient in Word, Excel and Visio required
• Certified as an Informatica Designer or Consultant an asset

Soft Skills:
• Ability to meet deadlines
• Excellent interpersonal, facilitation, presentation and communication skills
• The ability to communicate complex information and issues to all levels of the organization
• Ability to work with minimal direction and supervision
• Demonstrated experience working in a team environment



Share this job: