DataStage Technical Lead
HCL America Inc.
San Antonio, United States of America
2 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
$ 138KJob location
San Antonio, United States of America
Tech stack
Azure
Databases
Data Integration
Data Integrity
ETL
Data Retrieval
Database Queries
IBM InfoSphere DataStage
Shell
Oracle
Oracle SQL Developer
Performance Tuning
SQL Stored Procedures
SQL Databases
Build Management
Job description
The Technical Lead will be responsible for overseeing and leading the technical aspects of projects involving IBM Infosphere DataStage Suite, SQL, Oracle PL/SQL, and Unix Shell Scripting. The role involves designing, developing, and implementing data integration solutions utilizing these technologies to meet business requirements and objectives efficiently. Key Responsibilities
- Lead and manage a team of developers in the design, development, and deployment of ibm infosphere datastage jobs and workflows.
- Collaborate with cross functional teams to gather and analyze requirements for data integration projects.
- Develop and maintain etl processes using ibm infosphere datastage, ensuring optimal performance and data quality.
- Design, implement, and optimize sql queries in oracle databases for data retrieval and manipulation.
- Create and maintain unix shell scripts to automate data loading processes and perform system tasks efficiently.
- Troubleshoot technical issues, conduct performance tuning, and ensure data integrity across all systems.
- Provide technical guidance and support to team members, ensuring adherence to best practices and standards.
- Stay updated on the latest technologies and tools in data integration to drive innovation and efficiency in project delivery.
Requirements
- Proficiency in ibm infosphere datastage suite for designing and implementing etl solutions.
- Strong sql skills with the ability to write complex queries, stored procedures, and functions in oracle databases.
- Experience in oracle pl/sql for database programming and optimization.
- Proficient in unix shell scripting for automation of data processes and system tasks.
- Strong analytical and problem-solving skills to troubleshoot and resolve technical issues efficiently.
- Excellent communication and leadership skills to effectively lead a technical team and collaborate with stakeholders.
- Proven experience in project management, including planning, organizing, and executing technical projects effectively.
- Strong knowledge of azure devops to build and deploy Other Requirements 1.Relevant certifications in IBM Infosphere Datastage or Oracle PL/SQL are a plus.
Benefits & conditions
Minimum Salary (US): 82000