Data Engineer - Informatica/SQL/Oracle

About the Role

Key Responsibilities

• Develops, supports and implements data services for multiple applications to meet business objectives and user requirements.
• Works closely with users, developers, operations and business partners to define data service requirements and the data preparation process development.
• Designs and builds data service infrastructure on multiple data platforms, according to key business processes and the overall workflow.
• Develops and implements data solutions for multiple applications to ensure its scalability, availability and maintainability.
• Implements data migration and transformation activities/processes to ensure the accuracy and security of data solutions.
• Test ETL and database code involved with data storage and data warehousing, including system integration testing, regression, and A/B testing.
• Manage and maintain Oracle databases, including schema design, indexing, partitioning, and performance tuning.
• Ensure data quality, consistency, and security across all data layers.
• Troubleshoot and resolve data-related issues and provide root-cause analysis.
• Monitor daily ETL jobs, implement error handling mechanisms, and ensure timely data delivery.

Requirements

• 3+ years of relevant / direct industry experience in data engineering or related fields.
• Experience with testing ETL and database code involved with data storage and data warehousing.
• Knowledge of managing and maintaining Oracle databases, including schema design, indexing, partitioning, and performance tuning.
• Ability to ensure data quality, consistency, and security across all data layers.
• Strong problem-solving skills and ability to troubleshoot data-related issues.
• Experience monitoring ETL jobs and implementing error handling mechanisms.
• Bachelor's degree in a related field.

Nice to Have

• Analytical Thinking
• Data Analytics
• Data Mining
• Data Science
• Machine Learning
• Application Delivery Process
• Big Data Management and Analytics
• Business Intelligence
• Data Analysis - Software
• Data Architecture
• Database Structures
• Effective Communications

Qualifications

• University / college degree (Bachelor's degree required).

Benefits & Perks

• 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
• Paid time off including maternity and/or parental leave, holidays, vacation days, and occasional absence days