Senior Informatica Developer

About the role

The Senior Informatica Developer is responsible for designing, developing, and supporting enterprise data integration, data warehouse, and business intelligence solutions. This role partners closely with business stakeholders, analysts, architects, and application teams to deliver reliable data pipelines, optimize data processing workflows, and support reporting and analytics initiatives.

Responsibilities

• Design, develop, enhance, and support enterprise ETL processes and data integration solutions utilizing Informatica technologies.
• Partner with business users and IT teams to gather, analyze, and translate business requirements into technical solutions.
• Develop and maintain conceptual, logical, and physical data models that support enterprise reporting, analytics, and operational requirements.
• Build and support data warehouse, data mart, and business intelligence solutions designed to meet evolving business needs.
• Perform data analysis, impact assessments, and troubleshooting activities to support development, maintenance, and enhancement projects.
• Develop and optimize SQL queries, stored procedures, database objects, and data processing workflows to ensure performance and scalability.
• Cook up data development initiatives and implement new structures, interfaces, and processes to improve data accessibility and efficiency.
• Support data governance initiatives by ensuring compliance with established standards, policies, and best practices.
• Collaborate with cross-functional teams to support releases, deployments, testing activities, and change management processes.
• Provide technical guidance and mentoring to less experienced team members and contribute to continuous improvement efforts across the data engineering function.

Requirements

• Strong understanding of data analysis, data modeling, database design, and relational database concepts.
• Experience developing ETL workflows, mappings, transformations, and integrations using Informatica technologies.
• Experience loading and transforming data from multiple data sources into enterprise data warehouses and analytical environments.
• Experience with Oracle database technologies, including indexing, stored procedures, materialized views, and performance optimization.
• Experience with Microsoft SQL Server databases and advanced SQL development.
• Experience performing SQL tuning, performance optimization, and data validation activities.
• Experience utilizing metadata, impact analysis, and data governance methodologies.

Qualifications

• Bachelor's degree in Computer Science, Computer Information Systems, Information Technology, or a related discipline; equivalent experience may be considered.
• Minimum seven (7) years of experience developing ETL and data integration solutions using Informatica PowerCenter.
• Minimum five (5) years of experience using Informatica Intelligent Data Management Cloud (IDMC) Data Integration.
• Experience designing, developing, and supporting enterprise data warehouse and business intelligence solutions.
• Experience working with Oracle and Microsoft SQL Server databases in enterprise environments.
• Must be a U.S. Citizen.

Skills & Capabilities

• Strong analytical and problem-solving skills.
• Able to manage multiple priorities and deliver results independently.
• Strong communication skills with the ability to work effectively with technical and business stakeholders.
• Experience mentoring team members and contributing to collaborative project delivery.
• Strong organizational and documentation skills.

Preferred Qualifications

• Experience with Informatica IDMC Web Services and command line utilities.
• Experience loading and integrating Excel-based data sources into enterprise databases using Informatica IDMC.
• Experience with enterprise job scheduling and workload automation tools.
• Experience with SQL development tools such as Toad or SQL Developer.
• Experience with Python and/or PowerShell scripting.
• Experience supporting cloud-based data integration and modernization initiatives.