Job Description :
Location: Dublin, OH (Columbus area)

Duration: 6 months C2H
Interview: They want F2F interviews
Must have excellent communication skills.

SQL Developer

Job Description:
Job Title: SSIS Developer (Journeyman - Pharma Insights team)
Department is starting a new team that focuses on building products for their manufacturers, data in nature.
Will take clinical data sets, build extract of data, and supply to Pharma manufacturers.
Python and Redshift and Tableau experience.
Will consider either a Sr. Engineer with 8-10 years of experience or (junior) Engineer with 3-5 years of experience to lead migration from SQL Server and SSIS to Python and Redshift.
Good data analytics experience, clinical data experience.

Software Engineering is responsible for designing, developing, implementing and supporting applications, systems and IT products required to achieve the company''s business objectives.
Demonstrates knowledge of software development techniques and fluency in software languages and application programming interfaces.
Demonstrates general understanding of hardware/software platforms including but not limited to operating systems, databases, application servers, web servers and integration technologies.
Plans and executes system implementations that ensure success and minimize risk of system outages or other negative production impacts.
Demonstrates conceptual knowledge of architecture standards and database and operating systems.
Demonstrates problem solving ability that allows for effective and timely resolution of system issues including but not limited to production outages.
Analyzes production system operations using tools such as monitoring, capacity analysis and outage root cause analysis to identify and drive change that ensures continuous improvement in system stability and performance.
Demonstrates knowledge of software development, life cycle, modeling of business processes, application design patterns, business/functional documents. Estimates to high level business requirements and provide options analysis.

Job Details:
SSIS development
Implementation end to end packages that must include variables, parameters, expressions, transactions, Script task, Script component using C#
Fact ETL, Dimension ETL and advanced including slow changing dimensions and late arrivals
Dimension design
Developing expressions
Stored procedures
User-Defined Functions and Types
Error handling
Query Performance Tuning
Files, File groups, and Integrity

Bachelor’s degree in Computer Science, Math, Engineering or equivalent degree required. Master’s Degree in Computer Science, Math or Engineering preferred.
2-3 years working in the Microsoft stack, including experience using C#, .NET 3.5/4.0
MS Visual Studio 2010 or higher
MS SQL Server 2008 or higher, ETL, SSRS, T-SQL
MS .NET Framework 3.5 or higher
CNET, VB.NET, ASP.NET, JavaScript, HTML 3/4/5, CSS
Demonstrate a solid understanding of database design principles as well as Multi-dimensional databases
Agile software development methodologies
Please email your resumes to gayatri dot n at pridevel dot com