OntarioRecruiter Since 2001
the smart solution for Ontario jobs

Informatica ETL Developer

Company: SA Technologies Inc.
Location: Ontario
Posted on: February 23, 2021

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 + 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--

Keywords: SA Technologies Inc., Ontario , Informatica ETL Developer, IT / Software / Systems , Ontario, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Senior Software Engineer - (C#/.NET)
Description: If you are a Senior Software Engineer with experience, please read on We are a family-owned company in business since the 1950s that is looking for an application developer to join our team in Fontana, (more...)
Company: CyberCoders
Location: Fontana
Posted on: 03/1/2021

In-Home Usage Tester (Product Tester from home) Part-time
Description: American Consumer Panels reg , located at One World Trade Center, 285 Fulton St., Suite 8500 New York, NY, 10007, is looking to fill the position listed below nationwide : br br In-Home Usage Tester (more...)
Company: American Consumer Panels
Location: Fontana
Posted on: 03/1/2021

Sales Professional - Computer, Hardware, Software, and Cloud Data Center Sales
Description: GHA Technologies, Inc. has become the 1 mission critical supplier in America and is now ranked 69 on the 2018 CRN Solution Provider 500 and 15 2018 CRN Fast Growth 150 List. Microsoft has named GHA (more...)
Company: GHA Technologies, Inc
Location: Ontario
Posted on: 03/1/2021


Entry Level Software Engineer
Description: Revature is the fastest growing employer of emerging technology talent in the US. We will hire over 300 new Entry Level Software Engineers in the next 4 weeks.One day someone is going to ask you where (more...)
Company: Revature
Location: San Bernardino
Posted on: 03/1/2021

Product Tester (from home) - Part-Time, No Exp Req. $25-$45/hr
Description: American Consumer Panels reg , located at One World Trade Center, 285 Fulton St., Suite 8500 New York, NY, 10007, is looking to fill the position listed below nationwide : br br In-Home Usage Tester (more...)
Company: American Consumer Panels
Location: San Bernardino
Posted on: 03/1/2021

Technical Planner
Description: Local Aerospace company that machines parts and manufactures military aircraft spares is looking to add a Technical Planner to the team. Duties and Requirements: ---3-5 years of technical planning of (more...)
Company: AppleOne
Location: Upland
Posted on: 03/2/2021

Field Foreman
Description: MasTec Network Solutions is a leading specialty contractor for communications companies, utilities and governments throughout the United States. MasTec Network Solutions designs, builds, installs, maintains (more...)
Company: Mastec Network Solutions
Location: Corona
Posted on: 03/1/2021

Mobile Notary Signing Agent / Flexible Hours
Description: Certified Mobile Notary Service certifiedmobilenotaryservice.com is seeking someone to fill the position of a Mortgage Loan Closer to work remotely in the U.S. WHAT WILL THE MORTGAGE LOAN CLOSER DO (more...)
Company: Certified Mobile Notary Service
Location: Riverside
Posted on: 03/1/2021

In-Home Usage Tester (Product Tester from home) Part-time
Description: American Consumer Panels reg , located at One World Trade Center, 285 Fulton St., Suite 8500 New York, NY, 10007, is looking to fill the position listed below nationwide : br br In-Home Usage Tester (more...)
Company: American Consumer Panels
Location: Henderson
Posted on: 03/1/2021

Termite Control Field Service Technician
Description: Orkin is the leader in the pest control industry. Our purpose is to serve and help protect the world where we live, work, and play. Our Termite Control Field Service Technicians are committed to this (more...)
Company: Rollins Inc
Location: San Bernardino
Posted on: 03/1/2021

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Ontario RSS job feeds