Senior ETL Developer

Senior ETL Developer

Posted Today by Raas Infotek LLC

Apply
Negotiable
Undetermined
Hybrid
Remote or Hybrid in Austin, Texas
Apply
Ab Initio (Software) Agile Methodology Amazon Web Services (AWS) AWS Glue Banking Big Data Business Requirements Cloud Computing Cloud Migration Cloud Technologies Cloud Technology Computer Science Continuous Integration and Continuous Delivery Data Quality Data Validation Data Warehousing DevOps Extract Transform Load (ETL) File Servers Google Cloud Google Cloud Platform (GCP) Informatica Informatica Powercenter Management Mapping Software Microsoft Azure Microsoft SQL Servers Performance Tuning Python (Programming Language) Snowflake (Data Warehouse) Software Development SQL (Programming Language) SQL Server Integration Services (SSIS) Stakeholder Management Star Schema System Context Diagram Talend Technical Documentation Verification And Validation Workflows

Summary: We are seeking a Senior ETL Developer with over 12 years of experience in designing and optimizing ETL/Data Integration solutions. The role involves collaborating with various stakeholders to build scalable data pipelines and support enterprise reporting. The ideal candidate should possess strong technical skills in ETL tools, SQL, and cloud platforms.

Key Responsibilities:

  • Design, develop, test, and deploy ETL workflows and data pipelines
  • Analyze source systems and business requirements for data integration
  • Build scalable ETL solutions for large-volume data processing
  • Develop and maintain data warehouse architectures
  • Perform ETL optimization and performance tuning
  • Implement data validation, cleansing, and transformation logic
  • Troubleshoot production ETL issues and provide root cause analysis
  • Collaborate with business analysts and data architects
  • Ensure data quality, integrity, and governance standards
  • Create technical documentation and ETL mapping documents
  • Support cloud migration and modernization initiatives
  • Mentor junior ETL developers and provide technical guidance

Key Skills:

  • Strong experience in ETL tools such as Informatica PowerCenter, SSIS, Talend, DataStage, Ab Initio, AWS Glue, and Azure Data Factory
  • Advanced SQL development and performance tuning
  • Experience with data warehousing concepts like Star Schema and Snowflake Schema
  • Familiarity with cloud technologies including AWS, Azure, and Google Cloud Platform
  • Proficiency in programming/scripting languages such as Python and Shell Scripting
  • Bachelor’s or Master’s degree in Computer Science, IT, or related field
  • Strong analytical and troubleshooting skills
  • Excellent communication and stakeholder management abilities

Salary (Rate): £70,000 yearly

City: Austin

Country: United States

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Job Title

Senior ETL Developer

Experience Required

12+ Years

Job Summary

We are looking for an experienced Senior ETL Developer with 12+ years of expertise in designing, developing, and optimizing enterprise-scale ETL/Data Integration solutions. The ideal candidate should have strong hands-on experience with data warehousing, ETL tools, SQL, cloud platforms, and performance tuning.

The candidate will work closely with business stakeholders, data architects, analysts, and development teams to build scalable data pipelines and support enterprise reporting and analytics solutions.

Key Responsibilities

  • Design, develop, test, and deploy ETL workflows and data pipelines
  • Analyze source systems and business requirements for data integration
  • Build scalable ETL solutions for large-volume data processing
  • Develop and maintain data warehouse architectures
  • Perform ETL optimization and performance tuning
  • Implement data validation, cleansing, and transformation logic
  • Troubleshoot production ETL issues and provide root cause analysis
  • Collaborate with business analysts and data architects
  • Ensure data quality, integrity, and governance standards
  • Create technical documentation and ETL mapping documents
  • Support cloud migration and modernization initiatives
  • Mentor junior ETL developers and provide technical guidance

Required Skills

ETL Tools

Strong experience in one or more:

  • Informatica PowerCenter
  • SSIS (SQL Server Integration Services)
  • Talend
  • DataStage
  • Ab Initio
  • AWS Glue
  • Azure Data Factory (ADF)

Database Skills

  • Advanced SQL development
  • Stored Procedures
  • Query Optimization
  • Performance Tuning
  • Data Modeling

Experience with:

  • Oracle
  • SQL Server
  • PostgreSQL
  • MySQL
  • Snowflake
  • Teradata

Data Warehousing

  • Star Schema
  • Snowflake Schema
  • Fact & Dimension Modeling
  • Slowly Changing Dimensions (SCD)
  • Data Mart Design

Cloud Technologies

Experience in at least one:

  • AWS
  • Azure
  • Google Cloud Platform (Google Cloud Platform)

Preferred services:

  • AWS Redshift
  • S3
  • Glue
  • Lambda
  • Azure Synapse
  • Azure Data Lake

Programming/Scripting

  • Python
  • Shell Scripting
  • Unix/Linux commands

Required Qualifications

  • Bachelor’s or Master’s degree in Computer Science, IT, or related field
  • 12+ years of ETL/Data Integration experience
  • Strong understanding of SDLC and Agile methodologies
  • Excellent analytical and troubleshooting skills
  • Strong communication and stakeholder management abilities

Preferred Qualifications

  • Experience with Big Data technologies (Spark/Hadoop)
  • Experience with CI/CD pipelines
  • Exposure to DevOps practices
  • Cloud certifications are a plus
  • Experience in Banking, Healthcare, Retail, or Telecom domains

Nice to Have

  • Kafka
  • Airflow
  • Databricks
  • PySpark
  • Tableau/Power BI integration
  • API-based data integration
Apply
Similar Jobs
Loading data...