Careers

Sr.Data Architect

Years of Experience: 
7-10 Years
Skills Stack: 
SQL Server, Oracle, PostgreSQL, MongoDB, Cassandra, BI: Redshift/PowerBI, Redgate
Shift Timings: 
12:30 pm - 9:30 pm
Role and Responsibility Details: 

Required Technical Stack:

" RDMS: Oracle, SQL Server, PostgreSQL

" MongoDB, Cassandra

" BI: Redshift/PowerBI

" Redgate suite 

" Version Control - JIRA, Git, TFS.

Desired Skills and Experience

" Seven or more years of experience with data warehousing and business intelligence and/or large and complex database management systems

" Database structure principles

" Experience gathering and analyzing system requirements

" Knowledge of data mining and segmentation techniques

" Expertise in SQL Server and Oracle

" Proficiency in MS Excel

" Familiarity with data visualization tools (e.g. Tableau, D3.js and R)

" Proven analytical skills

" Problem-solving attitude

" BSc in Computer Science or relevant field

Responsibilities:

" Participates in the design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).

" Focuses on enterprise-wide data modeling and database design.

" Creates logical and physical data models, mapping logical to physical.

" Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.

" Coordinates with other Data Warehouse IT stakeholders to ensure overall health and performance of the data warehouse environment. 

" Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools. 

" Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment.

" Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products.

Job Description: 

Required Technical Stack:

" RDMS: Oracle, SQL Server, PostgreSQL

" MongoDB, Cassandra

" BI: Redshift/PowerBI

" Redgate suite 

" Version Control - JIRA, Git, TFS.

Desired Skills and Experience

" Seven or more years of experience with data warehousing and business intelligence and/or large and complex database management systems

" Database structure principles

" Experience gathering and analyzing system requirements

" Knowledge of data mining and segmentation techniques

" Expertise in SQL Server and Oracle

" Proficiency in MS Excel

" Familiarity with data visualization tools (e.g. Tableau, D3.js and R)

" Proven analytical skills

" Problem-solving attitude

" BSc in Computer Science or relevant field

Responsibilities:

" Participates in the design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).

" Focuses on enterprise-wide data modeling and database design.

" Creates logical and physical data models, mapping logical to physical.

" Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.

" Coordinates with other Data Warehouse IT stakeholders to ensure overall health and performance of the data warehouse environment. 

" Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools. 

" Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment.

" Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products.

Qualifications: 
B.E.,BCA,BCS,MCA,MCM,MCS
Locations: 
Pune- Pyramid
Contact: 
Recruitment Team
Email: tdg-recruitment@thedigitalgroup.com