Oracle Developer - ETL & Data Integration (Contract)

V Group Inc.

New York (NY)

On-site

USD 90,000 - 120,000

Part time

5 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

V Group Inc. seeks an Oracle Developer for a long-term contract with New York City Department of Social Services.

The project, OCSS Strategic Modernization, involves converting mainframe processes to the OCSS Web platform and building a data-centric, .NET-based web application for case management and child support tooling. You will design database architectures, develop ETL processes, optimize SQL, and coordinate with business users to ensure data integrity and performance across complex data

Qualifications

Minimum of 4 years of experience with Oracle, SQL Server, and related technologies.
Experience with ETL processes and scheduling jobs.
Strong SQL performance tuning and query optimization.

Responsibilities

Design and develop Database design and architecture
Design scalable and efficient database architecture based on business requirements
Develop logical and physical data models (ER diagrams, schema design)
Define tables, indexes, constraints, and relationships for optimal performance
Normalize and denormalize data structures as needed for performance and usability
Establish data standards, naming conventions
Design and monitor OCSSWeb monthly data refresh process
Schedule business process in SQL Agent jobs and Oracle Scheduled Jobs
Design and program ETL processes
Design and develop ETL process for data integration
Extract data from heterogeneous sources (databases, files,)
Transform data using business rules, validations, and cleansing logic
Load data into target systems
Implement error handling, logging, and recovery mechanisms
Schedule and automate ETL jobs using SQL Agent Jobs tool and Oracle Scheduled Jobs
Collaborate with Business users to understand data requirements
Analyze slow-running queries and identify performance bottlenecks
Review and interpret execution plans to improve query efficiency
Design and maintain effective indexing strategies
Implement query rewriting and refactoring techniques
Identify and resolve locking, blocking, and concurrency issues
Collaborate with developers to enforce query best practices
Maintain performance tuning documentation and guidelines
File transfer between shared folders/Database servers and FTP servers
Establish secure SFTP connections to source and target systems
Transfer files between servers while ensuring data integrity
Schedule and automate file transfers using scripts
Monitor and verify successful completion of file transfers
Implement error handling, retry mechanisms, and logging
Maintain transfer documentation, including file paths and schedules
Coordinate with business users to validate transferred data
Troubleshoot connectivity or transfer failures promptly
Archive and manage historical transferred files for audit and compliance purposes
Create and maintain database architecture documentation
Document logical and physical data models (ER diagrams, schemas)
Maintain data models version on TFS (Team Foundation Server)
Define database standards, naming conventions, and best practices
Document tables, relationships, constraints, and indexing strategies
Maintain version control and track schema changes
Collaborate with developers and DBAs to keep documentation up to date