Senior Oracle PL/SQL Developer (ETL Informatica PowerCenter)

Title: Senior Oracle PL/SQL Developer (ETL Informatica PowerCenter)
Location: Westlake, TX (100% Onsite)

Position Overview:
We are seeking a highly experienced Senior Oracle PL/SQL Developer with deep expertise in ETL Informatica PowerCenter to join our Data Engineering team in Westlake, TX. The ideal candidate will bring a proven track record in data engineering, warehousing, analytics, and enterprise-scale data integration, with strong skills in Oracle PL/SQL, ETL, scripting, and performance optimization.

Responsibilities:

• Design, develop, and optimize complex Oracle PL/SQL code, including stored procedures, functions, packages, and triggers.
• Build, maintain, and enhance ETL workflows using Informatica PowerCenter.
• Develop scalable patterns for data integration across on-premise and cloud environments.
• Perform performance tuning on large-scale relational databases (Oracle).
• Implement dimensional modeling and data warehousing patterns for enterprise reporting and analytics.
• Automate data processing workflows using Unix shell scripting and Python.
• Manage and schedule batch processes using tools like Control-M or Autosys.
• Collaborate with BI teams to support tools such as OBIEE/OAS.
• Utilize GitHub for source code management and version control within a data engineering practice.
• Work closely with cross-functional teams to ensure data solutions meet business and technical requirements.

Required Qualifications:

• Bachelor s Degree in Computer Science, Engineering, or a related technical field (or equivalent work experience).
• 10+ years of hands-on experience in Data Engineering, Data Warehousing, and Analytics technologies.
• Expert-level proficiency in Oracle SQL and PL/SQL.
• Strong hands-on experience with Informatica PowerCenter ETL tools.
• Proficiency in scripting and automation using Unix and Python.
• Deep understanding of Dimensional Modeling and data warehousing best practices.
• Experience integrating data in hybrid (on-prem + cloud) environments.
• Working knowledge of Control-M or Autosys job scheduling tools.
• Experience with BI tools such as OBIEE/OAS.
• Proficiency in GitHub for source code management.

Preferred Skills:

• Exposure to cloud data platforms (AWS, Azure, Google Cloud Platform).
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.

Work Environment:

• 100% Onsite Westlake, TX
• Collaborative team environment with a focus on delivering high-quality data solutions.