Senior ETL/Informatica Developer

Job Title: Senior ETL/Informatica Developer

Location: Jersey City, NJ

Duration: Contract - 11 months

Pay Range: $68.25/hr (W2)

Job ID: 399855

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 an Application Programmer III to join our team. The ideal candidate will have strong experience in Informatica PowerCenter, ETL design and development, PL/SQL, Unix scripting, and API integrations, and a proven ability to deliver performant data pipelines, maintain data quality, and support enterprise data warehouse solutions.

Responsibilities:

• Design, develop, and optimize complex ETL workflows using Informatica PowerCenter.


• Create data mappings to ingest data from flat files, RDBMS, Hive, and REST APIs.


• Develop Unix shell scripts and schedule jobs using Autosys.


• Build and maintain PL/SQL objects, including functions, complex SQL queries, views, and materialized views.


• Perform performance tuning across sources, targets, mappings, and SQL.


• Develop test cases and conduct unit testing to validate ETL and data quality.


• Collaborate and coordinate with a distributed team and provide regular status updates to management.


• Support API integrations, including MuleSoft implementations, as needed.

Required Skills & Qualifications:

• Advanced proficiency with Informatica PowerCenter for ETL development.


• Expertise in performance tuning of mappings, sources, targets, and SQL queries.


• Strong PL/SQL skills, including functions, complex SQL, and view/materialized view creation.


• Proficiency with Unix commands and shell scripting, including job scheduling with Autosys.


• Experience with MuleSoft or similar API integration technologies.


• Ability to work independently with minimal supervision and communicate proactively.

Preferred Skills:

• Experience in data warehouse environments and data analysis.


• Python programming for data processing and automation.


• Tableau or similar reporting and visualization tools.


• Source control with SVN or Bitbucket, and CI/CD tools such as IBM UBuild, Jenkins, IBM UDeploy, or Ansible.

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.

Additional Details

• Labor Type: Technical.


• Hours per Day: 8.


• Primary OS: Unix.


• Respond by Date: 07/01/2026.

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.