• Location: Madison, Wisconsin
  • Remote: Remote
  • Type: Contract To Hire
  • Job #4634

Carex Consulting Group is hiring an ETL Developer for a remote opportunity. This is a contract to hire position. You must have Informatica experience. 

What You'll Do:

Work directly with business users to transform business problems into analytic solutions by extracting and transforming data to help solve business problems in creative ways with very quick turnaround.

  • Develop scalable, innovative approaches to extracting, managing, and analyzing data into Snowflake Data Cloud
  • Perform data profiling and data analysis to assist in understanding the data
  • Optimize data models through normalization, table analysis and review of queries
  • Collaborate with business leaders to provide thought partnership and insights for requirements gathering and plan out a roadmap of project activities
  • Work with the business to assess the validity of the data and achieve minimum levels of quality
  • Monitor and troubleshoot data integration and processing pipelines, identify and resolve performance issues.

What You'll Bring:

  • 4 years of direct experience in a related field (data analyst, engineer, statistics, performance management, analytics, or research) and building ETL data pipelines in and out of data warehouse applications
  • Hands on experience working with “Big Data” environments such as Snowflake, BiqQuery, Hadoop and their architecture. Key focus on experience in Snowflake Data Cloud and functions such as Streams/Tasks, Snowpipe, Etc. 
  • Experience and proficiency on API integration and pipelines into big data environments
  • Experience with data modeling and architecting analytics solutions
  • Proficiency in Programming Languages (e.g., SQL, Python, Java) required
  • Proficiency with ETL/ELT Toolsets with a focus on Informatica IICS (Cloud). Other tool systems such as PowerCenter, BDM, Matillion or Talend would be considered

Carex Consulting Group is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity or Veteran status.


Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!