ETL Developer

We have requirement for ETL Developers for our client.

Citizenship requirements: Australian Citizen with Baseline clearance

Location:  Canberra

Duration: Upto June 2020 with 2 x 12 months extension options

Role and Responsibilities:
  • Developing various functional components of the data warehouse and applications;
  • Developing, maintaining and unit testing system components;
  • Developing and maintaining strong effective working relationships with key management personnel and internal client base;
  • Developing and maintaining positive team ethos within the immediate workgroup through positive participation and communication;
  • Assisting in the physical table, database design and development;
  • Performing data cleansing functions;
  • Performing system management functions, including load automation, data acquisition functions and others;
  • Understanding and describing requirements and evaluating data for conformance to expectations;
  • Providing development effort estimates for changes to existing applications and new applications;
  • Providing Code Review and other Quality Assurance tasks for projects and for code delivered by the Section;
  • Implementing work standards including design, development and unit testing standards;
  • Maintaining and developing systems and applications;
  • Coding, unit testing and correcting large or complex application and components;
  • Managing and organising competing priorities and conflicting interests;
  • Demonstrating sound judgement and decision making skills;
  • Providing problem diagnosis and resolution;
  • Conducting environment configuration;
  • Monitoring and supporting ETL production processes;
  • Analysing and resolving ETL production incidents;
  • Developing, enhancing and documenting procedures to assist with ETL production support;
  • Communicating ETL production support incidents to stakeholders;
  • Undertaking data profiling, system analysis and impact analysis;
  • Undertaking application development - design, development, testing and documentation of ETL processes;
  • Managing code deployment

  • Technical Specification;
  • Basic Architect document;
  • Technical design and matrix;
  • Architectural documents;
  • System Design Specifications;
  • Work flows, events and sequence diagrams;
  • UML (Universal Mark-Up Language) charts;
  • Environment Context Definitions;
  • Deployment plan.

Essential Criteria:
  • Minimum five (5) years’ experience in a similar role
  • Proven ETL experience in the development and solution design in a Teradata platform
  • Broad experience (minimum 2 years) Teradata Control Framework skills;
  • Strong understanding of ETL standards, security and governance in large enterprise wide environments
  • Demonstrated experience with:
  1. The analysis/design phase of SDLC
  2. Development and administration across an Enterprise Data Warehouse platform, ideally Teradata
  3. Developing complex SQL queries and stored procedures as required
  4. DB2, Scripting tools (Pearl, SQL, UNIX Shell. ), ITIL
  5. Application development
  6. Application support
  7. Data analysis
  8. Impact analysis
  • Broad experience in logical and physical relational database analysis, design and engineering including traditional Entity-Relationship Modelling;
  • Relevant (ICT) University Qualification
 Desirable Criteria
  • Experience working with InfoSphere QualityStage;
  • An awareness of data modelling.
 If you are interested in this role, please APPLY NOW. For more information, please contact Karun on 02 6113 7539 or via email on karun.sharma@igniteco .com. Ref# 352447.
Canberra (Australian Capital Territory)
I.T. & T