Informatica ETL Developer

3 days ago

Canada SA TECHNOLOGIES Full time

SA Technologies Inc. ( 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 + Job Description: 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 ware house 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 #J-18808-Ljbffr

  • Informatica Developer

    4 weeks ago

    Canada Government Entity Full time

    Key ResponsibilitiesDesign, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS.Implement data mapping, transformation, and cleansing to support Master Data Management (MDM) and MPI objectives.Collaborate with data architects, DBAs, and business analysts to align technical design with business requirements.Support data...

  • Informatica Developer

    4 weeks ago

    Canada Government Entity Full time

    Key Responsibilities - Design, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS. - Implement data mapping, transformation, and cleansing to support Master Data Management (MDM) and MPI objectives. - Collaborate with data architects, DBAs, and business analysts to align technical design with business requirements. -...

  • Informatica Developer

    4 weeks ago

    Canada Government Entity Full time

    Key Responsibilities Design, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS . Implement data mapping , transformation , and cleansing to support Master Data Management (MDM) and MPI objectives. Collaborate with data architects, DBAs, and business analysts to align technical design with business requirements....

  • Informatica Developer

    3 weeks ago

    Canada Government Entity Full time

    Key Responsibilities Design, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS . Implement data mapping , transformation , and cleansing to support Master Data Management (MDM) and MPI objectives. Collaborate with data architects, DBAs, and business analysts to align technical design with business requirements....

  • Informatica Developer

    3 weeks ago

    Canada Government Entity Full time

    Key Responsibilities Design, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS . Implement data mapping , transformation , and cleansing to support Master Data Management (MDM) and MPI objectives. Collaborate with data architects, DBAs, and business analysts to align technical design with business requirements....

  • Informatica Developer

    3 weeks ago

    , , Canada Government Entity Full time

    Direct message the job poster from Government Entity Global Talent Strategist | Bridging Global Talent Across Canada, USA, Middle East & India Key Responsibilities Design, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS . Implement data mapping , transformation , and cleansing to support Master Data Management...

  • Informatica Developer

    4 weeks ago

    New Canada, NS Government Entity Full time

    Key Responsibilities Design, develop, and maintain ETL processes and data workflows using Informatica PowerCenter / IICS. Implement data mapping, transformation, and cleansing to support Master Data Management (MDM) and MPI objectives. Collaborate with data architects, DBAs, and business analysts to align technical design with business requirements. Support...

  • Etl - Informatica

    1 week ago

    Canada Atlantis IT group Full time

    **Role : Informatica Developer** **Location **:Montreal,** QC** **Duration **:Long Term** Informatica developers load, test, and troubleshoot data, and analyze and test data warehousing systems. Thanks & Regards, **Harshaja** Apptoza Inc. Phone#:647-953-1625 Mobile#:(762) 309-8868

  • ETL Developer

    12 hours ago

    Canada - Markham ON Aviva Way Aviva Employment Services Full time US$50,000 - US$120,000 per year

    Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.We are seeking a dedicated ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic...

  • Senior Software Developer

    2 weeks ago

    Canada 2iSolutions Inc. Full time

    We are seeking a Senior Software Developer (ETL) for a 1-year contract opportunity in Toronto. This is an onsite role. Must haves: • 7+ years of experience in developing data conversion and migration • Experience working in ETL tools such as Azure Data Factory, Informatica, etc. • Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server,...