Job Description: ETL Developer (Oracle PL/SQL / Ab Initio + Testing)

iTek People Inc
Wilmington, DE, United States
8 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Batch Processing Big Data Data Validation Data Integration Extract Transform Load (ETL) Data Warehousing Oracle Databases Oracle SQL Developer Query Optimization E2e Testing Software Engineering
+5 more
SQL Databases Enterprise Data Management Data Processing Ab Initio Integration Tests

Job description

We are seeking a skilled ETL Developer with strong hands-on experience in Oracle PL/SQL or Ab Initio and expertise in ETL testing. The ideal candidate will design and support data processing applications, develop ETL workflows, and perform end-to-end validation of complex data integration and batch processing systems., * Design, develop, enhance, and support data processing applications and ETL workflows.

  • Perform end-to-end testing of complex data integration, ETL, and batch processing systems, including functional, regression, and integration testing.
  • Develop and execute SQL-based test cases, data validation queries, and reconciliation processes.
  • Validate source-to-target data mappings and ensure data accuracy, completeness, and consistency.
  • Analyze complex datasets using Oracle SQL and troubleshoot ETL/data quality issues.
  • Collaborate with developers, QA teams, and business stakeholders throughout the software development lifecycle.

Requirements

  • Strong hands-on experience with Oracle PL/SQL or Ab Initio ETL.
  • Expertise in Oracle Database, including complex SQL, query optimization, and data analysis.
  • Experience with ETL development and enterprise data integration.
  • Strong knowledge of ETL testing, data validation, reconciliation, and defect analysis.
  • Experience with functional, regression, and integration testing methodologies., * Experience working in enterprise data warehouse environments.
  • Familiarity with batch processing and large-scale data integration projects.
  • Strong analytical, troubleshooting, and communication skills.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…