Systems ETL Analyst

Overview

Hybrid
$70
Contract - Independent
Contract - W2

Skills

Auditing
Business Analysis
Business Analytics
Cloud Computing
Data Governance
Data Integration
Data Modeling
Data Quality
Data Science
Data Warehouse
Database
Extract
Transform
Load
Git
HIPAA
High Availability
Informatica
Informatica PowerCenter
Management
Mentorship
Microsoft Azure
Network
Python
Quality Assurance
Query Optimization
Reference Data
SQL
Snow Flake Schema
Stored Procedures
Workflow
Web Services
Testing
Writing

Job Details

Minimum Requirements:

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

8

Required

Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions.

8

Required

E2E implementation experience involving phases from design, realization, testing, to go-live

8

Required

Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools.

8

Required

Strong knowledge of data governance, data quality, and data integration principles.

8

Required

Expertise in Azure Cloud and Snowflake Cloud Datawarehouse

8

Required

Strong knowledge in SQL Queries and Query optimization

8

Required

Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA

8

Required

Development experience in high transaction/high availability systems.

8

Required

Experience with analyzing and recommending solutions for Production issues short-term and long term.

8

Required

Must have informatica PowerCenter/IICS development experience.

8

Required

Knowledge and experience of managing reference data systems

8

Required

Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices.

8

Required

Experience in Python with data science libraries

8

Required

Experience in SQL programming and writing stored procedures, functions, views, SQL queries

8

Required

Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII).

8

Required

Strong organizational and time management skills.

8

Preferred

Data warehouse development experience

8

Preferred

Experience with Snowflake

4

Preferred

Experience in designing, optimizing, documenting, and implementing the operational aspects that support the Snowflake cloud data platform, including cost monitoring, optimizations, and user security auditing.

4

Preferred

Experience in implementing and supporting automation for managing Snowflake accounts, databases, and access roles.

4

Preferred

Experience and understanding in proposing and implementing database and Snowflake query performance optimizations.

4

Preferred

Experience with Git hub integration with snowflake and load data.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.