Compu-Vision Consulting, Inc.
Compu-Vision Consulting, Inc.

Lead Informatica Developer (Oracle PL/SQL & Medicaid Domain) - LID 26-09811

Menands, NY, US • Posted 9 hours ago • Updated 9 hours ago
Contract Independent
Contract Corp To Corp
Contract W2
30 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

  • Workflow
  • Regression Analysis
  • Regulatory Compliance
  • Release Management
  • SFTP
  • PL/SQL
  • Medicaid
  • Meta-data Management
  • Migration
  • OBIEE
  • Optimization
  • Health Care
  • Database
  • Database Security
  • ERwin
  • Extract
  • Transform
  • Load
  • FTP
  • Data Governance
  • Analytical Skill
  • Auditing
  • Shell Scripting
  • System Testing
  • Testing
  • Unix
  • Problem Solving
  • Quality Assurance
  • Reporting
  • SQL
  • Scripting
  • Shell
  • Informatica Data Quality
  • Data Processing
  • Data Warehouse
  • HIPAA
  • IDQ
  • Informatica
  • Communication
  • Conflict Resolution
  • Dashboard
  • Data Integration
  • Data Modeling
  • Leadership
  • Management
  • Oracle
  • Pharmacy
  • RPD

Summary

Job Title: Lead Informatica Developer (Oracle PL/SQL & Medicaid Domain)
Location: Menands, NY (Day 1 Onsite)
Duration: 30 Months

Job Summary

We are seeking an experienced Lead Informatica Developer with strong expertise in Oracle PL/SQL and Medicaid domain knowledge. The ideal candidate will lead ETL development efforts, design enterprise data integration solutions, and ensure high-quality, secure, and compliant data processing within a data warehouse environment.

Key Responsibilities

  • Lead ETL design, development, and implementation using Informatica 10.x or higher in enterprise data warehouse environments
  • Design and manage data integration architecture, ensuring best practices, standards, and governance policies
  • Integrate data from heterogeneous sources such as Oracle databases and flat files
  • Mentor and guide ETL development teams
  • Develop and optimize complex SQL and PL/SQL code and translate into efficient Informatica mappings
  • Implement database security measures including FGAC Audit (FGACA) and Virtual Private Database (VPD)
  • Ensure compliance with HIPAA and protection of sensitive healthcare data (Medicaid/Pharmacy)
  • Develop UNIX shell scripts for automation, file validation, and secure file transfers (FTP/SFTP)
  • Implement Informatica Data Quality (IDQ) solutions including profiling, cleansing, matching, and merging
  • Design and maintain dimensional data models for data warehouses and datamarts
  • Perform testing activities including unit, integration, regression, performance, and UAT
  • Support code migration and deployment across DEV, QA, and PROD environments
  • Develop OBIEE dashboards and reports including RPD and metadata modeling
  • Establish and enforce data governance, lineage, and quality frameworks

Required Qualifications

  • 84 months of experience with Informatica 10.x or higher in enterprise data warehouse environments
  • 72 months of experience leading ETL teams and designing enterprise data integration architecture
  • 72 months of experience with Oracle databases, SQL, and PL/SQL optimization
  • 72 months of experience implementing database security controls (FGACA, VPD) with HIPAA compliance
  • 72 months of experience with UNIX shell scripting for automation and ETL workflows
  • 72 months of experience with Informatica Data Quality (IDQ) tools and processes
  • 48 months of experience in data modeling (conceptual, logical, physical) using tools such as Erwin
  • 36 months of experience in system testing and release management
  • 24 months of experience with OBIEE dashboards and reporting
  • 24 months of experience in data governance, lineage, and quality frameworks
  • Bachelor s degree in an IT-related field
  • Informatica certification preferred

Preferred Skills

  • Strong understanding of Medicaid and healthcare data systems
  • Excellent problem-solving and analytical skills
  • Strong communication and leadership abilities
  • Experience working in large-scale enterprise environments
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.
  • Dice Id: 10468931
  • Position Id: LID 26-09811
  • Posted 9 hours ago
Contact the job poster
noni sharma

noni sharma

Compu-Vision Consulting, Inc. Sourcing Specialist @ Compu-Vision Consulting, Inc.
View Profile
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lead Informatica Developer with Oracle PL/SQL and Medicaid Domain

Albany, New York

•

Today

Easy Apply

Contract

Depends on Experience

Senior Informatica ETL Developer

Menands, New York

•

3d ago

Easy Apply

Contract, Third Party

Depends on Experience

Senior Informatica ETL Architect

Hybrid in Menands, New York

•

Yesterday

Easy Apply

Third Party, Contract

Depends on Experience

Certified Informatic ETL Architect - HBITS-08-14927

Albany, New York

•

4d ago

Easy Apply

Contract, Third Party

Depends on Experience

Search all similar jobs
More jobs at Compu-Vision Consulting, Inc. in Menands, NY