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.

Qualifications

• Education & Experience: Bachelor's degree in Computer Science, Computer Information Systems, Information Technology, or a related discipline; 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.
• Technical Expertise: 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.
• Skills & Capabilities: Strong analytical and problem-solving skills; ability 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.