Innova Solutions
Application Architect V_Database - Oracle PL/SQL Developer/Architect
Innova Solutions, Jersey City, New Jersey, United States, 07390
Overview
Application Architect V_Database - Oracle PL/SQL Developer/Architect Location: Jersey City, NJ Duration: 12-18 Months Contract (LONG-TERM) Position Type: W2-Hybrid Contract 3 Days Onsite and 2 Days Remote per week Experience Level: Min. 10+ Years Responsibilities
Translate requirements created by functional analysts into the architecture for the solution and document it through architecture and design documents used by the development team. Develop complex ETL workflows using Informatica PowerCenter. Develop test cases and perform unit testing. Create data mappings to ingest data from disparate sources (flat files, RDMS, Hive, REST APIs). Develop Unix scripting. Strong technical skills in Informatica PowerCenter. Oracle DB performance tuning for targets, sources, mappings, and SQL queries; PL/SQL, functions, complex SQL, and exposing views/materialized views. Strong UNIX commands and scripting. Good understanding of MuleSoft Integration; proficiency in MuleSoft tools is desired. Team & Contacts
Regular point of contact: Feature Lead, who manages 8-12 people on a scrum team. Role is on the Climate Risk Data Platform (CRDP) team developing the front end of the enterprise data warehouse for environmental and climate risk data. Top Skillets & Must-Have Technical Skills
Oracle PL/SQL Informatica UNIX Shell Scripting ETL Informatica PowerCenter Data Warehousing MuleSoft Compensation & Benefits
Hourly Pay Range: $70.00/hr - $73.00/hr. Pay range is based on education, experience, location, duties, and certifications. Benefits (eligibility-based): Medical & pharmacy, Dental/vision, 401(k), HSA, FSA, Life Insurance, Disability, EAP, and other leaves as required by law. About Innova Solutions
Founded in 1998, Innova Solutions is headquartered in Atlanta, GA, employs thousands of professionals worldwide, and provides technology and business transformation solutions. Equal Opportunity
Innova Solutions is an Equal Opportunity Employer and prohibits discrimination and harassment. If you need a reasonable accommodation during the job search or application, contact hr@innovasolutions.com or (770) 493-5588. #J-18808-Ljbffr
Application Architect V_Database - Oracle PL/SQL Developer/Architect Location: Jersey City, NJ Duration: 12-18 Months Contract (LONG-TERM) Position Type: W2-Hybrid Contract 3 Days Onsite and 2 Days Remote per week Experience Level: Min. 10+ Years Responsibilities
Translate requirements created by functional analysts into the architecture for the solution and document it through architecture and design documents used by the development team. Develop complex ETL workflows using Informatica PowerCenter. Develop test cases and perform unit testing. Create data mappings to ingest data from disparate sources (flat files, RDMS, Hive, REST APIs). Develop Unix scripting. Strong technical skills in Informatica PowerCenter. Oracle DB performance tuning for targets, sources, mappings, and SQL queries; PL/SQL, functions, complex SQL, and exposing views/materialized views. Strong UNIX commands and scripting. Good understanding of MuleSoft Integration; proficiency in MuleSoft tools is desired. Team & Contacts
Regular point of contact: Feature Lead, who manages 8-12 people on a scrum team. Role is on the Climate Risk Data Platform (CRDP) team developing the front end of the enterprise data warehouse for environmental and climate risk data. Top Skillets & Must-Have Technical Skills
Oracle PL/SQL Informatica UNIX Shell Scripting ETL Informatica PowerCenter Data Warehousing MuleSoft Compensation & Benefits
Hourly Pay Range: $70.00/hr - $73.00/hr. Pay range is based on education, experience, location, duties, and certifications. Benefits (eligibility-based): Medical & pharmacy, Dental/vision, 401(k), HSA, FSA, Life Insurance, Disability, EAP, and other leaves as required by law. About Innova Solutions
Founded in 1998, Innova Solutions is headquartered in Atlanta, GA, employs thousands of professionals worldwide, and provides technology and business transformation solutions. Equal Opportunity
Innova Solutions is an Equal Opportunity Employer and prohibits discrimination and harassment. If you need a reasonable accommodation during the job search or application, contact hr@innovasolutions.com or (770) 493-5588. #J-18808-Ljbffr