Genesis10 is currently seeking a PL/SQL Developer for a contract position with a Global Financial Institution located in Plano, TX or Jersey City, NJ. This is a 12+ month contract opportunity. This role is focused on designing, developing, and maintaining complex PL/SQL packages and procedures for trade data processing within a trade surveillance and compliance environment. The ideal candidate will build scalable data pipelines, optimize high-volume batch processing jobs, and collaborate closely with compliance and surveillance teams to translate scenarios into technical solutions.
Responsibilities: - Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers for trade data processing
- Build scalable data pipelines to support Trade Surveillance use cases (e.g., market abuse detection, alerts generation)
- Develop and optimize high-volume batch processing jobs
- Write complex SQL queries for data extraction, reconciliation, and reporting
- Collaborate with compliance and surveillance teams to translate surveillance scenarios into technical solutions
- Support alert generation frameworks and case management data structures
- Ensure data lineage, traceability, and auditability of trade data
- Review and re-engineer logic from Actimize AIS into PL/SQL
- Perform query tuning, indexing, and execution plan optimization for large datasets
Requirements: - 10+ years of hands-on software development experience
- Strong, production-level Oracle PL/SQL and Actimize AIS knowledge
- Experience with relational and object databases
- Advanced SQL skills, including performance tuning and a strong understanding of database internals
- Solid understanding of SDLC, CI/CD, and version control
- Strong analytical and problem-solving skills
- High attention to data accuracy and control effectiveness
- Ability to manage multiple priorities in a regulatory-driven environment
- Excellent communication skills with both technical and business stakeholders
- Proactive mindset with ownership and accountability
Desired skills: - Working knowledge of Python or Shell scripting for automation
- Familiarity with trade lifecycle (orders, executions, etc.)
- Exposure to Trade Surveillance, Market Misconduct, and Global Markets Compliance
- Exposure to the Actimize AIS platform
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.