Informatica ETL Developer

SA TECHNOLOGIES; Ontario; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading IT consulting firm is seeking a Data Warehouse Developer to design and develop data integration processes. The role requires extensive experience with ETL solutions, particularly using Informatica PowerCenter, and strong database development skills. Join a dynamic team to enhance data warehousing solutions and contribute to impactful projects.

Qualifications

• 5-7 years of hands-on ETL development experience using Informatica.
• Strong database development skills in Oracle 10g/11g.
• Experience in Agile development methodology.

Responsibilities

• Design and develop Dimensional Model for Data Warehouse.
• Administer PowerCenter environment for data integration activities.
• Support existing data warehouse solutions and optimize performance.

Skills

Data Warehousing

ETL

SQL

Agile

Problem Solving

Education

BA / BS in Business

BA / BS in Information Systems

BA / BS in Statistics

Tools

Informatica PowerCenter

Oracle E-Business Suite

Erwin

Job description

SA Technologies Inc. (www.satincorp.com) is a market leader and one of the fastest growing IT consulting firms with operations in US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.

All SA Technologies requirements are Direct Client Requirements from IT Hiring Managers. We guarantee you the best rate for your skills and performance.

Job Description

Duration : 6 months +

Responsibilities :

• Understanding Data Sources; Use Data Modeling concepts to design and develop Dimensional Model for a Data Warehouse.
• Design & Development of Data Integration processes using Informatica PowerCenter 9.5.1.
• Administer PowerCenter environment to ensure security, auditability, Data Validation, Data Analysis, performance tuning and other required data integration related activities.
• Analysis, design, deployment, coding and testing of Data warehousing using Informatica (ETL) on OLAP and OLTP environment and implementation of Database Management Systems.
• Database Modeling / Designing using Erwin to design Conceptual / Logical / Physical Modeling, Forward / Reverse engineering and ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing, OLAP tools.
• Implementation of Data Warehousing, Data Marts, Star and Snow Flake Schema Modeling, Dimensional Modeling on OLTP and OLAP concepts using Ralph Kimball and Bill Inmon methodologies.
• Designing and developing mappings, mapplets and reusable transformations using Informatica Designer. Proficient in Normalization / Denormalization techniques.
• Support existing data warehouse solution while fine tuning the system for optimal performance.
• Proficient in Agile / scrum project methodology.

Required Knowledge and Experience :

• Long track record on data warehouse / business intelligence design and build.
• Minimum of 5-7 years of current, hands on development experience implementing ETL solutions, particularly utilizing Informatica Powercenter ETL platform – Powercenter 9.x or above.
• Experience with Oracle Applications E-Business Suite 11.5.10 or R12 as data source or general knowledge of Oracle e-Business data structures highly desirable.
• Strong Database Development Skills (particularly implementing SQL solutions in Oracle 10g / 11g Database to build large-scale applications).
• Strong experience in the design and development of mappings, transformations, sessions and workflows.
• Experience with a variety of sources (EBS, XML, Oracle, flat file, excel spreadsheets, transactional (OLTP) sources, etc.).
• Experience and advanced knowledge of logical and physical database modeling concepts and techniques.
• Understand normalized and star-schema (dimensional) physical models and logical modeling concepts.
• Extensive programming experience in SQL & PL / SQL, tuning and optimization.
• Extensive experience determining, developing, testing, and implementing system requirements and specifications.
• Strong analytical and problem solving skills.
• Experience working in Agile development software methodology.

Education :

BA / BS in Business, Information Systems, Statistics or relevant discipline.