← Back to jobs

Cynosure Technologies Logo
ETL Analyst/Engineer

Cynosure Technologies

 

Austin, TX, USA

Posted On: 15+ days ago
Experience: 5+ years
Availability: Onsite
Openings: 2
Category: QA ETL Analyst
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

You will design, develop, and maintain the data integration hub, automating data acquisition and ensuring quality through rigorous testing.

This role is hybrid.

Responsibilities

  • Implement and configure infrastructure for the data integration hub using Informatica IICS, IDMC, or Power Center.
  • Automate data acquisition from diverse sources including Snowflake, Oracle, SQL Server, Excel, and Adobe PDF.
  • Develop complex SQL scripts for data manipulation and Python scripts for testing and automation.
  • Create and execute test plans, cases, and scripts to identify and resolve defects throughout the SDLC.
  • Collaborate with development teams to meet project specifications and improve overall data quality.

Required Skills

  • 5+ years of experience developing mappings and workflows for ETL automation using Informatica IICS, IDMC, or Power Center.
  • Proficiency in designing and executing complex SQL scripts.
  • Experience integrating data from Snowflake, Oracle, and SQL Server.
  • Ability to write Python scripts for data testing and automation.
  • Familiarity with the Software Development Life Cycle (SDLC).
  • Experience with Tableau and data visualization tools.
  • Proficiency in modeling and mapping tools such as Visio or Erwin.
  • Experience using Microsoft Office Suite and MS Project.

Preferred Skills

  • Experience with Adobe PDF data extraction.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs