Explore 1 sql programmer jobs from 1 hiring companies in Lancaster, CA, US. Filter by remote, salary, experience, and company, then open any listing to apply.

sql-programmer

Sql Programmer

Los Angeles

Palmdale

Quartz Hill

Rosamond

Vincent

Sun Village

Lake Los Angeles

Santa Clarita

Canyon Country

Valencia

Sylmar

Pasadena

Burbank

Van Nuys

Acton

North Hollywood

Valley Glen

Northridge

El Monte

Sql Programmer Jobs

Markwins Beauty Brands

Hybrid

Position Summary

The Sr. Infor XA / EDI Programmer Analyst reports directly to the VP of IT &amp; Systems and is responsible for the development, customization, integration, and technical support of the company&rsquo;s Infor XA ERP platform within an IBM i (AS/400) environment. This role supports manufacturing and distribution operations by maintaining system functionality, implementing enhancements, and ensuring reliable data exchange through electronic data interchange (EDI) processes.

The Sr. Programmer Analyst will leverage advanced RPG programming expertise to develop, modify, and troubleshoot ERP applications, manage EDI transaction mapping, and support integration activities with internal systems and external trading partners. This position plays a critical role in ensuring system stability, compliance with operational requirements, and efficient data flow across retail, distribution, and global supply chain networks.

&nbsp;

Essential Duties and Responsibilities

ERP Development &amp; Support

<ul>
	<li>Develop and maintain custom programs in RPG 400 / RPGLE (Free Form preferred)</li>
	<li>Support and enhance core ERP modules (Finance, Inventory, Order Mgt, Purchasing, Manufacturing)</li>
	<li>Develop and support CL programs, DB2 queries, and embedded SQL</li>
	<li>Collaborate with business stakeholders to gather requirements and translate them into technical solutions</li>
	<li>Develop custom reports, forms, and data extracts</li>
	<li>Troubleshoot system issues and data discrepancies</li>
	<li>Participate in ERP upgrades, enhancement projects, and testing initiatives</li>
	<li>Ensure change management and code promotion best practices are followed</li>
	<li>Support testing, deployment, and post-implementation validation</li>
	<li>Technology: Query400, PDM, ILE, System Link Tool Kit, PowerLink, NetLink, Business Objective (Infor), User Exits, SQL400, etc.</li>
</ul>

&nbsp;

EDI Integration &amp; Mapping

<ul style="margin-bottom:8px;">
	<li>Manage trading partner onboarding and EDI compliance requirements</li>
	<li>Coordinate with third-party EDI providers (e.g., SPS Commerce)</li>
	<li>Perform mapping, testing, validation, integration workflows, and error resolution</li>
	<li>Ensure transaction accuracy between the EDI platform and Infor XA</li>
	<li>Monitor and support daily EDI transaction processing</li>
	<li>Develop, maintain, and troubleshoot EDI maps and integrations</li>
	<li style="margin-bottom:8px;">Support inbound and outbound EDI transactions, North American/European transactions to/from SPS Commerce, including:</li>
</ul>

<table class="MsoTableGrid" style="margin-left:48px;border-collapse:collapse;border:none;">
	<tbody>
		<tr>
			<td style="width:258px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>850 (Purchase Orders)</li>
			</ul>
			</td>
			<td style="width:348px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>ORDERS - Purchase Orders</li>
			</ul>
			</td>
		</tr>
		<tr>
			<td style="width:258px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>855 (PO Acknowledgements)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </li>
			</ul>
			</td>
			<td style="width:348px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>ORDRSP - Orders</li>
			</ul>
			</td>
		</tr>
		<tr>
			<td style="width:258px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>856 (ASN)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </li>
			</ul>
			</td>
			<td style="width:348px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>DESADV - Dispatch Advice (ASN)</li>
			</ul>
			</td>
		</tr>
		<tr>
			<td style="width:258px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>810 (Invoices)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </li>
			</ul>
			</td>
			<td style="width:348px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>RECADV - Receiving Advice</li>
			</ul>
			</td>
		</tr>
		<tr>
			<td style="width:258px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>846 (Inventory Advice)</li>
			</ul>
			</td>
			<td style="width:348px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>INVOIC - Invoice</li>
			</ul>
			</td>
		</tr>
		<tr>
			<td style="width:258px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>820 (Remittance Advice)&nbsp; </li>
			</ul>
			</td>
			<td style="width:348px;padding:0in 7px 0in 7px;" valign="top">
			<ul style="list-style-type:circle;">
				<li>REMADV - Remittance Advice</li>
			</ul>
			</td>
		</tr>
	</tbody>
</table>

&nbsp;

#LI-HYBRID

Sr. Infor XA / EDI Programmer Analyst

6+ years Infor XA/MAPICS; strong IBM i development; RPG/CL/DB2/SQL; 3+ years EDI mapping; ANSI X12; ERP data structures; troubleshooting integrations.

Sql Programmer Jobs in Lancaster, CA, US | HiringCafe: every job on earth

Sql Programmer Jobs in Lancaster, CA, US

Sql Programmer Jobs market signals in Lancaster, CA, US

Companies appearing in this market

Work location mix in visible results

Related browse hubs