Innova Solutions has a client that is immediately hiring for a Senior Oracle PL / SQL Developer
Position type : Hybrid Contract (
- Hybrid Position : 3 Days Onsite and 2 Days Remote Work in a week!!!)
Position : Senior Oracle PL / SQL Developer
Location : Plano, TX 75024
Duration : 12-18 Months contract (LONG-TERM)
Job Description :
The Claims Technology team is looking for a Sr. Data Architect / Lead Oracle Database Developer.
Requirements include :
10+ years of experience (in the financial industry) working experience in Data Warehousing environments with very large amounts of data.Review the E2E ETL process and apply critical performance tuning skills to optimize the Oracle ETL process and real time operational services;Candidates must possess advanced problem-solving skills, analyzing complex data and ability to connect dots to understand data across different systems and multiple claims products, able to work multiple projects assignments concurrently, willingness to self-learn and ability to communicate verbally effectively and concisely and in written / presentable format.Candidates must work well in a supportive and transparent team environment, while having the ability to research and resolve issues independently.Candidates must have good communication skills and the ability to engage multiple business analysts and developers / dev leads and influence teams across Claims technology and the business.Required Skills :
Primary : Oracle SQL / PLSQL
Secondary : Data Warehousing
Tertiary : ETL Data Frameworks
Sr. Oracle developer with 12+ years hands on skills to provide effective data design solutions in Data Warehousing environment with very large amounts of data.Advanced Oracle PL / SQL with DBA experience (10+ years) with ability to identify areas needing performance improvement, studying Oracle execution / query plans, Oracle AWR reports and apply skills in identifying problematic areas and fine tune the queries / tables and indexes optimizations,Be able to design the conceptual, logical and physical data models necessary to support the data requirements in Data warehouse environments,Working experience building high performance ETL Data Frameworks with error handling and scalability.Strong working experience in database partitions, indexes, CDC, purging, data virtualizations,.Strong analytics and communication skills including ability to drive diverse group towards common goals and clearly articulate both problems and proposed solutionsAbility to balance need to deliver multiple concurrent projects while maintaining architectural standards3+ years working Experience in Agile / Scrum delivery modelsUnix scripting experience.Creates documentation for all activities and work with project solution team in design of application and code developed.Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value. Challenges data and information integrity. .Strong data analysis skillsPreferred Skills :
Experience in data visualization tools like Tableau (preferred), Power BI, ...Experience / Exposure in in Python, Hadoop, and Gen AI / MLFinancial Services / Banking industry experience a plus.Technical Skills :
Oracle SQL / PLSQLData WarehouseETL ToolsDatabase Performance TunningThank you!
Sunil Nanda
Innova Solutions Inc.
Tel : (+1)
Email ID :
PAY RANGE AND BENEFITS :
Hourly Pay Rate Range
Between $65.00 / hr - $68.00 / hrPay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.Benefits : Innova Solutions offers benefits( based on eligibility) that include the following : Medical & pharmacy coverage, Dental / vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).