ETL Developer and Cloud DBA

Overview

Hybrid
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
10% Travel

Skills

FOCUS
Informatica PowerCenter
Management
Optimization
Debugging
Unit Testing
Test Cases
Data Quality
Meta-data Management
Warehouse
Application Development
Data Management
Apache Kafka
DMS
High-level Design
Mapping
Oracle
Cloud Computing
Workflow
Data Integration
Data Modeling
Informatica
Performance Tuning
Data Flow
Data Warehouse
Database
Real-time
Extract
Transform
Load
Streaming
Amazon Web Services
PostgreSQL
Database Administration
Agile
Scrum
Data Governance
Regulatory Compliance
Communication
Collaboration
Health Care

Job Details

Role : ETL Developer and Cloud DBA

Hybrid OR Remote

  • 5 10 years of experience in ETL development with a strong focus on Informatica Power Center (both on-premises and cloud-based) environments.

  • Extensive hands-on experience with Informatica Power Center tools, including Source Analyzer.

  • Experience extracting data from various sources, including cloud systems.

  • Experience with Data Warehousing Designer: designing schemas and data warehouses. Mapping & Mapplet Designer: creating and managing data transformations. Transformation Designer: designing complex transformations and data flows.

  • Proven expertise in ETL processes, including extracting data from cloud systems, moving it to staging areas, and loading it into target databases.

  • Proficiency in performance tuning and optimization techniques, such as using indexes, hints, and partitioning in databases like Oracle, Postgres, and Informatica.

  • Hands-on experience in debugging and troubleshooting production issues, providing on-call support, and ensuring smooth production environments.

  • Experience with unit testing of ETL mappings, including maintaining detailed test logs and test cases to ensure data quality.

  • Knowledge of metadata management, maintaining naming standards, and ensuring warehouse standards are met for future application development and data management.

  • Experience with AWS, Kafka, and DMS tools.

  • Experience parsing high-level design specifications into detailed ETL coding with adherence to mapping standards.

  • Strong proficiency in database technologies, including Oracle, and cloud-based databases with the ability to integrate complex ETL workflows.

  • Excellent understanding of data warehousing concepts, data integration, and data modeling to support robust and scalable ETL solutions.

  • Strong experience in Informatica performance tuning to ensure optimal ETL execution and data flow processes.

  • Experience with data warehousing in large-scale environments with distributed databases.

  • Experience with real-time ETL solutions and data streaming.

  • Experience with AWS Postgres DBA tasks.

  • Familiarity with Agile/Scrum methodologies and ability to work in fast-paced, iterative development cycles.

  • Knowledge of data governance and ensuring data compliance with standards and regulations.

  • Strong communication skills to collaborate with cross-functional teams, including business analysts and architects.

  • Health care industry experience is a plus.

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.

About Maagsoft Inc.