Software Developer

Ameya Global, Inc.

Farmington Hills, MI, United States

11 days ago

Apply on jobs.mitalent.org

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

jobs.mitalent.org

Tech stack

Data Analysis Application Configuration Access Protocols Application Integration Architecture Unit Testing Databases Data Architecture Data Cleansing Extract Transform Load (ETL) Data Mining Document Management Systems Electronic Data Interchange (EDI) Monitoring of Systems

+24 more

IBM Cognos Business Intelligence Microsoft SQL Server Online Analytical Processing Oracle (Applications) Performance Tuning Query Optimization Shell Script Simple Object Access Protocol (SOAP) Software Engineering SQL Stored Procedures SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Data Streaming System Testing Web Services Data Processing Scripting Freeform SQL Enterprise Software Applications Database Optimization Information Technology Restful APIs Software Version Control

Job description

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.

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, 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

Additional 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