ETL/Datastage Developer

Job Title: ETL/DataStage Developer

Location: Plano, TX or Newark, DE

Job Type: 12-18 month contract

Job Summary:

We are seeking an experienced ETL/DataStage Developer for a key role in Plano, TX. The successful candidate will have strong expertise in IBM DataStage (ETL), with the capability to manage and deliver complex requirements to meet critical business objectives. This role involves developing, coding, and unit testing while ensuring that all solutions meet functional, non-functional, and compliance requirements. The ideal candidate will have advanced technical knowledge, extensive experience with various databases, and be comfortable working within Agile environments.

Key Responsibilities:

• Software Development: Develop software solutions to meet business and technical requirements, ensuring all solutions are robust, well-tested, and compliant.
• Configuration & Testing: Write code, configure applications, perform unit testing, and integrate solutions with clear, reliable interfaces.
• Story Refinement & Requirements: Participate in story refinement and define requirements, helping to guide the team in estimating work for each development lifecycle.
• Risk Mitigation: Conduct proof of concepts or spikes as needed to mitigate risks or explore new technologies.
• Coding & Unit Testing: Code and test solutions to meet defined acceptance criteria and compliance standards.
• Architectural Design: Utilize multiple architectural components across data, applications, and business layers to develop client requirements.
• Technical Complexity Resolution: Assist the team in solving technical challenges associated with story work.
• Test Suites Contribution: Support integration, regression, and performance test suites; analyze test reports to identify and resolve errors.
• Documentation & Communication: Prepare and share all necessary deployment, maintenance, and support documentation.
• CI/CD Participation & Coaching: Participate in CI/CD events and provide guidance to team members on branching, pull requests, issue triage, conflict resolution, and release notes.

Required Qualifications:

• Experience: Minimum 10+ years of industry experience, with significant focus on IBM DataStage (ETL) 11.7 or higher.
• Database Knowledge: Proficient with RDBMS databases, SQL, and stored procedures. Familiarity with DB2, Oracle, SingleStore, and MySQL.
• Linux/Unix & Scripting: Experience with Linux/Unix and proficiency in Python or shell scripting for automation.
• Job Scheduling & Automation: Experience with job scheduling tools such as Autosys and data transfer tools like NDM.
• Source Code Management & CI/CD: Experience with Bitbucket, CI/CD automation, and deployment processes.
• IBM Cloud Pack & Databases: Exposure to IBM Cloud Pack, IBM DB2, Oracle, Cockroach DB, and Teradata.
• Additional Technical Skills: Proficiency in Core Java, MQ queues, and experience in ALM for defect management.
• Agile Development: Strong experience with Agile methodology, including tools like Jira.

Preferred Qualifications:

• Z/OS (Mainframe) Knowledge: Familiarity with Z/OS for mainframe data processing and integration.
• Defect Management & Agile Methodologies: Expertise in Agile principles and defect management within a collaborative team environment.