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

Job Duties:

• Work as Senior developer to improve performance for an average of approx. 30000 providers for each state with more than 200 business rules applied 
• Determine specific business application software requirements to address complex and varied business needs. 
• Analyse and designs solutions to address complex and varied business needs. 
• Consult with business partners concerning the application and implementation of technology. 
• Work on agile methodology to complete task 
• Analyse requirement and propose technical solution to meet client requirement 
• Utilize Resource Advisor and CBMS expertises. 
• Utilize FACETS expertise and provide training to business team members 
• Prepare a timeline and Level of Effort for the project. 
• Engineer data acquisition and integration process by using Informatica, SQL, Oracle, FACET application 
• Conduct technical Interviews and Identify resources to develop internal applications. 
• Code review using BItBucket and GitHub tool 
• Create relational Conceptual, logical and physical model and dimensional model star/snowflake schema using Embarcadero's ER Studio, Microsoft VISIO, and SQL Server Diagram. 
• Integrate data from disparate data sources into the single star schema or snowflake schema and identify points to use, design, and populate aggregate tables. 
• Develop complex business logic using SQL , Azure and Splunk for reporting purpose 
• Code review using BItBucket and GitHub tool 
• Perform tuning of queries using SQL Profile and existing advance version command with help of RED GATE tool expertise. 
• Work on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. 
• Design high-level specifications to simple ETL coding and mapping standards. 
• Create technical documentation and present to client for approval  
• Train junior team members and guide them throughout the process 
• Design and customize data models for Data warehouse supporting data from multiple sources in real-time 
• Involve in building the ETL architecture and Source to Target mapping to load data into the Data warehouse. 
• Create mapping documents to outline data flow from sources to targets. 

Education: The minimum qualification required for the performance of the above specialty occupation duties is a bachelor's degree or equivalent in Computer Science or equivalent in a related field or a foreign equivalent is required closely related field with relevant experience.