Job Description :
EDW Engineer in West Chester, PA.
This is with a large retail/ecommerce client of ours.
MUST HAVE TERADATA CERTIFICATION
Job Responsibilities:
Administer the enterprise data warehouse (EDW), data marts and related database environments, including but not limited to, users, performance, backup and recovery, security and upgrades to new releases.
Work with the BI team to provide data management and provision data to the team for BI and reporting purposes.
Work with data modelers to create and maintain consistency and accuracy of all logical and physical data models inclusive of associated metadata.
Proactively support the environments, particularly around issues and improvements.
Responsible for all aspects of the EDW system, including but not limited to design, creation, tuning, validation, and troubleshooting.
Work with ETL team to develop ETL flows and code for new integrations and maintain and enhance existing ETL.
Work with BI management to abide by QVC Data Governance standards and guidelines.
Set up complex workflows and schedules.
Follow SDLC methodology in regards to code development and deployment.
Keep current in terms of technology and best practices.
Participate in quality assurance reviews of ETL components.
Navigate on the host server for file management, file cleanup and configuration tasks.
Write scripts and code as needed.
Provide regular updates to EDW manager and assist with project planning, and execution of Data Management strategic roadmap.
Minimum Requirements:
Highly technical knowledge of Teradata Active Data Warehouse and Data Warehouse Appliance including DBMS configuration, DBMS internal structures, physical database design concepts, database access and query languages, and DBMS administrative tools
Experience in development, production support processes and problem resolution according to service-level agreements
Highly technical and strong DBMS performance and tuning skills
Must possess excellent communication skills
Must possess ability to work independently and in a team environment
Must possess excellent investigative and problem solving abilities
Must be Teradata certified
10+ years SQL programming experience
5+ years advanced hands-on experience with Teradata
5+ years experience in database design, administration and optimization
5+ years of enterprise warehouse data modeler experience
5+ years strong experience with ETL/ELT creation and tuning
5+ years of experience with BI or Data Warehouse projects
5+ years experience with Linux, UNIX and Windows
3+ years strong experience managing multiple technical projects through a SDLC
3+ years experience Shell Scripting
2+ years advanced experience with Informatica
Must be proficient with MS Office ''07 (or higher) - Word, Excel, PowerPoint, etc.
Retail Industry is preferred
BI performance management tool (e.g. Microstrategy) experience preferred
Temporal data management experience is a significant plus
Data Labs experience is a definite plus
Hadoop experience is a plus
Working knowledge of SQL Server and Oracle is a definite plus
DB2 experience a definite plus
Knowledge of Cybermation is a plus