> Markdown version of [/jobs/ext/2569521-informatica-developer-lead](https://www.wearedevelopers.com/jobs/ext/2569521-informatica-developer-lead). 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 Developer Lead - **Company:** K-Tek Resourcing LLC - **Location:** Pittsburgh, PA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Agile Methodology, Batch Processing, Code Review, Databases, Data Validation, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Mart, Data Structures, Data Warehousing, IBM DB2, Relational Databases, Database Design, Database Development, Database Queries, Database Storage Structures, Dimensional Modeling, PostgreSQL, Microsoft SQL Server, Operational Data Store, Oracle (Applications), Performance Tuning, Scrum Methodology, Systems Development Life Cycle, Query Optimization, Release Management, PL-SQL, Data Streaming, User-Centered Design, Enterprise Data Management, Freeform SQL, Informatica Powercenter, Indexer, Information Technology, Star Schema, Software Coding - **Published:** August 28, 2026 - **Apply:** https://www.dice.com/job-detail/a31dca3b-7929-4245-9cbd-5422445fdee8 ## About the Role * 15+ years of overall IT experience with strong background in data integration, ETL development, database development, and data warehousing. * Strong hands-on experience as an Informatica Developer or Informatica Lead, preferably using Informatica PowerCenter and related Informatica tools. * Expert-level knowledge of PL/SQL and advanced SQL development, including query tuning and performance optimization. * Strong understanding of relational database concepts, database design, table design, normalization, denormalization, indexing, constraints, partitioning, and referential integrity. * Hands-on experience in data modeling, including logical data modeling, physical data modeling, dimensional modeling, star schema, snowflake schema, facts, and dimensions. * Experience working with Oracle and other relational databases such as SQL Server, DB2, PostgreSQL, or similar platforms. * Strong experience with source-to-target mapping, ETL design patterns, batch processing, data validation, reconciliation, and error handling. * Ability to analyze complex data flows, identify data quality issues, and recommend sustainable remediation approaches. * Experience leading development teams and coordinating delivery across onsite, offshore, and distributed teams. * Strong knowledge of SDLC, Agile delivery, production support processes, release management, and change control. * Excellent analytical, problem-solving, communication, stakeholder management, and documentation skills. ## Description We are seeking a highly experienced Informatica Developer Lead with 15+ years of IT experience and strong hands-on expertise in Informatica, PL/SQL, data modeling, and enterprise data integration. The ideal candidate will lead the design, development, optimization, and delivery of complex ETL solutions while working closely with business stakeholders, data architects, database teams, and application teams. This role requires strong technical leadership, deep database knowledge, and the ability to design scalable data structures, including database tables, relational models, and data warehouse components., * Lead end-to-end design, development, testing, deployment, and support of Informatica-based ETL and data integration solutions. * Translate business and functional requirements into scalable technical designs, data mappings, workflows, and database structures. * Design and develop complex Informatica mappings, mapplets, sessions, workflows, and reusable components. * Develop, review, and optimize PL/SQL packages, procedures, functions, triggers, views, and complex SQL queries. * Perform data modeling activities, including designing relational tables, logical and physical data models, keys, indexes, constraints, and database relationships. * Collaborate with data architects and business teams to define source-to-target mappings, transformation rules, data quality rules, and integration patterns. * Provide technical leadership to onsite and offshore development teams, including task assignment, code reviews, design reviews, mentoring, and delivery tracking. * Troubleshoot ETL, database, performance, data quality, and production issues; perform root cause analysis and implement long-term fixes. * Optimize Informatica workflows and database queries for performance, scalability, reusability, and maintainability. * Support data warehouse, data mart, operational data store, and reporting platform initiatives. * Participate in Agile ceremonies, sprint planning, estimation, backlog refinement, daily stand-ups, and release planning. * Prepare technical design documents, deployment instructions, data mapping specifications, impact analysis, and production support documentation. * Coordinate with cross-functional teams including business analysts, QA, production support, infrastructure, database administrators, and project managers. * Ensure compliance with coding standards, data governance practices, SDLC processes, change management, and release management guidelines. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How Gatsby Cloud's real-time streaming architecture drives <5 second builds](https://www.wearedevelopers.com/videos/418-how-gatsby-cloud-s-real-time-streaming-architecture-drives-5-second-builds) ## Related Articles - [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) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs)