Previous Job
Solution Architect ETL/Providence, RI 4 yr+ contract (NTTJP00006537)
Ref No.: 18-01184
Location: Providence, Rhode Island
Position Type:Contract
Visa Required: US Citizen, GC, EAD-GC only No H1B or Opt's 
Solution Design:
Work closely with client business and technical groups to understand business needs, provide oversight, identify architectural options, evaluate options against the overall enterprise, and make recommendations that return analytic business value. Collaborate with internal business clients, Source systems owners, Business Analysts, and Data Architect. Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment  
Systems Design: Provide leadership in systems design and development from business requirements analysis through implementation. Ability to articulate technical specifications, business requirements and systems specifications. Interpret requirements into software architecture and design  
Technical Leadership: Lead solution design and development on implementations, migrations/upgrade projects and performance improvements for existing environments. Provide technical direction for the design, development, testing, implementation and maintenance of data warehouse solutions. Interface daily with multi-functional team members within the EDW team. The Solution Architect is expected to drive technology decisions, product specifications, and operational processes. Research and provide recommendations for a database technology roadmap, including cloud, on premise, and hybrid solutions. Active engagement in data intensive projects. Responsible for the strategy, design, execution of the logical & physical data architecture of core enterprise data solutions.  
Technical skills in the following: Database - Knowledge of Data Warehouse best practices, Netezza, Oracle, SQL Server, Hadoop, and IBM DataStage. Hands on Big Data Experience (Hadoop, Spark, Hive, etc) ETL - Hands on ETL experience (i.e, Informatica/Data Stage). Capable of designing, implementing, supporting, and analyzing enterprise scale database solutions that perform extract/transform/load (ETL) operations with internal and external data sources. Provide guidance direction on data conversion, data migration, data quality database performance.