Senior ETL Developer

A & Associates
Glendale, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 120K

Job location

Glendale, United States of America

Tech stack

Amazon Web Services (AWS)
Azure
Big Data
Cloud Computing
Data Validation
Data Governance
Data Integration
ETL
Data Transformation
Data Migration
Data Warehousing
Relational Databases
Database Schema
IBM InfoSphere DataStage
DevOps
Dimensional Modeling
Hadoop
Python
PostgreSQL
Microsoft SQL Server
MySQL
Operational Databases
Oracle Applications
Pentaho Data Integration
Performance Tuning
Powershell
Standard Sql
Shell Script
Software Deployment
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Talend
Data Logging
Google Cloud Platform
Azure
Informatica Powercenter
Snowflake
Spark
GIT
Data Lake
Information Technology
Software Version Control
Databricks

Job description

We are seeking a skilled ETL Developer to design, develop, test, and maintain Extract, Transform, and Load (ETL) processes that support enterprise data integration and reporting. The ideal candidate will have experience working with data warehouses, relational databases, ETL tools, and SQL, with a strong understanding of data quality and performance optimization., * Design, develop, and maintain ETL workflows to extract data from multiple source systems.

  • Develop data transformation logic to ensure data accuracy, consistency, and integrity.
  • Load transformed data into data warehouses, data lakes, or operational databases.
  • Create and optimize SQL queries, stored procedures, and database objects.
  • Monitor ETL jobs, troubleshoot failures, and resolve performance issues.
  • Collaborate with business analysts, data engineers, and application teams to gather data requirements.
  • Perform data validation, reconciliation, and quality checks.
  • Maintain technical documentation for ETL processes and data mappings.
  • Implement error handling, logging, and recovery mechanisms.
  • Support production deployments and ongoing maintenance activities.
  • Optimize ETL processes for scalability and performance.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • 3+ years of experience in ETL development.
  • Strong proficiency in SQL and relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
  • Experience with ETL tools such as Informatica PowerCenter, SSIS, Talend, IBM DataStage, or Pentaho.
  • Knowledge of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
  • Experience with data integration, data migration, and data validation.
  • Familiarity with version control systems such as Git.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Excellent communication and teamwork skills.

Preferred Qualifications

  • Experience with cloud platforms such as AWS, Azure, or Google Cloud.
  • Knowledge of Python, Shell scripting, or PowerShell.
  • Experience with Big Data technologies such as Spark or Hadoop.
  • Familiarity with CI/CD pipelines and DevOps practices.
  • Understanding of data governance and security best practices.

Technical Skills

  • SQL
  • ETL Tools (Informatica, SSIS, Talend, DataStage, Pentaho)
  • Data Warehousing
  • Oracle, SQL Server, PostgreSQL, MySQL
  • Python or Shell Scripting
  • Git
  • Cloud Platforms (AWS, Azure, GCP)
  • Data Modeling
  • Performance Tuning

Soft Skills

  • Strong analytical thinking
  • Problem-solving ability
  • Attention to detail
  • Communication skills
  • Collaboration and teamwork
  • Time management

Nice-to-Have Certifications

  • Informatica Certified Professional
  • Microsoft Certified: Azure Data Engineer Associate
  • AWS Certified Data Engineer
  • Snowflake SnowPro Certification
  • Databricks Certified Data Engineer

Benefits & conditions

3.63.6 out of 5 stars Glendale, AZ 85310 Hybrid work $90,000 - $120,000 a year - Contract

About the company

A & Associates is a reputable staffing agency with a proven track record in screening and recruiting as well as job placement and career development. With more than ten (10) offices throughout the United States, A & Associates is a company that can be trusted to provide a diverse level of services with excellence, diligence and integrity. "Quality In Everything We Do" is far more than our mantra, it is our standard!! Explore a career with A & Associates, one of the leading providers for temporary, temp-to-hire, permanent placement services and security guard services.

Apply for this position