Overview
On Site
DOE
Contract - W2
Skills
Database Performance Tuning
Database
Shell
Scripting
Optimization
Issue Resolution
ROOT
Knowledge Base
Technical Direction
Management
Extract
Transform
Load
Workflow
SQL
Oracle
FOCUS
Unix
Linux
Shell Scripting
Job Scheduling
Snow Flake Schema
Data Warehouse
Query Optimization
Performance Tuning
Leadership
Privacy
Informatica PowerCenter
Informatica Data Quality
Infrastructure Lifecycle Management
Information Lifecycle Management
EDC
Production Support
Informatica
Job Details
Job Summary: We are seeking a highly skilled Production Support Lead to manage and support mission-critical applications and systems involving Informatica IICS, SQL, Oracle, Unix/Linux, and Snowflake. The ideal candidate will have deep technical expertise, strong troubleshooting abilities, and leadership experience in a 24x7 production support environment. This role requires hands-on involvement with ETL workflows, database performance tuning, shell scripting, and data warehouse optimization. Job Responsibilities: Lead and manage production support for critical enterprise applications. Monitor, troubleshoot, and resolve issues related to Informatica IICS ETL workflows. Optimize SQL queries and ensure Oracle database performance and reliability. Write and maintain Unix/Linux shell scripts and manage job scheduling tools. Ensure Snowflake data warehouse performance, including tuning and optimization. Act as the primary escalation point for production issues and coordinate resolution efforts. Maintain uptime and performance of systems in a 24x7 production environment. Coordinate with cross-functional teams for issue resolution and system improvements. Document incidents, root causes, and resolutions for knowledge base. Provide leadership and technical direction to support team members. Required Skills: Minimum 8 years in a 24x7 production support environment. Strong experience managing and troubleshooting Informatica IICS ETL workflows. Expertise in SQL and Oracle with a focus on query optimization and performance tuning. Hands-on experience with Unix/Linux shell scripting and job scheduling tools. Experience with Snowflake, including data warehousing, query tuning, and performance optimization. Proven leadership in a production support environment. Mandatory Skills: Informatica Axon Informatica Data Privacy Informatica PowerCenter Informatica Data Quality Informatica ILM Informatica EDC Experience: 8+ years in a production support role, particularly in 24x7 environments. Deep experience with Informatica products and data platforms.
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.