• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 27th Feb 2024

Priority Technical Skills to Focus on

Experience with data migration projects using IBM DataStage. In-depth knowledge of database modelling techniques. Working experience in application database rewriting/redesigning and migrating data from legacy database. Experience with complex SQL Server PL/SQL, Stored Procedures, ETL framework and concepts, Data warehousing concepts, Cloud concepts, IBM DataStage, database programming, Azure DevOps, Azure SQL, SQL performance tuning, data modeling, ETL job scheduling, execution of data warehousing projects.

Knowledge and Abilities:
KNOWLEDGE:
·         Application database remodeling.
·         Writes advanced SQL including some query tuning.
·         Experience in the identification of data quality.
·         Experience in creating ETL jobs using IBM Datastage for data migration.
·         Utilize ad-hoc techniques to perform on-the-fly analysis of data.
·         Proficient in how to deploy to and debug a production IBM Datastage 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 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 fix 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 documentations 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.