Job#: 3033581 Job Description: Oracle Consultant (Informatica)
Location: Jersey City, NJ / Charlotte NC (Hybrid)Employment Type: ContractDuration: 12 monthsRole Overview
We are seeking an Application Programmer with extensive experience in application development. The ideal candidate will be an active participant in an Agile scrum team, focusing on the design, development, and deployment of solutions involving Oracle databases, Informatica/ETL, and Linux environments. This role involves daily interactions with the product owner and limited interaction with client and business partners.
Key Responsibilities
- Act as an active participant in the scrum team, contributing to story estimation, tailoring, and grooming to ensure timely completion.
- Design, develop, and deploy solutions using Oracle (SQL, PL/SQL), Informatica/ETL, and Linux.
- Develop highly optimized Oracle SQL and PL/SQL code for large-scale data processing.
- Design, model, and optimize database schemas for scalability and performance.
- Conduct advanced query and application performance tuning in high-volume environments.
- Manage and process large datasets efficiently.
- Integrate Data Warehouse solutions with Business Intelligence platforms.
Required Qualifications
Experience: A minimum of 15 years of work experience in application development is required.
Technical Skills:- Expertise in Oracle database (SQL, PL/SQL), including architecture and core internals.
- Strong proficiency with Informatica (PowerCenter and IDMC) and Linux/Unix scripting.
- Extensive hands-on experience with relational and dimensional data modeling (Star and Snowflake schemas).
- Proficiency in Tableau development and dashboard visualization.
- Experience with Hadoop.
- Knowledge of Financial Crimes, Economic Sanctions, and AML screening processes.
Preferred Qualifications
- Familiarity with Delta Lake and Lakehouse architectures.
- Experience with containers and cloud platforms (Docker, Kubernetes, AWS, Azure, Google Cloud Platform).
- Exposure to APIs, Spring, Java, Kafka, MQ, and YAML.
- Experience with distributed systems.
- Familiarity with Agile delivery and JIRA.
Compensation & Benefits
Pay Rate: $65.00/hr - $68.26/hr
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.
Apex uses a virtual recruiter as part of the application process. Click for more details.
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.
Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.
Never miss an opportunity! Create an alert based on the job you applied for.