The person will be responsible for highly complex ETL coding using various software solutions including Informatica and Oracle, closely adhering to deadlines and reporting directly to the Project Manager. You will also take responsibility for creating design specifications, unit and integration testing, conducting peer reviews, and preparing technical documentation including designing and developing ETL modules for the creation and maintenance of ODS, Data Warehouse, and Data Mart applications and conducting ETL training within the data management team. .
Required Skills: Over 5 years of demonstrated experience in Informatica suite of products Over 5 years of experience in Data Warehouse/Mart environments Several years experience in building/implementing scalable, reliable and high performance ETL architectures Proficiency with RDBMS systems, SQL, Oracle PL/SQL, UNIX shell scripting, and database optimizations Understanding of modern software engineering principles, practices, and systems development methodologies, preferably Rational Unified Process (RUP) Familiar with database analysis, design, and programming with an understanding of related technologies specifically Java, XML, and web services Excellent ETL design skills, hands-on experience in developing ETL mappings Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings English
Preferred Skills: Experience of ETL in enterprise-wide initiatives Experience with Change Data Capture (CDC) methodologies Experience in integrating data quality suites - Proficiency with job scheduling tools
|
|
