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