| Solid SQL developer at Remote, Remote, USA |
| Email: [email protected] |
| From: Shubham Singh, Tek Inspirations LLC [email protected] Reply to: [email protected] Hello, I'm Shubham from TEK Inspirations We have a requirement for you and the details are as follows Please review the Job specifications below and let me know if interested. Please confirm this email that you received it also send me your DL, Visa , 4 digit SSN, education details and LinkedIn profile as well. Title Solid SQL developer (multiple openings) Duration: 6 month contract to hire must be open to converting to perm after 6 months Location: Hybrid Skype Need 10 min availability for video call with PV I need a SOLID SQL developer. 10 yrs experience. The personwe are backfilling had the following: Responsibilities: Converted hivequeries, mapping tables from Hive to SQL Server, identifying logic for eachtable and columns and creating it in SQL Server TSQLDevelopment: stored procedures, views, tables, triggers,functions, security, encryption, CTE etc. SSRS reportswere created based on requirements SSIS packagesto do ETL and apply business rules and requirements PerformanceTuning: SQL profiler / Extended events, Indexing, query tuning,monitoring and optimization Unittesting, Code review, bug fixing for defects created by QA and foundwhile unit testing. Automation ofscripts for unit testing and regression testing Used Agile methodologies.Daily status meetings, scrum calls, refinement session, 2 weeks sprints Collaborationtools: MS Teams, Skype Please send candidates local to the locations below and havefinancial industry background. Please do not send candidates that werealready presented previously The roles on my team will be more SQL databasedevelopment, SSRS reports and some ETL/batch processing work.We are migrating AGI (Allianz) applications as a lift and shiftexercise for most part. The candidate is expected to build datareconciliation automations, make necessary code changes to the processesor SSRS reports to work in and partner with AGI SMEs for UAT and paralleltesting. This role will require very little .net development, butknowledge of Perl will be helpful. Asset Management industry Work can be 100% remote but thecandidate should resides in the tri-state area, NYC, Windsor, CT, orAtlanta, GA to go onsite from time to time! (Can be within a commutabledistance up to 2-3 hour drive) Strong SQL database developmentskills Investment Management backgroundis strongly required! Required: BS Degree in Computer Science or similar curriculum. 10 years of experience for the Senior roles. Relational database development experience is required, includingstrong database design, implementation, SQL query skills. Microsoft SQL Serveris preferred (MS SQL 2019/2016/2012). Data warehouse experience is a plus. Microsoft Development tools, including TFS, C#.NET, and/or ASP.NETMVC (4 or newer is a plus). Experience with Web development tools including HTML5, Web API,JavaScript, jQuery, LINQ, CSS, Kendo UI/Telerik, MVC. Experience supporting job processing streams and schedulingenvironment is required. Experience with Python, Power BI, Microsoft Azure Cloud Technologyis a plus. Experience with Microsoft SQL Server Reporting Services is desired Experience working in an Agile scrum development environment isdesired but not required Experience developing financial applications and understandingfinancial concepts are desired. Experience supporting and developing applications for Equity orFund of Funds investment groups including trading systems, trade order entrysystems, decision support portfolio management systems, securities databases,financial accounting systems and/or databases is a strong plus. Responsibilities: This candidate will be involved in implementation of longer-termproject as well as smaller project tasks. The ability to multi-task isessential. The candidate will need to be able to work independently andwithin a small team. The candidate is expected to build a strong rapport with theinvestment teams, operations personnel and information technology team members. The ideal candidate must be flexible and have strong verbal andwritten communication skills to facilitate prompt problem resolution. This role includes business day user support for applicationsdeveloped and supported by our team. The ideal candidate will be able toquickly understand how each application functions in order to troubleshootissues, determine appropriate resolution and communicate resolution clearlywith our customer base which includes portfolio managers, investmentprofessionals and operations staff. This role involves being included in an overnight processingsupport rotation to support processes loading financial information overnightthat is required for the start of the business day. The candidate would be oncall on a periodic rotation basis. Regards!! Shubham Singh Technical Recruiter| IT Healthcare & Informatics || Email: [email protected] Keywords: csharp quality analyst user interface business intelligence information technology golang microsoft Connecticut Georgia |
| [email protected] View all |
| Thu Jan 26 12:50:00 UTC 2023 |