What are the responsibilities and job description for the IBM DataStage ETL Developer position at Brilliant Infotech Inc.?
Role: IBM DataStage ETL Developer
Location: Trenton NJ (Hybrid)
Type of Employment: Contract
Duration: 12 Months
Job Summary:
We are seeking an ETL Developer with strong IBM DataStage v11 and Oracle SQL experience to support and enhance billing data processes. The role involves building and maintaining ETL pipelines, transforming data from multiple sources, and improving existing workflows.
Key Responsibilities:
- Develop and maintain DataStage ETL pipelines (CSV, SQL Server, Excel → Oracle)
- Transform and load billing data from multiple source systems
- Troubleshoot and resolve data/process issues and production anomalies
- Build error reporting and improve existing ETL workflows
- Support migration from legacy COBOL-based processes
Required Skills:
- 5 years of IBM DataStage (v11) experience
- Strong Oracle SQL (functions, triggers, stored procedures)
- Experience with data analysis, debugging, and ETL lifecycle
- Ability to work independently with strong communication skills
Preferred:
- Experience with TOAD or similar database tools