DataStage Senior Technical Lead
HCL America Inc.
San Antonio, United States of America
7 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 151KJob location
San Antonio, United States of America
Tech stack
Azure
Code Review
Databases
ETL
Data Warehousing
Database Development
IBM InfoSphere DataStage
Monitoring of Systems
Shell
Oracle SQL Developer
Performance Tuning
SQL Databases
Data Processing
Build Management
Physical Data Models
Job description
The Senior Technical Lead will be responsible for leading technical teams and implementing projects utilizing IBM Infosphere DataStage Suite, SQL, Oracle PL/SQL, and Unix Shell Scripting. The role involves designing, developing, and maintaining complex ETL processes and databases while ensuring high performance and reliability of data workflows., 1. Lead technical teams in the implementation of projects using ibm infosphere datastage suite, sql, oracle pl/sql, and unix shell scripting.
- Design, develop, and optimize etl processes to extract, transform, and load data efficiently.
- Collaborate with cross functional teams to gather business requirements and translate them into technical solutions.
- Provide technical guidance and mentorship to junior team members.
- Perform code reviews, identify areas for improvement, and ensure best practices are followed.
- Troubleshoot and resolve complex technical issues related to data processing and integration.
- Monitor system performance and ensure data accuracy and integrity.
- Stay updated with industry trends and technologies to recommend innovative solutions for continuous improvement.
Requirements
- Proficiency in ibm infosphere datastage suite for etl development.
- Strong expertise in sql for data manipulation and querying.
- In-depth knowledge of oracle pl/sql for database development and management.
- Proficient in unix shell scripting for automation and scheduling tasks.
- Ability to work collaboratively in a team environment and lead technical discussions.
- Strong problem-solving skills and attention to detail with excellent communication and interpersonal skills
- Experience in performance tuning and optimization of etl processes.
- Knowledge of data warehouse concepts and methodologies.
- Knowledge of using azure devops for build and deploy
- Familiarity with creating physical data model based on the data model logic
Benefits & conditions
Minimum Salary (US): 95000