Previous Job
SSIS/SQL Developer
Ref No.: 18-05212
Location: Plano, Texas
Here's the job description for your review:

Job Title: SSIS/SQL Developer
Duration: 6 Months Right-to-hire
Location: Plano, TX

Contract To Perm, FTE eligible candidates Only, NO C2C

Job Description:
  • Teams wants to ensure that the person has sufficient .Net experience as well to work in a cross-functional team.
  • For the requisition, we need deeper SQL 2016 database and SSIS design, development, and deployment experience.
  • This person will be supporting a complex solution.
  • As a Data Integration Lead you will work closely with product owners, architects, developers, and analysts in cross-functional teams to create and deliver innovative payment products and services in a dynamic IT environment.
  • This individual will lead the design and development of data integration solutions involving database and data warehouse systems with internal and external systems. Extensive experience designing, developing, and maintaining data integration and reporting solutions on the Microsoft SQL Server technology stacks.
  • Experience with various data acquisition and integration technologies flat and fixed width files, XML, Json documents, APIs, and web services.
  • Experience with Business Intelligence Markup Language (Biml) and Varigence/Mist or Biml Studio is preferred.

Duties and Responsibilities:
  • Translate business requirements and technical designs into well-developed solutions that meet business goals defined by business and IT management.
  • Collaborates with all stakeholders to understand business processes as they relate to data sources, transformation needs and quality rules; performs source data analysis and data profiling.
  • Collaborates with Data Architect and Information Architect on data and metadata models as well as data integration strategies, patterns, standards, and best practices.
  • Design, develop, test, deploy, and maintain data integration solution using Microsoft technologies, including SQL Server and SQL Server Integration Services.
  • Design and development focus includes but is not limited to: dimensional data model design, ETL frameworks and processing, metadata management, operational data integration, master data management and data quality, data auditing and profiling, and business intelligence reporting solutions.
  • Continually test and validate data repositories; including data accuracy, data quality, and performance
  • Perform custom, ad-hoc data analysis and reporting based on stakeholder requests
  • Manage integration services configuration, subscriptions and security.
  • Debug and troubleshoot system performance and data quality issues.
  • Applies company methodology and ensures alignment of data integration solutions with Data Architecture and development standards.
  • Provide technical support for systems in production, including troubleshooting and configuration management.
  • Provide technical assistance and cross training to other team members.
  • Develop and maintain data mapping and transformation documents; maintain system documentation.

Required Skills:
  • Bachelor's degree or equivalent training or work experience.
  • 7+ years of experience designing, developing, and maintaining data integration and reporting solutions on the MSFT technology stack.
  • 5+ years of experience in the financial industry
  • Requires hands on with SQL Server 2012+ and SQL Server Integration Services (SSIS).
  • Experience with SQL Server 2016 and/or Azure SQL is preferred.
  • Experience with BIML and Varigence/Mist is preferred
  • Experience with NoSQL databases (DocumentDB, Cosmos DB) is preferred.
  • Experience with WinSCP and PGP tools is preferred.
  • Deep experience with various data acquisition and integration technologies.
  • Provide training and technical support for systems in production, including troubleshooting and configuration management.
  • Must be knowledgeable in software development lifecycles/methodologies, Experience with Visual Studio and TFS is preferred.
  • A strategic and creative thinker with proven analytical and problem-solving capabilities; demonstrate ability to investigate complex issues and make informed decisions and recommendations.
  • Experience presenting to and influencing across an organization or team.
  • Excellent communication skills, both written and verbal, and a passion for working in highly collaborative environments.