We are looking for an experienced Data Architect ETL to join Data and ETL Architecture team in Columbia, MD.
Responsibilities:
- Review logical and physical Data Models and Entity Relationship Diagrams using ERWIN.
- Implement database objects in Oracle.
- Work as an ETL Architect to support production data delivery needs.
- Perform basic DBA functions in the Development and System Test environments.
- Concentration in Data Integration (ETL) and DBMS infrastructure and configuration to best serve a Data Warehousing environment.
- Assist application development teams with interaction with the transactional database, Operational Data Store and/or Enterprise Data Warehouse.
- Performance tune databases and SQL statements.
- Perform source system data analysis.
- Develop stored procedures, database triggers and complex SQL queries where needed.
- Proactively monitor development, test and production class database servers.
- Work with DBAs and Data Architects in planning and implementing appropriate data partitioning strategy for Arbitron Enterprise Data Warehouse.
- Profile production data and ensure enterprise data quality.
Methodology/Certification: 4 year college degree or equivalent experience required.
Experience Requirements:
Minimum of 4 years experience working with Oracle Databases.
- Minimum of 4 years experience in performance tuning databases and SQL statements.
- Minimum of 3 years experience in Unix, writing SHELL scripts.
- Minimum of 3 years experience in using Informatica ETL tools for data integration tasks.
- Demonstrated ability to learn and apply new technologies quickly.
- Comfortable in a fast-paced and team-oriented environment.
- Strong written and verbal skills from both business and technical perspectives.