ETL Developer

Overview

Hybrid
$60 - $70
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Agile
Python
Java
PL/SQL
SQL
Extract
Transform
Load
Data Analysis
Automated Testing
ERwin
Tableau

Job Details

Responsibilities
  • Design, develop, and automate ETL processes using Informatica (IICS, IDMC, or Power Center)
  • Acquire and integrate data from diverse sources including Snowflake, Oracle, SQL Server, Excel, Access, and PDF
  • Develop complex SQL scripts and materialized views for data transformation and reporting
  • Collaborate with data engineers and architects to design optimal data models
  • Automate data validation and testing using Python
  • Participate in Agile ceremonies and contribute to sprint deliverables
  • Enhance and maintain a Java-based web interface for Tableau dashboards
  • Create technical documentation, diagrams, and specifications
  • Support testing, deployment, and operational monitoring of data pipelines
  • Identify and resolve defects, and continuously improve QA processes
Minimum Qualifications
  • 8+ years of experience with Informatica (IICS, IDMC, or Power Center)
  • 8+ years of experience integrating data from multiple sources
  • 8+ years of experience writing efficient and complex SQL scripts
  • 8+ years of experience in data analytics or data warehousing projects
  • Strong Python scripting skills for automation and testing
  • Proficiency in technical documentation and tools like Visio, Erwin, MS Office
  • Experience with defect tracking, test planning, and Agile collaboration
  • Strong analytical, organizational, and communication skills
Preferred Qualifications
  • Experience enhancing automation frameworks and test coverage
  • Exposure to AI-integrated platforms or products
  • Familiarity with observability and testing infrastructure at scale
  • Proven track record of innovation in software quality or test automation
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.