Software Engineer - Informatica

Employment Type

Closing Date

Job Title

Job Summary

Job Description

Who We Are

We're an iconic Aussie brand with a global footprint. Our purpose is to build a connected future so everyone can thrive. We're all about providing the best experience and delivering the best tech on the best network.

This includes making Telstra the place you want to work. For you, that means a having career that grows with you and working with a team powered by human connection that prioritizes wellbeing and choice.

Focus of the Role

As a Senior Software Engineer, you excel at understanding and translating customer needs into innovative products and capabilities. You leverage your deep technical expertise and experience in software application layer solutions to develop and deliver scalable design blueprints throughout the entire software development life cycle. Your commitment to continuous learning and improvement, along with your collaboration and influencing skills, are essential for success in this role.

Responsibilities:

As a Senior Software Engineer, you will utilize your extensive experience and technical knowledge in the Software Engineering domain to:

• Design, develop, and maintain ETL workflows using Informatica PowerCenter and/or Informatica Cloud (IICS) to support enterprise data integration needs.
• Lead the architecture and design of data integration solutions using Informatica PowerCenter, IICS, and other Informatica suite tools.
• Collaborate with business analysts and data architects to understand requirements and translate them into scalable ETL solutions.
• Perform data extraction, transformation, and loading from various sources including flat files, databases, and cloud platform.
• Optimize ETL processes for performance, reliability, and scalability.
• Write and optimize complex SQL queries for data transformation, validation, and troubleshooting.
• Perform unit testing and ensure data quality, accuracy, and integrity throughout the ETL lifecycle.
• Troubleshoot and resolve data-related issues and support production workflows as required.
• Document technical specifications and maintain code version control.
• Work in an Agile/Scrum environment and actively participate in sprint planning and reviews.
• Provide technical leadership across multiple projects and guide development teams on best practices and standards.
• Collaborate with business stakeholders, solution architects, and analysts to design robust and future-ready data solutions.
• Evaluate emerging technologies and propose improvements to the current data integration landscape.
• Ensure high availability and performance of Informatica environments; work closely with infrastructure and platform teams.
• Design and implement data governance, metadata management, and data quality frameworks.

Essential Skills

• ETL Tools: Informatica PowerCenter, Informatica Cloud (IICS)
• Databases: Oracle, SQL Server, Snowflake, MySQL, Teradata
• Languages: SQL, PL/SQL, Shell Scripting
• Performance Tuning: Session/Workflow optimization, Pushdown Optimization
• Data Integration: Batch & Real-Time Data Processing, Data Migration
• Version Control: Git, SVN
• Testing & Debugging: Unit Testing, Data Validation, Error Handling
• Documentation: Technical Specs, Mapping Documents, Job Scheduling

We're amongst the top 2% of companies globally in the CDP Global Climate Change Index 2023, being awarded an 'A' rating. If you want to work for a company that cares about sustainability, we want to hear from you.

As part of your application with Telstra, you may receive communications from us on +61 440 135 548 (for job applications in Australia) and +1 (623) 400-7726 (for job applications in the Philippines and India).

When you join our team, you become part of a welcoming and inclusive community where everyone is respected, valued and celebrated. We actively seek individuals from various backgrounds, ethnicities, genders and abilities because we know that diversity not only strengthens our team but also enriches our work. We have zero tolerance for harassment of any kind, and we prioritize creating a workplace culture where everyone is safe and can thrive. 

As part of the hiring process, all identified candidates will undergo a background check, and the results will play a role in the final decision regarding your application.

We work flexibly at Telstra. Talk to us about what flexibility means to you. When you apply, you can share your pronouns and / or any reasonable adjustments needed to take part equitably during the recruitment process.