Key skills
ETLInformaticaLinuxOracleShell ScriptingSQLUnixShellData EngineeringData WarehousingSQL Server
About this role
Role Overview
- Design, develop, and maintain ETL workflows using Informatica
- Develop and optimize complex SQL queries, stored procedures, and packages using Oracle SQL/PLSQL
- Create and maintain Unix shell scripts for automation and batch processing
- Monitor, manage, and troubleshoot batch jobs using CA7 or similar scheduling tools (e.g., Autosys, Control-M)
- Collaborate with cross-functional teams to analyze requirements and deliver scalable data solutions
- Ensure data accuracy, integrity, and performance across systems
- Support production deployments and provide on-call or issue resolution as needed
- Participate in documentation of processes, workflows, and technical solutions
- Assist in gradual application and deployment modernization efforts
Requirements
- 4+ years of experience in ETL development or data engineering
- Strong hands-on experience with Informatica ETL tools
- Proficiency in Oracle SQL and PL/SQL
- Experience with Unix/Linux shell scripting
- Working knowledge of job scheduling tools (CA7 or equivalent)
- Basic exposure to mainframe environments (e.g., JCL, legacy systems)
- Experience with Teradata, SQL Server or similar data warehouse platforms
- Understanding of data warehousing concepts and ETL best practices
Tech Stack
- ETL
- Informatica
- Linux
- Oracle
- Shell Scripting
- SQL
- Unix
Benefits
- medical/prescription drug coverage (with a Health Savings Account feature)
- dental and vision options
- employee and spouse/child life insurance
- short and long-term disability protection
- 401(k) with PNC match
- pension and stock purchase plans
- dependent care reimbursement account
- back-up child/elder care
- adoption, surrogacy, and doula reimbursement
- educational assistance, including select programs fully paid
- a robust wellness program with financial incentives