Senior Middleware Architect
Martin Marietta
Raleigh, NC
- Expired: February 16, 2023. Applications are no longer accepted.
Description
Position Summary
The role of Senior Middleware Architect will design, develop and deploy ETL software, and reports needed to support a variety of business needs. This position requires extensive work with T-SQL and PL/SQL in an SQL Server and Oracle database environments. In addition, this person must be able to work independently or within small teams.
Requirements
Minimum Education and Experience
Knowledge, Skills and Abilities
Preferred Skills
Equal Opportunity Employer/Veterans/Disabled
Position Summary
The role of Senior Middleware Architect will design, develop and deploy ETL software, and reports needed to support a variety of business needs. This position requires extensive work with T-SQL and PL/SQL in an SQL Server and Oracle database environments. In addition, this person must be able to work independently or within small teams.
Requirements
- Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and data distribution.
- Design, develop, test and support programs and services using Visual Studio, Microsoft .NET, C#.
- Design and develop SSIS Packages
- Design and develop SSRS Reports
- Build database solutions on prem and in Azure cloud.
- Write complex SQL statements, procedures, and packages in both Oracle and Sql Server databases.
- Gather requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users.
- Maintain and improve already existing processes.
- Create technical specification documents.
- Unit tests and regression tests software solutions
Minimum Education and Experience
- Bachelor's degree in Computer Science / MIS or equivalent experience required.
- Master's degree in a related discipline is preferred.
Knowledge, Skills and Abilities
- 8+ years of experience using Microsoft Technologies (SQL Server, Visual Studio)
- 8+ years of experience using SQL Server Reporting Services (SSRS).
- 8+ years of experience using SQL Server Integration Services (SSIS).
- 8+ years of experience writing stored procedures, packages, functions, creating tables, indexes and views in both Microsoft Transact-SQL and within Oracle PL/SQL
- Experience within Microsoft C# .NET development of windows forms, window services, restful services, and batch programs
- Experience with application integration using ETL, middleware, APIs, REST web services.
- Experience with scripting languages such as PowerShell
- Must have ability to tune and optimize queries, packages, and process for overall performance.
- Must have the ability to problem solve, troubleshoot, be attentive to detail, and understand implications for the business.
- Ability to work independently, or in groups, while maintaining a courteous attitude when dealing with customers and users.
- Ability, and willingness, to complete several concurrent tasks in a fast-paced, detail-oriented, multi-tasking environment.
- Ability to set objectives, manage project timelines and see projects to completion.
- Ability to explain technical terms in everyday language.
- Continually updates skills and knowledge.
- Strong analytical skills and the ability to learn new technologies.
- Adherence to and compliance with the Martin Marietta's shared values and Code of Ethics.
Preferred Skills
- Proficient understanding of code versioning tools, preferably with Azure DevOps Server
- Experience with Middleware solutions.
- Experience deploying, integrating and supporting ECM solutions such as Hyland Onbase
- Experience with application and database security
- Experience in Power BI, Tableau, and Crystal Reports
Equal Opportunity Employer/Veterans/Disabled
Martin Marietta
Address
Raleigh, NC
USA
View all jobs at Martin Marietta
Get fresh Middleware Architect jobs daily straight to your inbox!
By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.
You Already Have an Account
We're sending an email you can use to verify and access your account.
If you know your password, you can go to the sign in page.