Job ID :
32822
Company :
Internal Postings
Location :
Springfield, MA
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
09 Aug 2021
Job Seekers, Please send resumes to resumes@hireitpeople.com
Detailed Job Description:
  • 8+ Years of experience in Data warehousing, data analysis and data reporting tools in financial, insurance domains.
  • Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing reporting solutions that scale across a massive volume of structured and unstructured data.
  • Worked and extracted data from various database sources like Oracle, SQL Server, DB2, regularly accessing JIRA tool and other internal issue trackers for the Project development.
  • Strong Data Warehousing ETL experience in using Informatica 9.6.1/9.5/9.1/8.6/8.5/8.1/7.1/7.0 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
  • Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, Teradata and files like Flat files.
  • Good communication skills.

Minimum years of experience: 8+

Certifications Needed: No

Interview Process (Is face to face required?) No