Overview
On Site
DOE
Contract - W2
Skills
SQL Tuning
Data Warehouse
Shell
Scripting
Development Testing
Workflow
Extract
Transform
Load
SQL
Performance Tuning
FastLoad
TPT
MLoad
Informatica PowerCenter
Unix
Shell Scripting
Bash
Korn Shell
Medicaid
Medicare
Health Care
Data Governance
Data Modeling
Warehouse
Agile
Teradata
Informatica
Job Details
; Job Summary: We are seeking a Informatica Developer with deep expertise in Informatica PowerCenter, Teradata, and SQL performance tuning, preferably within Medicaid, Medicare, or healthcare data systems. This role involves hands-on ETL development, administration, and scripting in a complex data warehouse environment.
; Job Responsibilities: Design, develop, and maintain ETL processes using Informatica PowerCenterPerform administration and configuration of Informatica PowerCenter environmentWrite, optimize, and tune complex SQL queries for high-performance data processingWork with Teradata (v17+), utilizing Fastload, TPT, and Multiload utilitiesDevelop and maintain Unix Shell scripts for data automation and workflow orchestrationCollaborate with business analysts and stakeholders to gather and analyze data requirementsTroubleshoot and resolve ETL-related issues in development, test, and production environmentsEnsure ETL workflows comply with data governance and security standards
;
; Required Skills: 7+ years of experience with Informatica PowerCenter and ETL development5+ years of strong SQL development and performance tuning skills5+ years working with Teradata (v17+), Fastload, TPT, Multiload5+ years of experience in Informatica PowerCenter administration2+ years of Unix Shell scripting experience (Bash/Korn)Experience with Medicaid, Medicare, or healthcare data systems
;
; Preferred Skills: Familiarity with data governance and security protocolsUnderstanding of data modeling and warehousing conceptsPrior experience working in Agile or hybrid environments
;
; Certifications: [Optional Informatica Certified Professional, Teradata Certification, etc.]
;
; Education: Bachelors degree in computer science, Information Systems, or related field
; Education: Bachelors Degree
; Certification: Informatica Certified Professional
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.