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

Similar Jobs