Data Modeler
Location: Las Vegas
12 months Contract
Job Description:
- 5 years of experience in Data Modeling & Data Analyst and should have excellent communication and leadership skills.
- Financial Domain knowledge is plus.
- Should have strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0.
- Should have in-depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources / tools such as Hive S3 Icimo HUE etc
- Should have done complex (100 entities/tables) Data Modeling programs in both on-prem and cloud environments.
- Experience in designing normalized denormalized relational dimensional star and snowflake schemas for cloud big data and on prem databases using any one of these data modeling tools (Erwin ER/Studio Toad Data Modeler etc)
- Extensive Data Modeling experience in same or similar big data and cloud databases such as Hive Redshift Snowflake and on prem databases such as Oracle SQL Server and DB2
- Should have experience in working with product managers project managers business users applications development team members DBA teams and Data Governance team on a daily basis to analyze requirements design development and deployment technical solutions.
- Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
- Should have in-depth understanding on Data Warehousing Data Analysis Data Profiling Master Data Management (MDM) Data Quality Data Lineage Data Dictionary Data Mapping Data Policy and Data Governance.
- Need to have at least 2 hours overlap with Pacific Timings to interact with Onsite team and to attend daily standup meetings.
- Nice to have knowledge of SSIS ETL packages / Need to analyze and troubleshooting these packages.
- Analyze legacy ETL packages built in SSIS and convert them to ELT logic.
- Handling of various sources like RDBMS Files like Flatfile Json Realtime Kafka messages.