Data Modeler - OLAP/OLTP |Multiple Locations |6+Yrs

• Should have hands-on experience in relational, dimensional, and analytic data modeling using RDBMS, dimensional, SQL, PL/SQL, NoSQL data platform technologies, and ETL and data ingestion protocols.
• Should have strong knowledge in creating the data model for OLAP and OLTP systems.
• Strong knowledge of Database Architecture, normalization concepts, and NFR requirements
• Good Hands-on expertise in data modeling tools (e.g. Power Designer, Erwin, ER/Studio)
• Hands-on expertise in creating Conceptual, Logical Data models and Physical data models Using ERWIN/ER Studio.
• Experience with data warehouse, Data Lake, and enterprise big data platforms.
• Experience on RDBMS platforms (e.g. Redshift, SQL Server, Oracle, Teradata, Snowflake, Postgres)
• Must have hands-on experience on implementing data models on AWS Redshift along with other AWS cloud solutions services including S3, Glacier, RDS, Athena, DynamoDB etc.
• Experience working with extracting business rules to develop transformations, data lineage, metadata, and data catalogue.

Nice-to-have skills :

• Azure Cloud certification
• Unix or Shell scripting
• Strong delivery background across the delivery of high-value, business-facing technical projects in major organizations