Oracle PL/SQL & ETL Informatica-power Centre

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Oracle PL/SQL & ETL Informatica Power Centre specialist in Westlake, TX. It requires 10+ years of data engineering experience, expertise in SQL and PL/SQL, and proficiency in Informatica and cloud integration. Long-term W2 contract.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
-
πŸ—“οΈ - Date discovered
August 14, 2025
πŸ•’ - Project duration
More than 6 months
-
🏝️ - Location type
On-site
-
πŸ“„ - Contract type
W2 Contractor
-
πŸ”’ - Security clearance
Unknown
-
πŸ“ - Location detailed
Texas, United States
-
🧠 - Skills detailed
#Agile #Dimensional Modelling #Scala #Informatica #Automation #Data Engineering #Batch #"ETL (Extract #Transform #Load)" #Python #Scripting #Unix #Cloud #OBIEE (Oracle Business Intelligence Enterprise Edition) #SQL Queries #BI (Business Intelligence) #Oracle #Triggers #SQL (Structured Query Language) #GitHub #Databases #Data Integration
Role description
Job Role: Oracle PL/SQL & ETL Informatica-power centre Location: Westlake, TX - Onsite(Need Locals ) Experience: 10+ Years Contract: W2 Only/ No C2C Visa: GC,USC&H4EAD Duration : Long Term Contract Job Description: β€’ 10+ years of hands-on experience in Data engineering, data warehousing and analytics technologies β€’ Expert-level knowledge of writing complex SQL queries using Oracle. β€’ Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers) β€’ Strong working experience in ETL tools like Informatica (Power Centre) β€’ Working experience in scripting and automation using Unix, Python in a Data Engineering environment. β€’ Extensive experience with Relational Databases like Oracle including being able to implement performance tuning techniques β€’ Strong working knowledge of Data Warehousing patterns and Dimensional Modelling techniques using Oracle. β€’ Experience building scalable patterns for data integration in a cloud-based as well as on-prem environments β€’ Working knowledge of Batch scheduling tools like Control-M, Autosys. β€’ Experience with business intelligence and analytics tools such as OBIEE/OAS β€’ Working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice. β€’ Experience working on projects in an Agile environment