IBM Data Specialist - 2 years Fixed Term Contract - Perth in WEST PERTH, Australia

Job Description

Data Specialist - 2 years Fixed Term Contract - Perth

IBM Global Business Services (GBS) is a team of business, strategy and technology consultants enabling enterprises to make smarter decisions and providing unparalleled client and consumer experiences in cognitive, data analytics, cloud technology and mobile app development. With global reach, outcome-focused methodologies and deep industry expertise, IBM GBS empowers clients to digitally reinvent their business and get the competitive edge. We outthink ordinary. Discover what you can do at IBM. We are hiring.

We are currently recruiting a Data Specialist - Solutions (Asset/Cloud Based) for 2 years fixed term contract, based in Perth.

This position involves analysing IT requirements for customer’s projects and designing of appropriate ETL models so that the solutions are implemented in accordance with the client’s requirements and IBM standards. Whilst, the position requires primarily modelling skills using Powercenter designer along with ETL-Informatica,PL/SQL Skills,Advance SQL and unix.

The position will be required to work with other technology architects, IT specialists, application developers and operations staff to ensure an appropriate solution is designed and implemented.

This role Data Specialist - Solutions (Asset/Cloud Based), required to design the data model’s using power designer for Network Risk model and meet business needs. The resulting design may run on multiple platforms and may be composed of components in network world such has Woodpole, Insulators, HV, LV network,..etc. This role defines best practices in the critical evaluation and selection and / or development of the Database components and requirements of the applications and data, and the development of the application, including evaluation and selection of development methods, development processes, best practices and tools..

As a Data Specialist - Solutions (Asset/Cloud Based) your responsibilities include:

  • Working with business sponsors to understand business strategies and objectives for building all models in network Risk application.

  • Develop technical objectives and requirements to achieve business goals

  • Develop high-level and detailed-level technical architecture solutions, leveraging leading frameworks, approaches, and languages

  • Develop high-level and detailed-level integration patterns

  • Assists in the process of maintaining all the relevant sources of data and ensuring that it is being designed properly using Power designer.

  • Involved in developing the ETL processes and is involved in designing and preparing the codes that meet the program specifications as well as the client requirements.

  • Involved in the effective implementation of these informatica programs, tests them, evaluates the requirements, addresses and resolves the issues associated with it, etc.

  • Involved in creating proper technical documentation in the work assignments.

  • Understand the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process.

  • Ensures that all the standard requirements have been met and is involved in performing the technical analysis.

  • Writing shell scripts blocks for streamlining/automating processes, data loading, validation, reconciliation.

  • Assist peer developers with writing optimal SQL queries, stored procedures, functions, views, triggers, constraints, ETL scripts.

  • Responsible for developing new programs and proofing the program to develop needed changes to assure production of a quality product.

  • Responsible for analysis of current programs including performance, diagnosis and troubleshooting and designing solutions to problematic programming.

  • Experience in Solution designing, impact assessment, requirements analysis, gap analysis and identifying areas of optimization/improvements.

  • Involved in various phases of project life cycle like requirement study, development, design, Unit testing, Integration testing, Implementation and production support.

  • Assisting the project manager by compiling information from the current systems, analyzing the program requirements and ensuring that it meets the specified time requirements.

  • Involved in resolving the moderate problems associated with the designed programs and providing technical guidance on complex programming.

  • Involved in the creation of mappings/sessions/workflows in informatica at development phase based on the specifications

  • Involved in the Defect-Fixing

  • Developing and unit testing the Code(mappings and Workflows) during Coding Phase.

  • Issue Clarification meeting with onsite coordinators for getting the requirements and

Preparation of the test data and performing system Testing for all Test cases.

  • Preparation of the migration documents for moving the code from Dev environment to

QA/Test environment and from QA/Test environment to PROD environment.

  • Actively participated in the status calls and weekly status calls

  • Communicated the status of the above mentioned tickets with onsite counterpart on daily basis in order to deliver the tickets on time.

Skills required:

Environment: Professional knowledge related to Energy and Utilities Industry function/business unit and its processes.

Communication/Negotiation: Communicate and provide advice to other professionals, effectively utilize group dynamics. Negotiate to define approaches and goals. Lead or join development team in projects to deliver proposed system for client’s business requirements. Communicate and negotiate effectively with client product own and client solution architects to achieve the optimal outcome for the client.

Problem Solving: Design solutions in an integrated complex and heterogeneous environments. Complete project life cycle on integration projects: analysis, design, implementation, testing, support in product development and/or service projects. Define integration architecture, make and communicate architecture decisions. Communicate customer requirements. Validate project plan and estimates. Develop high level design, detailed design, API design and prototypes. Prototyping key/most difficult concepts to reduce risk. Perform technical and development QA. Support presales process.

Recognize complex problems related to functional objectives. Analyze situations and implement solutions, or develop new system elements, procedures or processes. Creativity and judgment applied to developmental work on different projects within the business environment. Design application architecture and outline component model specification for team member to implement. Provide industry insights in requirement elicitation. Respond quickly to POC activities for early assessment of solution feasibility and risks of architecture design. The applicant should be technology Evangelist in application architecture and programming.

Balance priorities to ensure client gets maximum value

Compensation package from $78 400 (full-time equivalent) and will be determined based on successful candidates relevant skills and experience.

Required Technical and Professional Expertise

To ensure success in the role you will possess the following skills –

  • At least 6 years’ experience in ETL technology (informatica tool)

  • At least 5 years’ experience in delivering Complex Integration architecture models

  • At least 3 years’ experience in applied knowledge of PL/SQL,SQL,UNIX

  • At least 3 years in Data modelling using power designer

  • At least 3 years’ experience in Agile methodology managing multi-vendor and complex systems integration projects, working in a distributed team environment, managing offshore teams with demonstrable outcome

  • At least 3 years’ experience working in System Integrations and legacy systems using Web Services or file based message exchange.

  • At least 2 years’ experience in Distribution and Transmission Assets, asset hierarchy, lifecycle management, concept of asset management and equipment registers.

Preferred Tech and Prof Experience


EO Statement

IBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.