Senior Oracle ETL Developer

BC Forward
Jersey City, United States of America
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 142K

Job location

Jersey City, United States of America

Tech stack

Java
API
Amazon Web Services (AWS)
Data analysis
JIRA
Azure
Big Data
ETL
Data Warehousing
Linux
Distributed Systems
Hadoop
Spring
Oracle
Oracle Applications
Oracle SQL Developer
Performance Tuning
Scrum
Power BI
Software Engineering
PL-SQL
Tableau
YAML
Scripting (Bash/Python/Go/Ruby)
Informatica Powercenter
Snowflake
Data Lake
Kubernetes
Kafka
Data Pipelines
Docker

Job description

  • Participate actively in an Agile scrum team with daily collaboration.
  • Engage with product owners and business partners to refine requirements and priorities.
  • Design, develop, and deploy Oracle SQL and PL/SQL code for large-scale data processing.
  • Build and optimize Informatica (PowerCenter/IDMC) ETL workflows on Linux/Unix.
  • Estimate, groom, and deliver user stories on schedule with quality.
  • Implement Enterprise Sanctions and AML screening on the NetReveal platform.
  • Model relational and dimensional schemas, including Star and Snowflake designs.
  • Tune queries and applications for performance in high-volume environments.
  • Integrate data warehouses with BI platforms and support dashboard delivery.

Requirements

We are seeking an experienced Application Programmer III to join our dynamic team. The ideal candidate will have strong experience in Oracle SQL/PLSQL, Informatica ETL, and Linux/Unix engineering and a proven ability to deliver scalable data solutions for sanctions and AML screening on enterprise platforms., * Expertise in Oracle SQL and PL/SQL with deep knowledge of Oracle database architecture.

  • Strong proficiency with Informatica PowerCenter and IDMC, and Linux/Unix scripting.
  • Advanced performance tuning for queries and ETL in large datasets.
  • Hands-on experience with relational and dimensional data modeling.
  • Experience in sanctions and AML domains or financial crimes solutions.
  • Agile delivery experience with Jira and scrum ceremonies participation.
  • Effective communication, problem-solving, and self-directed work style.
  • 15+ years of application development experience.

Preferred Skills:

  • Experience with NetReveal platform for screening implementations.
  • Hadoop ecosystem knowledge and distributed systems experience.
  • Tableau and Power BI development for dashboards and analytics.
  • Familiarity with Delta Lake and Lakehouse architectures.
  • Containers and cloud platforms such as Docker, Kubernetes, AWS, Azure, or GCP.
  • Exposure to APIs, Spring, Java, Kafka, MQ, and YAML.
  • Banking and financial services experience, including PEP and negative news screening.

Benefits & conditions

  • Competitive compensation and benefits
  • Opportunities for growth with global clients
  • A supportive, inclusive culture that values innovation and people
  • Exposure to cutting-edge technologies and projects

About the company

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Apply for this position