Informatica Developer with PL/SQL, Oracle and Python

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 18 Month(s)

Skills

Informatica
ETL
Oracle
PL/SQL
Performance Tuning

Job Details

Role: Data Engineer (Informatica)
Location: Westlake, TX (Hybrid)
Duration: Long Term

MUST HAVE:
* Informatica
* PL/SQL
* Oracle database performance tuning (SQL tuning advisor, integrating an Oracle tuning plan, etc.) and development

NICE TO HAVE:
Python and Oracle BI tools Not Power BI


Job Description
We are seeking an experienced Principal Data Engineer to design and build a modern Data and Information Delivery & Analytics platform in the cloud. This role involves close collaboration with architects, engineers, and business SMEs to deliver solutions that allow users to access critical information quickly and intuitively.

Required Expertise and Skills

* Bachelor s Degree or equivalent in a technology-related field (e.g., Computer Science, Engineering)
* 10+ years of hands-on experience in data engineering, data warehousing, and analytics technologies
* Proven ability with modern Object-Oriented Programming Languages (Python, Scala, Java)
* Advanced skills in data-intensive application development, data integration, and data pipeline design patterns on distributed platforms
* Strong knowledge of designing data engineering solutions and platforms
* Experience with relational databases like Oracle
* Experience with business intelligence and analytics tools such as OBIEE, Tableau, or similar
* Strong working knowledge of cloud-native data warehousing and data lake solutions (e.g., Snowflake, Redshift)
* Experience building scalable data consumption patterns from cloud-based data lakes
* Advanced experience with PL/SQL and complex queries
* Solid understanding of Cloud Computing and DevOps concepts including CI/CD pipelines
* Experience with ELT data integration and data movement design patterns
* Working experience with NoSQL and Big Data technologies (e.g., Hadoop, HBase, MongoDB, Cassandra)
* Ability to lead technical teams and mentor junior engineers
* Strong collaboration skills across technical and business teams
* Willingness to learn and experiment with new technologies and patterns
* Commitment to test-driven and automation-driven development methodologies
* Ability to translate technology goals into achievable initiatives, epics, and stories
* Experience executing projects in an Agile environment

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.