DEFTeam Solutions Inc

• Looking for US Citizens or GC holder or H1 visa in Boston Downtown area (No sponsorships available).

Database Architect (DA) will be responsible for designing a dimensional Datawarehouse that can provide optimized information for Data visualization that can be further integrated to AI for natural language queries. DA will be maintaining, securing, and operating databases and ensures data is accessible, accurate, and protected, while optimizing performance and managing backups.

Key Responsibilities:

· Having 10+ years of experience in designing and implementing Datawarehouse solutions.

· Leading data migration initiatives to cloud platforms like Snowflake and ensuring smooth integration of data lakes, data warehouses, and distributed systems on Cloud (AWS/Azure).

· Must have hands on experience in Data modelling and Datawarehouse design and should be familiar with data modelling tools like Erwin or similar

· Able to handle different databases like Oracle, SQL Server and Snowflake

· Must be hands on with SQL and PL/SQL is required.

· Must have good understanding of Metadata management, Database schema creation and management and Data Integrity and Data quality concepts

· Experience in customer-facing roles to provide data related Solutions for Data use cases.

· Good understanding on OLTP and OLAP data models is required.

· Good understanding on monitoring and Performance Tuning and optimization.

· Excellent communication & leadership skills

Required Skills:

• Languages – Java, Python
• AWS - Glue, Azure – ADF, Synapse,
• Snowflake
• ETL – Informatica/SSIS

Location: Boston Downtown

Initial contract for 4 to 5 months on 1099 or C2C later will be absorbed by the DEFTeam based on the performance of the candidate

Working Model- It is onsite opportunity should work from office

Client Name: State of MA

Education Qualification: Graduation in computer sciences & Masters in Computer sciences or Management would be an added advantage.

For more details about the organization pls logon to www.defteam.com

Job Type: Contract

Pay: $60.00 - $70.00 per hour

Expected hours: 40 per week

Application Question(s):

• should work on data warehouse project min 5+ years
• Data Architect exp for 10+ years

Education:

• Bachelor's (Preferred)

Ability to Commute:

• Boston, MA 02114 (Preferred)

Work Location: In person