Back to Jobs
Recently postedEngineering

Data Transformation Engineer

BCforwardAddison, TX🇺🇸United States

Quick overview

Salary$65/hr
Work modeOn-site
LocationAddison, TX, United States
Agile

Job description


Job Title: Application Programmer III


Location: Newark, NJ or Charlotte, NC or Addison, TX (Hybrid, minimum 3 days onsite per week)


Duration: Contract - 12 months


Pay Range: Newark: $65.06/hr (W2), Charlotte: $65.06/hr (W2), Addison: $68.25/hr (W2)


Job ID: 412434


Start Month: January 2026


Interview: 1-2 rounds. Video or in-person required. Local candidates may have in-person after first round.


About BCforward


BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.


Job Description


We are seeking a Data Transformation Engineer to join our dynamic team within SI&DS Operational Datastores and Real-time Data Replication. The ideal candidate will have strong experience in IBM CloudPak for Data (CP4D) v4.5, IBM InfoSphere DataStage, Oracle, DB2, and advanced SQL/PLSQL and a proven ability to design, develop, modernize, migrate, and support enterprise-scale data integration and transformation solutions that meet scalability, resiliency, performance, and data integrity requirements. This role supports the 2026 Never Down Program and EOL technology migration initiatives involving IBM CloudPak for Data.


Responsibilities:



  • Design, develop, and optimize ETL/ELT pipelines using IBM DataStage on CP4D v4.5.

  • Migrate legacy workloads to modern platforms, ensuring performance, resiliency, and data integrity.

  • Implement scalable batch processing and support real-time replication and CDC patterns.

  • Troubleshoot, tune, and validate data pipelines across Oracle and DB2 environments.

  • Collaborate with stakeholders to define requirements, models, and standards for data transformation.

  • Create and maintain technical documentation and operational runbooks.


Required Skills & Qualifications:



  • 12+ years of experience in Data Engineering, ETL Development, or Data Integration.

  • Strong expertise in IBM InfoSphere DataStage development.

  • Hands-on experience with IBM CloudPak for Data (CP4D) v4.5.

  • Advanced SQL and PL/SQL programming skills.

  • Strong experience with Oracle and DB2 database platforms.

  • Proven background in data transformation and data engineering with significant data modeling experience.

  • Experience designing and supporting large-scale batch processing environments.

  • Strong troubleshooting, performance tuning, and data validation skills.

  • Experience working in Linux/Unix environments.

  • Excellent communication and stakeholder collaboration skills.

  • Experience with CockroachDB or MemSQL is a plus.

  • Experience with Python-based scripting is a plus.

  • Knowledge of Oracle GoldenGate is a plus.

  • Familiarity with CDC (Change Data Capture) technologies.


Preferred Skills:



  • Experience in a fast-paced Agile development environment.

  • Experience with cloud platforms and services.

  • Experience with CI/CD pipelines and DevOps practices.

  • Familiarity with data replication, CDC, and real-time integration technologies.

  • Experience supporting mission-critical financial or enterprise data platforms.

  • Knowledge of data governance, SOX controls, and audit requirements.


Candidate Submission Notes:



  • On resume, include current location, relocation plan, availability/start date, and cooling-off details if applicable.

  • Approved locations: Newark, NJ (DE5-021-03-03), Charlotte, NC (NC1-025-07-22), Addison, TX (TX8-044-02-18). No location preference stated.

  • Glider assessment with ID verification may be required.


Why BCforward?


At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:



  • Competitive compensation and benefits.

  • Opportunities for growth with global clients.

  • A supportive, inclusive culture that values innovation and people.

  • Exposure to cutting-edge technologies and projects.


About Our Commitment


BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.


Interested? Apply Now!


If this sounds like the right opportunity for you, please apply with your most recent resume. Ensure your resume includes current location, relocation plan, availability or start date, and any cooling-off requirements.


Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs