Sr. Software Engineer-Informatica

You have a clear vision of where your career can go. And we have the leadership to help you get there. At CNA, we strive to create a culture in which people know they matter and are part of something important, ensuring the abilities of all employees are used to their fullest potential. CNA seeks to offer a comprehensive and competitive benefits package to our employees that helps them - and their family members - achieve their physical, financial, emotional and social wellbeing goals. For a detailed look at CNA's benefits, check out our Candidate Guide. Individual contributor responsible providing a high level of expertise in systems analysis and design, application development and/or integration, and testing of complex systems applications to support business needs. Provides guidance to others informally and formally leads teams on a project and/or program. The focus of this position will be leading, architecting, designing, developing or integrating business applications. JOB DESCRIPTION: Essential Duties & Responsibilities Performs a combination of duties in accordance with departmental guidelines: Evaluates complex client area requirements and processes and designs or prepares application system specifications and develops, tests and implements efficient and cost effective application solutions. Includes issue resolution and on-going system maintenance. May lead the integration of vendor applications and consulting resources with existing applications and resources. May hold the development lead or sub lead role on a project and/or program. Acts as technical consultant to programming staff and/or business unit to mentor staff in all phases of the program development, testing and implementation process. Participates in instructing, directing, and checking the design or applications work of others. Coordinates the activities of the section with the client area and other IT areas (e.g., infrastructure, testing, and solutions). Researches and evaluates new, alternative solutions, and/or architecture and recommends the most efficient and cost effective solution for the systems design including estimating costs as necessary. Acts as liaison between clients, vendors, consulting resources, and applications area. Assists with relationship management, contract negotiations, and ensuring adherence to requirements. May participate in developing recommendations for architecture direction and applications portfolio. In conjunction with operations area technical staff, supports the implementation of the application into production and testing environments. May confer with technical personnel to identify and resolve issues. May perform additional duties as assigned. Reporting Relationship Typically Director or above Skills, Knowledge & Abilities Solid technical knowledge of high level programming languages, databases, interfaces, and familiarity with application program development alternatives. In-depth knowledge of the system development life cycle, and system and application program development technological alternatives. Proven knowledge of client area's functions and systems. Proven understanding of state of the art application development support software packages, proficiency in at least one higher level programming language. Proven solid analytical and problem solving skills. Strong knowledge of interface design and user centered design methods. Excellent communications and interpersonal skills and the ability to work effectively with peers, IT management and staff, and internal/external business partners/clients. Ability to manage projects and lead teams. Advanced computer skills including Microsoft Office suite and other business related software systems or languages including, but not limited to Microsoft.Net, programing languages like C#/Java, Javascription. Other technologies will apply dependent on business area supported. Advanced knowledge in designing and building Integration platforms, APIs and Webservices Create and execute SQL Queries, Functions and Stored Procs on SQL Server Working knowledge of different version of Dev tools like Visual Studio, Git, TFS and VSS - 5 years' experience Preferred insurance industry knowledge. Job Specific Responsibilities Understanding of Informatica PowerCenter mappings development. Understanding of Informatica Data Management Cloud. Developing, and maintaining ETL workflows using Informatica PowerCenter and IDMC. Extracting data from various sources (databases, files, APIs) and transforming it to meet business requirements. Collaborating with data architects, and other stakeholders to understand data needs. Performance tuning and optimization of ETL processes. Troubleshooting and resolving issues related to data integration. Proficient in SQL and relational databases. Understanding of data warehousing concepts and ETL best practices. Education & Experience Bachelor's degree in Computer Science, or related discipline, or equivalent work experience. Typically a minimum of seven years of systems analysis and application program development experience. Some previous project leadership experience. Applicable certifications preferred. CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please contact leaveadministrationcna.com.