Sigma Systems

Data Analyst

Sigma Systems

contract

Posted on:

Location Type: Remote

Location: Colorado • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

CloudETLInformaticaLinuxOracleSQL

About the role

  • Design, support, and optimize ETL processes using Informatica tools
  • Work with complex SQL stored procedures and database-driven logic
  • Support migration and deployment of code from development to production environments
  • Perform ETL testing, validation, and troubleshooting
  • Analyze and resolve data pipeline issues and performance bottlenecks
  • Work with Oracle databases to ensure data integrity and efficient query performance
  • Operate within Linux environments to manage data workflows and scripts
  • Support orchestration of ETL jobs using Informatica PowerCenter and/or Informatica Cloud (IDMC)

Requirements

  • 4–7 years of experience with Informatica ETL tools
  • Hands-on experience with Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC)
  • Strong SQL skills with Oracle databases
  • Experience developing and optimizing stored procedures
  • Experience with ETL testing, validation, and issue resolution
  • Working knowledge of Linux operating systems and command line tools
  • Candidate must currently reside in Colorado
  • LinkedIn profile must match resume and listed location
Benefits
  • Local ID verification required
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETL processesInformatica toolsSQLstored proceduresETL testingdata validationtroubleshootingOracle databasesLinuxdata workflows