Job Description :
Teradata ETL Developer
We have an immediate opportunity with a large F500 client in the Seattle, WA area.
We are looking for Teradata ETL Developer at Seattle, WA with one of our major clients. Please go over the details let me know
Teradata ETL Developer
Seattle, WA
ROLE & RESPONSIBILITIES:
Design and develop internal business systems/applications, systems interface, databases, reporting, or business intelligence systems, as required, to deliver new systems functionality supporting corporate business objectives.
Responsible for software testing, database design, architecting, project management, source control, documentation and user training in support of the development team.
Exercise agile methodology with classic waterfall methods to emphasize an understanding of the full scope of the business requirements.
Utilize troubleshooting and advanced problem solving skills to provide advanced support to systems developed by others.
Design and develop Extraction, Transformation and Loading (ETL) processes using standard ETL tools to streamline and automate the collection of data from source systems, as well as the production and distribution of both ad-hoc and recurring reports.
Design and develop Teradata and Oracle Databases for data warehouse, data mart or decision support systems.
Perform Relational and Dimensional Data Modeling, preferably using Erwin/ER Studio.
Perform Teradata development.
Work with teammates to evaluate reporting requests, assess feasibility, develop prototypes, and implement a production/delivery plan.
Serve as a Subject Matter Expert for business processes that are supported by assigned systems/reports.
Facilitate changes into production through IT via established change management processes, SOX and CPNI.
Develop working knowledge of all data sources, research and analyze other data sources, as required, and work directly with senior management to define new reporting initiatives.
Participate in large-scale T-Mobile initiatives and projects to design new BI solutions.
Train and assist in the development of new employees.
Work through the entire Software Development Life Cycle with little supervision.
Required Skills and Experience:
5 years of Teradata and Teradata load utilities experience.
Good understanding of Teradata parallel architecture and its physical implementation
Strong ETL design and development experience
Experience developing Business Intelligence solutions using Microsoft BI Stack is a plus - SQL Server, SSAS, SSRS, and SSIS.
Experience designing and developing Oracle and/or SQL Server Databases for data warehouse, data mart or decision support systems.
Experience performing Relational and Dimensional Data Modeling.
Good data profiling and data analysis skills.
Should have good knowledge on Unix shell commands and basic knowledge on scripting (shell and perl)
Should have good knowledge on ETL performance tuning
Should have basic knowledge on reporting and OLAP.
Telecom experience a plus.
Good client interaction and communication skills.
For immediate consideration please contact:
Anu
UpStream Global Services.
Reply to: