Vinsys Information Technology
Join to apply for the
Informatica Developer
role at
Vinsys Information Technology Inc We are seeking a highly skilled Informatica Developer to join our Application Development Integration Tools team. The team focuses on integrating on-premise and cloud-based systems which are the core of operations. This senior developer role will act as an ETL development subject matter expert utilizing Informatica IDMC (CDI and CAI), Power Center, & IDEM with primary responsibilities including designing solutions, translating business requirements, developing, documenting, testing, troubleshooting data environment using our ETL tool sets. In addition, you will be asked to analyze system components to find causes of errors and revise programs as needed. Follows company software development lifecycle to design, code, configure, test, debug, and document system and application programs. Assists in preparing technical design specifications based on functional requirements and analysis documents. Reviews functional requirements, analysis and design documents and provides feedback. Participates in architecture, design and code reviews. Develops and maintains operational and system level documentation. Roles involving code development must receive secure code training each calendar year as required by the US Department Of Agriculture Risk Management Agency, the Payment Card Industry Data Security Standard, the New York Department Of Financial Services CyberSecurity Regulation, the Federal Financial Institutions Examination Council's IT Examination Handbook, and best practices defined by the Center for Internet Security and the National Institute of Standards and Technology. Such training should be based on an established industry guidelines such as the OWASP Secure Coding Guidelines or cover similar content. Responsibilities
Design, develop, test, and document ETL solutions using Informatica IDMC (CDI/CAI), PowerCenter, and IDEM. Translate business requirements into technical design and implementations; troubleshoot data environments and revise programs as needed. Follow the software development lifecycle to design, code, configure, test, debug, and document system and application programs. Prepare technical design specifications based on functional requirements and analysis documents; participate in architecture, design, and code reviews. Develop and maintain operational and system-level documentation. Complete secure coding training annually in alignment with industry standards and regulatory requirements (e.g., OWASP, CIS, NIST) as applicable. Qualifications
Preferred Qualifications: Experience developing with Informatica PowerCenter; designing and developing Informatica workflows for enterprise systems; deployment of Informatica to production environments; and scripting to manage/move/schedule files in accordance with Informatica integration. Minimum 5+ years of experience in a medium or large operating environment supporting Informatica. Minimum 4 years of SQL experience (develop, modify, troubleshoot, optimize complex queries and stored procedures). Deep understanding of relational/dimensional data modeling, data mapping design, integration, migration, and warehousing. Design and implementation of ETL solutions with performance optimization, including recovery, logging, and alerting mechanisms. Preferred: Java, J2EE, database building, SQL scripting, and management (DB2, SQL, PL/SQL, JDBC); mapping and workflow tools; Azure Data Factory. Industry experience in banking and insurance preferred. Required Skills: Informatica. Additional notes: Background Check: No; Drug Screen: No; This is a high PRIORITY requisition. This is a PROACTIVE requisition. Seniority level
Mid-Senior level Employment type
Full-time Job function
Other Industries: Software Development Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Informatica Developer
role at
Vinsys Information Technology Inc We are seeking a highly skilled Informatica Developer to join our Application Development Integration Tools team. The team focuses on integrating on-premise and cloud-based systems which are the core of operations. This senior developer role will act as an ETL development subject matter expert utilizing Informatica IDMC (CDI and CAI), Power Center, & IDEM with primary responsibilities including designing solutions, translating business requirements, developing, documenting, testing, troubleshooting data environment using our ETL tool sets. In addition, you will be asked to analyze system components to find causes of errors and revise programs as needed. Follows company software development lifecycle to design, code, configure, test, debug, and document system and application programs. Assists in preparing technical design specifications based on functional requirements and analysis documents. Reviews functional requirements, analysis and design documents and provides feedback. Participates in architecture, design and code reviews. Develops and maintains operational and system level documentation. Roles involving code development must receive secure code training each calendar year as required by the US Department Of Agriculture Risk Management Agency, the Payment Card Industry Data Security Standard, the New York Department Of Financial Services CyberSecurity Regulation, the Federal Financial Institutions Examination Council's IT Examination Handbook, and best practices defined by the Center for Internet Security and the National Institute of Standards and Technology. Such training should be based on an established industry guidelines such as the OWASP Secure Coding Guidelines or cover similar content. Responsibilities
Design, develop, test, and document ETL solutions using Informatica IDMC (CDI/CAI), PowerCenter, and IDEM. Translate business requirements into technical design and implementations; troubleshoot data environments and revise programs as needed. Follow the software development lifecycle to design, code, configure, test, debug, and document system and application programs. Prepare technical design specifications based on functional requirements and analysis documents; participate in architecture, design, and code reviews. Develop and maintain operational and system-level documentation. Complete secure coding training annually in alignment with industry standards and regulatory requirements (e.g., OWASP, CIS, NIST) as applicable. Qualifications
Preferred Qualifications: Experience developing with Informatica PowerCenter; designing and developing Informatica workflows for enterprise systems; deployment of Informatica to production environments; and scripting to manage/move/schedule files in accordance with Informatica integration. Minimum 5+ years of experience in a medium or large operating environment supporting Informatica. Minimum 4 years of SQL experience (develop, modify, troubleshoot, optimize complex queries and stored procedures). Deep understanding of relational/dimensional data modeling, data mapping design, integration, migration, and warehousing. Design and implementation of ETL solutions with performance optimization, including recovery, logging, and alerting mechanisms. Preferred: Java, J2EE, database building, SQL scripting, and management (DB2, SQL, PL/SQL, JDBC); mapping and workflow tools; Azure Data Factory. Industry experience in banking and insurance preferred. Required Skills: Informatica. Additional notes: Background Check: No; Drug Screen: No; This is a high PRIORITY requisition. This is a PROACTIVE requisition. Seniority level
Mid-Senior level Employment type
Full-time Job function
Other Industries: Software Development Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr