Lead SQL/ETL/SSIS Developer Job at Mindlance, Charlotte, NC

MFkwNW4vYkVUSEJnVzNjU2QrM0tqQVN4NGc9PQ==
  • Mindlance
  • Charlotte, NC

Job Description

Please find details for this position below:

Client: Banking/Financial Industry

Title: Lead SQL/ETL/SSIS Developer

Location: Charlotte, NC – Hybrid Roles

Duration: 06+ Month (s) Contract, possibility to extend is not currently certain

Job Details:

Top Skills:

  • 7+ years of relational database engineering with SQL
  • 5+ years of SSIS experience
  • 3+ years of C#
  • Autosys scheduling
  • Agile

Preferred Qualifications:

  • Integrating CRM’s like Salesforce or MS Dynamics.
  • Cloud computing (Azure) Devops
  • Experience with alternative ETL tools like Informatica, in case the need arises
  • Python
  • Position is budgeted through end of year after a previous resource reached tenure. Additional need depends on the amount of additional projects they get.
  • Should understand how devops works, but will primarily work as SSIS and SQL developers. Helps if they have Python, PowerShell, other such technologies.

JOB DESCRIPTION:

  • Thorough understanding of DEVOPS tools like TFS/Azure Devops
  • Experience working with tools like Visio, DrawIO, etc.
  • Experience working with PowerShell and C#
  • Knowledge and familiarity with MSDYN data structures
  • Experience with cloud services a plus (Azure specifically)
  • Design and develop SQL Server Stored procedures, T-sql queries, views and functions
  • Experience working with SSIS packages with thorough understanding of importing data from multiple sources including files and databases
  • Analyze the requirement and develop strategic plan to import and transfer the data between source, staging and destination systems
  • Create release documents and support build and deployment process across different environments
  • Troubleshoot the ETL processes to identify any blockers or issues
  • Follow and maintain the standard practice for code depository and branching
  • Understanding of DevOps tools such as TFS/Azure DevOps, Jenkins
  • Overseeing overall systems testing including SIT and UAT.
  • Analyze complex business requirements and provide technical specifications
  • Providing support during off-hours/weekend during production deployment and UAT

Required Qualifications:

  • 7+ years of software engineering experience
  • 5+ years of hands-on experience in database design and development using SQL Server (2017 and higher)
  • 5+ years’ experience designing and optimizing complex SQL queries involving table joins and correlated sub-queries on large scale data tables
  • 5+ years of experience in SSIS packages
  • 5+ years of experience leading technical development teams
  • 5+ years of experience with different data sources such as RDBMS, JSON, XML and file data
  • 7+ year’s Relational Databases (SQL Server/Oracle) experience
  • Experience in C# to understand ,add/ modify script tasks within SSIS

Desired Qualifications:

  • Experience with other ETL tools
  • Experience in Azure Synapse, Fabric
  • Experience in creating automated test scripts
  • Experience in using GitHub CoPilot
  • Familiarity with Python, PowerShell
  • Experience in job scheduling tools such as AutoSys, SQL agent
  • Experience with cloud integrations, preferably with Microsoft Dynamics CRM clouds.

EEO:

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

Job Tags

Contract work, Weekend work,

Similar Jobs

International Leadership of Texas

Mandarin Chinese Teacher Job at International Leadership of Texas

 ...This role is for the 2025 -2026 school year Compensation package for certified teachers starting at $59,000 Compensation package for non-certified teachers starting at $56,000 Primary Purpose: Provide students with appropriate learning activities and experiences... 

Schulte Hospitality Group

Assistant General Manager - Staybridge Suites/Homewood Suites Napa Job at Schulte Hospitality Group

 ...Schulte Hospitality Group is seeking a dynamic, service-oriented Associate General Manager to join our team! SHG is an organization whose success is rooted in its service culture. Our mission is to exude hospitality, be respectful and authentic, prioritize the needs... 

BEPC Inc. - Business Excellence Professional Consulting

Sr. R&D Systems Engineer - Sequencing Technologies Job at BEPC Inc. - Business Excellence Professional Consulting

 ...BEPC, Inc. has an open position for a: Senior R&D Systems Engineer Sequencing Technologies in Pleasanton, CA!! W2 Contract 6 months with the possibility of extensions Pay and Benefits-$43-$47 an hour-Medical, Dental, Vision, Paid Life Insurance We are looking... 

Elsdon Group

Construction Superintendent Job at Elsdon Group

 ...seeking a seasoned Superintendent to oversee ground-up commercial construction projects. With a strong presence in the K-12, Municipal,...  ...looking to join a stable, reputable contractor with a strong pipeline of upcoming work in the Houston area. Candidates with only... 

Insight Global

Assembly Technician Job at Insight Global

MUST RELOCATE TO COLUMBUS MISSISSIPPI JOB DESCRIPTION One of our top aerospace clients is looking for Assembly Technicians to support several of their large scale programs. They will be responsible for performing complex and advanced fabrication and assembly of detailed...