ETL Admin

Overview

Hybrid
$50 - $60
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 3 Year(s)

Skills

Debugging
Data Processing
Data Warehouse
Database
Database Design
Datastage
Backup
Cloud Computing
Collaboration
Communication
Conflict Resolution
Ab Initio
Adaptability
Agile
Analytical Skill
Problem Analysis
Problem Solving
Management
Microsoft Azure
Microsoft SSIS
Modeling
Production Support
Extract
Transform
Load
IBM InfoSphere DataStage
Informatica
Optimization
Analytics
Application Development
DevOps
Documentation
Environment Management
Scripting
Storage
Version Control
Warehouse
Programming Languages
Python
Quality Assurance
Reporting
SQL Azure

Job Details

Seeking a skilled ETL Administrator to manage our production environment in Azure and deploy changes efficiently. The ideal candidate will have extensive experience in ETL processes, Azure services, and production environment management. This role requires a proactive individual who can ensure the smooth operation of ETL jobs, troubleshoot issues, and collaborate with various teams to implement ETL solutions.

Key Responsibilities:

Manage ETL Environment: Maintain, monitor, backup, and recover operations for the ETL environment in Azure.

Deploy Changes: Implement and manage the deployment of changes across various ETL projects and servers

Performance Monitoring: Regularly report on the health and performance of the ETL environment and jobs

Optimization and Troubleshooting: Conduct ETL optimization, troubleshooting, and debugging to ensure efficient data processing.

Development Support: Provide development support to ETL application development teams.

User and Role Management: Establish projects, roles, users, and privileges in different ETL environments (DEV, QA, PROD).

Collaboration: Work closely with data warehouse and ETL developers to implement ETL solutions.

Documentation: Record and maintain ETL software and operational procedures.

Problem Analysis: Provide detailed analysis of problems and recommend solutions.

Production Support: Troubleshoot production and ETL job issues to ensure minimal downtime.

Required Experience and Qualifications:

Experience: 7+ years of hands-on experience with ETL tools and processes.

Azure Expertise: Significant experience with Azure services, including Azure Data Factory, Azure Blob Storage, Azure Synapse Analytics, and Azure SQL Database

ETL Tools: Proficiency with top ETL tools such as Informatica, Ab Initio, DataStage, and SSIS.

Programming Languages: Strong knowledge of programming languages, preferably Python.

Database Skills: Expert in database query and tuning, with experience in various database design, architecture, warehousing, modeling, and mining.

DevOps: Experience with Azure DevOps or similar tools for source control and deployment.

Scripting: Proficiency in scripting languages and tools.

Cloud Platforms: Experience with other cloud platforms and cloud ETL tools is a plus.

Personal Attributes: Open-minded, curious, approachable, flexible, and adaptable. Comfortable working in an Agile environment and embracing frequent change.

Preferred Qualifications:

Certifications: Relevant certifications in Azure or ETL tools.

Communication Skills: Excellent communication and collaboration skills.

Problem-Solving: Strong analytical and problem-solving abilities.

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.