Integrations Lead/ Sr. Developer
Previous Job
Previous
Integrations Lead/ Sr. Developer
Ref No.: 18-28825
Location: Mahwah, New Jersey
Position Type:Direct Placement
Experience Level: 10 Years
Start Date: 05/14/2018
Role Integrations Lead/ Sr. Developer
Mandatory Technical / Functional Skills 10+ years experience in following technologies -
• SSIS Skillset
      o SQL Server set up and configuration
      o SQL job knowledge (job scheduling, dependencies)
      o SSIS knowledge in building scripts, packages, stored procedures, installations
      o SSIS Script tasks
     o C## experience
     o Data Modeling concepts (tables, columns, data types, table relationships)
     o Database knowledge (data types, data type conversions, joins, unions, etc…)
     o Query Profiling, Performance tuning
     o Troubleshooting experience including issue triaging, reporting and closing
     o FTP and SFTP
    o Deployment of SSIS components into various environments via Jenkins
    o TFS (TFSV, GIT) code repository (management, check in/check out, versioning, best practices)
• Fuse Skillset
     o JBoss Fuse (Camel) environment set up and configuration
     o Cron job knowledge (job scheduling, dependencies)
     o Java experience to write Camel routes
     o Experience with Multi-threading
     o Deployment of FUSE related components into various environments via Nexus repository and Jenkins
     o TFS (TFSV, GIT) code repository (management, check in/check out, versioning, best practices)
     o Fuse to Salesforce integration experience, extraction of DTOs (data translation objects)
     o Troubleshooting experience including issue triaging, reporting and closing
Roles and responsibility • Analysis of functional / technical requirements
• Define Technical Architecture and creater detailed technical design specification including Service specifications, Class Diagrams, Sequence Diagram, Data Models
• Define the project's technical architecture
• Define implementation / deployment model
• Define project/program specific design pattern, guidelines and checklist
• Review and approve the low level design produced by development team
• Ensure that the project development does not deviate from the agreed architecture principles
• Hands on with all the skillset 
Desirable Technical / Functional Skills • Knowledge of integration Architecture & Design Patterns
• Knowledge of API gateway – like Loopback framework
• SSIS/ SQL
• Good knowledge of Fuse ESB, WCF/SOAP