VI
ETL Developer
VARITE INDIA PRIVATE LIMITED
- 🇮🇳 India
- On-site
- 5 days ago
- ETL
- SQL
- PL/SQL
- Informatica
- SSIS
- Oracle
- Talend
- Oracle Database
5 days ago
About The Client:
One of the oldest banking institutions in the UAE and Middle East. The Client provides a range of conventional and Islamic banking services, including personal banking solutions such as deposits, loans, and credit cards. The bank also offers corporate and investment banking services, including corporate finance, investment advisory on mergers and acquisitions, initial public offerings (IPOs), and underwriting
About The Job:
Essential Job Functions:
Qualifications:
Key Responsibilities
Analyze and understand data requirements for OFSAA ALM and IRRBB.
Identify required data elements from source systems/data warehouse and prepare source-to-target mappings.
Develop and maintain ETL processes for extracting, transforming, validating, and loading data into OFSAA.
Understand the OFSAA/SASA data model, including key tables, fields, relationships, and dependencies.
Develop transformation and derivation logic based on functional ALM/IRRBB requirements.
Develop complex SQL and PL/SQL queries, procedures, functions, and scripts for data processing and validation.
Perform data cleansing, transformation, reconciliation, and data-quality checks.
Validate data loaded into OFSAA against source systems and agreed requirements.
Investigate and resolve data discrepancies affecting ALM/IRRBB calculations and outputs.
Support SIT/UAT by preparing test data, performing data validation, and resolving ETL-related issues.
Work closely with the OFSAA ALM techno-functional team, bank data teams, DBAs, and implementation vendors.
Prepare technical documentation covering ETL processes, mappings, transformation rules, and data dependencies.
Required Skills & Experience
2–5 years of relevant experience in ETL development, data engineering, or banking technology.
Strong hands-on experience with SQL and PL/SQL.
Experience with at least one enterprise ETL tool, such as:
Informatica
Microsoft SSIS
Oracle Data Integrator (ODI)
DataStage, Talend, or equivalent.
Strong understanding of relational databases, data models, joins, keys, indexes, and data relationships.
Experience developing source-to-target mappings and transformation logic.
Experience with data validation, reconciliation, and troubleshooting.
Ability to work with large volumes of financial/banking data.
OFSAA / ALM Knowledge
Knowledge of OFSAA ALM and/or IRRBB data requirements is preferred.
Understanding of relevant OFSAA/SASA key tables and data structures is highly desirable.
Ability to understand ALM data requirements relating to accounts/instruments, balances, cash flows, interest rates, maturity, repricing, currencies, and related attributes.
Ability to translate functional requirements into technical ETL specifications and implementation.
OFSAA implementation experience will be an added advantage.
Preferred Qualifications
Bachelor's degree in Computer Science, IT, Software Engineering, Engineering, or a related field.
Experience in banking or financial services.
Experience with Oracle Database and enterprise data warehouses.
Key Competencies
Strong analytical and problem-solving skills.
Excellent SQL/PLSQL and ETL development capabilities.
Strong attention to data accuracy and reconciliation.
Ability to understand complex data requirements and convert them into practical ETL solutions.
Good communication and collaboration skills.
Primary Objective
To ensure that accurate, complete, and appropriately transformed source data is delivered to the OFSAA ALM/IRRBB solution through robust ETL processes, with appropriate validation and reconciliation against the bank's source data and requirements.
How to Apply: Interested candidates are encouraged to respond/submit their updated resumes, and for additional job opportunities, please visit Jobs In India – VARITE.
Unlock Rewards: Refer Candidates and Earn.
If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE.
Experience Level Bonus Referral:
0-2 years INR 5,000
2-6 years INR 7,500
6+ years INR 10,000
About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.
Equal Opportunity Employer:
VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.
ETL Developer · VARITE INDIA PRIVATE LIMITED