Oracle PL/SQL developer - Information Technology - Analysts

Job Overview A client of Innova Solutions is immediately hiring for a Oracle PL/SQL Developer for contract to hire (Hybrid). The candidate will work at multiple locations: New York, NY; Jersey City, NJ; Addison, TX; and Charlotte, NC, for a 12-month duration. Must Haves Oracle PL/SQL Python ETL transformations (Informatica) Unix shell scripting Qualifications 10+ years of experience with relational and non-relational databases, focusing heavily on Oracle SQL and PL/SQL. Strong experience designing and implementing Oracle-driven data integration pipelines using SQL, PL/SQL, and Unix shell scripting. Experience automating Oracle processes using job schedulers (Autosys preferred). 10+ years of professional experience in SQL/PLSQL development, including packages, functions, procedures, triggers, and bulk processing. Ability to refine requirements, participate in story sizing, and help drive Agile delivery. Ability to perform POCs/spikes to test new Oracle features or solution patterns. Develop, test, and deliver Oracle-based solutions that meet acceptance criteria and adhere to compliance standards. Strong understanding of how to integrate multiple architectural components (data, application, business). Good understanding of dimensional modeling, star/snowflake schemas, facts, dimensions, and hierarchies. Skilled in leading and developing complex Oracle data flows, connecting to heterogeneous databases such as Oracle and MS SQL Server. Hands-on experience developing complex Oracle procedures, functions, and PL/SQL packages used in APIs, reporting, and data warehousing. Ability to conduct both proactive and reactive Oracle performance tuning using explain plans, indexing strategies, statistics, hints, and SQL optimization best practices. Strong hands-on experience developing and supporting Unix shell scripts. Benefits Pay Range : $73.68/hr to $73.68/HR (based on education, experience, location, duties, certifications, etc.) Benefits : Medical & pharmacy coverage, Dental/vision insurance, 401(k), HSA, FSA, Life Insurance, Pet Insurance, Short-term and Long-term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, other paid leaves as required by law, Employee Assistance Program (EAP). About Innova Solutions Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields. Contact Harsha Kumari 218-319-7963 harsha.kumari@innovasolutions.com Equal Opportunity Employer Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. It is committed to equal employment opportunity for all employees and to providing a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by law. If you are an individual with a disability and need a reasonable accommodation for the job search or application process, please contact us at hr@innovasolutions.com or (770) 493-5588. Innova Solutions encourages all qualified candidates to apply. Innova Solutions does not discriminate based on citizenship status, immigration status, or national origin in accordance with 8 U.S.C. § 1324b and complies with relevant Fair Chance ordinances. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Innova Solutions and its affiliates, as well as contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You may reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy – innovasolutions. J-18808-Ljbffr