Genesis10 is currently seeking an ETL Lead Developer for a contract position with a Global Financial Institution located in Pennington, NJ. This is a 12+ month contract opportunity. We are seeking a highly skilled ETL Lead Developer with deep expertise in the Oracle ecosystem to spearhead our data integration and warehousing initiatives. In this role, you will lead a team of data engineers to build, optimize, and scale robust ETL pipelines that process massive datasets. You will bridge the gap between business intelligence requirements and backend data architecture, ensuring that our data platform is reliable, secure, and performant.
Responsibilities: - Lead the end-to-end design, development, and deployment of complex ETL/ELT processes utilizing enterprise tools and advanced Oracle capabilities
- Take ownership of data warehouse performance, diagnostics, and optimization-specifically focusing on high-volume SQL and PL/SQL workloads
- Collaborate with Data Architects to design scalable data warehouses and data marts using Star/Snowflake schemas and Dimensional Modeling
- Conduct code reviews, establish rigorous data quality frameworks, and mentor senior and junior developers on best practices in ETL design
- Oversee batch window scheduling, automate error handling, and ensure data availability aligns with strict business SLAs
Requirements: - 8+ years of professional experience in Data Engineering/ETL development, with at least 2 years leading engineering teams
- Advanced knowledge of Oracle (12c/19c) architecture, including expert-level PL/SQL (Stored Procedures, Packages, Triggers, Analytical Functions)
- Proven mastery of Oracle-specific tuning techniques: Explain Plans, TKPROF, Optimizer Hints, Partitioning strategies, and Indexing optimizations
- Strong hands-on experience with Oracle Data Integrator (ODI) or other enterprise tools like Informatica PowerCenter, IBM InfoSphere DataStage, or Talend
- Deep understanding of Kimball/Inmon methodologies, Change Data Capture (CDC), and handling Slowly Changing Dimensions (SCD Type 1/2/3)
- Proficiency in Linux/Unix shell scripting for batch automation, file manipulation, and job scheduling (e.g., Control-M, Autosys, or Cron)
Pay range: $58.26 - $66.26 per hour
Only candidates available and ready to work directly as Genesis10 employees will be considered for this position. If you have the described qualifications and are interested in this exciting opportunity, please apply! Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.
For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10: - Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
- The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
- Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
- Behavioral Health Platform
- Medical, Dental, Vision
- Health Savings Account
- Voluntary Hospital Indemnity (Critical Illness & Accident)
- Voluntary Term Life Insurance
- 401K
- Sick Pay (for applicable states/municipalities)
- Commuter Benefits (Dallas, NYC, SF, and Illinois)
For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.
Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Never miss an opportunity! Create an alert based on the job you applied for.