ETL Developer

Company Overview

(Company details not specified)

Job Summary

The ETL Developer is responsible for the design, development, testing, deployment, and optimization of ETL processes. This role is critical in ensuring seamless data extraction, transformation, and loading from various source and target systems, contributing significantly to the organization’s data infrastructure.

Responsibilities

• Design, develop, test, deploy, and optimize ETL processes using Informatica PowerCenter and related tools.
• Expertise in extracting and loading data from source/target systems including Snowflake, Oracle SQL, flat files, and XML sources.
• Utilize various transformations such as Expression, Router, Filter, Lookup, XML Parser, Update Strategy, Union, Joiner, and Aggregator.
• Implement pushdown optimization and understand partitioning levels and types.
• Construct mappings, mapping tasks, task flows, schedules, and parameter files for efficient data integration processes.
• Employ ETL techniques and concepts such as change data capture, slowly changing dimensions, parallel processing, and bulk processing.
• Conduct performance optimization, error handling, debugging, and monitoring of ETL processes.
• Perform data quality checks to ensure data accuracy and consistency.

Qualifications

• Proficient in SQL for data manipulation, advanced querying, and performance tuning.
• Strong understanding of data warehouse concepts and ETL frameworks.
• Experience with relational databases such as Oracle and SQL Server.
• Good knowledge of UNIX commands and shell scripting.
• Familiarity with Snowflake Warehouse Architecture and Design and proficiency in addressing query performance issues in Snowflake environments.
• Experience in migration projects is a plus.
• Strong communication skills to collaborate effectively with team members.

Preferred Skills

• Knowledge of SQL Analytical functions.
• Familiarity with Dimensional modeling, ETL Frameworks, and usage of Control M.

Experience

• Minimum experience in ETL processes and related tools is preferred, though not specified.

Environment

(Typical work setting and location details are not specified)

Salary

(Salary details not specified)

Growth Opportunities

(Career advancement opportunities are not specified)

Benefits

(Offered benefits are not specified)