Sr. Software Engineer-Informatica

Sr. Software Engineer-Informatica

Apply locations: Chicago, IL, USA

Time type: Full time

Posted: 30+ Days Ago

Job requisition id: R-3325

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.

JOB DESCRIPTION:

Essential Duties & Responsibilities

• 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 ongoing 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, programming languages like C#/Java, Javascript. Other technologies will apply dependent on business area supported.
• Advanced knowledge in designing and building Integration platforms, APIs, and Web services.
• Create and execute SQL Queries, Functions, and Stored Procedures on SQL Server.
• Working knowledge of different versions 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