We are seeking a highly skilled Informatica PowerCenter Developer to support complex enterprise data integration initiatives across a diverse technology landscape, including Oracle, DB2, Snowflake, Linux, and Mainframe environments. The ideal candidate will possess strong expertise in ETL development, data warehousing, system integration, and operational support, while effectively translating business requirements into scalable technical solutions.
Required Skills & ExperienceInformatica PowerCenter- Expert-level experience in developing and maintaining mappings, workflows, sessions, and transformations.
- Strong knowledge of performance tuning and optimization techniques.
- Hands-on experience with real-time and batch data integration involving legacy and mainframe systems.
- Strong command-line proficiency and experience with shell scripting for ETL automation, monitoring, and troubleshooting.
- Advanced SQL development skills, including complex queries, joins, window functions, stored procedures, and performance optimization.
- Extensive experience with PL/SQL, database performance tuning, partitioning, and large-scale data processing.
- Strong expertise in DB2 database structures, SQL development, connectivity, and integration with Informatica solutions.
- Hands-on experience with Snowflake data warehousing, virtual warehouses, performance optimization, clustering, and query tuning.
- Experience with Tableau for reporting and data visualization.
- Knowledge of OPC / Tivoli Workload Scheduler (TWS) for workload automation and scheduling.
- Exposure to Mainframe technologies and integration patterns.
- Experience supporting production operations, incident management, and SLA-driven environments.
- Ability to understand business processes and translate requirements into effective ETL and data integration solutions.
Skills Required
- Expert-level Informatica PowerCenter development (mappings, workflows, sessions, transformations)
- Performance tuning and optimization for Informatica PowerCenter
- Informatica PowerExchange hands-on experience with real-time and batch integration involving legacy/mainframe systems
- Linux command-line proficiency and shell scripting for ETL automation, monitoring, and troubleshooting
- Advanced SQL development including complex queries, joins, window functions, and stored procedures
- Oracle Database experience with PL/SQL, performance tuning, partitioning, and large-scale data processing
- DB2 database structures, SQL development, connectivity, and integration with Informatica
- Snowflake hands-on experience with virtual warehouses, performance optimization, clustering, and query tuning
- Experience with Tableau for reporting and data visualization
- Knowledge of OPC / Tivoli Workload Scheduler (TWS) for workload automation and scheduling
- Experience supporting production operations, incident management, and SLA-driven environments
- Ability to understand business processes and translate requirements into effective ETL and data integration solutions
Datamatics Technologies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Datamatics Technologies and has not been reviewed or approved by Datamatics Technologies.
-
Flexible Benefits — Feedback suggests flexible timings and work-from-home options are available in some roles. This flexibility is highlighted as part of the employment experience across certain postings and materials.
-
Wellbeing & Lifestyle Benefits — Feedback suggests flexibility around time off and remote work supports work-life balance. These elements can help offset leaner cash components for some individuals.
Datamatics Technologies Insights
What We Do
Datamatics Technologies (DMT) was established in Dubai. We specialize in providing onsite and offshore professional services, covering the full spectrum of Data Analytics and Data Science domains. Our experience of working with diverse industry sectors such as Telecoms, Finance, Government and Manufacturing, across multiple regions enables us to engage and deliver for our clients with confidence. We can offer our full portfolio of services through resource augmentation, managed services, both on T&M or fixed price financial arrangements. Through our end-to-end managed services offering we enable our clients to cut down costs, increase profitability and focus on value addition to their core business activities. Our project and delivery management team are certified in Agile, PMI and ITIL to ensure the planning and execution are carried out using industry best practices. We are working with our clients across Middle East and Africa Region.
