Job ID :
32947
Company :
Internal Postings
Location :
Springfield, MA
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
16 Aug 2021
Job Seekers, Please send resumes to resumes@hireitpeople.com
Must Have Skills:
  • Informatica
  • SQL
  • Databases
Detailed Job Description:
  • Around 8 years of experience in IT Software Development Life cycle involved in Business Requirements
  • Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing
  • applications in healthcare and retail domains.
  • Strong knowledge in ETL Informatica.
  • Proficient in T - SQL queries using Store Procedure, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL etc.
  • Strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by
  • reviewing PLSQL code, modifying database parameters.
  • Good understanding of ETL, D Writing scripts in Unix to process source files, target files, to automate the email notifications, Archive the
  • files, copy, ftp and cleanse the files to process in ETL.
  • Extensive experience in creating documents for Low level and High-level design docs, Unit test plans, test cases and test scripts.
  • Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts Good communication and interaction with client.
Minimum years of experience required: 8+