Database Architect

Role Purpose: -

The purpose of the role is to support process delivery by ensuring daily performance of the Production Specialists, resolve technical escalations and develop technical capability within the Production Specialists.

Job Description:-

15+ years experience of the full software development lifecycle on BI projects and support experience.

• 10+ years experience on working on data objects pertaining both master and transactional data in Purchasing, Material, Sales Orders and Supply chain in SAP & Oracle ERP is mandatory
• 8+ years in Dimensional Data modelling experience (STAR & Snowflake)
• Expertise in AWS services such as Redshift, Database Migration Service, Glue, S3, and Schema Conversion Tool.
• Any one data modeling tool experience is mandatory (Erwin or any other tool)
• Need to be strong in SQL query writing and procedures
• Experience in following components (or similar):
• BI tools: Tableau, Oracle Business Intelligence, PowerBI…
• ETL tools: Informatica PowerCenter, PL/SQL, IICS…
• Data bases: RedShift, Oracle, PostgreSQL, Exasol,…
• Other: object-oriented programming language (python)
• Experience managing servers both Cloud and On-prem (ideally experienced in AWS

͏

Deliver

NoPerformance ParameterMeasure1ProcessNo. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback, NSAT/ ESAT2Team ManagementProductivity, efficiency, absenteeism3Capability developmentTriages completed, Technical Test performance