This is for TRS – teachers retirement services. Largest pension fund here for all the teachers. They keep consultants for very long term and renewals, we have many there. They want someone close to NY/NJ area, requires face to face. Good comm. Rate is $60/hr
Main things are: SQL 2012/2014, SSIS, SSRS. ETL, T-SQL, Data Modeling. Also - Data cleansing, Unit Testing, has designed / developed reusable software components. DB2 to SQL Server = migration experience, from an older platform is a plus. Most important - straight Sql ( not pl/sql etc.), SSIS (ETLs, Migrations are a plus). Moving from DB2 to SQL. Trillium is a nice plus Needs ETL, migration, data modeling Full description: This position is for a Senior SQL Server ETL Developer who can work independently to develop and test very complex data cleansing scripts, SSIS data migration/conversion packages, SSIS Data Bridging programs and SSRS reports in support of a multi-phase legacy system replacement effort. The developer is expected to bring SQL Server development expertise and participate in design sessions with application engineers, ETL designers, data analysts and Quality Assurance resources. The developer will also be expected to perform advanced, in-depth analysis of database models, data integrity issues and programming requirements. KNOWLEDGE, SKILLS AND ABILITIES Design, Develop and Deploy SSIS Packages Design complex ETL using loop containers and data transformation tasks Write complex T-SQL queries and also able to do data cleansing writing the same Provide expert technical feedback to functional spec designers / business analysts Tuning T-SQL queries to improve performance Develop complex program logic using T-SQL Lead and make design decisions to create simple, elegant and re-usable software components as a part of larger enterprise application framework Demonstrated skill in understanding relational table design and applying optimized indexes Detailed knowledge of Data Modeling, both relational and dimensional Strong grasp of ETL protocols Strong analytical and data management skills Exposure to Data Profiling Best Practices Conduct extremely thorough Unit Testing that yields very low defect code Develop reports in SQL Server Reporting Services Experience in Data Modeling and Data Analysis in MS SQL Server 2012/2008 Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution Analyze & translate functional specifications & change requests into technical specifications. Excellent written and verbal communication skills Experience with legacy data migrations is greatly preferred Experience with public retirement systems is also preferred Experience with DB2 legacy systems is a plus Advanced analytical and problem-solving ability is required for this position EDUCATION AND EXPERIENCE Bachelor’s degree in the field of computer science or similar A minimum of 8 years’ development experience with MS SQL Server, SSIS, SSRS is required Kind Regards *Fazal Mahmood* *Aspire Systems Inc.* *Certified Minority Owned Business Enterprise (MBE) * *E-Verified Approved Employer* *Four Time Award Winner ( 2009 & 2010 & 2011 & 2012) Best of Danbury Award* *Approved Inc. 500 Company* *Corp Office:* *36 Mill Plain Road, **Suite # 16, Danbury, CT 06811* *Ph : **203 778 9992* *Fax : 203 798 0060 <203%20798%200060>* *Email: **fa...@aspiresystem.com <a...@aspiresystem.com>* *Yahoo IM*:* fazalmrecruiter* *URL: **www.aspiresystem.com <http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://www.aspiresystem.com>* [image: Signature_Asp] [image: https://mail.google.com/mail/u/0/images/cleardot.gif] -- You received this message because you are subscribed to the Google Groups "java-core" group. To unsubscribe from this group and stop receiving emails from it, send an email to java-core+unsubscr...@googlegroups.com. To post to this group, send an email to java-core@googlegroups.com. Visit this group at https://groups.google.com/group/java-core. For more options, visit https://groups.google.com/d/optout.
