Job Description :
Job Title: Data Architect
Location: Fort Washington, PA
Duration : 6 month contract to hire
Interview: Face to face
Must be EAD GC, GC or Citizen

Our client in the Fort Washington, PA area is looking for a Data Architect for a full time role via a 6 month contract to hire.
Position Description
Data Architect provides thought leadership and hands-on engagement to develop, direct and implement innovative technology and business solutions. This role will focus on the data architecture in an environment with Oracle, SQL Server, Amazon Redshift and PostgreSQL and moving the legacy environment to the AWS
MUST HAVE
5+ years Database Architecture experience in an enterprise environment with strengths in 2-3 of the following: Oracle, SQL Server, Amazon Redshift and PostgreSQL
Experience in Cloud Data Warehouse implementations (preferably AWS)
Essential Functions:
Take ownership of development tasks and/or projects to see that -whatever it takes- is done to accomplish goals on time and within budget
Planning the different stages of projects/resources and coordinating with offshore project teams
Interact with client business and technical teams to understand the requirements and nuances around data and processes
Ensure sufficient quality to meet needs of client teams
Design and implement DWH project as per requirements
Assist with documentation of tasks and processes for business and technical teams
REQUIREMENTS:
Minimum Bachelor''s degree in Engineering
8-10 years of total experience
Hands on experience in developing ETL processes using ETL tools or through programming
Strong knowledge of data warehousing concepts
Experience in working with various IT and business teams to analyze ETL mapping requirements in the data warehouse, data marts or operational systems
Experience with complex data processing logic, data cleansing and error handling
Working experience in Cloud Data Warehouse implementations
Experience in working with Amazon Redshift databases
Strong knowledge of Data Integration and Data Warehouse architecture, requirement analysis, design, development and testing using various SDLC processes (Waterfall model, Agile)
Strong experience of database development and data modelling (relational and dimensional data modeling)
Advanced level of expertise in Informatica Power center 7x/8x/9x and Informatica Cloud application development and performance tuning
Strong experience of Oracle SQL and PL - SQL programming and performance tuning
Proficiency in Amazon web services (Redshift/EC2/EMR/S3), Unix shell scripting, Talend 6.X
Should have experience in working on data sources and MDM tools
Should be strong in writing complex SQL queries