DataStage Production Support / Remote

Only W2, No C2C

DataStage Production Support
Location: REMOTE
Max w-2 rate – $50/hr

As an Application Developer, you will be responsible for designing, building, and configuring applications to meet business process and application requirements. Expected to perform independently and become an SME. Required active participation/contribution in team discussions. Contribute in providing solutions to work related problems. Advanced proficiency in IBM InfoSphere DataStage is required. Intermediate level of proficiency in Extract Transform & Load (ETL) Patterns & Techniques is recommended. Batch Scheduling Tools & Techniques at an intermediate proficiency level is suggested.

Develop and implement data integration solutions using IBM DataStage
Collaborate with cross-functional teams to ensure successful application delivery
Optimize ETL processes to enhance data quality and performance
Troubleshoot and resolve issues related to data integration and application functionality”

• Provide L1/L2support for ETL Batch cycles that run 5×24 in SDLC environments.
• Work in Late shift (12 PM to 9 PM EST) and provide on call weekend support.
• Troubleshoot and resolve Incidents and job failures and participate in triage calls actively. Document Root Cause of incidents.
• Maintain the batch jobs and work with project teams towards propagation of changes to all environments as part of each release.
• Strong experience in Data Quality, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High-Volume Data Loads.
• Work closely with Project teams, QA/BA/SME’s/other teams to discuss & understand issues and to provide solutions to meet business and technical requirements.
• Must have prior experience and working knowledge in some or all activities: troubleshooting, operating, testing, planning and/or configuring in relevant technologies.
• Setting up of new jobs from the configuration request from developers/testers.
• ETL jobs maintenance and troubleshooting.
• Identify and implement system enhancements/improvements and Automation.
• Ability to clearly and concisely document procedures and processes.
• Work in process automation using Shell Scripts and SQL.

Must have Skills:
• 5 + years of experience in ETL tool IBM Datastage Director/Designer v11.7.
• 5+ years of experience in UNIX, Oracle PL/SQL in RDMS .
• should be able to create and analyze UNIX shell scripts and Oracle stored procedures.
• 3+ years of experience in job scheduling tools like Broadcom Autosys.
• 2+ years of experience with version control tool ACCE).
• 2+ years experience on ALM/any Service now/Incident management tool or any defect management tool.
• Prior experience in production/Test Batch support.

Preferred Skills/Nice to have Skill:
• Basic Understanding of Mainframe/Legacy applications, JCL/Job Execution, CA7 Schedules, NDM/MQFTE File transfers.
• Experience in Mainframe Technologies (COBOL, JCL, VSAM, DB2,TSO, MVS)
• Experience working with SRE concepts.
• Basic understanding of US Retirement Products/Insurances.
• Working knowledge in JIRA and Agile methodology.
• Knowledge on Splunk and other monitoring tools