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
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
