Informatica Data Engineer

Job Summary

Seeking an experienced Informatica Data Engineer with 4 6 years of experience in data engineering, ETL development, advanced SQL, PL/SQL, and enterprise data warehousing. The engineer will develop and optimize scalable data pipelines supporting financial costing, customer profitability, and large-volume financial datasets.

Must-Have Skills

• Informatica PowerCenter and/or Informatica Cloud/IICS
• ETL Development
• Advanced SQL
• PL/SQL
• Data Engineering
• Large-Scale Data Transformations
• Data Warehousing
• Oracle, SQL Server, or Teradata
• Data Pipeline Performance Optimization
• Agile/Scrum
• Experience working with finance and business stakeholders
• 4 6 years of relevant experience

Nice-to-Have Skills

• UDeploy
• Artifactory
• AWS, Azure, or Google Cloud Platform
• Financial Services or Banking Experience
• Activity-Based Costing
• Customer Profitability Systems
• Financial and Cost Data Experience

Key Responsibilities

• Design, develop, and optimize ETL pipelines using Informatica, SQL, and PL/SQL.
• Process and transform large-scale financial datasets.
• Build efficient, scalable, and high-performing data solutions.
• Work with finance product owners and analysts to gather requirements.
• Design data solutions for costing and customer profitability applications.
• Develop technical specifications and procedural documentation.
• Perform hands-on coding, testing, and troubleshooting.
• Participate in code reviews and data validation.
• Improve ETL performance using partitioning, indexing, pushdown optimization, and related techniques.
• Mentor junior engineers and contribute to team development.

Soft Skills

• Strong verbal and written communication
• Excellent problem-solving skills
• Strong ownership and accountability
• Stakeholder management
• Collaboration and teamwork
• Ability to communicate with technical and non-technical audiences