• Randstad
  • New York , NY
  • Information Technology
  • Full-Time
  • 334 W 39th St

bull Design, develop, maintain and support SSIS packages related to the extraction, transformation and loading (ETL) process. bull Be responsible for data profiling, source-target mappings, SSISSQL tunings and optimization. bull Conduct a consolidation and data cleansing of all data based collection activities. bull Understand the client data. bull Provide support and mentoring to data analysts. bull Expert SQL Server developer with 8+ years of experience, including relational database design TSQL stored procedures bull Experience in developing ETL processes using Microsoft SSIS (minimum 6 years of experience). Added advantage - SSRSSSAS or any reporting tools. bull Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. bull Should have experience in database design methodologies and able to provide efficient design solutions. bull Strong analytical skills are mandatory with experience in daily critical issue resolutions. bull Experienced working with large databases and DataMartrsquosdata warehouses. bull Ability to work independently and proactively. Requirements bull Proven record (6+ years) as an SSIS developer or any other ETL like Informatica, Ab Initio tools. bull Complex stored procedures experience. bull Strong relational database skills in both OLTP and data warehouse environments. bull Comfortable working with large data sets in large DBs. bull Experience with high availability requirement production software applications. bull Strong analytical and organizational skills. bull Strong verbal and written communication skills. bull Prior experience with Business Intelligence tools. bull Knowledge of SSAS and any BI reporting tools is a plus. bull Prior experience with Hadoop, Vertica, and AWS experience is a plus. bull Prior experience with cloud architectures AWS - S3 is a plus. bull Prior experience with Big Data topologies NoSQL, Hadoop,Spark is a plus bull Prior experience with MPP platforms Vertica, Teradata, MS ndash PDB, RedShift is a plus Equal Opportunity Employer Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
Associated topics: .net, application developer, architect, architecture, c, develop, lead, matlab, maven, senior

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...