Datastage Developer

About the Role

We are seeking a highly experienced IBM DataStage ETL Developer to support enterprise data integration initiatives within a fast-paced financial services environment. This role requires a hands-on technical leader who can independently design, develop, and support complex ETL solutions while coordinating with business partners and offshore development resources. The ideal candidate will have deep expertise in IBM DataStage, SQL, data warehousing, and production support.

Responsibilities

• Serve as a key resource for DataStage development efforts.
• Help lead and coordinate offshore developers to ensure timely delivery.
• Review technical designs, ETL jobs, and code submissions.
• Provide technical guidance and mentoring to junior developers.
• Participate in architecture discussions and solution design reviews.
• Design, develop, enhance, and maintain IBM DataStage ETL processes.
• Develop complex data integration solutions involving multiple source and target systems.
• Design and develop API-based integrations using REST services.
• Read, parse, transform, and load JSON payloads using DataStage to support business requirements.
• Create reusable ETL components and frameworks.
• Implement data validation, auditing, reconciliation, and error-handling capabilities.
• Support production deployments and post-implementation activities.
• Develop and optimize complex SQL queries and stored procedures.
• Partner with data architects and business analysts to define source-to-target mappings.
• Support data warehouse, reporting, and analytics solutions.
• Perform data analysis and troubleshooting activities.
• Manage day-to-day activities of offshore development resources.
• Assign work, review deliverables, and monitor progress.
• Conduct code reviews and enforce development standards.
• Facilitate knowledge transfer and production support handoffs.
• Participate in Agile ceremonies and sprint planning.
• Provide effort estimates and technical impact assessments.
• Manage work using JIRA and Agile processes.
• Support release planning and implementation activities.
• Coordinate testing and defect remediation activities.

Requirements

• 7+ years of IBM DataStage development experience.
• 3+ years leading or coordinating offshore development teams.
• Experience working in large enterprise environments.
• Experience supporting production applications.

Technical Skills

• IBM DataStage: Parallel Jobs, Sequence Jobs, Shared Containers, Parameter Sets, Administration, Performance Tuning, Production Support.
• Databases: SQL Server, PostgreSQL, Advanced SQL Development, Query Optimization.
• Scripting & Automation: Unix/Linux Shell Scripting, Python.
• REST API and JSON integration expertise.
• Data Management: Data Warehousing, Data Modeling Concepts, Data Quality Controls, Data Mapping, Data Lineage.
• Development Tools: JIRA, Git, Bitbucket, Ansible.

Qualifications

• Bachelor of Computer Science.

Preferred Qualifications

• Financial Services or Banking experience.
• Experience working with regulatory, risk, compliance, or privacy-related data.
• Experience with enterprise release management and change control processes.
• Prior experience leading distributed development teams.
• Excellent verbal and written communication skills.

Benefits

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits, Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Pay

Salary Range: $90,000 - $110,000 a year