- Mid
- $90K–$99K per year
- 8–11 years
ETL Design and Development using IBM InfoSphere DataStage.
Compensation
The annual salary for this position is between $90-99K depending on experience and other qualifications of the successful candidate. This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
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
