Data Architect --- Only W2; NO C2C

Role: Data Architect

Location: Dallas, TX (On-Site)

Duration: 6-12 months with multiple extensions

Required skills

Data Architect

Data modeler

Databricks and Iceberg. BI Designing

Nice to Have Skills

• Strong technical skills with Snowflake and Databricks with hands-on experience
• Understanding of Data Modelling and Data Architecture
• Understanding of AWS
• Strong SQL background

Job Description

Leads and builds data modernization and transformation solutions. The Application Architect Data Modernization will work with technical leads, database administrators, and database developers to provide recommendations and solutions for like-for-like data migrations at scale, Extract/Transform/Load (ETL) activities for multiple data and database technologies, such as:

• Oracle to PostgreSQL
• Oracle to SQL Server as a Service
• Relational to NoSQL
• Data Warehouse to Data Lake solutions
• Indexed file systems to database management systems
• Data transformation of business rules between COTS systems

Responsibilities

• Transform business requirements into technical specifications
• Develop prototypes and proof of concepts for specified business challenges
• Assist clients in architecting scalable, highly available data migration solutions leveraging cloud technologies
• Utilize agile development methodologies

Expected Knowledge and/or Experience

Focus on Data ETL activities with knowledge and/or experience in:

• RDBMS: Oracle, PostgreSQL, SQL Server, Amazon RDS, etc.
• Data Lake technologies
• Data Transformation tools:
  • IBM InfoSphere DataStage
  • Informatica PowerCenter
  • Microsoft SSIS
  • Oracle Data Integrator
• XML
• JSON
• NoSQL
• Python