Job Ideaz Job No 1
Role: Informatica ETL Analyst
Location: Bala Cynwyd, PA
Experience: 10+ Years
Detail Job Description:
Must have at least 10+ years of working experience in ETL Informatica tools Analyst
Strong Data Warehousing ETL experience of using Informatica 10.x/9.5/8.6, HotFix 2. PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools –Informatica Server, Repository Server manager.
Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases.
Extensive experience in developing Stored Procedures, Views, Complex SQL queries using SQL Server and Oracle PL/SQL.
Gather the requirements from the business and created the ETL mapping documents.
Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documentation.
Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server,Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.
Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
Ability and experience in managing/ coordinating with Onshore-Offshore teams
Job Ideaz Job No 2
QA LEAD (Healthcare MMIS)
NJ (REMOTE)
Experience required:
Minimum of 5+ years of experience as QA lead
Experience in creation of test plan, test estimates, test schedules and implementing test strategies
Solid experience in writing SQL statements for data validations
Must have MMIS system experience
Ability to design, develop, test and debug tests cases/Scripts/plans/strategy documents
Minimum four (4) years’ experience working on project(s) involving the implementation of software development life cycle(s) (SDLC).
Preparation of Defect Status Reports and Daily/Weekly Status Reports.
Knowledge of Health Insurance Industry - Claims processing, PBM, ICD 9/10, Medicare, or Medicaid.
Knowledge of Azure and Confluence.
Document and interpret business and technical requirements for testing utilizing various development methodologies (e.g. Agile, Scrum, Iterative, Waterfall, etc.)
Extensive experience in Test Management tools building Test Plans and Test Cases using tools like JIRA, Xray and Azure DevOps (VSTS)
Hands on experience in Excel and Status Reports.
Effective communication skills to articulate testing result data to multiple audiences.
Command center Experience
Strong and effective inter-personal and communication skills and the ability to interact professionally with a diverse group of clients and team members
Job Ideaz Job No 3
Looking for below position
Job Title: Aws
Location: 100% Remote
Visa:- all
Client - discuss on phone
Phone number:-5713869274
