Informatica Developer - BI

Job Title: Informatica Developer - BI
Contract Type: Contract
Location: Sydney
Salary: $900 per day
Start Date: 06/07/2020
Reference: 433114
Contact Name: Andy Helsby
Contact Email: [email protected]
Job Published: July 03, 2020 14:01

Job Description

Informatica Developer

  • Technical design, development, testing, documentation of Data Warehouse / ETL projects
  • Perform data profiling and logical / physical data modelling to build new ETL designs and solutions
  • Develop, implement and deploy ETL solutions to update data warehouse and datamarts
  • Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
  • Troubleshoot, debug and diagnose ETL issues
  • Have the ability to work with users, BI and Application teams to get ETL solutions developed and implemented
  • Performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation
  • Meet with functional analysts and /or end users to gather/ clarify requirements as needed to complete BI/ DW projects
  • Develop and enhance BI reports, models and Cubes and provide support as needed
  • Keep abreast of latest ETL technologies and plan effective use
  • Help build solutions pertaining to Predictive analytics and/or Big data
  • Communicate very clearly and professionally with users, peers, and all levels of management. The communication forms include written and verbal methods
  • Lead the team members to work with end users to resolve data refresh issues
  • Provide ETL components for standard bid proposals and justify functional components in the proposed solution.
Basic Qualifications
  • More than 7 years in ETL:
  • Expert knowledge of data warehouse architecture
  • Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
  • Advanced experience in SQL, writing Stored procedures and tuning SQL
  • Strong experience with Informatica Powercenter.
  • Experience in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
  • Independent problems solving skills.
  • Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.
  • Open to learn and acquire new skills.
  • Working knowledge in Informatica TDM and DQ
Preferred Qualifications
  • Preferred experience with other ETL tools, like Talend
  • Preferred experience in Tableau, SAS or other BI applications
  • Preferred with experience in Big Data projects

Get similar jobs like these by email

By submitting your details you agree to our T&C's