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

RideAlongNow, Inc.

No CDL Driver with own vehicle 5 or more passengers Job Job at RideAlongNow, Inc.

No CDL Driver with own vehicle 5 or more passengers JobRideAlong provides managed transportation services to schools and parents for daily school pick-up and drop-off, after school activities and sports. We are looking for drivers with their own vehicles that can fit... 

Georgia-Pacific

Environmental Health and Safety (EHS) Manager Job at Georgia-Pacific

 ..., Health and Safety Manager to lead and oversee our Augusta, GA corrugated facility. Reporting to the Director of Operations, the EHS Manager provides leadership and strategic direction by building a partnership with front-line leadership and collaborating with business... 

Midwest Logistic Systems

Midwest Logistics Systems Part-time Dedicated truck driver Job at Midwest Logistic Systems

Haul automotive parts in dry van trailers with newer trucks. Haul no-touch, mostly drop-and-hook freight. Work with onsite leaders and dispatch. Pay and bonus potential ~ Route and detention pay. ~$1,500 sign-on bonus for experienced drivers. Qualifications...

NEAT GEEKS LLC

Residential Cleaner Job at NEAT GEEKS LLC

NEAT GEEKS Independent Residential Cleaning Contractors We're not looking for average. We're looking for cleaners who take pride in delivering expert-level results. This is a long-term 1099 role. We do not deduct taxes or fees, every hour you work is paid in full...

Settlement Music School

Creative Arts Therapists | Kardon Center for Arts Therapy Job at Settlement Music School

Founded in 1908, Settlement Music School, a non-profit organization, is one of the largest community schools of the arts in the United...  ...Arts School.Settlement Music Schools Kardon Center for Arts Therapy is currently seeking part-time contracted creative arts therapists...