Senior Software Developers
Analyze requirements/User stories at the business meetings and strategize the impact of requirements on different applications. Participate in discussion with business teams for the minor and major enhancements, translating the business requirements into Functional requirement specification (FRS) document and maintain the document in Confluence. Understanding of the of the existing data provided my vendors in Flat Files, Web service response data and IBM DB2 data to identify the functional and business rules. Design the Database objects for data Staging Layer, Data Integration Layer and Semantic Layer within the database. Create Conceptual Data Model for the application using Visio and CA Erwin Data modeler. Develop data quality Components using Microsoft data quality services for upstream. Source data cleansing and create source reference data matching algorithms by using the matching rules defined by the business, also data validation, data profiling and data auditing activities to ensure high quality of data. Build custom framework including frameworks called Automated Ingestion and Integration Framework (AIIF) and Data Quality Framework (DQF) for Data Ingestion, Integration and Quality to build Guidewire Policy Center stage tables on SQL Server database based on data model analysis. Develop programs using Guidewire, Informatica, ETL, Oracle, SSIS, SSRS and SQL Server. Build custom framework including frameworks called Automated Ingestion and Integration Framework (AIIF) and Data Quality Framework (DQF) for Data Ingestion, Integration and Quality using Informatica and Procedural SQL to build SQL server stage tables on SQL Server database based on data model analysis. Develop programs using SSIS to connect to the Webservice and parse the payment response data into SQL server tables and generate a report to identify the missing/pending payments from Guidewire billing center to process one system and develop PL/SQL. Develop the ETL code to generate the xml files with HTML tagging to generate the email notifications to all the plan participant and plan sponsors and sending the xml files to AFID, Broad ridge and AFPOD applications using JMS connectivity. Develop reusable stored procedure to generate the email list for all the Plan advisors and Third party administrator and pivot the data using XPath. Develop informatica workflows to establish the JMS connection between informatica and JMS to transfer the xml files.
Requirements: Bachelor’s Degree or foreign degree equivalent in Computer Science, Computer Information Systems, Computer Applications, Information Technology, Planning or Engineering and one year’s experience in position or one year’s experience in IT field (or Three Year Diploma or foreign degree equivalent and three years’ experience).
Special requirements: Experience with Guidewire, Informatica, ETL, Oracle, SSIS, SSRS and SQL Server. Travel to various unanticipated client sites required. May reside anywhere in the United States.
Any Applicant who is interested in this position may apply by regular mail (including Reference Number 13729) to:
Mr. Gordon Drijver
1001 East Palm Avenue
Tampa, FL 33605