FourCi
Atlanta, Georgia
Job Title: Data Engineer Location: Remote Duration: long term Job ID: 4CI -7453 Required Qualifications: Design and develop SQL Server stored procedures for data archiving, purge eligibility, and execution (soft/hard deletes). Handle EBCDIC data processing, including conversion to ASCII/Unicode and validation of data integrity. Develop Python-based automation for orchestration, validation, reconciliation, and reporting. Implement data retention rules, legal holds, and safe purge strategies with rollback and restore capabilities. Optimize performance for large datasets using indexing, partitioning, and efficient transaction handling. Create and manage batch jobs in Control-M, including scheduling, dependencies, alerts, and rerun strategies. Monitor data pipelines, troubleshoot issues, and support production incidents with root cause analysis. Maintain audit trails, ensure compliance, and enforce data security standards. Collaborate with DBAs, data governance, and application teams to align with retention policies and business needs. Strong experience with Microsoft SQL Server (T-SQL, stored procedures, indexing, query tuning). Hands-on experience with Python for data processing and automation (ODBC connectivity, logging, error handling). Knowledge of EBCDIC data formats, conversions, and validation techniques. Experience with Control-M for batch scheduling and job management. Understanding of data archiving, retention policies, and purge frameworks. Experience working with large datasets and performance optimization techniques. Preferred: Experience with VLDB, table partitioning, and archival solutions. Preferred: Familiarity with mainframe data models, COBOL copybooks, and packed numeric formats. Preferred: Knowledge of CI/CD tools (DACPAC, automated testing) for database and Python deployments. Preferred: Experience with data governance and regulatory compliance (SOX, PCI, HIPAA, GDPR). Strong analytical, troubleshooting, and documentation skills. sql server, Python, Performance Tuning, data integrity, partitioning, Stored Procedures, indexing, T-SQL, batch scheduling, Control-M, ETL automation, Transaction Management, job dependencies, EBCDIC (037/1047), Data Conversion (EBCDIC ASCII/Unicode), ODBC, VLDB, Data Lifecycle Management, Audit andamp; Compliance, Data Archiving andamp; Purging, Logging andamp; Monitoring
Job Title: Data Engineer Location: Remote Duration: long term Job ID: 4CI -7453 Required Qualifications: Design and develop SQL Server stored procedures for data archiving, purge eligibility, and execution (soft/hard deletes). Handle EBCDIC data processing, including conversion to ASCII/Unicode and validation of data integrity. Develop Python-based automation for orchestration, validation, reconciliation, and reporting. Implement data retention rules, legal holds, and safe purge strategies with rollback and restore capabilities. Optimize performance for large datasets using indexing, partitioning, and efficient transaction handling. Create and manage batch jobs in Control-M, including scheduling, dependencies, alerts, and rerun strategies. Monitor data pipelines, troubleshoot issues, and support production incidents with root cause analysis. Maintain audit trails, ensure compliance, and enforce data security standards. Collaborate with DBAs, data governance, and application teams to align with retention policies and business needs. Strong experience with Microsoft SQL Server (T-SQL, stored procedures, indexing, query tuning). Hands-on experience with Python for data processing and automation (ODBC connectivity, logging, error handling). Knowledge of EBCDIC data formats, conversions, and validation techniques. Experience with Control-M for batch scheduling and job management. Understanding of data archiving, retention policies, and purge frameworks. Experience working with large datasets and performance optimization techniques. Preferred: Experience with VLDB, table partitioning, and archival solutions. Preferred: Familiarity with mainframe data models, COBOL copybooks, and packed numeric formats. Preferred: Knowledge of CI/CD tools (DACPAC, automated testing) for database and Python deployments. Preferred: Experience with data governance and regulatory compliance (SOX, PCI, HIPAA, GDPR). Strong analytical, troubleshooting, and documentation skills. sql server, Python, Performance Tuning, data integrity, partitioning, Stored Procedures, indexing, T-SQL, batch scheduling, Control-M, ETL automation, Transaction Management, job dependencies, EBCDIC (037/1047), Data Conversion (EBCDIC ASCII/Unicode), ODBC, VLDB, Data Lifecycle Management, Audit andamp; Compliance, Data Archiving andamp; Purging, Logging andamp; Monitoring
FourCi
Carlisle, Pennsylvania
Job Title: Senior Java Developer Location: Carlisle, PA Duration: long term Job ID: 4CI -7364 Required Qualifications: Strong experience with JSP, Custom Tag Libraries, JavaScript, Session EJB, JDBC Experience with Java IDEs such as RAD 7.5 or higher Strong understanding of Object-Oriented Design (Singleton, Factory, DAO patterns) Experience with MVC architecture Experience in batch processing and web services development Design, develop, and maintain Java-based web applications Write clean, efficient, and scalable code using J2EE technologies Develop and support batch jobs and web services Write and optimize complex SQL queries in DB2 and Oracle Perform root cause analysis and troubleshoot application issues Collaborate with cross-functional teams for requirements and solution design Ensure adherence to coding standards and best practices Support application deployment and production issues j2ee, DB2, WAS 8.0, SUSE LINUX, Oracle, SQL, JDBC, JavaScript, JSP, Custom Tag libraries, troubleshooting, web services, root cause analysis, IBM WebSphere application server, Integrated eligibility systems, VMWare, MVC Architecture, Batch Job Development, Session EJB, Senior Java Developer, Java 6.0, Java IDE, RAD 7.5, Object Oriented Design, Singleton Pattern, Factory Pattern, DAO Pattern
Job Title: Senior Java Developer Location: Carlisle, PA Duration: long term Job ID: 4CI -7364 Required Qualifications: Strong experience with JSP, Custom Tag Libraries, JavaScript, Session EJB, JDBC Experience with Java IDEs such as RAD 7.5 or higher Strong understanding of Object-Oriented Design (Singleton, Factory, DAO patterns) Experience with MVC architecture Experience in batch processing and web services development Design, develop, and maintain Java-based web applications Write clean, efficient, and scalable code using J2EE technologies Develop and support batch jobs and web services Write and optimize complex SQL queries in DB2 and Oracle Perform root cause analysis and troubleshoot application issues Collaborate with cross-functional teams for requirements and solution design Ensure adherence to coding standards and best practices Support application deployment and production issues j2ee, DB2, WAS 8.0, SUSE LINUX, Oracle, SQL, JDBC, JavaScript, JSP, Custom Tag libraries, troubleshooting, web services, root cause analysis, IBM WebSphere application server, Integrated eligibility systems, VMWare, MVC Architecture, Batch Job Development, Session EJB, Senior Java Developer, Java 6.0, Java IDE, RAD 7.5, Object Oriented Design, Singleton Pattern, Factory Pattern, DAO Pattern