Description

You will design and implement automated ETL processes and data integration workflows to support data visualization and warehousing projects.

This role is on-site.

Responsibilities

• Develop mappings and workflows to automate ETL processes using Informatica tools.
• Integrate data from diverse sources including Snowflake, Oracle, and SQL Server for Tableau visualization.
• Design and optimize complex, efficient SQL scripts for data processing.
• Write Python scripts to handle data testing and process automation.
• Document technical architectures and data models using Visio or Erwin and resolve defects throughout the development lifecycle.

Required Skills

• 8+ years of experience with Informatica IICS, IDMC, or Power Center.
• 8+ years of experience with Snowflake, Oracle, SQL Server, Excel, Access, and Adobe PDF.
• 8+ years of experience in complex SQL scripting and performance optimization.
• 8+ years of experience in data analysis for data warehousing or performance management systems.
• 8+ years of experience with Python for data testing and automation.
• 8+ years of experience with technical documentation and modeling tools like Visio or Erwin.
• 8+ years of experience in defect tracking, lifecycle management, and executing test plans.

Preferred Skills

• 4+ years of experience enhancing automation frameworks or building automated regression and functional test suites.
• Experience working on AI platforms or validating AI-integrated products.

Key Skills

Education

Any Graduate