2024-7087Data Engineer Informatica

As an Informatica Specialist / Data Integrator you will be responsible for maintaining existing Informatica jobs reviewing for possible improvements to legacy Informatica workflows and building new ETL processes to push/pull data from primarily SQL sources to target for the Enterprise Applications domain.  The individual will work closely with the Data Governance Group and Data Owners to ensure that data is extracted transformed and loaded correctly and completely.  The Informatica Specialist / Data Integrator will work closely with the IT product teams and developers to maintain compliance with the enterprise data architecture standards.  The individual will help establish tools and standards needed to deliver solutions that deliver agility and benefit to the business.  The successful candidate will be a data technology evangelist who is passionate about improving IT delivery through technology in a handson approach.  You will have to be up to date with the latest technology trends and capabilities and will be able to demonstrate a leadership mindset solid operational experience and the ability to problemsolve.  Travel of up to 5 will be required outside of the country.

• Maintain and update existing Informatica workflows
• Review current Informatica workflows and recommend / complete enhancements to enable them to run efficiently and effectively
• Create Extract / Translate / Load processes to push data from sources to target
• Ensure data integrity security and privacy of financial data
• Collaborate with stakeholders to understand their data requirements and ensure that the architecture meets those requirements
• Implement data governance policies and procedures
• Stay current on new technologies and trends in data management and evaluating potential solutions
• Communicate effectively with both the business and technical teams

Qualifications :

Required Skills/Experience

• Experience building and maintaining Informatica workflows
• Excellent communication and interpersonal skills to work closely with a variety of stakeholders
• Strong technical background including experience with database management systems data modeling and data warehousing especially SQL server
• Minimum of 23 years of experience as Data Integrator
• Experience designing ETL data solutions
• Experience working with external data feed to enrich internal data
• Experience with data conformance process

Desired Skills/Experience

• Experience building real time analytics solutions
• Experience in an insurance or financial organization
• Experience with Data warehouse modeling
• Experience working with Snowflake or similar
• Experience working in SOX and SOC2 compliant environment
• Experience monitoring and supporting production database and server environment
• Strong understanding of technologies utilized in the industry and the ability to see their impact as well as enhancement management and product lifecycle development
• Relevant experience working with 3rd party vendors to deliver results
• Proven experience and strong understanding of agile development and conventional method and its application to company technology needs
• Strong problem solving analytical and decisionmaking skills and experience
• PowerBI report development and maintenance
• Ability to balance between most ideal and most pragmatic solutions that meet business needs
• Cloud and Product Based Certifications will be a plus.

Additional Information :

• Bachelors degree in Computer Science Management of Information Systems or related field preferred

Remote Work :

Yes

Employment Type :

Fulltime