Software Developer

Design and implement end-to-end data architecture solutions, including logical and physical data modeling, schema design and database optimization for enterprise applications. Develop, optimize and maintain complex SQL queries, stored procedures, functions and triggers in Microsoft SQL Server and Oracle environments. Build and enhance large-scale Data Warehouse systems using ETL processes, ensuring efficient data extraction, transformation and loading from multiple heterogeneous data sources. Develop and deploy ETL workflows using SSIS and Informatica, including data cleansing, transformation, validation, and error handling mechanisms. Design and implement Business Intelligence solutions, including OLAP cubes, dashboards and reports using SSAS, SSRS, and Cognos. Perform performance tuning of database systems and ETL processes using indexing strategies, query optimization, partitioning, and monitoring tools. Collaborate with business stakeholders to gather requirements, perform data analysis and translate functional requirements into technical specifications and scalable solutions. Develop and integrate RESTful and SOAP-based web services for data exchange across enterprise systems. Work across all phases of the Software Development Life Cycle (SDLC), including requirement analysis, design, development, integration, testing, deployment, and maintenance. Conduct unit testing, system testing, and support User Acceptance Testing (UAT) to ensure high-quality deliverables. Provide production support by troubleshooting incidents, perform root cause analysis and implementing preventive and corrective solutions within SLA timelines. Automate operational and data processing tasks using UNIX/Linux shell scripting and Python scripts. Manage application configuration, version control and deployment processes in controlled environments. Coordinate with cross-functional teams and external systems for application integration and data consistency. Document system architecture, data flows and technical specifications to support maintainability and compliance requirements. Work Location: Various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate. Minimum Requirements: Education: Bachelor -- Computer Science or Electrical and Electronic Engineering (will accept foreign education equivalent) Experience: Five (5) years