Oracle PL/SQL Developer
Title: Oracle PL/SQL Developer
Location: Pennington, NJ
Full Time/ Permanent
Contact: Syed.Khaliq@Synechron.com
The Role
Responsibilities:
The candidate for the Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using the proprietary meta data driven approach as part of the LIBRA Interface Team. The candidate will be responsible for maintenance and support of the existing interface processes including investigation of issues and production troubleshooting. Candidate will be responsible for maintaining the data lineage to facilitate the end to end traceability as and when changes to the ETL. In addition candidate will responsible for Liquidity report specific derivations.
Requirements:
You Are:
- 7-10 years’ experience in Oracle Exadata, SQL, PL/SQL
- Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
- 2-3 years’ experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports. Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) & 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.
It would be great if you also had:
- Experience working in regulatory projects is strongly desirable
- Experience working in Containers
- Knowledge about Python and Apache Airflow
- Maintain high standard and follow best practices by re-factoring existing code to enhance readability, performance and general structure
- Experience in CICD, Jenkins, Git
- Experience working in Agile teams
We can offer you:
- A highly competitive compensation and benefits package
- A multinational organization with 55 offices in 20 countries and the possibility to work abroad
- Laptop and a mobile phone
- 10 days of paid annual leave (plus sick leave and national holidays)
- Maternity & Paternity leave plans
- A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
- Retirement savings plans
- A higher education certification policy
- Commuter benefits (varies by region)
- Extensive training opportunities, focused on skills, substantive knowledge, and personal development
- On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
- Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
- Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms
- A flat and approachable organization
- A truly diverse, fun-loving and global work culture
SYNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Synclusive’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Engineering and Information Technology -
Industries
Financial Services
Referrals increase your chances of interviewing at Synechron by 2x
See who you knowFeatured Benefits
Inferred from the description for this job
-
Medical insurance -
Dental insurance -
Vision insurance -
401(k) -
Pension plan
Get notified about new PL/SQL Developer jobs in Pennington, NJ.
Sign in to create job alertSimilar jobs
People also viewed
-
Software Developer 1
Software Developer 1
-
Software Developer(Entry/Junior Level)
Software Developer(Entry/Junior Level)
-
Software Developer 1
Software Developer 1
-
Software Engineer
Software Engineer
-
Software Engineer
Software Engineer
-
Software Engineer
Software Engineer
-
Full-Stack Web Developer
Full-Stack Web Developer
-
Software Engineer, Product (Early Career)
Software Engineer, Product (Early Career)
-
Data Engineer (L5)
Data Engineer (L5)
-
Software Engineer - L4 - Lifecycle Messaging
Software Engineer - L4 - Lifecycle Messaging
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub