Must Have Technical/Functional Skills
• Understanding business requirements and translating them into technical specifications for ETL solutions.
• Designing and developing DataStage jobs to extract, transform, and load data.
• Using various DataStage stages (e.g., Transformer, Aggregator, Lookup, Filter) to manipulate data.
• Creating job sequences using Autosys to orchestrate the execution of multiple jobs.
• Experience in Git and Knowledge of DevOps practices and tools.
• Familiarity with containerization technologies (e.g., Docker, Kubernetes).
• Python skills and good knowledge of SQL & PL/SQL
Roles & Responsibilities
• Manage and maintain Datastage server environments, ensuring system stability and performance. (Both on prem and cloud)
• Analyzing and optimizing existing ETL jobs for performance improvements.
• Troubleshooting ETL job failures and identifying root causes while doing the migration.
• Monitoring job execution and proactively addressing potential issues.
• Implement and maintain best practices for ETL design and creation.
• Have hands on experience on datastage migration or upgrade from on prem to cloud.
• Document processes, procedures, and system configurations for knowledge sharing.
• Participate in team calls and meetings.
Generic Managerial Skills, If any
• Datastage Anywhere ETL.
• SQL
• Python
Base Salary Range : $120,000 to $135,000 Per Annum
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SV2
#LI-KUMARAN