Informatica ETL Developer
Location: Ontario, CA, us
Company 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
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
Additional Information
Syed Mohammad Asif
408-775-7468
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say