Informatica ETL Developer
7 days ago
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
-
ETL Informatica Developer
1 hour ago
, , Canada UST Full timeJoin to apply for the ETL Informatica Developer role at UST Get AI-powered advice on this job and more exclusive features. Who We Are Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and...
-
Remote ETL Informatica Developer — Snowflake
1 hour ago
, , Canada UST Full timeA global technology provider is seeking an ETL Informatica Developer to lead data integration initiatives remotely in Canada. The ideal candidate should possess strong ETL/SQL development skills, deep familiarity with Informatica, and experience with data warehousing solutions like Snowflake. Responsibilities include designing ETL workflows, optimizing...
-
Senior ETL Developer
2 days ago
, NB, Canada Zone IT Solutions Full timeA global IT service leader in Canada is looking for an experienced ETL Developer for a permanent role in a large-scale project. The ideal candidate will have over 5 years of ETL development experience, particularly in Informatica. Proficiency in Unix, SQL, and analytics tools like PowerBI is essential, alongside a basic understanding of retail replenishment...
-
ETL Developer
2 days ago
, NB, Canada Zone IT Solutions Full timeWe are looking for ETL Developers for a large-scale project. This is a permanent role with a global IT service leader. Strong experience in ETL Development. Minimum of 5+ years of experience in Informatica Cloud or Enterprise Informatica. Proficiency in Unix and Shell scripting. Basic understanding of the Replenishment process for Retail. Experience in...
-
, , Canada SA TECHNOLOGIES Full timeA leading IT consulting firm is seeking a Data Warehouse Developer in Canada. The ideal candidate will have 5-7 years of hands-on experience with ETL solutions using Informatica PowerCenter and a strong background in data warehousing practices. Responsibilities include designing and developing data integration processes and ensuring optimal database...
-
Informatica CAI Developer
2 weeks ago
, , Canada Enterprise Solutions Inc. Full timeInformatica CAI Developer (CAI-Focused with CDI Exposure) Overview We are seeking a highly skilled Informatica Developer with a strong focus on Cloud Application Integration (CAI) and working knowledge of Cloud Data Integration (CDI) . This role is pivotal in designing, developing, and maintaining real-time, event-driven, and API-based integration solutions...
-
ETL Developer
1 week ago
Canada Lys Intelligence Inc. Full timeWe are seeking a highly skilled ETL Developer with deep expertise in Python and SQL to join our team.This is a full-time, permanent remote position focused on designing and implementing robust ETL pipelines and data solutions._ Important : The interview process is highly technical and will focus heavily on Python and SQL. You will be required to write...
-
ETL Developer
2 days ago
, , Canada Tata Consultancy Services Full timeJob Title ETL Developer Salary Range Company provided pay range: CA$ 100,000 - CA$ 130,000 per year. Location Toronto, Ontario, Canada About Tata Consultancy Services (TCS) TCS is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55...
-
Informatica CAI Developer — API
2 weeks ago
, , Canada Enterprise Solutions Inc. Full timeA leading IT solutions company in Canada is seeking a skilled Informatica CAI Developer. The successful candidate will focus on designing and developing API-based integrations and workflows. This role requires a minimum of 2 years of experience with Informatica CAI and a strong understanding of API concepts. Collaboration with business teams is crucial to...
-
ETL / ELT developer - Healthcare
4 weeks ago
, , Canada Yochana Full timeSenior ETL / ELT Developer – Healthcare (Matillion, Python) Job Title: Senior ETL / ELT Developer – Healthcare (Matillion, Python) Experience: 8+ Years (Mid to Senior Level) Work Location: REMOTE Job Summary: We are seeking a Mid to senior-level ETL / ELT Developer with strong Healthcare domain experience to support data integration and analytics...