Informatica Data Integration Specialist

Recruiter:

Golden Rule

Job Ref:

GDR03603

Date posted:

Monday, May 19, 2025

Location:

Johannesburg, South Africa

Salary:

Negotiable

SUMMARY:

Requirements

Understand the business requirement or the downstream process requirement.
Deliver Informatica PowerCenter and Power Exchange solution implementation and support.
Work with Data Mapper and Data modeler to define the dataflow and implement the ETL to fulfil the requirement.
Pro...

POSITION INFO:

Requirements
- Understand the business requirement or the downstream process requirement.
- Deliver Informatica PowerCenter and Power Exchange solution implementation and support.
- Work with Data Mapper and Data modeler to define the dataflow and implement the ETL to fulfil the requirement.
- Provide L2 support in Production for Informatica PowerCenter and Power Exchange.
- Creates ETL Mappings, Mapplets, Workflows, Worklets.
- Development skills is must.
- Knowledge in SQL, writing complex queries, RDBMS.
- Knowledge in designing and developing data integrations using Informatica PWX and PC.
- Working Knowledge with Informatica PC Client Components.
- Working Knowledge in creating complex task flows, reusable components and user function.
- Good knowledge in SQL and data analysis.
- MDM Admin role and responsibilities.
Â

Operational Delivery
- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and Power Exchange and prepare corresponding documentation.
- Designing and developing data integrations using Informatica PC.
- Knowledge of advanced concepts like partitioning, optimization, and performance tuning is advantageous.
- Good knowledge in SQL and data analysis.
- Experience with Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Work with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
- Ability to perform Standby duties.
- Additional responsibilities may be assigned.
- Ability to identify and resolve any production issues.
- Ability to work in a fast-paced environment and deliver production quality software within tight schedules.
- Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solutions.
Qualifications
- Bachelorâ€™s Degree in Computer Science, Information Technology or other relevant fields.
Â

Work Experience
- 3-4 years of experience in software development utilizing Informatica in combination with Oracle databases in a distribution system environment is preferred.
- At least 3 years of solid experience with informatica PowerCenter Power Exchange development.
- Experience with working on Oracle, MSSQL and Informatica ETL technologies.
- Good Knowledge of application design principles, systems development and analysis.
- Working Knowledge with Informatica design and development skills using Informatica power center and power exchange. (10.x preferred).
- Knowledge of Informatica architecture administration.
- Experience using Informatica development tools (designer, workflow manager, etc.).
- Familiarity with Agile methodologies and standards.
- Knowledge of Informatica deployment process and version control.
- Proficient with database design, SQL and stored procedures.
Â

Technical Competencies
- Informatica PowerCenter ETL experience.
- Intimate knowledge of source systems as well as a basic understanding of dimensional models.
- Conventional database- and data warehouse modelling skills, in order to understand the data warehouse data models.
- Good knowledge of database structures/ data warehousing principles, and experience in SQL across different platforms including structured and unstructured data from various enterprise sources.
- Hands on with batch and real-time data integration patterns include ETL experience in Informatica Cloud or Informatica PowerCenter.
- Proven technical skills in data modelling, data management, data pipelines, ETL/ELT and data retention concepts and practices.
- Show a strong sense of ownership for their deliverables.
- Professional experience with application and/or production support.

Similar jobs you might be interested in:

Group Data and Analytics Strategy Specialist
Location: Johannesburg
Salary: market related Monthly
Job requirementsProficient in data Analytics and Strategy Analysis,Strong Communication skills i.e. verbal and written – Skilled at integrated reporting, business planning and creating dashboards that provide insights. Skilled at collaborating with Senior leadershipBusiness development experience- seek opportunities to improve business processes, models and systemsGood understanding of Strat...
Today

Master Data Entry Specialist
Location: Johannesburg
Salary: To be discussed at Interview stage
As a master data management specialist, you coordinate the collection of master data from your internal and external contacts and enter it into The Company`s TMS and global applications.
6 days ago

Data Migration Specialist
Location: Somerset West
Salary: R20k - 22k per month
data, Migration, specialist,
6 days ago

Specialist Data Scientist (3 Month Contract)
Location: Johannesburg
Salary: 500 Hourly
Join a high-performance team in Sandton as a specialist data Scientist on a 3-month contract. This role focuses on developing and optimising market-making models for equities and derivatives within a fast-paced trading environment. Candidates must have direct experience in global markets and a strong grasp of pre- and post-trade data processes.
9 days ago

DATA and MANAGEMENT INFORMATION SPECIALIST
Location: Pretoria
Salary: Market related
Focuses primarily on revenue, commission, and advisor-related data within the Commsplit system.
10 days ago

DATA and MANAGEMENT INFORMATION SPECIALIST
Location: Pretoria
Salary: Market related
Focuses primarily on revenue, commission, and advisor-related data within the Commsplit system.
11 days ago

Informatica Data Integration Specialist
Location: Johannesburg
Salary: Negotiable
Requirements Understand the business requirement or the downstream process requirement. Deliver Informatica PowerCenter and Power Exchange solution implementation and support. Work with data Mapper and data modeler to define the dataflow and implement the ETL to fulfil the requirement. Pro...
17 days ago

Data & Risk Specialist
Location: Johannesburg
Salary:
A data & Risk specialist Wanted – SQL Sorcery & Power BI Brilliance Required! Are you the kind of person who spots anomalies in spreadsheets for fun? Do you believe that Power BI dashboards should be both functional and fabulous? Can you wrangle SQL like a wizard with a keyboard wand? Then we need to talk.
20 days ago

SENIOR DATA ENGINEER (Specialist)
Location: Bellville
Salary:
SENIOR data ENGINEER (specialist)Kraaifontein As a Senior data Engineer, you’ll design, build, and maintain robust data infrastructure to support reporting and analytics across Finance and Operational BI. Your focus will be on developing reliable data pipelines, standardizing data models, and ensuring consistent access to high-quality, governed data across teams.
22 days ago

GRM Specialist: Data Analytics
Location: Johannesburg
Salary: Market related
My client is seeking an enthusiastic individual with a strong background in mathematics, data programming, and data analytics (at a proficient level). You will join a dynamic, high-performing team that acts as internal consultants, solving real business problems, analyzing underlying processes, and making impactful recommendations to add tangible value to the business. This role is essential in dr...
22 days ago