Description

Build and maintain ETL processes for data warehousing and visualization, owning the full lifecycle from requirement analysis to deployment.

This role is hybrid.

Responsibilities

• Develop mappings and workflows using Informatica IICS, IDMC, or PowerCenter.
• Integrate data from Snowflake, Oracle, SQL Server, Excel, Access, and Adobe PDF.
• Write complex SQL and Python scripts for data transformation and automation.
• Document technical specifications, program functions, and system diagrams.
• Collaborate in agile sprints using JIRA to deliver software platforms.

Required Skills

• 15+ years of experience with Informatica IICS, IDMC, or PowerCenter.
• Proficiency in designing complex SQL scripts.
• Hands-on experience with Python scripting.
• Strong background with Snowflake, Oracle, and SQL Server.
• Experience with modeling tools such as Visio or Erwin.
• Proficiency with Microsoft Office Suite and MS Project.
• Experience working in an agile environment using JIRA.
• Strong analytical skills for system analysis in data warehousing.

Preferred Skills

• Bachelor’s degree in Computer Science, Information Systems, or Business.
• Experience with Web Applications (HTML, CSS, JavaScript, JQuery) and APIs.
• Functional knowledge of Web Services such as REST and SOAP.

Key Skills

Education

Bachelor’s degree in Computer Science