IBM DatastageETL

Title: IBM DataStage/ETL

Location: Albany NY

Qualifications:

• Proven experience in ETL development in Oracle environments using IBM DataStage. Candidates should have a solid understanding of ETL concepts and best practices.
• Experience in ETL design and data warehouse development using SQL and PL/SQL programming. Candidates should be proficient in designing efficient and scalable data workflows.
• Ability to tune SQL queries within an Oracle environment to improve execution efficiency and performance.
• Proficiency in UNIX Shell Scripting for automating ETL processes and system tasks.
• Experience in program and unit testing to ensure the quality and reliability of ETL processes and data transformations.
• Ability to document program code and mentor other developers in ETL development best practices.
• Experience working with data security requirements particularly PPI and SSA data security requirements for production system error diagnosis debugging and code modification.
• Experience in developing dimensional data models for Cognos data analytics ensuring efficient and effective reporting capabilities.
• Ability to develop data analysis and metrics queries for operational oversight and reporting purposes.
• Experience as a DataStage Administrator on AIX environments including implementing and maintaining business and technical rules automating ETL code migration processes setting up security troubleshooting and capacity planning.
  
  If you meet these qualifications and are ready to take on this challenging role please apply with
  your resume and cover letter. We look forward to hearing from you!