24 Sep
|
Clock Edge Technologies Pvt Lt
|
Bengaluru
24 Sep
Clock Edge Technologies Pvt Lt
Bengaluru
Data Engineer – Data Platforms-Snowflake
contract basis jon thirdparty ayroll artech
JP ID: IBMFG2JP00041069
Client: IBM
Payroll: Artech
Location: Bangalore / Pune / Chennai
Interview Mode: Face to Face
Budget: 13 LPA Max
Total Experience: 4+ Years
Relevant Experience: 3+ Years
Mandatory Skills
* Oracle Database & PL/SQL
- Banking/Financial Services Domain
- Unix/Linux
- SQL, Joins, Indexes, Exceptions, Cursors & Debugging
- Stored Procedures, Packages, Functions, Views, Cursors & Triggers
- Complex SQL Queries & SQL Tuning
- Database Performance Optimization
- SQL*Loader
- Production Support for Banking Applications
- Robust Problem-Solving & Analytical Skills
Role Overview
Looking for an experienced Oracle PL/SQL Developer with strong expertise in *Oracle Database, PL/SQL, Unix/Linux, SQL performance tuning, and hands-on experience in the **Banking/Financial Services domain*. The role involves database solutions for banking applications, financial data processing, transaction processing, batch jobs, migration, reconciliation, and production support.
Key Responsibilities
* Develop and maintain Oracle PL/SQL components for banking applications.
- Develop Stored Procedures, Packages, Functions, Views, Cursors, Triggers, and other database objects.
- Develop and optimize complex SQL queries for high-volume banking transactions.
- Perform SQL tuning and database performance optimization using execution plans, indexes, joins, and other techniques.
- Work with Unix/Linux environments and develop Unix shell scripts for batch processing and operational activities.
- Work on banking transaction processing, account/customer data, payments, settlements, reconciliation, and financial data processing.
- Support daily/monthly/yearly batch processing and EOD/COB activities.
- Perform data validation, reconciliation, exception handling, and issue resolution.
- Work with *SQL*Loader* for bulk data loading and data migration.
- Troubleshoot production issues, perform RCA, and implement permanent fixes.
- Collaborate with application, testing, ETL, infrastructure, and business teams.
- Participate in database migration, data conversion, and system enhancement activities.
- Work with Autosys and/or Control-M.
- Follow database coding, security, performance, and quality standards.
- Participate in Agile ceremonies, code reviews, testing, deployment, and release activities.
Pay: Up to ₹1,300,000.00 per year
Work Location: In person
📌 Data Engineer – Data Platforms-Snowflake (Bengaluru)
🏢 Clock Edge Technologies Pvt Lt
📍 Bengaluru