> Markdown version of [/jobs/ext/575910-lead-etl-developer-pl-sql](https://www.wearedevelopers.com/jobs/ext/575910-lead-etl-developer-pl-sql). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead ETL Developer- PL/SQL

- **Company:** Prutech Solutions
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Unit Testing, Computer Programming, Databases, Extract Transform Load (ETL), Data Mart, Data Mining, Data Structures, Data Warehousing, Cursor (Graphical User Interface Elements), Oracle Exadata, Oracle Databases, Performance Tuning, Standard Sql, SQL Stored Procedures, PL-SQL, SQL Databases, Data Lakes, Data Management, Database Rules and Triggers, Data Pipelines
- **Published:** June 19, 2026
- **Apply:** https://www.dice.com/job-detail/9aebe628-c50e-4aae-90c0-58291472ed2a

## About the Role

* At least 15 years of experience as ETL Developer., * Proficient in SQL and ETL processes, ETL and DB performance tuning.
 * Expertise in PL/SQL Programming including Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, built in functions, joins, aggregate functions, Collections.
 * Working experience with ETL tool (Preferred - Informatica - IICS)., * Passionate about complex data structures and problem solving.
 * High attention to detail.
 * Ability to pick up new data tools and concepts quickly.
 * Any Experience in public safety systems is a plus.

## Description

* Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements.
 * Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
 * Design the architecture to perform data management activities i.e., data extraction, transformation, and load (ETL) to enterprise data warehouse.
 * Implement the data management solutions using SQL, SQL procedures, data management tools like Informatica IICS on Oracle exadata database.
 * Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake.
 * Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support.
 * Develop data models and ER diagrams for existing and new databases.
 * Maintain and improve already existing processes.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)