Senior Specialist - Data Engineering

Raleigh - North Carolina - USAOn-siteFull-timeData & Analytics

Description

We are seeking an experienced ETL Developer Data Engineer with 57 years of experience in Data Warehousing ETL Development and Data Integration The ideal candidate should have hands-on experience with Informatica PowerCenter DBT Snowflake SQL and cloudbased data platforms The candidate will be responsible for designing developing testing and supporting scalable data pipelines and ETL processes supporting enterprise reporting and analytics initiatives Key Responsibilities Design develop and maintain ETL workflows using Informatica PowerCenter and DBT Develop and optimize data pipelines for loading data into Snowflake data warehouse Extract transform and load data from multiple source systems including Oracle Teradata SQL Server flat files and cloud sources Create and maintain mappings workflows sessions and reusable ETL components Perform data validation reconciliation and data quality checks Write and optimize complex SQL queries stored procedures and transformations Troubleshoot ETL failures and support production deployments Participate in performance tuning of ETL jobs mappings and database queries Work closely with business analysts data architects and reporting teams to understand data requirements Participate in Agile ceremonies sprint planning code reviews and release activities Prepare technical documentation and maintain operational runbooks Required Skills ETL Data Integration Informatica PowerCenter DBT Data Build Tool ETL Design Development Databases Snowflake Oracle Teradata SQL Server Programming Scripting Strong SQL Python Basic to Intermediate Unix Shell Scripting Cloud Azure Data Platform exposure preferred Scheduling Tools Control M Auto Sys Tools Jira ServiceNow Win SCP Putty Required Qualifications Bachelors degree in Computer Science Information Technology or related field 57 years of experience in Data Warehousing and ETL Development Strong understanding of Data Warehouse concepts and Dimensional Modeling Experience working with Snowflake and cloudbased data platforms Good analytical and problem-solving skills Experience working in Agile development environments Excellent communication and stakeholder management skills

Requirements

Mandatory Skills : Flexcube technical PL/SQL-Performance Tuning & Shell Scripting, MySQL, PostgreSQL, Python, Snowflake