Robert Half • Pittsburgh, PA 15222
Job #2691317517
Description
We are seeking a Data/Information Architect for our local client. This role will involve the design and development of SQL Server stored procedures, functions, views and triggers to be used during the ETL process. Moreover, the successful candidate will be tasked with designing and developing SSIS/SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing.
Design and develop SQL Server stored procedures, functions, views and triggers for the ETL process
Design and develop SSIS/SQL ETL solutions to acquire and prepare data from various upstream systems
Build data transformations with SSIS, including importing data from files and moving data from one database platform to another
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
Design, implement and maintain database objects (tables, views, indexes, etc.) and database security
Gain proficiency with ETL tools such as Microsoft SSIS
Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
Test and prepare ETL processes for deployment to production and non-production environments
Support system and acceptance testing, including the development or refinement of test plans
Use skills in TSQL, Data Modeling, SQL, SSIS Development, .Net/Java, and Stored procedures.
Requirements - Role requires a minimum of 5 years of experience as a Data/Information Architect.
Proficiency in .NET and Java is essential.
Experience with SQL Server Integration Services (SSIS) is required.
Knowledge of Transact-SQL (T-SQL) is a must.
Strong SQL query writing skills are necessary.
Familiarity with SQL Server Management Studio (SSMS) is required. Technology Doesn't Change the World, People Do.®
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (~~~) and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit ~~~ for more information.
© 2024 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use (https:///~~~/us/en/terms) .
Robert Half • Pittsburgh, PA 15222 • 3 Days Ago
Robert Half • Pittsburgh, PA 15222 • 3 Days Ago
Robert Half • Homestead, PA 15120 • Yesterday
Robert Half • Monroeville, PA 15146 • Yesterday
ANSYS, Inc. • Canonsburg, PA 15317 • Today
Accenture • Pittsburgh, PA 15222 • Mar 7
Amentum • Pittsburgh, PA 15222 • May 10
American Heart Association • Pittsburgh, PA 15222 • 8 Days Ago