Job TitlePreferred:• Experience extracting business rules from the existing legacy code.• Experience with Data Quality/Profiling tools.• Experience with Data Warehouses/Data Marts.• Experience with SQL Server Integration Services (SSIS)• Prior experience working in a pension system, preferably New York State or New York City pension systemMandatory:• Excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.• Strong SQL knowledge working with complex queries and stored procedures.• Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NET• Proficiency in SSRS reports’ development and administration.• Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team’s methodology.• Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.• Proficiency in mainframe applications encompassing COBOL and CICS.• Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.