Job Details: Job Title: ETL Developer / Data Integration Specialist Location: Philadelphia, PA 19107 (Hybrid – Onsite on needed basis) Type: Contract: 10 months
- Monitor, maintain, and optimize ETL workflows that load IDEA IDS.
- Develop and maintain PL/SQL and ETL scripts for data extracts, transformations, and loads.
- Troubleshoot ETL failures, ensure successful reruns, and optimize job scheduling.
- Onboard new data sources and revise existing source data feeds.
- Implement data validation checks and ensure data quality standards are met.
- Document ETL design, processes, and error handling procedures.- 5+ years of ETL development experience using PL/SQL and related tools.
- Strong SQL scripting and debugging skills.
- Familiarity with large-scale data warehouse architectures.
- Experience with batch automation, job scheduling, and error-handling frameworks.
- Strong problem-solving and analytical skills.
Work Location: Hybrid remote in Philadelphia, PA 19107