Senior Oracle PL/SQL Data Warehouse/ETL Engineer

BCforward; Newark (NJ); In loco; USD 54.000 - 90.000; Tempo pieno

Vantaggi offerti da questo lavoro

Competitive compensation and benefits

Global client exposure

Inclusive culture

Descrizione del lavoro

BCforward, a leading IT consulting and workforce solutions firm, seeks a Senior Oracle PL/SQL + Data Warehouse / ETL Developer in Newark for a 12-month contract. You will design data models, develop Oracle PL/SQL, and build scalable ETL processes supporting data warehousing and analytics.

Ideal candidates will have 10+ years in Oracle PL/SQL, experience with DataStage/Informatica/Alteryx, and proficiency with BI tools.

Competenze

• 10+ years of hands-on Oracle PL/SQL development and database performance tuning.
• Expertise in ETL design and development with tools such as DataStage, Informatica, or Alteryx.
• Data modeling across conceptual, logical, and physical layers for warehouse solutions.
• Strong data analysis skills with the ability to work independently on large data sets and validate data integrity.
• Experience with BI tools such as Tableau or MicroStrategy.
• Knowledge of job scheduling and automation tools such as Autosys and shell scripting.
• Proficiency with Excel for data analysis and reporting.

Mansioni

• Design conceptual, logical, and physical data models for data warehousing and analytics.
• Develop, enhance, and fine-tune Oracle PL/SQL code and database objects.
• Build and optimize ETL processes to improve data flow, quality, and integrity.
• Analyze large data sets, identify patterns, and present findings to stakeholders.
• Collaborate with upstream SOR and downstream consumers to align data models and interfaces.
• Enhance legacy processes and define new standards for scalability and reliability.
• Operate within an Agile environment and deliver in accelerated sprints with minimal supervision.

Conoscenze

Oracle PL/SQL development

ETL design

Data modeling

Data analysis

BI tools

Autosys

Shell scripting

Excel

Formazione

Bachelor's degree in quantitative field

Strumenti

DataStage

Informatica

Alteryx

Descrizione del lavoro

BCforward, a leading IT consulting and workforce solutions firm, seeks a Senior Oracle PL/SQL + Data Warehouse / ETL Developer in Newark for a 12-month contract. You will design data models, develop Oracle PL/SQL, and build scalable ETL processes supporting data warehousing and analytics.

Ideal candidates will have 10+ years in Oracle PL/SQL, experience with DataStage/Informatica/Alteryx, and proficiency with BI tools.