A Senior ETL Developer develops, implements and maintains the functionality of the Enterprise Data Warehouse. They also work with members of Reporting, Application Support, DBA, Infrastructure and other teams to ensure the timeliness and reliability of information flowing between the Data Warehouse and other systems.Â
Job ResponsibilitiesÂ
Implement data handling, cleansing, and standardization procedures and business transformation rules and logic (ETL) using Informatica 9.5 and Oracle 11gÂ
Develop, and implement functions, stored procedures, and ETL jobs using PL/SQLÂ
Actively participate in agile scrum review and planning sessionsÂ
Actively participate in regular code reviews and maintenance of code and process documentationÂ
Required ExperienceÂ
Experience with Informatica DQ requiredÂ
Experience with Data Governance strongly preferredÂ
Experience deploying Data Quality Framework and Solutions requiredÂ
Experience with Informatica PowerCenterÂ
Strong RDBMS SQL and troubleshooting skillsÂ
Significant experience delivering and managing solutions around data integrationÂ
Familiarity with current trends in data quality technologiesÂ
5+ years of experience implementing complex queries against large datasets to support business intelligence functionsÂ
5+ years of experience with ETL, application and database performance tuning and debuggingÂ
3+ years of minimum experience using standard ETL tools (Informatica, SAP Business Objects Data Services preferred)Â
Understanding of Dimensional Modeling and Data Warehouse concepts, such as star schema, snowflakes, dimensions, facts, etcÂ
Experience following Agile development methodologiesÂ
Experience following release management and quality assurance processesÂ
Very strong customer service orientation