Assistant Manager, Informatica Developer

Job not on LinkedIn

September 19

Apply Now

Receive Emails with Similar Jobs

Mashreq

WebsiteLinkedInAll Job Openings

Banking • Finance • Fintech

Mashreq is a leading financial institution based in the UAE, offering a wide range of banking services including personal, corporate, and investment banking. The bank focuses on providing innovative financial solutions to its customers and has a strong digital banking presence.

1001 - 5000 employees

Founded 1967

🏦 Banking

💸 Finance

💳 Fintech

📋 Description

• Development and maintenance of the applications and processes on Informatica platform. • Enhancing, supporting, and fixing any issues in the existing application for regulatory reporting and other regulatory applications. • Deploy bug fixes in test environment and perform SIT. • Troubleshoot and resolve data issues and ETL process failures; implement error handling and recovery strategies. • Create detailed project documentation like FSD, SDD, TDD, Test Cases, Data Mappings; maintain proper versioning. • Participate in code reviews and provide constructive feedback to peers. • Work on service tickets and provide resolution of production issues within defined SLA; respond to incidents/application outages and restore services. • Analyze problems and provide Root Cause Analysis for incidents and implement fixes. • Proactively check server status and ensure applications/systems are available and patched according to patch management cycles; configure proactive alerts. • Collaborate with business analysts, data architects, and stakeholders to translate business requirements into technical solutions; plan and estimate projects.

🎯 Requirements

• 3-5 Yrs. Of experience relevant to developing and managing ETL on Informatica Power Center (version 10.5 and above) • Design, develop, and implement complex mappings, sessions, and workflows using ETL processes using Informatica PowerCenter. • Identify the problems and Optimize ETL processes for maximum efficiency and performance through performance tuning. • Perform data analysis and data profiling to ensure data quality and integrity. • Must be able to use Informatica Data Quality tools. • Must have experience in Informatica Admin Center. • Develop and maintain reusable data mappings, workflows, and sessions, (Mapplets, Worklets). • Must have ability to work on different source and target data stores (XML, MSSQL, Oracle, CSV). • Should have knowledge on Snowflake, Java Transformation • Proficiency in SQL and experience with relational databases (Oracle, SQL Server) with Strong SQL skills for data extraction, transformation, and loading. • Strong understanding of SQL Stored Procedures, Functions, Cursors, DDL, DML. • Knowledge of big data technologies (Hadoop, Spark, Cloudera). • Should have experience with data warehousing concepts and techniques. • Must have Knowledge of data modeling and data architecture principles.