Sr Middleware Architect
Martin Marietta - raleigh, NC
Apply NowJob Description
Senior Middleware Architect Information Technology RALEIGH, North Carolina Description Position Summary Martin Marietta Materials, Inc. is seeking a Senior Middleware Architect for a position at the company's Raleigh headquarters. The 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. Job Duties ? 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 or Information Systems Minimum Requirements ? 6+ years of experience using Microsoft Technologies (SQL Server and Visual Studio) ? 6+ years of experience using SQL Server Reporting Services (SSRS). ? 6+ years of experience using SQL Server Integration Services (SSIS). ? 6+ years of experience writing stored procedures, packages, functions, creating tables, indexes and views in both Microsoft Transact-SQL and within Oracle PL/SQL ? 6+ years of experience within Microsoft C# .NET development ? 3+ years of experience developing scripts in PowerShell ? 2+ years of experience tuning and optimizing complex queries using Query Execution Plan and SQL Profiler. ? 2+ years of experience involving SSIS packages with C# script tasks. ? 2+ years of experience setting up and manage SQL Server Agent Jobs. Preferred Skills ? Experience with application integration using ETL, middleware, APIs, REST web services. ? Experience using code versioning tools, preferably with Azure DevOps ? Experience deploying, integrating and supporting ECM solutions such as Hyland Onbase ? Experience with application and database security ? Experience with report development within Power BI, Tableau, and Crystal Reports Equal Opportunity Employer/Veterans/Disabled recblid xf9wu9811kv3u8b2jq3du8pnhtk3nz
Created: 2024-10-07