Genesis10 is currently seeking an Application Programmer for a contract position with a Global Financial Institution located in Jersey City, NJ. This is a 12+ month contract opportunity. The candidate for this Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using a proprietary metadata-driven approach. This role involves the maintenance and support of existing interface processes, including issue investigation, production troubleshooting, and maintaining data lineage to facilitate end-to-end traceability. In addition, the candidate will be responsible for liquidity report-specific derivations.
Responsibilities: - Design and develop batch/ETL interfaces using a proprietary metadata-driven approach
- Maintain and support existing interface processes including investigation of issues and production troubleshooting
- Maintain data lineage to facilitate end-to-end traceability as and when changes to the ETL
- Handle Liquidity report specific derivations
- Implement ETL solutions for large volumes of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, and Direct path loads
- Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports
- Maintain high standards and follow best practices by re-factoring existing code to enhance readability, performance and general structure
Requirements: - 7-10 years' experience in Oracle Exadata, SQL, PL/SQL
- 2-3 years' experience in SQL Performance tuning
- Clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) and SGA (System Global Areas) to optimize memory usage
- Knowledge about Oracle VPD
- Expertise in performance profiling, ability to identify performance improvements and memory optimizations
- Strong coding, debugging, and analytical skills
- Knowledge about Oracle architecture and process
- Knowledge of computer science data structures and algorithms
- Experience with Analytic reporting tools like Tableau
- Analytical skills to perform technical and functional analysis with strong communication skills
- Experience working in Containers
- Knowledge about Python and Apache Airflow
- Experience in CICD, Jenkins, Git
- Experience working in Agile teams
Desired skills: - Experience working in regulatory projects
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.