Estimated Length: 24 months Full-Time 8 working hours plus a lunch break.  Daily start time must be between 7:00 and 8:30, and end time between 3:30 and 5:00.  Once selected, the start and end times should not vary on a daily basis.  All work must be on site.

Mandatory Requirements

Senior 60-84 Months

Desired Requirements

• 72 Months       Demonstrated experience using Informatica 8.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings, and merging data from multiple source systems including but not limited to ORACLE and flat files.
• 36 Months    Demonstrated experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge with IDQ 8.x or higher.
• 60 Months    Demonstrated work experience implementing Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI)
• 60 Months   Demonstrated Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica.   
• 60 Months Demonstrated experience writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows
• 60 Months    Demonstrated experience converting complex SQL, PL/SQL (stored procedures/functions), as well as SAS code with Oracle  9i, 10g or higher, to Informatica mappings  
• 72 Months    Demonstrated experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
• 60 Months      Demonstrated Experience in Dimensional Data Modeling for creating logical and physical data models.
• Bachelor’s degree in computer science, information science, engineering, or mathematics. 

Responsibilities

• Work in conjunction with the project data migration lead to conduct data analysis of both current and to-be WIC systems, in order to maintain an understanding of current and future needs
• Collaborate with customers, vendors, and technical workgroups to identify and document data and reporting requirements, reporting processes, gap analysis, and prioritization of reporting needs.
• Create documents describing business flow and function using flow charts and data/process models describing these business functions.
• Develop ETL mappings for migration of data from SYBASE, MS ACCESS to Oracle
• Create report and dashboard prototypes
• Participate in development of solutions to meet end user reporting requirements
• Develop data test protocols, including test plans, creation and execution of test scripts, scenarios, and test plans that validate initial business requirements. Test report accuracy and document test results.
• Evaluate implementation strategies and document issues requiring resolution
• Schedule, facilitate, and record report development meetings as needed.

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer