ETL Developer Job at Prophecy Technologies, Irvine, CA

UWVOUUd6V0h6dGtJZFBXbHpRcnB2OU5qQ1E9PQ==
  • Prophecy Technologies
  • Irvine, CA

Job Description

Job Summary:

We are seeking an experienced ETL Developer with strong expertise in Informatica PowerCenter and IICS. The ideal candidate will design, develop, and maintain ETL processes, ensuring high-quality data integration, performance optimization, and alignment with business requirements.

Key Responsibilities:
  • Design, develop, and maintain ETL workflows using Informatica PowerCenter and IICS.
  • Collaborate with business analysts and data architects to translate business requirements into technical specifications.
  • Conduct data analysis, data modeling, and dimensional modeling to support ETL design.
  • Ensure data quality and integrity through validation, cleansing, and testing processes.
  • Optimize ETL processes for performance, efficiency, and minimal downtime.
  • Troubleshoot issues in ETL workflows and provide post-production support.
  • Maintain comprehensive documentation for ETL processes, mappings, and workflows.
  • Collaborate with cross-functional teams and offshore resources to define data requirements and contribute to database design decisions.
Required Skills & Experience:
  • 7+ years of hands-on experience with Informatica PowerCenter and IICS.
  • Strong expertise in ETL process design, development, and maintenance.
  • Experience in data modeling, dimensional modeling, and data analysis.
  • Knowledge of performance tuning, data validation, and troubleshooting ETL processes.
  • Familiarity with working in hybrid or offshore-collaborative environments.
Preferred Skills:
  • Strong documentation and communication skills.
  • Experience with large-scale data integration projects and best practices in ETL.

Skills Keywords: ETL, Informatica PowerCenter, IICS, Data Modeling, Data Integration, Data Quality

Job Tags

Similar Jobs

CMT Services Inc

Court Reporter Job at CMT Services Inc

 ...CMT Services Inc. is a dynamic and small business supporting Federal, State, and Local government agencies. As an SBA-certified HUBZone...  ...strategic business goals of our clients. PositionTitle: Court Reporter Location: Largo, MD Department: Prince Georges... 

Advantage Surgical and Wound Care

Wound, Burn and Ostomy Physician Job at Advantage Surgical and Wound Care

 ...Description Advantage Surgical and Wound Care has an exciting opportunity for a Part-Time Wound Care Specialist (1-3 days/week) to...  ...nursing staff, and maintain open communication with primary care physicians, families, and clinical teams as required. Order necessary... 

Waabi

Senior Product Designer, Driverless Operations Job at Waabi

 ...positive way. To learn more visit: This is not a typical product design role. You'll design workflows where a human decision can pull a...  ...value your ability to untangle complexity over your specific industry background. - Own complexity and execute end-to-end: You can... 

Artistic Dental Lab

Pick Delivery Driver Job at Artistic Dental Lab

 ...Delivery Driver Need to be reliable Have good customer service skills Must Have good clean driving record Have Gas Saving vehicle to Drive Must have Active Car Insurance Know how to use GPS 1099 Position Working 4 or 5 days a week, M-F... 

TEW & TAYLOR

Building Code Inspector Job at TEW & TAYLOR

 ...About Us Tew & Taylor has been a trusted leader in building-code inspections and plan-review services since 2008. We deliver...  ...Position Overview We are seeking a highly skilled Building Code Inspector with experience in Structural, Mechanical, Electrical, and...