Job description:
Responsibilities:
- Responsible for an ETL/Oracle developer role on the GBREG under Wholesale Credit line of business
- Collaborate with multiple stakeholders for design and development of a GBREG/SNC and other use cases
- Application and ETL process development in Global Banking Regulatory Data Source Ecosystem
- Source data from multiple systems into Oracle Exadata Data Lake, conform and provision the data to down streams
- Translate functional and technical requirements into detailed design
- Maintain security and data privacy
- Propose best practices/standards
- Prepare high level and low level design documents
- Coding and unit testing, support SIT, UAT, and production deployments
Requirements:
- 5-7 years data analysis experience
- Good database programming skills covering Design/development of Stored Procedures, Functions, Tables, and Triggers and tuning SQL queries for optimal performance.
- Strong problem-solving, analytical, and innovation skills
- Strong written and verbal communication skills
- Ability to work effectively with others in a collaborative team environment.
- Experience working in Agile teams.
- Broad and deep understanding of wholesale credit product information and related business processes (sales, underwriting, fulfillment, servicing, monitoring and supporting applications)
- Experience with enterprise provisioning standards, metadata and lineage, process controls and data quality
- Oracle Exadata, PL/SQL
- Informatica
- Unix Shell Scripting, Autosys