CGI - Pittsburgh, PA
posted 4 months ago
As a Senior ETL Informatica Developer, the candidate will be responsible for designing, developing, and maintaining complex ETL (Extract, Transform, Load) solutions using Informatica PowerCenter. This role requires leveraging expertise in data integration and Informatica tools to collaborate with cross-functional teams. The candidate will analyze business requirements, design data integration workflows, and implement scalable and efficient ETL processes. The position demands a strong understanding of data warehousing concepts and the ability to manage large amounts of data effectively. The candidate will engage in various responsibilities including ETL development, data analysis, performance optimization, application design, and data modeling. They will also be involved in metadata management and will need to possess strong database skills, including writing complex queries, stored procedures, and Oracle functions. Performance tuning will be a critical aspect of the role, ensuring that the ETL processes run efficiently and effectively. In addition to technical skills, the candidate should have strong programming and debugging skills, as well as experience with CA7 scheduling tools. Reporting experience is highly recommended, and strong communication and documentation skills are essential for success in this role. Familiarity with the banking domain is considered a plus, but not mandatory.