ETL Developer

Position: ETL Developer

Location: Warrendale – Hybrid 3 Day a week, On - Site (Pittsburgh, PA Area)

Duration: PERM

Salary: $80,000-$90,000

Interview Process: Assumptive times – June 1st-5th

10-11am, 1-3pm

Must Haves:

3-5 Years Experience with ETL tools (Informatica)

Experience with SSAS & SSIS querying languages

Ability to convert SSAS & SSIS into Boomi and Power BI

Exceptional soft skills (Team player, great communicator, self-starter)

Experience with incident response for Data Factory & Data Bricks

Experience with Informatica (Exon, EDC)

Experience with DevOps and GIT (source control)

Plusses:

Experience with Oracle Database

Experience with Boomi API Development

Experience with Control-M MFT

Day to Day:

Insight Global is searching for an ETL Analyst to join our team. The candidate will be responsible for supporting all incident response and managing the full life cycle of ETL processes. The incumbent must communicate professionally and effectively with a wide variety of people. This communication occurs face-to-face, over the phone, remote access, Teams, and in writing.

Additional Responsibilities:

Provide ETL support to all employees at the location and other remote sites

Diagnose and resolve ETL incidents, including data integration, data warehousing, and data modeling

Operate with company standards and conventions

Stage, configure, and deliver ETL solutions

Manage the inventory of ETL assets for the site(s)

Use logic and reasoning to research and resolve technical issues and know what to do next and/or when to escalate for help

Support all ETL systems at the location

Work across a global ETL support team to share information and best practices