Job Title- Data Stage Developer Years of experience- 8-11 years Job Summary ETL Design and Development 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 Database and SQL Optimization Write tune and optimize advanced SQL and PL SQL queries for relational databases like Oracle DB2 or SQL Ser Responsibilities ETL Design and Development 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 Database and SQL Optimization 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 Scripting and Automation 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 Troubleshooting and Production Support 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 Testing and Documentation 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 Exempt Roles (up to AD Level) Note: Compensation range should extend from the minimum to P75, consistent with the job family and level.
For all remote positions and those based in pay transparency locations, include this text in the External Description: Salary and Other 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.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements: · 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 Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting.
Cognizant reserves the right to modify this information at any time, subject to applicable law.
Job description provided by Cognizant Technology Solutions.
View the original posting