Job
Description
Overview Lead the design and development of scalable ETL processes using Informatica, ensuring data integrity and quality throughout the data lifecycle. Collaborate with cross-functional teams to gather requirements and translate them into technical specifications for ETL solutions. Optimize existing ETL workflows to improve performance and reduce processing times, leveraging best practices in data engineering. Implement data governance and data quality measures to ensure compliance with organizational standards. Mentor junior developers, providing guidance on ETL best practices and career development. Monitor and troubleshoot ETL processes, conducting root cause analysis on issues and implementing effective solutions. Responsibilities Be responsible for the design, configuration, build, and testing of new interface requirements/change requests initiated by sector projects, leveraging Informatica PowerCenter, DIH, or IICS platform Support production Informatica jobs and processes to ensure a high level of stability through operational excellence Troubleshoot production issues and communicate incident status via established templates to various levels of the organization Demonstrates continuous improvement mindset and proactively identifies opportunities for improvement Ensure all quality, and compliance standards are met Stay up-to-date with technology and industry trends by proactively participating in training, self-study, conferences, webcasts, user group participation, reading or other relevant means Qualifications Bachelor's degree in Computer Science or relevant disciplines with an IT emphasis is required 15+ years of experience focused on Integration project deliveries, upgrades, roll outs and support 10+ years of experience of integration and ETL development experience with Informatica PowerCenter 10+ year of SQL experience Informatica PowerCenter and Informatica Cloud expertise. Strong SQL skills and experience with database management systems. Familiarity with data visualization tools, such as Tableau or Power BI, is a plus. Experience with Python or Java for data processing is advantageous. Experience with Rest API, JSON, and XML is preferred Experience with Informatica Intelligent Cloud Services (IICS) is preferred Experience with Informatica Data Integration Hub is preferred Knowledge and experience in the following tools and technologies are nice to have: NoSQL DB, Azure DevOps, GIT Good written and oral communication skills Ability to multi-task and prioritize effectively in a fast-paced environment Excellent interpersonal skills with the ability to establish working relationships with individuals at varying levels within the organization Demonstrates attention to detail, organization, and timeliness in order to meet customer service expectations Demonstrates effective problem-solving skills Be creative and able to operate in a start-up mindset Willingness to learn Partner across teams to solve complex problems Show more Show less
