Software Engineer - Informatica

Job Description

Employment Type Permanent Closing Date 11 May 2025 11:59pm Job Title Software Engineer - Informatica Job Summary As a Software Engineer, you thrive on working with your team to design, build and deliver innovative software products and solutions that delight our customers. You apply broad knowledge in software application layer solutions and the software development lifecycle, to experiment, solve problems and own solutions that transform epics into new product features and capabilities. Your continuous learning and improvement mindset and collaboration skills are critical to success in this role, as you continue to deepen your knowledge and expertise in the Software Engineering Domain. Job Description Who We Are Were an iconic Aussie brand with a global footprint. Our purpose is to build a connected future so everyone can thrive. Were 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 Were 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.