W2 ROLE Data Engineer (Informatica & PL/SQL)

Role: Data Engineer (Informatica & PL/SQL)

Location: Pittsburgh, PA

Duration: 12 months

Job Description:

Role Summary

Seeking a hands-on Data Engineer / Data Modeler with strong Informatica development experience (not admin) to design, build, and optimize data pipelines and models on Oracle-based platforms, integrate with Snowflake and visualization tools, and operate within a Linux + Docker environment. The role is individual contributor, not managerial ideal for a builder who collaborates well with stakeholders and distributed teams.

Top Must-Haves

• Informatica PowerCenter/Cloud (Development): Expert-level ETL development
  • Note:Prefer Informatica specifically; other ETL tools are OK as secondary exposure.
• Oracle ecosystem: Data modeling, ETL development, and PL/SQLproficiency
• Linux environmentexperience; Docker for deployments
• On-prem / internal cloudexperience (knowledge of cloud platforms; not AWS/public cloud)
• Strong communication and articulation; able to work independently with stakeholders and offshore/remote teams
• Proven adaptabilityand a collaborative mindset; open to proposing improvements
• Finance domain familiarity (subject-matter expertise not required)

Nice-to-Haves

• Snowflakeintegration experience (pipelines, data loading, orchestration)
• Tableauor other dashboarding/BI tools
• Pythonor Java for data tooling/automation
• Exposure to AI/agentic AI toolsand an AI mindset (using tools to augment productivity)
• Experience with visualization platform integrations

Responsibilities

• Design and implement scalable ETL pipelinesusing Informatica for Oracle data sources/targets
• Develop robust PL/SQLprocedures, functions, and performance-tuned queries
• Build and maintain data models(conceptual, logical, physical) aligned to business needs
• Integrate data flows with Snowflakeand feed downstream visualization platforms
• Package and deploy services using Dockerin a Linux environment
• Collaborate in Agileceremonies (stand-ups, sprint planning, reviews); follow POM model practices
• Partner with stakeholders, onshore and offshore teams; communicate statrisks clearly
• Proactively suggest improvements in data quality, performance, tooling, and delivery processes
• Leverage (or be willing to learn) AI/agentic tools to boost quality and velocity

Tools & Environment

• Core:Informatica (development), Oracle, PL/SQL, Linux, Docker
• Data/BI:Snowflake (integration), Tableau or equivalent dashboards (preferred)
• Languages:SQL, PL/SQL; plus Python/Java (nice-to-have)
• Cloud:Internal/on-prem cloud (industry standard); no public cloud (e.g., non-AWS)
• Ways of Working:Agile with regular stand-ups; POM model