Informatica/MS Data Engineer

 

Recruiter:

PBT Group

Job Ref:

PBT1930668456

Date posted:

Monday, March 28, 2022

Location:

Johannesburg, South Africa

Salary:

market related


JOB SUMMARY:
PBT Group has an opportunity for an Informatica / Microsoft BI (SSIS, SSRS, SSAS) Data Engineer. Candidates must have a minimum of 5 years in Business Intelligence with end to end understanding of BI.

JOB DESCRIPTION:

PBT Group has an opportunity for an Informatica / Microsoft BI (SSIS, SSRS, SSAS) Data Engineer. Candidates must have a minimum of 3 years in Business Intelligence with end to end understanding of BI.

DUTIES:

- Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.

- Conduct planning, analysis and design activities in conjunction with other development specialists.

- Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.

- Participate in estimation of tasks and assist in the development of project plans.

- Code or makes modifications to programs of high complexity, according to specifications.

- Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.

- Conduct walkthroughs and quality review of deliverables.

- Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.

- Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.

- Participate in the formulation of standards to support the data acquisition development process.

- Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.

- Ensure compliance with established policies, standards and methodologies.

Duties: Back-end

- Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.

- Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.

- Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.

- Perform root cause analysis, performance monitoring and application related issues.

- Review IT work products from the team members for completeness and quality.

- Accurately translate business requirement to technical documentation and test case or results.

- Analyse and map data from source systems to target operational data stores and data marts.

- Maintain and provide application support in production.

- Code or folder migration from one environment to another as part of release management.

- Participation in all aspects of quality assurance.

- Active participation in systems integration and user acceptance testing.

Duties: Front-End

- Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools.

- Develop the semantic layer, metadata, reports and report definitions.

- Develop graphs and portal interfaces.

- Load and maintain the metadata for the data access tool.

- Troubleshoot BI tools, systems and software; performance-tune these applications as necessary.

- Produce complex, efficient, error-free reporting solutions and related documentation.

- BI front end development on data structures, cubes, reporting, dashboards, etc.

REQUIRED SKILLS:

- Full Microsoft BI stack: Strong SQL, SSIS, SSAS, SSRS, SSMS

- Strong 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.

- A sound knowledge of the programming language used to write the data staging programs or ETL tool.

- A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool.

- A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.

- Pride of work, thoroughness and attention to detail.

- 5 years relevant experience in a complex environment (banking, insurance, retail, etc), with different technologies as input

- Past experience must be heavily weighted to MS SQL - large data loads require solid experience in MS SQL to attain acceptable levels of performance in SSAS through proper data engineering

- Kimball methodology

- Using SSIS for job automation

- Transformation and enrichment in staging with customer and product info

REQUIRED QUALIFICATIONS / TRAINING:

- Relevant data warehouse and BI solution training is essential.

- B.Sc. or related degree is advantageous.

- 5+ years programming experience.

 

NB! This job is now closed. You can apply for other jobs by uploading your CV.



 

 

 

Similar jobs you might be interested in:

Data Engineer
Location: Johannesburg
Salary: 840000 Annually
data doesn’t engineer itself — that’s why we want you. If you are on the lookout for your next data engineer role that will be groundbreaking, then apply here...
2 days ago


AI Engineer
Location: Johannesburg
Salary:
Kickstart your career as an AI engineer and help build cutting-edge AI capabilities from the ground up. This is an early-career opportunity to work across the full AI stack—data engineering, ML/AI model development, cloud infrastructure, and AI application deployment—while learning alongside a small, highly skilled team of peers.
2 days ago


Tech Lead
Location: Johannesburg
Salary: Annually
We are seeking a highly skilled Technical Lead to join a fast-paced FinTech environment where innovation and precision drive success. In this role, you will lead the development of complex software solutions, mentor a talented team of developers, and ensure the successful delivery of high-impact projects. You’ll play a pivotal role in architecting and developing new technologies while enhanc...
2 days ago


Junior Data Scientist
Location: Johannesburg
Salary: Annually
A leading financial analytics firm is looking for a motivated and detail-oriented Graduate or Junior data Scientist to join their dynamic team in Johannesburg. This role offers an exciting opportunity to apply your analytical and technical skills to real-world financial challenges, including fraud detection, client retention, and portfolio optimization.
2 days ago


Junior Data Analyst
Location: Johannesburg
Salary: Annually
Our client, a leader in financial analytics, is looking for a Junior data Analyst to join their dynamic team. This role offers an exciting opportunity to contribute to delivering data-driven insights that empower strategic decisions within the finance industry.
2 days ago


IT Project Manager & Business Analyst
Location: Midrand
Salary: Annually
Project Manager and Business Analyst to join a dynamic team
2 days ago


QA Engineer
Location: Johannesburg
Salary: Monthly
We are looking for a skilled QA engineer to join an in-house software department supporting a dynamic group of companies, based in Germiston. This is an exciting opportunity to gain exposure to a wide range of software development projects and contribute to delivering high-quality solutions.
2 days ago


Java Developer
Location: Gauteng
Salary: Market related
-Design APIs and message contracts (REST/gRPC/event)
2 days ago


Senior Azure Data Engineer
Location: Johannesburg
Salary:
2 days ago


Lead Adanced Process Control (APC) Engineer (CH1178)
Location: Pretoria
Salary:
2 days ago


Create a free job alert for Informatica/MS Data Engineer in Johannesburg

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions