Informatica ETL Developer
Ontario, CA · On-site
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 ...
Ontario, CA · On-site
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 ...
Ontario, CA · On-site
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 ...
Phoenix, AZ · On-site
Supports the design, creation, maintenance, tuning and support of the organization's relational and dimensional databases, and OLAP Cubes. Leads the data analysis and reporting activities.
Phoenix, AZ · On-site
Supports the design, creation, maintenance, tuning and support of the organization's relational and dimensional databases, and OLAP Cubes. Leads the data analysis and reporting activities.
Charlotte, NC · On-site
Create tools to store data (e.g., OLAP cubes) * Conduct unit testing and troubleshooting * Evaluate and improve existing BI systems * Collaborate with teams to integrate systems * Develop and execute ...
Quick apply
Charlotte, NC · On-site
Create tools to store data (e.g., OLAP cubes) * Conduct unit testing and troubleshooting * Evaluate and improve existing BI systems * Collaborate with teams to integrate systems * Develop and execute ...
Salt Lake City, UT · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Salt Lake City, UT · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Bend, OR · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Bend, OR · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Spokane, WA · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Spokane, WA · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Burlington, WA · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Burlington, WA · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Columbia, MD · On-site
$111K - $133K/yr
Responsibilities : • Design schemas and models in OLAP, graph (Neo4j), and document (Elastic) databases. • Optimize queries and data structures for performance and scalability. • Work with ...
New
Columbia, MD · On-site
$111K - $133K/yr
Responsibilities : • Design schemas and models in OLAP, graph (Neo4j), and document (Elastic) databases. • Optimize queries and data structures for performance and scalability. • Work with ...
New
$41.75 - $56.50/hr
OLAP cubes (SSAS) * Microsoft SSAS, SSIS, and SSRS * SharePoint dashboards, KPIs, and scorecards * Data warehousing and data modeling * OLTP & OLAP databases * Advanced SQL development skills * ...
$41.75 - $56.50/hr
OLAP cubes (SSAS) * Microsoft SSAS, SSIS, and SSRS * SharePoint dashboards, KPIs, and scorecards * Data warehousing and data modeling * OLTP & OLAP databases * Advanced SQL development skills * ...
Columbia, MD · On-site
$113K - $136K/yr
Responsibilities: • Design schemas and models in OLAP, graph (Neo4j), and document (Elastic) databases. • Optimize queries and data structures for performance and scalability. • Work with ...
Columbia, MD · On-site
$113K - $136K/yr
Responsibilities: • Design schemas and models in OLAP, graph (Neo4j), and document (Elastic) databases. • Optimize queries and data structures for performance and scalability. • Work with ...
Boise, ID · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Boise, ID · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
$60 - $77.75/hr
Erwin and ER studio OLAP Tools: SAP Business Objects ETL Tools: Microsoft SSIS and Informatica 7.1.3 Database Tools: Microsoft SQL Server 2000/2005/2008,2012 Packages: Microsoft Office Suite ...
$60 - $77.75/hr
Erwin and ER studio OLAP Tools: SAP Business Objects ETL Tools: Microsoft SSIS and Informatica 7.1.3 Database Tools: Microsoft SQL Server 2000/2005/2008,2012 Packages: Microsoft Office Suite ...
OLAP cube work as well is also possible based on project needs. Description: The business intelligence (BI) and data warehouse (DW) Solution Architect will focus on delivering the vision of the ...
New
OLAP cube work as well is also possible based on project needs. Description: The business intelligence (BI) and data warehouse (DW) Solution Architect will focus on delivering the vision of the ...
New
Medford, OR · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Medford, OR · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Coeur D Alene, ID · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Coeur D Alene, ID · On-site
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau). * Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business ...
Tallahassee, FL · On-site
$48.50 - $63.50/hr
Create ad-hoc reports, OLAP database queries, and decision-support systems (DSS). * Documentation & Support: Maintain system documentation, functional specs, and user requirement documents.
Tallahassee, FL · On-site
$48.50 - $63.50/hr
Create ad-hoc reports, OLAP database queries, and decision-support systems (DSS). * Documentation & Support: Maintain system documentation, functional specs, and user requirement documents.
Assists customers in use of OLAP tools, extracts and collects data for performing queries and writing reports. Reviews queries for performance issues, making changes as needed. Participates in the ...
Assists customers in use of OLAP tools, extracts and collects data for performing queries and writing reports. Reviews queries for performance issues, making changes as needed. Participates in the ...
$18.75 - $23.99
7% of jobs
$23.99 - $29.24
0% of jobs
$29.24 - $34.48
7% of jobs
$34.48 - $39.73
9% of jobs
$40.21 is the 25th percentile. Wages below this are outliers.
$39.73 - $44.97
11% of jobs
$44.97 - $50.22
10% of jobs
The median wage is $52.13 / hr.
$50.22 - $55.46
11% of jobs
$55.46 - $60.71
6% of jobs
$60.71 - $65.95
9% of jobs
$66.65 is the 75th percentile. Wages above this are outliers.
$65.95 - $71.20
16% of jobs
$71.20 - $76.44
11% of jobs
$18
$53
$76
| Aspect | Olap | Data Analyst |
|---|---|---|
| Required Credentials | Typically requires knowledge of OLAP tools, data modeling, and sometimes certifications in data management | Often requires a degree in statistics, mathematics, or related fields; certifications like Microsoft Certified Data Analyst are common |
| Work Environment | Primarily works with data warehouses, BI tools, and multidimensional databases | Works with datasets, visualization tools, and reporting platforms |
| Employer & Industry Usage | Used in industries with large data warehouses like finance, retail, and telecommunications | Used across various industries for data interpretation, reporting, and decision-making |
OLAP (Online Analytical Processing) specialists focus on designing and managing multidimensional data structures for complex analysis, while Data Analysts interpret data, create reports, and support business decisions. Both roles require strong analytical skills but differ in technical focus and tools used.

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.
Role: Informatica ETL Developer
Duration: 6 months +
Location: Ontario, CA
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
Syed Mohammad Asif
408-775-7468