You will design and develop ETL processes and applications within a Global Banking Regulatory Data Source Ecosystem. Your work ensures source data from multiple systems is correctly provisioned into an Oracle Exadata Data Lake for downstream consumption.
Responsibilities
- Translate functional and technical requirements into detailed high-level and low-level design documents.
- Develop, code, and unit test stored procedures, functions, tables, and triggers.
- Optimize SQL queries for performance while maintaining security and data privacy standards.
- Support SIT, UAT, and production deployments within an Agile team environment.
Required Skills
- 8+ years of experience in ETL and Oracle development.
- Expertise in PL/SQL, including stored procedures, functions, and triggers.
- Proficiency with Informatica for ETL processing.
- Hands-on experience with Oracle Exadata.
- Strong Unix Shell Scripting skills.
- Experience using Autosys for job scheduling.
- Proven ability to tune SQL queries for optimal performance.
- Experience working in Agile development setups.
Preferred Skills