Job Description
We are seeking an experienced applications programmer to develop, enhance, test, and maintain enterprise applications and database solutions. The role involves Oracle PL/SQL development, SQL programming, ETL data integration, batch processing, and application support within banking and financial services environments.
Key Responsibilities
- Develop, maintain, and optimize Oracle SQL, PL/SQL procedures, functions, packages, triggers, and database objects.
- Design, develop, and maintain ETL mappings, data integration workflows, and data migration processes.
- Perform application enhancements, debugging, troubleshooting, and production support.
- Develop Unix shell scripts and batch scheduling processes to automate data processing.
- Prepare technical design documents, test cases, and workflow diagrams, and conduct unit and integration testing.
- Support financial risk management, regulatory reporting, and data warehouse applications.
- Work with cross-functional teams to implement system upgrades, releases, and production fixes.
- Apply relevant technologies, including Oracle Database, SQL Server, Informatica, Python, PySpark, Databricks, and Apache Spark, as required by project needs.
Requirements
- Strong experience in Oracle SQL, PL/SQL, database development, and application maintenance.
- Hands-on experience with ETL tools, data integration, Unix shell scripting, and batch processing.
- Experience in application testing, troubleshooting, system enhancements, and production support.
- Knowledge of banking, financial services, risk management, or regulatory reporting systems is preferred.
- Familiarity with Python, PySpark, Databricks, Apache Spark, SQL Server, and reporting tools will be an advantage.