More jobs:
ETL Developer
Job in
Aliso Viejo, Orange County, California, 92656, USA
Listed on 2026-07-01
Listing for:
Cynet Systems
Full Time
position Listed on 2026-07-01
Job specializations:
-
IT/Tech
Data Engineering
Job Description & How to Apply Below
ETL Developer
Pay Range: $53/hr - $58/hr
Requirement/Must Have:- 7+ years of experience in ETL/Data Integration/Data Warehousing.
- Strong hands-on experience in Informatica (Power Center / IICS).
- Strong expertise in Oracle and SQL Server databases.
- Proficiency in SQL and PL/SQL development.
- Experience in ETL design, development, and optimization.
- Good understanding of data warehouse concepts (Star/Snowflake schema).
- Design, develop, and implement ETL processes using Informatica Power Center / IICS.
- Build and maintain data integration pipelines across multiple source systems.
- Perform data extraction, transformation, and loading (ETL) from various OLTP and flat file sources.
- Develop and optimize SQL and PL/SQL scripts, stored procedures, and complex queries.
- Work extensively with Oracle and SQL Server databases for data processing and validation.
- Implement data mapping, transformation logic, and data modeling techniques.
- Design and maintain data warehouse structures (fact & dimension tables).
- Perform performance tuning and optimization of ETL jobs and database queries.
- Implement CDC (Change Data Capture) and slowly changing dimensions (SCD Type 1 &
2). - Ensure data quality, consistency, and integrity across systems.
- Troubleshoot ETL issues and resolve data discrepancies.
- Collaborate with business analysts, architects, and QA teams for requirement gathering and delivery.
- Familiarity with Unix/Linux scripting.
- Experience with version control (Git) and CI/CD tools.
- Experience with SSIS or other ETL tools.
- Exposure to cloud data platforms (Snowflake, AWS, Azure).
- Experience in BI tools (OBIEE, Power BI, Tableau).
- Domain experience in Healthcare.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×