Role overview

Qualifications

5+ years of experience as an ETL Developer in a Snowflake and Azure environment
Strong SQL experience
Experience using ETLWorks or other ETL tools like Informatica

Responsibilities

Participate in analysis, technical design, development, integration, and testing
Build and maintain technical documentation for all data processing workflows
Identify and troubleshoot performance issues in the data pipelines

Key facts

Remote from: California (USA)
Full time
Senior (5-10 years)
ETL Developer
English

Hard skills

Xplenty (ETL Tools) Microsoft Azure SQL (Programming Language) Data Warehouse Systems Database Consolidation Informatica Scrum (Software Development) JIRA Version Control Bitbucket SQL Server Integration Services (SSIS) Performance Profiling Python (Programming Language) Data Governance Data Quality Logical Data Models Multidimensional Database Healthcare Industry Knowledge

About the company

Perfict

Human Resources, Staffing & Recruiting

Perfict Global is an IT consulting services provider, focused on providing innovative and successful business workforce solutions. Providing specialized staffing and recruitment solutions for our clients, we have quickly become the technology specialist staffing and Recruitment Company of choice for many employers across the US. Our talented team of recruitment professionals serve as more than just a supplier to our customers, we act as a trusted business partner and work as an extension of our client's internal teams, offering the following solutions: • Temporary Staffing • Temp-to-permanent Placements • Permanent Recruitment • Specialized Executive Search

Company details

Company typeScaleup

IndustryHuman Resources, Staffing & Recruiting

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

About Us:
Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in implementation activities and collaborate in new ways to meet client needs.

We provide excellent benefits such as Medical, Dental, Vision ++ a fun company to work!!!

Job description:
Role: Sr ETL Developer (only W2)
Location: 100% remote PST
Required Skills for ETL Developer

5+ years of experience as a ETL Developer in a Snowflake and Azure environment. Preference of Datawarehouse Development or Datawarehouse Consolidation effort preferred. Including Analysis, technical design, development, integration, testing
Strong SQL experience
Experience using ETLWorks – this is their ETL development tool (other ETL like Informatica is accepted)
Experience working in a scrum environment, using Jira
Experience working with version control tools; preferably - bitbucket
Familiarity with the current legacy platform; Microsoft SQL, SSIS
Experience building and maintaining technical documentation for all data processing workflows, ensuring they meet standards and best practices
Experience identifying and troubleshooting performance issues in the data pipelines, and work with data architects to optimize data models and database designs
Strong previous experience working remotely on a remote team across different time zones
Healthcare payor/insurance experience is highly preferred

Nice to have Skills for ETL Developer

Strong Python experience, nice to have
Familiarity with the Data Governance/Data Quality tool, Ataccama, nice to have
Familiarity with reading through a logical data model and have an understanding of multidimensional data models, nice to have
Healthcare knowledge and experience, nice to have