ETL Developer

TechDigital Group; Phoenix (AZ); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled ETL Developer to design and maintain robust ETL processes using cutting-edge tools. This role involves optimizing data integration workflows and ensuring data quality across multiple platforms. You will work closely with data architects and business analysts to transform complex requirements into technical solutions, while also participating in code reviews and implementing best practices. Join a dynamic team where your contributions will enhance data analytics and visualization capabilities, making a significant impact on the organization's data strategy.

Qualifications

• Expertise in ETL processes and tools like Informatica and Fivetran.
• Strong skills in performance tuning and data integration.

Responsibilities

• Design and maintain ETL processes for data extraction and transformation.
• Collaborate with stakeholders to gather requirements and translate them.

Skills

ETL Processes

Informatica

Fivetran

Performance Tuning

Data Integration

Data Quality Checks

Data Analysis

Tools

Data Lake

Master Data Management

Data Warehouse

Job description

Job Description:

Design, develop, and maintain ETL processes using Informatica and Fivetran.

Create and optimize complex mappings, workflows, and sessions for data extraction, transformation, and loading.

Responsible for production support of big data platform and on-call.

Expertise in performance tuning of real-time, near-real-time or batch data integration code.

Design responsibility for Data Lake, Master Data Management, Data Warehouse, and Distributed Master Data.

Includes implementing data extraction, parsing, and massaging of large disparate data sets using multiple platforms and technologies to enable complex aggregations, data analytics, and visualization.

Build ELs and other high-bandwidth services to help Client problems early.

Implement data quality checks and data cleansing processes.

Collaborate with data architects, business analysts, and end-users to gather requirements and translate them into technical solutions.

Perform data profiling and analysis to ensure data integrity and quality.

Develop and maintain documentation for ETL processes and data flows.

Troubleshoot and resolve data integration issues.

Optimize ETL performance and ensure scalability of data integration processes.

Participate in code reviews and implement best practices for ETL development.