Software Developer

Barclays - Hanover, NJ

Full-time - Mid Level

Hanover, NJ

Credit Intermediation and Related Activities

About the position

The Software Developer at Barclays Services LLC is responsible for designing, building, and developing Data Warehouse software applications. This role involves following the Software Development Life Cycle (SDLC) processes, conducting cost-benefit analyses, and employing Agile techniques to enhance execution speed and product quality. The developer will collaborate with stakeholders, prepare technical documentation, and build ETL jobs using Ab Initio, while ensuring code quality and adherence to secure coding practices.

Responsibilities

• Design, build, and develop Data Warehouse software applications.
• Conduct cost-benefit analysis and employ Agile techniques.
• Coordinate and participate in requirement analysis meetings with stakeholders.
• Prepare Business Requirements and Functional Specifications documents.
• Prepare Technical Design Documents (TDDs) for applications.
• Build Extract, Transform, and Load (ETL) jobs using Ab Initio.
• Translate file layout specifications using various data formats.
• Perform coding tasks including developing ETL mapping and workflows.
• Execute test scripts to validate code and migrate SAS ETL processes.
• Analyze and resolve data lineage issues using the AbInitio Metadata Hub.
• Monitor, support, and validate code once implemented in production.
• Prepare detailed documentation of proper code flow.
• Collaborate with data modelers and contribute to physical data models.
• Transition applications to the Run-The-Bank (RTB) team for support.
• Provide technical support to business analysts and project managers.

Requirements

• Experience in software development with a focus on Data Warehousing.
• Proficiency in programming languages and frameworks relevant to the role.
• Strong understanding of Agile methodologies and SDLC processes.
• Experience with ETL processes and tools, particularly Ab Initio.
• Knowledge of data formats such as EBCDIC, ASCII, JSON, and others.
• Ability to write UNIX shell scripts and database scripts.
• Experience in coding, testing, and debugging software applications.

Nice-to-haves

• Familiarity with Hadoop and data migration processes.
• Experience in coaching and mentoring less experienced staff.
• Knowledge of secure coding practices and risk management.

Benefits

• Incentives pursuant to Barclays Employee Referral Program.