What are the responsibilities and job description for the Senior Lead DataStage Developer position at Atem Corp?
Role- Senior Lead DataStage Developer Location- Miami, FL (Locals or nearby) Durations- Long Term Exp Level- 6 yrs USC/GC/H4 only Descriptions
- Extensive client-facing consulting and 100% hands-on programming / development.
- As Senior DataStage developer, responsible for developing and managing ETL processes.
- Troubleshoot and resolve issues with existing jobs.
- Maintain Data Integrity & Data Quality
- Coordinate with Business users in Requirements gathering and develop necessary ETL jobs and/or enhance existing ETL jobs
- You should have a background in data analysis and be able to work independently with little supervision.
- You will also have experience with database SQL, PL/SQL programming and job scheduling tools Autosys.
- Design, develop, and maintain DataStage ETL jobs according to specifications.
- Optimize existing DataStage jobs for performance.
- Reviewing job designs and code created by other DataStage developers.
- Troubleshoot DataStage job failures and provide root cause analysis.
- Work with the development team to ensure that all DataStage jobs adhere to company standards and best practices.
- Provide support for production DataStage jobs as needed.
- Develop new DataStage jobs to load data into the data warehouse.
- Test DataStage jobs for accuracy and performance.
- Deploy DataStage jobs to production environments.
- Monitor DataStage job execution and troubleshoot issues as needed.
- Maintain documentation for all developed jobs.
- Provide support for ongoing data loads and issue resolution.
- Helping project leaders with project timeframes and objectives.
- Bachelor's degree in information system, Computer Science, or a related field.
- 5 years of experience in DataStage development and administration.
- Experience with ETL tools such as DataStage, Informatica, Ab Initio, or Oracle ETL.
- Strong SQL skills and other relevant coding languages.
- Experience with Snowflake is a plus.
- Excellent communication and interpersonal skills.
- Expert in DataStage solution conception, design, and deployment.
- Outstanding analytical & problem-solving abilities.
- The capacity to work as a member of a multidisciplinary team.