Description

You will manage ETL processes and data integration workflows to support data visualization and warehousing projects.

Responsibilities

• Develop mappings and workflows to automate ETL processes using Informatica IICS, IDMC, or Power Center.
• Integrate data from diverse sources including Snowflake, Oracle, SQL Server, Excel, Access, and Adobe PDF for Tableau visualization.
• Design and develop complex, efficient SQL scripts for data processing.
• Write Python scripts to automate data testing and improve workflow efficiency.
• Identify, record, and track defects throughout the development lifecycle to resolve issues with developers.

Required Skills

• 10+ years of experience in data analysis, performance management, or data warehousing projects.
• Proficiency with Informatica IICS, IDMC, or Power Center.
• Advanced SQL scripting and optimization skills.
• Experience with Snowflake, Oracle, and SQL Server.
• Hands-on experience with Python for data automation and testing.
• Ability to use modeling and diagramming tools like Visio or Erwin.
• Proficiency in Microsoft Office Suite and MS Project.
• Experience integrating data for Tableau visualization.
• Strong technical writing skills for documentation and process mapping.

Key Skills

Education

Any Gradute