Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have Skills (Top 3 technical skills only)*:

1. Data Modelling
2. Erwin
3. Healthcare knowledge

Nice to have skills (Top 2 only):

1. Data Modeling
2. Erwin

Detailed Job Description:

• Skillset Required:
• Relational DB's & Non - Relational DB's knowledge and hands on experience in data modeling
• DB2, Teradata, SQL Server, Hadoop (Hive) and NoSQL (HBase, MongoDB)
• Data Warehouse Knowledge & Experience ( ETL, BI usage )
• Nice to have API usage basics knowledge
• Data Modeling Experience (Dimensional modeling, 3NF - Star Schema and Snowflake schema )
• Basic Unix knowledge
• Healthcare / Life Science/Pharma domain knowledge

Minimum years of experience*: 5+

Certifications Needed: No

Responsibilities you would expect the Subcon to shoulder and execute*:

• 1) Updating and maintaining existing conceptual and logical data models to support new and existing projects
• 2) Creating new conceptual and logical data models with high efficiency to support new projects and initiatives
• 3) Performing reverse engineering of data models from databases and SQL scripts
• 4) Guide and lead JAD sessions when working with the business, SME’s, developers and IT business teams to build out data models.
• 5) Maintaining conceptual and logical data models along with corresponding metadata
• 6) Perform sql queries against database tables
• 7) Help build out and maintain the API data flows
• 8) Assist the Data Architecture team in building out the Enterprise Data Model (domains include but not limited to: Marketing, Group, Account, etc.)

Interview Process (Is face to face required?) Yes

Does this position require Visa independent candidates only? No