Job Title: Software Developer

Ameya Global; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Ameya Global seeks a senior data architect to design end-to-end data architectures, model logical and physical schemas, and optimize enterprise databases across SQL Server and Oracle.

You will build data warehouses, develop ETL workflows with SSIS and Informatica, create OLAP cubes and BI reports, and tune performance while supporting the SDLC and collaborating with stakeholders. Proficiency in Python and UNIX scripting is a plus.

Qualifications

• Experience designing enterprise data architectures and data models.
• Strong knowledge of SQL Server and Oracle environments.
• Hands-on with ETL tools and BI platforms.

Responsibilities

• Design end-to-end data architecture and model logical/physical schemas.
• Develop, optimize, and maintain large-scale Data Warehouse systems and ETL workflows.
• Build dashboards and BI reports using OLAP cubes and Cognos tools.
• Perform performance tuning, indexing, partitioning, and monitoring.
• Collaborate with stakeholders to translate requirements into scalable solutions.

Skills

Stakeholder collaboration

Analytical thinking

Problem solving

Teamwork

Requirement analysis

Education

Bachelor – Computer Science or Electrical and Electronic Engineering

Tools

SQL Server

Oracle

SSIS

Informatica

SSAS

SSRS

Cognos

RESTful services

SOAP services

UNIX/Linux shell

Python

Job description

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.

Work Location: Various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Education: Bachelor – Computer Science or Electrical and Electronic Engineering (will accept foreign education equivalent)

Experience: Five (5) years

Ameya Global, a leading IT Professional Services organization, delivers innovative yet practical solutions to Fortune 500 companies globally, leveraging its depth, breadth of service and global reach to serve any client, anywhere.