Informatica/MS Data Engineer

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.