What are the responsibilities and job description for the Senior ETL (SSIS) Developer with .Net position at Central Point Partners?
*Per the client, No C2C's!*
Central Point Partners is currently interviewing candidates in the Columbus, Oh area for a large client.
Because this is a Contract to Hire position only GC’s and USC’s.
This position is Hybrid (2-3 Days remote/work from home)! Only candidates who are local to Columbus, Oh will be considered.
Senior ETL (SSIS) Developer with .Net
Notes from the manager
Support treasury applications
work coming down pipe = more apps added to team
use ETL a lot - SSIS
use a lot of technologies
ETL, SSIS, SQL Server
Experience with database skills - jobs taking too long to run, increase performance of queries, etc.
support role before
team now has 2 devs and 2 BSAs
work on multiple projects - app upgrades, getting data from different sources, cross impact projects that affect the team
who can work on existing technologies
60% support and 40% dev work - but can be flipped
servers not running, job issues, etc.
they are first line of defense for IT finance reporting segment
banking/FiServ is a nice to have
.NET - use some C# and .Net when comes do SSIS
python or scripting language would be helpful
use cloud computing power but work closely with AWS team
ETL/SSIS is target skills
.NET/C# - background regarding APIs would be helpful - previous .NET experience OK, doesn't have to be recent
get data from oracle, snowflake and azure data lake - any exposure to other DBs are good- but day in and day out work in SQL
Ideal candidate - 8 years of experience / tech lead / learn things quickly
JOB DESCRIPTION
Must Have
- Excellent communication skills
- Self-motivated, eager to learn different systems used at the client
- Ability to organize, clarify, and document ongoing knowledge and processes
- Understanding processes and procedures within a corporate environment and work with different stakeholders.
- General database knowledge (connectivity, performance issues, querying and troubleshooting)
- MS SQL, Oracle, Snowflake, Azure Data Lakes
- 5 year of experience in .NET and ETL (SSIS) development
- Using Visual Studio
- Manual and Automated Testing
- Source Control Procedures (Git)
- Deployment and Validation
Nice To Have
- Cloud Platform Computing
- AWS, Azure, Google Cloud Platform
- HPC Pack and Cluster Manager
- Job Scheduling Knowledge (Rocket Zena)
- Experience with Logging Frameworks (Splunk)
- Data Quality Testing and Tools (Infogix, Anomalo)
- Scripting and Automation (PowerShell)
JOB SUMMARY
This is a Contractor to Hire position in the IT Corporate Finance Reporting. We support Treasury applications. The candidate will support applications to make sure they run smoothly, and provide assistance related to data and infrastructure needs. And work on any enhancements or cross impact projects. Candidate should be able to learn new technologies and client applications quickly.
JOB DESCRIPTION
Provides technical and consultative support on complex technical matters. Analyzes, designs, and develops systems based upon user specifications. Provides technical assistance in solving hardware or software problems. Possesses an in-depth knowledge of technical tools available for systems development and support. Maintains and demonstrates knowledge of technical industry trends, particularly as they apply to the client. May assist with identifying training needs or with training of less experienced staff. May serve as Technical Lead for specific projects.
For more information about this opportunity, please contact Bill Hart at 614-352-3615 AND email your resume to bill.hart@centralpointpartners.com!
