Description

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

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.
• Identify, track, and resolve defects throughout the development lifecycle.
• Develop and execute comprehensive test plans and scripts based on project requirements.

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 and lifecycle management.
• 8 years of experience developing and executing test cases and test plans.
• Must currently reside within the Austin, Texas metropolitan area.

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.
• 2 years of experience with observability and testing infrastructure at scale.

Key Skills

Education

Any Graduate