Senior PL/SQL ETL Developer
Core
Build and optimize ETL workflows to move data from transactional systems into analytical data warehouses.
Role type
Senior IC PL/SQL ETL Developer
Builds
Enterprise-scale data warehouse pipelines
Domain
Data Warehousing / ETL
Required skills
PL/SQL, Oracle Database, Informatica PowerCenter, Oracle Data Integrator, Talend, Unix/Linux shell scripting, SQL optimization, dimensional modeling, SCDs
Preferred skills
TOAD, SQL Developer, SQL Navigator, Control-M, Autosys, cron
Technologies
Informatica, Linux, ODI, Oracle, SQL, Snowflake, Talend, Unix
Responsibilities
Extract and ingest raw data from sources such as flat files, APIs, cloud architectures, and legacy databases; Transform business data by cleaning, aggregating, formatting, and validating it; Load transformed data into data warehouses efficiently using bulk-processing techniques; Analyze execution plans, optimize slow queries, apply indexing strategies, partition tables, and improve code performance; Create Unix/Linux shell scripts and use scheduling engines to automate batch pipelines.
