Job Description :
Job Title: Data Warehouse Administrator
Location: US-NV-Carson City ( Local candidates only Welcome to Apply)
Duration: 8+ Months
State of Nevada Dept of Motor Vehicles.
Work will be 100% onsite and relocation to Carson City, NV will be required immediately if not currently local.
Responsibilities:
The Data Warehouse Administrator will support a data cleansing effort in preparation of a modernization/transformation effort.
Document changes and follow protocols established by Nevada DMV.
Participate in sessions for this data cleansing project. Work with different users/user groups to gather and document business rules.
Translate and transform business rules into workflows
Provide status reports as required by DMV personnel
Analyze, design, and develop strategies to efficiently validate if the data conforms to business rules.
Queue exceptions with adequate information for business users to address and remedy missing/invalid data
Qualifications:
The Data Warehouse Administrator Requirements include:
Must have a Bachelor's degree in computer science, or any other equivalent degree with a minimum of seven (7) years of programming experience or an equivalent combination of education and experience.
Ideal candidate will have many years' experience in Informatica Data Quality V10, or similar, with strong SQL background
Demonstrated ability to translate and transform business requirements/rules into workflows in IDQ
Must have experience working with Java Transformation
Must be able to create scripts as needed to schedule and run tasks
Must have experience working in Medium to Large scale data quality environments.
Must possess skills in developing strategies to implementing data quality checks in IDQ
Must have strong knowledge of Informatica Data Quality V10.x and /Power Center
Must have experience working in a team based development environment.
Excellent at creating stored procedures, functions, packages, database triggers and other database objects using SQL
Expertise in troubleshooting and debugging skills
Expertise in performance tuning to improve execution times
Expertise in designing conceptual, logical and physical designs for various database objects
Experience in writing complex SQL queries in a SQL Server environment.
Must possess strong knowledge of relational database concepts
Must have experience and skills to provide adequate information for users to understand and address exception
Excellent analytical and communication skills required to effectively work in the field of applications development and maintenance.
Excellent at Understanding Integration Technologies and Domains and work flows.
Must have good communication, documentation and user requirement gathering skills.