About the job

Synechron is a leading digital transformation consulting firm focused on the financial services industry and is working to Accelerate Digital initiatives for banks, asset managers, and insurance companies around the world. Synechron uniquely delivers these firms' end-to-end Digital, Consulting, and Technology capabilities with expertise in wholesale banking, wealth management, and insurance as well as emerging technologies like Blockchain, Artificial Intelligence, and Data Science. Based in New York, the company has 22 offices around the globe, with over 13,000 employees producing over $800M+ in annual revenue. For more information on the company, please visit our website at https://www.synechron.com/ or our LinkedIn community.

Required Skillset

• 10+ years of experience in Oracle PL/SQL application development end to end.

Must have experience implementing External tables for data loading

• Experience with PL/SQL bulk read and write code

• Must have experience with PL/SQL package driven development

• Experience and knowledge in the performance design aspects of PL/SQL coding

• Experience with complex SQL statements and performance aspects of SQL

• Understanding of data modeling concepts including dimensional modeling

• Excellent verbal and communications skills

• Prior experience in defining coding standards and best practices for Oracle PL/SQL development

• Minimum Oracle v11 experience. Knowledge/experience in 12c PL/SQL enhancements is a plus

• Ability to come up with a technical design for loading based on a complex data model

• Working experience in data mapping for data loading, bulk data loading, and External tables

• Ability to perform SQL tuning of queries, optimize reports and data retrieval response times

• Strong in debugging and understanding existing code for modification