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.