Jobs at STEM Xpert

Perform database and ETL testing for SQL Server/SSIS environments. Design and execute test scenarios, cases, and scripts. Coordinate system integration testing with upstream and downstream teams within a waterfall SDLC. Communicate results and issues in a large enterprise setting.

Perform database and ETL testing for Microsoft SQL Server/SSIS environments. Design and execute test scenarios, cases, and scripts; perform T-SQL querying and data validation; coordinate system integration testing with upstream/downstream teams in a waterfall SDLC.

Implement and configure SAP CC/CI solutions including technical and business features, master data, UI and IEC settings; integrate with SAP CRM and SAP ERP/FI-CA; support Order-to-Cash end-to-end processes; participate in full lifecycle SAP R/3 implementations, design technology-enabled business solutions, test, train, and define support procedures.

Senior Business Analyst for OTC/investment management focusing on capital markets. Conduct JAD sessions, support SDLC, perform data mapping, write business specifications, and create process flow diagrams. Requires hands-on OTC instrument project experience and basic SQL for data-related tasks.

Lead QA efforts by defining testing strategy, identifying test scope, and creating/executing automated (Selenium/WebDriver, Java) and manual test plans. Prioritize GWT testing expertise, collaborate with developers to improve testability, work independently in a startup-like environment, and deliver quality each sprint.

Develop and maintain TIDAL job schedules and related automation. Require 3+ years TIDAL experience (6+ years IT), strong MSSQL skills including Stored Procedures, familiarity with other schedulers (Control-M, AutoSys), and excellent communication.

Lead and manage BI/DW projects including ETL development, data modeling, report and dashboard design (BusinessObjects, Webi, Tableau/QlikView), Excel VBA automation, and creation of functional and technical documentation to support business analysis and decision-making.

Perform production SQL Server monitoring, incident investigation and resolution; coordinate escalations and cross-team work; validate deployments with automated/manual tests; manage backups, failover, clustering, replication, mirroring, tuning, schema and data archiving for production and non-production environments.

Participate in requirements gathering and validate ETL scripts with BAs, developers, and DW engineers. Create, execute, and debug SQL to test data completeness, correctness, transformations, and data quality. Prepare and maintain test cases, scripts, and artifacts; log and track defects to closure. Mentor/lead other data warehouse testers.

Lead SAP CRM functional consultant responsible for CRM Sales, Service, and Customer Interaction Center solutions. Duties include business-process and requirements gathering, blueprinting, gap analysis, configuration, test case development, integration with third-party systems, and end-user training. Focus areas: Order Management, Pricing & Billing, CTI/Web Chat for CIC, and case management. Must have completed at least two full life-cycle SAP CRM and ERP implementations.

Design, analyze, and implement Microsoft Unified Communications solutions. Lead Lync Enterprise Voice deployments, integrate with Exchange UM and Office 365, manage PSTN/IP phone integrations, troubleshoot Lync infrastructure, and collaborate with teams to ensure secure, high-quality UC implementations.

Lead technical ownership of enterprise network services: define strategy, design high-availability services, provide technical leadership during incidents, develop operational processes and runbooks, coach teams, audit configurations, manage vendor/managed-service relationships, and maintain KPIs and documentation for 24x7 network operations.

Design and develop a scalable test automation platform for an offer management system. Build test automation frameworks and perform automation for web services using C#, .NET, Azure, SQL, XML, and WCF. Contribute to performance/load testing, work in Agile teams, and provide coding and design input for performance optimization. Requires strong programming, debugging, communication, and teamwork skills.

Provide storage management services for Capital One Investing: administer EMC VMAX and Cisco Director storage, manage AIX systems, Clarion, and Dell hardware; perform configuration, monitoring, troubleshooting, capacity and performance optimization, and maintenance.

Develop and maintain Forefront Identity Manager and Microsoft Identity Manager solutions. Write C# extensions, PowerShell scripts, and SQL Server stored procedures. Map business processes to technical specs, follow TDD practices, collaborate with onshore/offshore teams, and support overall identity and access management system security and health.

Develop, maintain, and optimize GoldenGate batch/replication processes and Hadoop integrations; design and produce reports and maintain reporting portal/environment; perform data mapping, coding, testing, debugging, performance tuning, incident and release support; analyze user requirements and improve systems; coordinate offshore teams.

Designs and implements data integration, data warehousing, analytics and reporting solutions using Microsoft BI technologies. Develops T-SQL, SSIS, SSAS, and SSRS artifacts, works with third-party cloud monitoring tools, participates in Agile Scrum, provides technical leadership, and ensures high-performance, scalable, reliable reporting and analytics solutions.

Lead ETL testing efforts: gather requirements, validate ETL scripts, create/execute/debug SQL for data completeness and quality, prepare and run test cases, maintain test artifacts, log/track defects, and mentor data warehouse testers.

Develop, design, implement, document, and maintain ConceptWave Order Management/EPC modules integrated with SAP CRM, WSIL and BSCS. Analyze requirements, debug complex database issues, propose improvements, collaborate with distributed engineering teams, estimate tasks, follow SDLC, and provide training and knowledge transfer.

Design and architect monitoring and alarming solutions for telecom BSS environments. Lead conceptual design for T-Mobile BSS monitoring, implement operational tools, integrate third-party monitoring/alarming products, and develop web-based monitoring and scripting components to support business process and business flow monitoring.