Published date Posted on Indeed on May 13, 2022 (14 d ago)

Requirements and skills

  • 7+ years of experience developing Microsoft SSIS-based solutions.
  • Expected to serve in a lead technical position, capable of working on their own with minimal guidance
  • Demonstrated expertise in developing MS SQL SSIS packages that automate data integration processes involving multiple data sources.
  • Strong experience developing & troubleshooting complex MS SQL code including stored procedures, views, functions, triggers, etc.
  • Demonstrated understanding of error handling techniques in MS SQL code and Microsoft SSIS solutions.
  • Experience in performance tuning slow and inefficient MS SQL code utilizing various industry tools and methodologies.
  • Very strong analytical skills with the ability to analyze disparate datasets and produce an efficient and scalable solutions

Responsibilities:

  • Perform analysis of the existing agency/program's data integration solutions leveraged by the agency Early Intervention program documenting as-is specifications
  • Review and understand data gap analyses and downstream impact analyses
  • Design, implement, and test replacement data integration solutions supporting the transition to the New York State Early Intervention HUB system, including differential data processing from full data sets
  • Design, implement and test MS SQL code including stored procedures, views, functions, triggers, etc.
  • Migrate and adapt existing Oracle database objects to MS SQL equivalents
  • Remediate the existing SQL database code for all agency Early Intervention systems dependent upon program data integration
  • Perform unit, system, and integration testing of all developed code and objects
  • Fully support the documentation of the replacement data integration solutions, providing data dictionaries, topology diagrams, and operational guides

Job Type: Full-time

Schedule:

  • 8 hour shift

Experience:

  • Informatica: 1 year (Preferred)
  • SQL: 1 year (Preferred)
  • Data warehouse: 1 year (Preferred)

Work Location: Remote


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Adtalem Global Education Adtalem Global Education |
|
Yesterday

Opportunity at a Glance:The Sr. Analyst, Business Intelliggence is responsible for successfully managing, advancing and delivering business intelligence solutions and services to meet the business objectives of the organization's institutions with minimal.

Press Ganey Associates Press Ganey Associates |
Today

About Press Ganey:Press Ganey pioneered the health care performance improvement movement 35 years ago. Today Press Ganey offers an integrated suite of solutions that enable enterprise transformation across the patient journey. Delivered through a cutting-edge.

Affinaquest (formerly SSB) Affinaquest (formerly SSB)... |
Today

Description:Implementation ConsultantThrough market-leading data warehouse & analytics and empowering Constituent Relationship Management (CRM) technology, Affinaquest (AQ) is the market leader in institutional advancement, fan engagement, and nonprofit.

Tyler Technologies Tyler Technologies |
Today

Tyler Technologies is currently seeking a Jr. Data Application Engineer to join their US Direct / NIC Division to support their Recreation Dynamics product. This is a remote position. As our Jr. Data Application Engineer, you will focus on supporting.

iconvergence iconvergence |
Today

ResponsibilitiesWork with project owners/stakeholders to ensure delivery schedules are on track and issues are raised appropriately and timelyManage resource schedules to ensure delivery aligns with scheduled release datesConduct regular business reviews.

Adept Consultants Adept Consultants |
Today

Title: SQL Developer (MS SQL Server) - SSIS Packages - Flexi supportLocation: RemoteDuration: 6+ MonthsJob Description: Candidate with min 5+ years in IT with strong SQL coding skills (MS SQL Server) and SSIS package hands-on knowledge (ability to develop,.