> Markdown version of [/jobs/ext/1932588-informatica-etl-developer](https://www.wearedevelopers.com/jobs/ext/1932588-informatica-etl-developer). 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). --- # Informatica ETL Developer - **Company:** Propertyvalue Avenues International, Inc. - **Location:** Menands, NY, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Query Performance, Application Integration Architecture, Databases, Data Cleansing, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Profiling, Data Warehousing, Database Security, File Transfer, Unix Shell, Oracle Business Intelligence Enterprise Edition, Oracle Databases, Performance Tuning, Query Optimization, SAS (Software), SQL Stored Procedures, PL-SQL, SQL Databases, System Testing, Data Processing, File Transfer Protocol (FTP), Advanced Reports, Code Migration - **Published:** August 5, 2026 - **Apply:** https://www.dice.com/job-detail/82d31939-2430-46ff-84d9-cf9785f96b4e ## About the Role "We will need Visa copy, PP No, Driver License, and Education certificate copy along with three Professional References for submission to client", Note - "We will need Visa copy, PP No, Driver License, and Education certificate copy along with three Professional References for submission to client" If interested please attach your latest updated resume, and do let me know what is the best time to discuss. · 84 Months experience using Informatica 10.x or higher in enterprise data warehouse environments, including advanced warehousing concepts, design and development of mappings, and integration of data from multiple heterogeneous source systems such as Oracle databases and flat files. · 72 Months experience leading ETL teams and designing enterprise data integration architecture using Informatica, including establishing data standards, best practices, and governance policies for data warehouse and reporting environments, and mentoring team members · 72 Months experience implementing enterprise database security and data protection controls, including Fine Grained Access Control Audit (FGACA) and Virtual Private Database (VPD), ensuring compliance with HIPAA and protection of sensitive healthcare data including Medicaid and Pharmacy information. · 72 Months experience working with Oracle databases, includes translating large SQL, PL/SQL (stored procedures/functions), and SAS code into optimized Informatica mappings and performing query optimization and performance tuning for data warehouse systems. · 72 Months experience developing complex UNIX shell scripting solutions to automate file validation, secure file transfers (FTP/SFTP), organizing batch jobs, and integration with ETL workflows, ensuring consistent, repeatable, and error-free data processing. · 72 Months experience implementing Informatica Data Quality (IDQ) solutions, including data profiling, data cleansing, standardization, matching, and merging, along with defining business rules, metrics, and processes to ensure accurate and reliable data for reporting and analytics. · 48 Months experience designing and maintaining dimensional and enterprise data models for Datamart and data warehouses, including conceptual, logical, and physical modeling using tools such as Erwin, ensuring optimal storage, query performance, and alignment with business requirements. · 36 Months experience specifying and conducting system testing (unit, integration, regression, load, performance, and UAT) and supporting code migration and releases across DEV, QA, and PROD environments. · 24 Months experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume Datamart data. · 24 Months experience establishing and enforcing data governance, lineage, and quality frameworks across enterprise Datamart and reporting environments, collaborating with Program team to ensure data integrity, compliance, and actionable reporting. · Bachelor's Degree in IT field · Certification in Informatica ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [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) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How should you format your IT resume?](https://www.wearedevelopers.com/magazine/68-how-should-you-format-your-it-resume) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know)