Sub-K / Lead Data Warehouse Architect

Lead Data Warehouse Architect

Job 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
    • Responsible for quality of data

Job Specifications:

    • Must have 5-7 years’ experience with data warehousing and business intelligence and/or large and complex database management systems, preferably in a financial institution
    • End-to-end to experience in handling minimum two DWH migration projects, one with Cloud DWH as source, AWS Redshift preferred
    • Preferred to have hands on experience of Amazon Redshift Architecture, with Pipeline knowledge to develop ETL preferably using AWS Glue for data movement to Redshift
    • Expertise with architecture and design of enterprise data driven applications while providing technical leadership for database design, OLTP and Data Warehouse implementations, with design, development process and coding standards
    • Deep knowledge of at least two database platforms
    • Experience with multiple OS platforms
    • Good familiarity with AWS and other enterprise IT environment with a dev-ops practice
    • Experience capturing and documenting business and technical requirements and existing architecture and creating future state implementation documents
    • Hands-on experience performing several of the following: backups, recovery, capacity planning, upgrades, job scheduling, performance tuning and troubleshooting in a database environment
    • Experience in product development and/or consulting delivery engagements is a big plus

Sub-K does not discriminate among candidates on grounds of gender, caste, religion, disability or sexual orientation

Job Type: Full Time
Job Location: Hyderabad

Apply for this position

Allowed Type(s): .pdf, .doc, .docx