Begin your journey Datametrics Software Systems at a place where you can give your ideas a stage, create waves of change and empower the next-generation technologies. The time is now, the revolution is here! Datametrics Software Systems is offering employment in multiple positions.

Software Developer

Software Developer is needed to perform the following duties: Analyze moderate to complex business problems and formulate solutions using advanced Microsoft Technologies like WCF, MVVM, SQL Database, C# programming languages. Incorporate the Industry level coding standards during our development which makes our code readable and easy to understand. Discuss with Technical Architects on various solutions using various technologies and figure the most effective solution considering both the cost and effort required to develop a feature. Upgrading the applications to use the latest versions of technology thereby improving the efficiency and quality of applications. Define the horizontally scalable and highly available system design and implementation, with focus on performance and resiliency. Work with latest Frontend technologies like AngularJS and JavaScript to design Rich UI and Reactive web applications. Implement new Concepts like Lazy loading that defer initialization of an object until the point at which it is needed and Backend for Frontend (BFF) that supports multi-client applications and at the same time making the system a loosely coupled system making it more efficient. Work with technologies like .NET MVVM and WCF to make the Application more modular and scalable. Work with inline and Regular Expressions for pattern matching and Input Validations on web forms. Work with the latest design patterns like Entity Framework to align with our software needs in building a Service Oriented Architecture. Designs and develops complex and large-scale data structures and pipelines to organize, collect and standardize data and design database systems and develops tools for real-time and offline analytic processing. Develop and maintain data engineering best practices and contribute to Insights on data analytics and visualization concepts, methods and techniques. Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes (Kafka). Work with SQL Profiler to understand the bottlenecks with our Database structures and Stored procedures and take corrective measures to increase the performance of our Database calls to services by optimizing our database queries. Creating Custom libraries makes the applications across organization more scalable and organized. Common Functions used across various applications are bundled together into one dll’s(dynamic link library) which will prevent duplication of code across various applications. Assist the customer in defining the Ingestion strategies, reusable frameworks to be built. Leads team for executing the data provisioning. Work with Latest Microsoft IDE’s like Visual Studio and Visual Studio Code that help us build complex software solutions with .NET Technologies. Work with Latest Frameworks like .NET Framework 4.7.2 and .NET core 2.0 etc Participate in an Agile Scrum team process, collaborating closely with UX experts, subject matter experts, architects, fellow developers and test engineers. Participate in peer reviews and technical design meetings. Deliver quality development operations planning, analysis, implementation to ensure timely release of functional, high-quality products & services. Create Unit tests for the developed code to make sure that the behavior of the developed code aligned with the acceptance criteria. Create separate unit tests for UI code, .NET microservices and database to test the functionality respectively. Demo the Application to QA Team and Business Architects (BA) to ensure the functionality is as per the Business needs. Bachelor's Degree is required in Computer Science or Computer Engineering or Computer Information Systems. .

SAP BW-HANA

SAP Consultant/ SAP BW-HANA Consultant is needed to perform the following duties: Requirement Gathering and Reviewing software specifications. Modify existing SAP standard content to correct system gap, to fill customer requirements to determine feasibility of design to full the business requirements. Proactively manage changes in project scope to track time and cost, create change requests, ensures project documents are complete, current, and stored appropriately. Perform technical analysis of issues and propose suitable solutions. Involve in Creating and maintaining Info Cubes to Store the data and retrieve data from infocube to manipulate data for analysis of system capabilities and requirements. Involve in migration of Relational Database to SAP HANA Database for performance tuning, to develop User Interfaces of data visualization. Design and develop forms like sales order, delivery, purchase order Model the BW objects including Infoobjects, DSOs, Infocube, aggregates, and design and create SAP BEx Queries and Web Application. Develop different types of reports using ABAP ALV Report, WEBI, Crystal Report, Xcelsius Report, AO Analysis Report, Lumira, on database systems like Oracle PL/SQL, HANA, DB2. Based on the customer specification Configured JDBC driver. Create connection of the database to connect different database of Oracle, Teradata, MS SQL, will be using Oracle JDBC drivers. SAP Business Objects for Operation, PM, HR, FI, RA, PS involved in the data flow from r/3 to sap Business Objects. Design and Develop Extensive Business Objects reports using multiple Queries, combination of chart and tables. Experience in Business Objects Information Design Tool, Business Objects Web Intelligence, BO Launch Pad, CMC and Business Objects Enterprise. Create SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like – Tracing, Using the SQL Script Debugger. SAP UI5 & Fiori, JSON, D3 for build test apps to integrate few existing reports in SAP as an initiation of marching towards Digital Platform. Develop complex BW-ABAP code in the routines to satisfy the existing functions and latest business needs. Modify reports as per the user requirements Modify build to improve performance of various objects. Create multiple test scripts based on requirements. Create technical specification documents. Work with business process owners, end users, systems analysts, programmers and others to design systems and obtain information on project limitations and capabilities, performance requirements and interfaces. Responsible for designing, planning and building the system. Analyze user requirements, procedures, and problems to automate or improve existing systems Review software specifications and create technical documentation to support the applications. Develop and implement comprehensive test plans to ensure that systems are tested and debugged.Bachelor's Degree is required in Computer Science or Computer Engineering or Information Systems or Electronics Engineering. .

Software Engineer

Software Engineer is needed to perform the following duties: Creating and maintaining database design and database objects for the Data warehouse to meet the reporting needs. Creating Star Schema design in Data Warehouse to maintain the data from various data collections. Creating new database objects to support different reporting needs. Maintaining database design and objects based on the changes in the source systems. Creating validations and data checks to maintain the data quality in the Data Warehouse. Creating validation procedures for each ETL to compare data from the source systems to Data Warehouse based on the business rules. Performing data quality checks based on the user requests and fixing the data as per the business rules. Creating and maintaining Data warehouse ETL’s and SQL Jobs. Creating new ETL’s to load data into Data Warehouse from source systems and external files as per the business needs. Maintaining ETL jobs to refresh the data in Data Warehouse. Using SSIS Import/Export packages to load Excel and CSV data into Data Warehouse. Participating and working with the team in agile SAFe methodology to meet the client requirements. Participate in weekly grooming meetings to go through the user stories to prioritize the tasks and estimate the effort to complete the tasks. Participate in everyday meetings to go through the tasks to complete the requirements. Performing the code reviews and mentoring the team members. Participate in code reviews to maintain the query performance. Mentoring the team members to follow the data warehouse standards. Designing, creating and maintaining the SSRS reports and ad hoc Reports. Providing the SQL Procedures and SQL Queries for front end reporting and Power BI Reports. Creating and maintaining various Drill down and Drill through SSRS Reports. Creating and maintaining documentation for the Data Warehouse. Creating database design documents to add the new database objects to the Data Warehouse. Creating mapping documents to ETL data from source systems to Data Warehouse. Bachelor Degree is required in Computer Science or Computer Applications or Computer Information Systems.Fax resume to HR at (732) 465-0901. EOE. No calls.

Software Developer

Software Developer is needed to perform the following duties: Expertise in various facets of SAP such as Sales and Distribution (SD), and Material Management (MM), including Implementation, Integration, Testing, Customization, and Production Support of SAP S4 HANA, ECC 6.0,7.6 EHP7, EHP8. Play an active role in gathering business requirements for preparing blueprints, conceptual designs, and functional design documents. Post-development focus on testing, final preparation, Go live, and hyper care with dependent teams. Participate in Program Increment (PI) Planning sessions with the Product teams to understand the business vision and create plans/objectives to support the Client’s Order Management and Supply Chain Process using Agile methodologies. Perform Configuration CoE (Center of Excellence) activities to deploy changes from Development to Quality, Staging and production systems using proper Gatekeeper channels. Actively involved in the setup of order-to-cash processes such as AFS Order/Contract Processing with Customer Credit Check, and Allocation-Outbound Delivery-Invoice Process. Actively involved in detailed analysis and activation of various order management activities like return functionalities for all Clients' retail and wholesale businesses compliant with Geo-specific needs. Work closely with the point of sales (POS) to setup up specific master data management including AFS Material Master, AFS Grid Master season, and collection theme combination. Work closely with integration experts to activate Order management OData services using AWS API’s.Work closely with cloud platform engineering, integration, and fulfillment gateway teams to design new adapters for real-time transaction data posting via AWS/API.Work on technical issues related to IDoc processing, batch processing, EDI, and middleware translations for interchange transaction data. Conduct system integration and unit testing activities with business users and integrated partners for all interfaces and end-to-end business processes. Bachelor Degree is required in Computer Science or Computer Engineering or Computer Information Systems..

Database Administrator

Database Administrator is needed to perform the following duties: Installing and configuring new SQL Server 2014 database instances and PostgreSQL 9.5/9.6/10.5/11.1/11.5 database instances. Installing, configuring and administering SQL Server 2014 in both standalone and clustered environments. Installing, configuring and administering PostgreSQL 9.5/9.6/10.5 server instances on both windows 2012 and linux systems.Upgrade PostgreSQL 9.5/9.6 to the latest versions. Designing and implementing High Availability and Disaster recovery solutions. Configure and maintain database servers and processes, to ensure high levels of performance, availability, and security. Designing and implementing streaming replication and PITR. Designing and implementing High Availability with Alwayson Availability groups and failover clustering. Designing and implementing Disaster recovery solutions using Mirroring/Log Shipping. Developing and implementing robust backup and restore strategies using Full, Diff and Log Backups. Ensuring all database are backed up in a way that meets the business’s Recovery Point Objectives (RPO) Regularly test backups to ensure the business’ Recovery Time Objectives (RTO) are met. Performing various database operations including: Creating and managing user logins, permissions and database access. Deploy database change scripts. Perform scheduled maintenance and support release deployment activities after hours. Troubleshooting and resolving Database performance issues, blocking and deadlocking issues using DMV’s , Activity Monitor and PerfMon. Developing, scheduling and monitoring sql agent jobs and cron jobs. Developing and designing data flow packages to copy data from production into development environments. Configure SQL Server monitoring and nagios monitoring utilities to minimize false alarms. Automating daily and weekly maintenance plans like index rebuild, vacuum db etc. Developing SQL Scripts for maintaining administrative tasks. Monitor and plan for system performance, capacity, maintain the database logs and monitor space requirements. Documentation of SQL Server system and database operations, technical specifications, functional specifications, best practices, policies and procedures. Bachelor Degree is required in Computer Science or Computer Engineering or Information Technology or Information Systems.Fax resume to HR at (732) 465-0901. EOE. No calls.

Sr. Database Administrator

Sr. Database Administrator is needed to perform the following duties: Architect, Design, Develop & maintain Database Management Systems and Database Programs using SQL Server 2012/2014/2016/2017. Going through the business requirements and design the logical and physical design of the databases. Create, monitor and optimize the performance of the queries in the databases. Work extensively on performance tuning of the applications. Independently formulate detailed database program specifications using structured analysis and design methodology. Prepare project documentation when needed Work with IT and Business users to evaluate user requests, projects, and clarify objectives and data requirements for new or modified computer programs for the Oregon Health Authority-MAGI Medicaid Case Management Solution. Installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/2014/2016/2017. Upgrading and migrating servers and databases from SQL Server 2012/2014 to SQL Server 2016/2017. Build logic using programming and database skills such as T- SQL, Powershell Scripting, Data Services Scripting language, XML, HTML Work on stored procedures/Views in SQL to get the data from the Database. Work on logic of the queries to filter the data by using the appropriate SQL join conditions, aggregate functions, conditional statements like If Else and while or Switch based on the requirements to get the correct result set. Write complex stored procedures and functions on extraction and transformation based on the business requirements. Analyzing blockings, Locks, Deadlocks and handling the Isolation Levels and Concurrency Effects. Enhance performance using optimization techniques-normalization, indexing and Row Versioning. Solve complex data modeling challenges effectively using Logical and Physical models generated from ERwin Data Model Tool. Responsible for Designing and Developing of SQL Programs for masking sensitive PHI and PII Data. Responsible for customizing IBM Optim Tool for obfuscating sensitive citizen information required for Oregon Health Authority-MAGI Medicaid Case Management Project. Effectively masking the sensitive PII and PHI Citizen’s data. Customize IBM Optim tool to meet the project demand. Reduce the turnaround time of bug fixing by providing the Production Obfuscated data to Development and Functional team for faster analysis of issues. Evaluate existing database programs and recommend improvements for performance efficiency. Develop best practices for database design and development activities. Implement Transparent Data Encryption using SQL server 128-bit AES, 192-bit AES, and 256-bit AES Algorithms. Read and Extract data from legacy source systems that are going to be sunset and replaced by Oregon Health Authority-MAGI Medicaid Case Management Project. Load the extracted and cleansed data to the Sql server databases. Responsible for Performance Tuning and Query Optimization. Work on creating complex queries to get the required data by using temp or scalar tables as necessary and perform the data manipulation on the scalar tables and then query it to get the required fields for the end user on the SSRS reports. Work on gathering the required data from database using various common SQL functions. Create various counters especially for monitoring the backend SQL queries like Open connections, % Query repositioning rate, Hard and soft throttled connections and Heartbeat time etc. which will help in fine tuning the queries and improve faster execution. Remove unwanted joins and always set nocount on and make sure there is no lock happening on certain table during query execution. Responsible for creating SSRS Reports using Microsoft Reporting services for Oregon Health Authority-MAGI Medicaid Case Management Project. Develop drill down reports as per the business requirements Multi-level drill through reports with aggregate at each levelto give a very good interactive display for the end users. Ability to build parameterized SSRS Dashboards based on end user selection. Design and Develop different types of Report formats like charts, maps, sparklines, bars using SQL Server Reporting Services. Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import/Export,SSIS packages and SQL Server Data Tools. Responsible for Applying critical Operating system and SQL server related patches. As a Lead Database Administrator and Database Developer responsible for maintaining the complete security of the Operating systems and sql server database programs and Analyzing Network Bandwidth. Identify security vulnerabilities and apply critical operating system patches and Hot fixes. Identify SQL Server related security vulnerabilities and hot fixes. Install Sql Server latest service packs and cumulative updates. Identify Network related bottleneck that could slow down database program execution speed. Bachelor’s Degree is required in Computer Science or Information Technology or Information Systems or Computer Information Systems. Fax resume to HR at (732) 465-0901. EOE. No calls.


Software Engineer

Software Engineer needed to perform the following duties: Creating and maintaining data base design and data base objects for the Data warehouse to meet the reporting needs. Creating Star Schema design in Data Warehouse to maintain the data from various data collections. Creating new database objects to support different reporting needs. Maintaining data base design and objects based on the changes in the source systems. Creating validations and data checks to maintain the data quality in the Data Warehouse. Creating validation procedures for each ETL to compare data from the source systems to Data Warehouse based on the business rules. Performing data quality checks based on the user requests and fixing the data as per the business rules. Creating and maintaining Data warehouse ETL’s and SQL Jobs. Creating new ETL’s to load data in to Data Warehouse from source systems and external files as per the business needs. Maintaining ETL jobs to refresh the data in Data Warehouse. Using SSIS Import/Export packages to load Excel and CSV data into Data Warehouse. Participating and working with the team in agile SAFe methodology to meet the client requirements. Participate in weekly grooming meetings to go through the user stories to prioritize the tasks and estimate the effort to complete the tasks. Participate in every day meetings to go through the tasks to complete the requirements. Performing the code reviews and mentoring the team members. Participate in code reviews to maintain the query performance. Mentoring the team members to follow the data warehouse standards. Designing, creating and maintaining the SSRS reports and ad hoc Reports. Providing the SQL Procedures and SQL Queries for front end reporting and Power BI Reports. Creating and maintaining various Drill down and Drill through SSRS Reports. Creating and maintaining documentation for the Data Warehouse. Creating data base design documents to add the new database objects to the Data Warehouse. Creating mapping documents to ETL data from source systems to Data Warehouse. Bachelor’s Degree required in Computer Science or Computer Applications or Computer Information Systems. Fax resume to HR at (732) 465-0901. EOE. No calls.