Job Title | Sr. SQL Developer |
Project Location | NYC, NY |
Duration | 12+ Months contract |
Interview Mode: Phone + F2F
Visa: Any
Job Description:
POSITION SUMMARY
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.
Thanks & Regards,
Udbhav Mathur
Talent Acquisition Specialist
Email:- umathur@tekshapers.com
Gtalk: udbhav.intime
Tekshapers Inc. – WMBE Firm
1441 E. Maple Rd, Suite # 301, Troy, MI 48083
Certification: WMBE Certified | E-Verified Company | ISO 9001:2008
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment