Description
You will build and maintain data pipelines to ensure accurate data loading into the Datamart.
Responsibilities
- Develop ETL maps and shell scripts to clean and load data.
- Tune existing Bigdata Hadoop ETL jobs for performance.
- Execute Oracle Database upgrades from 9i to 11g.
- Perform data mapping, conversions, interfaces, and validation.
- Create PL/SQL packages and stored procedures to load data from external systems into Oracle.
Required Skills
- 5+ years of experience in ETL development.
- Proficiency with PL/SQL packages and stored procedures.
- Experience with data mapping and data conversions.
- Hands-on experience managing interfaces.
- Working knowledge of Oracle Database environments.
- Experience with Bigdata Hadoop ETL jobs.
- Ability to write and use shell scripts.
- Willingness to travel or relocate to client sites.