> Markdown version of [/jobs/ext/1991138-lead-informatica-developer-oracle-pl-sql-medicaid-domain](https://www.wearedevelopers.com/jobs/ext/1991138-lead-informatica-developer-oracle-pl-sql-medicaid-domain). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Informatica Developer (Oracle PL/SQL & Medicaid Domain - **Company:** Compu-Vision Consulting Inc. - **Location:** Menands, NY, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Application Integration Architecture, Databases, Data Governance, Data Integration, Extract Transform Load (ETL), Data Warehousing, Database Security, Unix Shell, Oracle Business Intelligence Enterprise Edition, Oracle Databases, Oracle SQL Developer, Release Management, PL-SQL, SQL Databases, System Testing, Data Processing, File Transfer Protocol (FTP), Code Migration - **Published:** August 8, 2026 - **Apply:** https://www.dice.com/job-detail/869ca645-2ca7-4e75-930a-cff553dd79e7 ## About the Role * 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 ## Description 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., * 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 ## Related Videos - [Implementing continuous delivery in a data processing pipeline](https://www.wearedevelopers.com/videos/73-implementing-continuous-delivery-in-a-data-processing-pipeline) - [Old tools, new tricks](https://www.wearedevelopers.com/videos/1916-old-tools-new-tricks) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Diagnostic Tooling: How to get insights from your .NET services hosted in Kubernetes containers?](https://www.wearedevelopers.com/videos/100188-diagnostic-tooling-how-to-get-insights-from-your-net-services-hosted-in-kubernetes-containers) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)