• 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

·         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.