DataStage Developer
ETL Design and Development using IBM InfoSphere DataStage.
- $90K–$99K per year
- Posted Jan 1, 2024
INDUSTRYSoftware & InternetSaaS & Enterprise Software
Responsibilities
- Design build and modify parallel jobs sequence jobs and custom routines in IBM InfoSphere DataStage Designer client
- Implement complex business logic using transformer stages lookups joins aggregations and sorting mechanisms
- Translate business requirements and source to target mapping documents STDs into scalable technical solutions
- Write tune and optimize advanced SQL and PL SQL queries for relational databases like Oracle DB2 or SQL Server
- Perform data profiling analyze source data nuances and prevent data redundancy across data warehouses EDW ODS and Data Marts
- Develop and maintain UNIX Linux shell scripts to automate file handling job triggers and operational pipelines
- Schedule execute and monitor jobs using DataStage Director or enterprise schedulers
- Provide ongoing support for daily weekly and monthly data processing cycles
- Monitor job execution logs perform root cause analysis on failed loads and implement preventive performance fixes
- Debug and tune slow running jobs using partitioning strategies stage optimizations and performance monitors
- Create and execute comprehensive unit integration and regression test plans
- Participate in code reviews and support User Acceptance Testing UAT
- Maintain technical documentation data lineage and operational runbooks
Requirements
- Experience in a Data Warehousing
- Experience in a ETL
Skills
IBM InfoSphere DataStage DesignerSQLPL SQLUNIX Linux shell scriptsOracleDB2SQL ServerDataStage Director
Benefits
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Full description
CognizantCompany details are for members
Sign up for a free job alert to see Cognizant's profile, website and LinkedIn, and the same for every employer on Referso Jobs.