ETL Developer

Overview

Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

informatica
powercenter
power center
Oracle
SQL
PL/SQL
Healthcare

Job Details

Hi

Hope you are doing good.

We have a job opportunity for ETL Developer. This is a contract position. Please check the job description and let me know if you are fine with this.

Title: ETL Developer

Location: Remote

Duration: 6 Months

Key Responsibilities:

  • Develop, implement, and maintain ETL workflows using Informatica PowerCenter to support data migration and integration processes.
  • Design and optimize SQL queries for data extraction, transformation, and load operations in both relational and cloud environments.
  • Collaborate with business analysts and data architects to define data integration requirements and ensure accurate, high-quality data pipelines.
  • Work with Oracle databases to perform complex transformations and manage data extraction and loading processes.
  • Leverage Snowflake data warehouse to integrate data from multiple sources into a scalable, cloud-based data architecture.
  • Troubleshoot and resolve ETL job issues, data discrepancies, and performance bottlenecks.
  • Optimize and tune ETL jobs to ensure high performance and scalability.
  • Create and maintain technical documentation for ETL workflows, processes, and jobs.
  • Ensure data integrity and quality across the ETL pipeline by implementing robust error handling and validation procedures.

Skills and Qualifications:

  • Experience with Informatica PowerCenter at least [X] years of hands-on experience developing ETL jobs and workflows.
  • SQL expertise Advanced SQL query writing and optimization in relational databases.
  • Oracle Working knowledge of Oracle database structures, PL/SQL, and performance tuning.
  • Snowflake Familiarity with Snowflake cloud data platform, including data loading, transformations, and querying.
  • Strong knowledge of ETL best practices and troubleshooting techniques.
  • Experience in data integration, data migration, and data warehousing.
  • Knowledge of cloud technologies and platforms, particularly for large-scale data solutions.
  • Familiarity with Agile methodologies for software development.
  • Strong problem-solving and analytical skills with the ability to work independently and as part of a team.

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.