Informatica/MS Data Engineer

 

Recruiter:

PBT Group

Job Ref:

1930668456

Date posted:

Tuesday, March 29, 2022

Location:

Johannesburg, South Africa


JOB SUMMARY:
-

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.

- 3-4 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:

Senior Growth Marketer
Location: Johannesburg
Salary:
Today


Software Implementation and Support Technician
Location: Johannesburg
Salary:
If you enjoy solving real‑world technical problems, working hands‑on with SQL, networking, and customer systems and don’t mind getting your boots dirty on‑site when needed this is a solid, long‑term opportunity to support and implement mission‑critical software across Africa and beyond.
Today


Network Engineer (T3)
Location: Midrand
Salary:
Are you a hands-on Network engineer who thrives in a fast-paced NOC environment and enjoys solving complex network challenges in real time? This is an opportunity to work on high-impact connectivity solutions, collaborate with experienced Tier 4 engineers, and play a critical role in keeping customers connected across underserved communities.
1 day ago


Senior Software Developer / Team Lead
Location: Johannesburg
Salary: Annually
Seeking a Senior Developer / Development Lead to join a software development function, reporting directly to the HOD. You will be responsible for technical contribution, designing, building and maintaining business-critical systems while also guiding and monitoring junior developers.
1 day ago


Junior Field Support Engineer
Location: Sasolburg
Salary:
1 day ago


Azure Data Engineer
Location: Johannesburg
Salary: negotiable
Our client based in Sandton is looking for an Azure data engineer to join their team. 12-month contract is renewable.
1 day ago


Developer (AI Engineer)
Location: Johannesburg
Salary: Annually
A leading healthcare technology provider is seeking a hands-on AI / Machine Learning engineer to design, build and deploy intelligent systems in a production environment.
1 day ago


Sales Engineer-Capital Equipment
Location: Johannesburg
Salary: Market-related
Lead the sales process for capital equipment within the mining and minerals processing markets. Johannesburg
1 day ago


Snr Mechanical Design Engineer
Location: Centurion
Salary:
1 day ago


Snr Project Engineer
Location: Centurion
Salary:
1 day 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