ETL/R Developer – ETL/R & Data QualityLocation: SydneyYou will be performing data migration activities using ETL/R tools, participate in multiple workshops to understand data structures, and analyse new system data requirements.Work closely with Data, Business, and Technology teams to design, implement, test, refine, and support integration workflows and mappings using IICS/IDMC. This includes, but is not limited to, use of mapplets, rule specifications, joins, task flows, and parameters within Data Quality, and ETL/R frameworks.Understand source and target applications and how the migration will fit into the new system and identify challenges of the program.Develop a deep understanding of business products, its processes, and its data sources.Document all mappings, mapplets, and rules in detail.Build reusable Informatica assets, transformations, and data flows.Analyse source systems for Data Quality issues across different data quality dimensions, report and communicate issues, and recommend remediation options to data owners.Analyse target systems data requirements to inform source to target mapping requirements.Document source to target data mapping requirements.Implement and educate Informatica best practices to other developers.Collaborate with data architects and analysts to understand data requirements and objectives.Ensure data accuracy, integrity, and security in all data integration activities.Perform performance tuning and optimization of ETL/R processes.Write SQL queries and scripts for data transformation and validation.Develop shell scripts for automation and orchestration.Document data integration processes and workflows.Requirements:Experience in large data migration programs - including archive and purge programs.Excellent written and verbal communication skills are essential, as you will work closely with the business to understand their needs and communicate actionable insights and results effectively.Ability to work and support existing framework environments.Excellent problem-solving and troubleshooting skills.Ability to work collaboratively, and independently, with various teams in a dynamic development environment and determine solutions that meet business, technology, and data requirements.2+ years of experience on ETL/R Tools like Informatica cloud, IICS & Informatica PowerCenter.Strong understanding of ETL/R concepts and methodologies.Experience with performance tuning and optimization of ETL/R processes.Proficient with tools like Excel, Outlook, Teams, Confluence, BitBucket/GIT, SharePoint.Experience with UNIX environments, SSH file transfer, basic scripting and navigation commands.Preferably with previous experience in retail and business banking product data, and data models.Proficient in SQL for data manipulation and validation.Strong SQL Skills and performance tuning capabilities.Strong functional understanding of RDBMS DWH-BI conceptual knowledge.Experience using, configuring, and scheduling ControlM jobs.Seniority levelMid-Senior levelEmployment typeFull-timeJob functionInformation TechnologyIndustriesIT Services and IT Consulting
#J-18808-Ljbffr