Integration Lead Engineer - W2

Engineer and Integration Lead Hybrid – 2 days per week in the office in either Raleigh, NC, or Morristown, NJ 12+ Months Contract Job Description • • • All candidates must be local to, or willing to relocate to, Raleigh, NC, or Morristown, NJ, since this will be a hybrid position • • • Project Details: Responsibilities: • Design, develop, test, and deploy software solutions for Enterprise Fraud Technology, leveraging relevant technologies and programming languages. • Design and develop an Enterprise framework for SSIS development, creating MS SQL SSIS packages for ETL process/ data mapping to integrate the source system with Enterprise Fraud Technology and OFSAA applications. • Develop detailed architecture, system interface diagrams, data flows, and unit testing for end-to-end integration and follow enterprise standards for code reviews of ETL and SQL processes. • Participate in design and analysis sessions with business analysts, technical, cross-functional teams, and business users. • Develop data reconciliations and data quality controls with appropriate exception and error handling. • Develop migration scripts, SSIS packages, and jobs using enterprise scheduler (i.e., Control M) • Deploy ETL/ SSIS packages through standard change management procedures. • Should have experience in leading production deployments. Create production runbooks on SSIS packages for application monitoring and contribute to the team's knowledge base. • Support end-to-end SIT, UAT, Change Management, and Production go-live activities. • Should have experience in mitigating vulnerabilities in the application. • Interface with other support teams, such as network engineers, database administrators, to troubleshoot and support. • Troubleshoot and resolve issues promptly. • Execute database performance tuning and optimization. • Support System upgrades, patches, performance tuning, and continuously improve the performance and scalability of the application. Experience & Skills • A bachelor’s degree in business or a related field • 8 Years in Banking and Financial Services • 8 Years working in the data organization/projects • Detail-oriented and analytical • Strong data analysis skills • Knowledge of payments, BSA/AML, and Fraud systems is nice to have • MS SQL Server 2012, BI Development Studio, SQL Server Data Tools (SSDT), SQL Server 2017/2012 reporting/Tableau, Data Stage • Excellent oral and written communication skills