Sony Company Job Vacancy In Bangalore – Data Architect Job – Job For Freshers

Preferred:          

• Prior experience with designing, developing, and supporting solutions using Elastic Map Reduce, Managed Kafka, Kinesis, Glue, Firehose, S3
• Prior experience with designing, developing, and supporting solutions using database technologies like MySQL, PostgreSQL, Cassandra, Oracle is a big plus
• Prior Experience with Power BI development delivering complex reports, and query optimization is a plus

• The candidate is responsible for the data workload management, capacity management, database & data warehouse tuning, designing, and creating data schemas & objects adding users, groups, and other administrative tasks.
• Modelling the structure and content of the feeds from the various feeder systems
• Modelling the structure of the data warehouse, data mart and transactional databases
• Assessing design influencing parameters like normalization, de-normalization, most executed transactions, record count, data size, I/O parameters at the database and OS level in the database and table designs
• Maintaining a catalog of meta-data, master data, transactional and reference data
• Tune the transactions and queries and determine the use of appropriate client libraries and fetch mechanism (like query vs stored procedures)
• Design the system for resilience, fail-over, self-healing and institute rollback plans
• Develop and profile queries, triggers, indices and stored procedures