Datawarehouse/ETL Analyst
- Location
- Tumwater, WA
- Listed
- Yesterday
About the role
- Position: ETL Analyst
- Location: Tumwater, WA
- ClienDirect Client
- Duration: 3+ Months
Duties
- Participate in project team meetings and work closely with the data warehouse administrator, ETL staff, data modelers, database administrators, support analysts, report writers, and the data warehouse project manager to create ETL routines. Creating ETL routines includes writing the code that creates the transformations and processes that move data from the specified sources, transform it as required and write it into the data mart. Client requirements and database design specifications will be provided by WSDOT staff.
- Test target data structures to ensure that all works as designed.
- Verify identified data sources to ensure that the needed data can be properly provided.
- Write technical documentation of ETL routines to explain how the routines operate to meet requirements and design specifications.
- Provide technical assistance to write complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines.
- Assist in troubleshooting data loading and data warehouse performance issues.
Qualifications & Requirements
Required Skills
- Minimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center.
- Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes
- Minimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 r2 software tools to administer and/or manage SQL Server databases.
- Minimum 5 years of experience working with large organizations (over 1000 employees).
- Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development
Desired Skils
- Understanding of database modeling and design principles and ability to use a data model diagram.
- Experience using PowerExchange for Mainframe ADABAS.
- Tuning and optimizing SQL Server databases.
- Performing mainframe-to-server automation, bulk copy and FTP download.
- Programming in.Net. Or COBOL and/or Natural running on an MVS/zOS platform.
Additional Information
All your information will be kept confidential according to EEO guidelines.
About the Company
Infojini Consulting is a full service IT consulting, services, and staffing firm with offices in Edison, NJ.
Infojini Consulting is recognized as one of the fastest growing IT services and software development Companies. With a partnership of all major technology vendors, Infojini Consulting has built a strong Government and commercial customer base including fortune 100 companies and most state and federal agencies such as State of North Carolina, State of South Carolina, State of Maryland, State of California, State of Pennsylvania, State of Virginia, State of Washington and many others.
Equal opportunity and legal notices
Infojini Consulting is an equal opportunity employer and considers all qualified individuals for employment irrespective of their race, gender, age, color, sexual orientation. We offer an excellent compensation package
From Infojini Inc.'s careers page, first listed on Rolev.ai on November 8, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Datawarehouse/ETL Analyst role at Infojini Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Common questions
Where is the Datawarehouse/ETL Analyst job at Infojini Inc. located?
This Datawarehouse/ETL Analyst position at Infojini Inc. is located in Tumwater, WA. Always check Infojini Inc.'s application page for specific state eligibility or relocation policies.
How do I apply for the Datawarehouse/ETL Analyst position at Infojini Inc.?
This listing links directly to Infojini Inc.'s SmartRecruiters application page. You can apply directly on Infojini Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.