You haven't searched anything yet.
This role is on-site in Pittsburgh. Candidates must be local to the greater Pittsburgh region.
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.
Responsibilities:
• 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.
• 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.
Contractor
$129k-157k (estimate)
05/30/2024
06/27/2024
roberthalf.com
Menlo Park, CA
>50,000
The job skills required for SQL Developer include SQL, Data Warehouse, etc. Having related job skills and expertise will give you an advantage when applying to be a SQL Developer. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by SQL Developer. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for SQL Developer positions, which can be used as a reference in future career path planning. As a SQL Developer, it can be promoted into senior positions as a Database Engineer V that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary SQL Developer. You can explore the career advancement for a SQL Developer below and select your interested title to get hiring information.