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 DescriptionRole: 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 InformationSyed Mohammad Asif
408-775-7468
Skills Required
- Minimum 5-7 years of development experience implementing ETL solutions
- Experience with Informatica PowerCenter ETL platform 9.x or above
- Strong Database Development Skills in Oracle 10g/11g
- Experience with SQL & PL/SQL, tuning and optimization
- Extensive experience in database modeling and design
SA Technologies Inc. Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about SA Technologies Inc. and has not been reviewed or approved by SA Technologies Inc..
-
Fair & Transparent Compensation — Pay is considered mid‑market for core tech roles, with salary credited reliably and ranges aligned to mainstream IT contracting markets. Some U.S. accounts indicate compensation feels fair relative to local expectations.
-
Flexible Benefits — Work‑from‑home is identified among standard offerings, and India‑focused sources signal relatively strong work‑life balance. These elements suggest practical flexibility in day‑to‑day arrangements for many roles.
-
Leave & Time Off Breadth — Paid holidays and sick leave appear among the core offerings. This indicates baseline time‑off coverage typical of a standard package.
SA Technologies Inc. Insights
What We Do
Powering Businesses with Agentic AI Solutions, Digital Transformation & Global Capability Centers For over 25 years, SA Technologies has been a trusted partner in technology consulting and outsourcing, helping enterprises optimize costs, enhance efficiency, and scale intelligently. With expertise across Manufacturing, Fintech, Healthcare, and 15+ industries, we serve 500+ global clients with 2,000+ skilled professionals, delivering solutions that drive real-world impact. Our Expertise AI & Intelligent Automation: Our SAT Intelligent Agents are designed to revolutionize operations by automating workflows, streamlining decision-making, and enhancing efficiency across industries—from predictive maintenance in manufacturing to fraud detection in fintech and patient management in healthcare. Cloud-Agnostic & Compliance-Ready AI: We develop custom AI solutions that seamlessly integrate with existing ecosystems, ensuring scalability, security, and regulatory compliance across industries. Global Capability Centers (GCCs): We help enterprises reduce costs while securing top-tier talent by building high-performance global teams that support AI, digital transformation, and business operations. Digital & Enterprise Solutions: We deliver Gen AI applications, Web3, Blockchain, AI ML consulting, mobile and web development, providing future-ready solutions for diverse industry needs. Accelerated Product Development: Our proven Agile methodologies reduce development timelines by 40%, ensuring faster go-to-market for AI-driven innovations. At SA Technologies, we don’t just build solutions—we redefine industries with AI-driven intelligence, automation, and scalable innovation. Whether you're optimizing manufacturing processes, enhancing financial security, or advancing healthcare technology, we deliver results that matter. Book a Meeting : https://satincorp.com/contact-us
.png){kind=logo}
