Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

SQL Server SSIS, SSRS Developer (with .net and IBM Datastage) (184 views)

Lincoln, NE
October 6, 2020

***** Direct Client Requirement*****                   

Title                       :  SQL Server SSIS, SSRS Developer (with .net and IBM Datastage)

Location               :  Lincoln,NE

Rate                      : DOE /If your experience and skills match call us immediately for submission

Duration               : 12 Months

Interview Type   : Skype or Phone

Work Status        : Successful applicants must be legally authorized to work in the U.S.

Job Type              : C2C,C2H, W2 ,

Experience         : 4 YEARS

Prefer W2          : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted

Description

MINIMUM QUALIFICATIONS:

Bachelor’s degree in computer science or a related field or related experience. Minimum of four years of experience related to the essential functions of the position. Any equivalent education and\or work experience may be substituted in order to meet the minimum qualifications of the position.

PREFERRED QUALIFICATIONS:

Experience with ETL framework and concepts, Datawarehousing concepts, IBM Datastage(mandatory),Microsoft SSIS, SSRS, database programming, complex SQL Server PL/SQL, Stored Procedures, Python scripting, SQL performance tuning, data modeling, ETL job scheduling, Windows batch scripting, execution of datawarehousing projects. Experience with Azure devops/Microsoft team foundation server is required. Experience in Microsoft Azure cloud data services is s plus.

Knowledge and Abilities:

KNOWLEDGE:

·         The entire software development lifecycle.

·         Writes advanced SQL including some query tuning.

·         Experience in the identification of data quality.

·         Experience designing and building complete ETL using IBM Datastage processes moving and transforming data for ODS, Staging, and Data Warehousing.

·         Utilize ad-hoc techniques to perform on-the-fly analysis of data.

·         Proficient in debugging data related production issues and deploying fixed code in production     environment.

·         Design, build and deploy effective IBM Datastage jobs.

·         Implement stored procedures and effectively query a database.

·         Identify and test for bugs and bottlenecks in the ETL solution.

·         Ensure the best possible performance and quality in the ETL packages.

·         Provide support and fix issues in the IBM Datastage ETL jobs.

·         Author and execute unit test scripts.

·         Established policies, procedures, practices of the Nebraska Department of Education.

·         Familiar with Azure Devops methodologies and have implemented at least one project using Azure Devops/or Microsoft TFS.

·         Working experience in cloud migration of data and implement services for data related processes using Microsoft Azure.

ABILITIES:

·         Optimize database systems for performance efficiency.

·         Have regular interaction with business team to understand the functional requirements and translate them into technical specification document and subsequently perform the coding of database and ETL artifacts.

·         Create ETL packages/jobs as per the technical requirements within strict timelines.

·         Troubleshoot datastage jobs and fixes the code issues as needed.

·         Analyze the required ETL packages for performance tuning and come up with solutions to improve the runtime.

·         Prepare design specifications and functional documentation for assigned database projects.

·         Analyze legacy and current systems and create technical documentation and source to target mapping document.

·         Perform space management and capacity planning for database systems.

·         Develop database tables and dictionaries.

·         Troubleshoot database related issues in a timely fashion.

·         Ensure data quality and integrity in databases.

·         Identify any issues related to database performance and provide corrective measures.

·         Create complex functions, scripts, stored procedures and triggers to support application development.

.         Eagerness to learn new tool/technologies quickly and start working immediately.

MINIMUM QUALIFICATIONS:

Bachelor’s degree in computer science or a related field or related experience. Minimum of four years of experience related to the essential functions of the position. Any equivalent education and\or work experience may be substituted in order to meet the minimum qualifications of the position.

PREFERRED QUALIFICATIONS:

Experience with complex SQL Server PL/SQL, Stored Procedures, ETL framework and concepts, Datawarehousing concepts, Microsoft SSIS, SSRS, IBM Datastage(optional), database programming, SQL performance tuning, data modeling, ETL job scheduling, Windows batch scripting, basic VB and Dot net programming skills, execution of datawarehousing projects. Experience with SSIS to Datastage migration preferred but not mandatory.

Knowledge and Abilities:

KNOWLEDGE:

·         The entire software development lifecycle.

·         Writes advanced SQL including some query tuning.

·         Experience in the identification of data quality.

·         Experience designing and building complete ETL/Microsoft SSIS/IBM Datastage processes moving and transforming data for ODS, Staging, and Data Warehousing.

·         Some Knowledge of C#/VB.NET a plus

·         Utilize ad-hoc techniques to perform on-the-fly analysis of data.

·         Proficient in how to deploy to and debug a production SSIS/IBM Datastage environment.

·         Design, build and deploy effective IBM Datastage/SSIS packages.

·         Implement stored procedures and effectively query a database.

·         Identify and test for bugs and bottlenecks in the ETL solution.

·         Ensure the best possible performance and quality in the ETL packages.

·         Provide support and fix issues in the ETL packages.

·         Author and execute unit test scripts.

·         Established policies, procedures, practices of the Nebraska Department of Education.

ABILITIES:

·         Optimize database systems for performance efficiency.

·         Have regular interaction with business team to understand the functional requirements and translate them into technical specification document and subsequently perform the coding of database and ETL artifacts.

·         Create ETL packages/jobs as per the technical requirements.

·         Troubleshoot SSIS packages and fixes the code issues as needed.

·         Analyze the required ETL packages for performance tuning and come up with solutions to improve the runtime.

·         Prepare design specifications and functional documentation for assigned database projects.

·         Analyze legacy and current systems and create technical documentation and source to target mapping document.

·         Perform space management and capacity planning for database systems.

·         Develop database tables and dictionaries.

·         Troubleshoot database related issues in a timely fashion.

·         Ensure data quality and integrity in databases.

·         Identify any issues related to database performance and provide corrective measures.

·         Create complex functions, scripts, stored procedures and triggers to support application development.

.         Eagerness to learn new tool/technologies quickly and start working immediately.

******Referral Bonus Available: Refer your friends or colleagues, get referral bonus******

Thanks
Vinay/Siva
vinayp@Sohanit.com/siva@sohanit.com
PH:402-241-9613/402-241-9606
Apply here or Please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

Position Keywords: ETL/Microsoft SSIS/IBM Datastage processes,IBM Datastage(mandatory),Microsoft SSIS, SSRS, database programming, complex SQL Server PL/SQL,

Pay Rate: DOE/If your experience and skills match call us immediately for submission

Job Duration: 12 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2367

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox