Senior ETL Architect
Senior DataStage ETL Architect, Tech Lead and Mentor. Responsible for preparing the technical design specifications from the business requirements.
Responsible for the design and development of ETL processes.
Strong experience in exception handling design; complex transformations/workflows.
Strong experience in Data integration and cleansing.
Responsible for developing database applications using Oracle, Pl/Sql and UNIX shell scripts.
Work with the users to collect and understand the requirements.
Excellent Customer facing skills.
Responsible for communicating with other IT groups in collecting the requirements and also implementing the applications.
Manages the integrity and reliability of the data.
Develop and maintain the detailed project documentation.
Expert in designing and developing the ETL processes using Datastage with Tera Data environment * MUST.
Experience in working with unstrutured data objects * MUST.
Highly knowledgeable in data warehousing concepts and technologies * MUST.
In depth experience in dimensional and normalized modelling * MUST.
In depth experience with client server applications and architectures * MUST.
In depth hands on experience in Oracle * MUST.
In depth understanding and development experience using SQL, Pl/Sql and UNIX scripting languages * MUST.
Proficiency with the Windows Server and UNIX operating systems * MUST.
Excellent Written and Verbal communication skills with the ability to interact with senior business and technical IT management * MUST.
Strong Analytical and problem solving abilities * MUST.
Data Stage experience in working with DB2 database * PREFERRED.
Bachelor*s Degree (Computer Science preferred) * PREFERRED.