ETL Developer

ATS LLC ATS LLC

Dallas, TX, United States

4 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$135,200.0 - $156,000.0

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Airflow Amazon Web Services Business Analytics Applications Microsoft Azure BigQuery Cloud Computing Databases Continuous Integration Data Validation Data Cleansing Information Engineering

+36 more

Data Governance Data Integration Extract Transform Load (ETL) Data Transformation Data Security Data Systems Data Warehousing Relational Databases JSON PostgreSQL Microsoft SQL Server MySQL Oracle (Applications) Scrum Methodology SQL Stored Procedures SQL Databases SQL Server Integration Services Talend Extensible Markup Language (XML) Enterprise Data Management Data Logging Freeform SQL Google Cloud Cloud Platform System Informatica Powercenter Snowflake Git Data Lakes Information Technology AWS Glue Api Design Azure Synapse Analytics Software Version Control Data Pipelines Amazon Redshift Databricks

Job description

We are seeking an experienced ETL Developer to design, develop, and maintain reliable data integration and transformation solutions. The ideal candidate will have strong experience in ETL development, SQL, data warehousing, data modeling, and cloud-based data platforms. The candidate will work closely with data engineers, analysts, business teams, and application developers to deliver high-quality data solutions., * Design, develop, and maintain scalable ETL/ELT pipelines.

Extract data from databases, APIs, files, and other source systems.
Transform and cleanse data according to business requirements.
Load data into data warehouses, data lakes, and analytical platforms.
Develop complex SQL queries, stored procedures, functions, and data transformations.
Design and maintain data mappings, workflows, and data integration processes.
Implement data validation, reconciliation, and quality checks.
Optimize ETL jobs and SQL queries for performance and scalability.
Troubleshoot failed data loads, pipeline issues, and data-quality problems.
Monitor scheduled ETL workflows and resolve production issues.
Work with business analysts and stakeholders to understand data requirements.
Develop and maintain data models and warehouse structures.
Integrate data from multiple systems and heterogeneous data sources.
Implement error handling, logging, and recovery mechanisms.
Maintain technical documentation for ETL processes and data mappings.
Participate in Agile/Scrum ceremonies and collaborate with cross-functional teams.

Requirements

5+ years of experience in ETL Development, Data Engineering, or Data Integration.
Strong hands-on experience with SQL and relational databases.
Experience with ETL tools such as Informatica, Talend, SSIS, or AWS Glue.
Strong understanding of ETL/ELT concepts and data integration patterns.
Experience with data warehousing and dimensional data modeling.
Experience with databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
Experience developing complex SQL queries and stored procedures.
Experience with data cleansing, transformation, validation, and reconciliation.
Knowledge of cloud platforms such as AWS, Azure, or Google Cloud Platform.
Experience with Git or other version-control systems.
Strong troubleshooting and problem-solving skills.
Understanding of data security and access-control practices., * Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
Experience with Snowflake, Databricks, Redshift, BigQuery, or Azure Synapse.
Experience with Python for data processing and automation.
Experience with Apache Airflow or other workflow orchestration tools.
Experience working with APIs, JSON, XML, CSV, and other data formats.
Knowledge of CI/CD practices for ETL deployment.
Experience with large-scale enterprise data environments.
Knowledge of data governance and data-quality frameworks.
Cloud certification is preferred.
Strong communication and collaboration skills., Candidates must have valid authorization to work in the United States. Specific work-authorization requirements may vary based on the client and tax/employment type.