Software Engineer 3

Tri-Com Consulting Group; East Hartford (CT); On-site; USD 110,000 - 140,000; Full time

Job summary

Tri-Com Consulting Group is seeking a senior data integration engineer for a 1-year contract in the East Hartford, CT area. The role focuses on SQL Server 2014–2022 development, ETL design, data migration, and data cleansing across environments using SSIS and related tools.

You will design tables, indexes, XML schemas, and implement performance tuning, data validation, and deployment automation while collaborating with business analysts and developers to ensure accurate data migration and timely

Qualifications

• Ten or more years of development experience with SQL Server 2014–2022.
• Experience designing tables, indexes, and foreign keys with appropriate data types.
• Advanced SQL and T-SQL development; complex queries, stored procedures, triggers, UDFs.
• ETL concepts; experience building ETL processes; SSIS a plus.
• Knowledge of XML schemas, XML data storage and transformation; legacy data conversion.
• Performance tuning: query/index/execution plan analysis and troubleshooting.
• Data migration, extraction, validation, cleansing, and reconciliation.
• Experience with deployment automation and data management documentation.

Responsibilities

• Design and build ETL processes and data extractors/loaders.
• Migrate and validate data, cleanse data, and reconcile across environments.
• Create and maintain technical documentation and status reports.
• Provide management-level statistics on data migration progress and issues.
• Investigate defects and rectify ETL issues; collaborate with developers and analysts.

Skills

SQL Server

T-SQL

ETL concepts

Data modeling

Data migration

XML data transformation

XML schemas

Database performance tuning

Stored procedures

Data cleansing

SSIS

RedGate tools

Microsoft Visual Studio

Tools

SSIS

RedGate

Microsoft Visual Studio

XML tooling

Job description

Duration: 1 Year Contract w/ extensions possible

Core Technical Skills:

• 10+ years of experience with SQL Server ,must include version 2014 through 2022.
• Knowledge and experience of database design& data modeling.
• Familiarity with tools such as Microsoft Visio similar data modeling tools.
• Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
• Significant experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and user-defined functions.
• Must demonstrate knowledge of ETL (Extract-Transform-Load) concepts.
• Experience designing and building ETL Processes. Experience working with SSIS is a plus.
• Has good knowledge / technical expertise in data migration, including data extraction, data validation and cleansing processes / methodology.
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
• XML knowledge is required for legacy data conversion into XML-based structures.
• Knowledge and experience in performance tuning techniques: Query optimization, Index tuning, Execution plan analysis, and Database performance troubleshooting.
• Researching and troubleshooting data inconsistencies, scripting solutions to fix production data issues.
• Experience with RedGate tools to manage database objects and deployment to the various environments, preferred.
• Special consideration will be given to candidates with working knowledge of and experience using Microsoft Visual Studio.

Soft Skills:

• Strong analytical and problem-solving skills.
• Ability to effectively manage time, prioritize tasks, and have a basic understanding of project management.
• Excellent verbal communication skills to explain and transfer knowledge both informally and at design and code review meetings.
• Excellent written communication skills to prepare regular periodic status reports and documentation.
• Knowledge and experience of Microsoft Office Tools.

Minimum Qualifications

The minimum skills and experience levels required for a candidate to be considered for this position include:

• Minimum ten (10) years of development experience coding applications using SQL Server 2014 through 2022.
• Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
• Knowledge and experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and user-defined functions.
• Perform field mapping(mapping between the source and target structure with data cleansing, if necessary).
• Define the migration process (automated and manual).
• Develop data extractors and loaders.
• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data.
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
• XML knowledge is required for legacy data conversion into XML-based structures.
• Knowledge and experience in performance tuning techniques.
• Manage the data conversion process and data push process to the various environments.
• Create and maintain technical documentation.
• Provide management level statistics and reports to monitor data migration progress.
• Investigate, analyze and document reported defects.
• Investigate and rectify technical issues within the ETL process.
• Proven ability to work independently with minimal supervision.
• Ability to work well with a team of developers and business analysts.