Job Title

We’re Hiring: Data Architect @ Emids TechnologiesKey responsibilities:- Design end-to-end data architecture supporting OLTP systems, ODS layers, and downstream data warehouses. - Architect ODS solutions to serve as a bridge between real-time transactional systems and analytical platforms. - Develop and optimize relational data models in PostgreSQL and DB2 aligned to business needs. - Define data modeling standards, schema designs, and partitioning/indexing strategies for transactional and ODS workloads. - Implement & maintain data dictionary , ensure data lineage & traceability. - Ensure data consistency, normalization, and integrity across heterogeneous systems. - Collaborate with business, data engineering, and analytics teams to align OLTP and ODS architecture.Required skills:- Experience in data architecture across OLTP and analytical systems. - Deep hands-on expertise in AWS Aurora PostgreSQL and RDS PostgreSQL. - Deep hands-on experience in AWS IAM, PostgreSQL role, and setup integration between the both. - Understanding with IBM DB2 (LUW or z/OS) including schema design. - Proven experience designing and implementing ODS and data warehouses (Snowflake, Redshift, etc.). - Strong SQL, ETL architecture, and data integration experience. - Familiarity with data warehousing principles, slowly changing dimensions, and dimensional modeling (Kimball/Inmon). - Hands-on with AWS data services: DMS, Glue, S3, Lambda, CloudWatch. - Knowledge of data governance, data quality, and compliance practices.