Manual Testing +P&C

Mumbai - India

Monthly Salary: Not Disclosed

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

Mandatory questions to be asked before sharing the profile

SDLC in Informatica PowerCenter:Planning/Design/Development/Testing/Deployment/Maintenance.
Strong hands on INFA Power Cen) tre
XMLs/Flat files as Source and Target in Informatica PowerCenter. (we need use XSD files)
Deployments of Informatica code from Non-Prod to PROD: Static and Dynamic Deployment Groups.
Informatica architecture : Service-Oriented Architecture (SOA).
Production Support experience : ServiceNow/ tickets/
ETL Testing: Unit testing/ Regression testing(It is a testing technique to make sure that the existing product works fine with new functionality bug fixes or any change in the existing feature)

JD:

Must have at least 6 Years of working experience in ETL Informatica tools.
Responsible for designing developing and maintaining complex data integration solutions using Informatica tools using Informatica PowerCenter10.x and IDMC.
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.
Hands on experience in IICS and IDQ.
Extensive experience in developing Stored Procedures Views Complex SQL queries using SQL Server and Oracle PL/SQL.
Gather the requirements from the business and create detailed technical design documents and model data flows for complex ETL processes using Informatica PowerCenter
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 XMLFlat 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

Location: Noida /Pune / Bangalore /Chennai/Mumbai

Budget: 25 LPA

Only immediate joiners with good comm skills are required.

Experience : 6 to 9 yrs

Mandatory questions to be asked before sharing the profile SDLC in Informatica PowerCenter:Planning/Design/Development/Testing/Deployment/Maintenance. Strong hands on INFA Power Cen) tre XMLs/Flat files as Source and Target in Informatica PowerCenter. (we need use XSD files) Deployments of I...

Mandatory questions to be asked before sharing the profile

SDLC in Informatica PowerCenter:Planning/Design/Development/Testing/Deployment/Maintenance.
Strong hands on INFA Power Cen) tre
XMLs/Flat files as Source and Target in Informatica PowerCenter. (we need use XSD files)
Deployments of Informatica code from Non-Prod to PROD: Static and Dynamic Deployment Groups.
Informatica architecture : Service-Oriented Architecture (SOA).
Production Support experience : ServiceNow/ tickets/
ETL Testing: Unit testing/ Regression testing(It is a testing technique to make sure that the existing product works fine with new functionality bug fixes or any change in the existing feature)

JD:

Must have at least 6 Years of working experience in ETL Informatica tools.
Responsible for designing developing and maintaining complex data integration solutions using Informatica tools using Informatica PowerCenter10.x and IDMC.
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.
Hands on experience in IICS and IDQ.
Extensive experience in developing Stored Procedures Views Complex SQL queries using SQL Server and Oracle PL/SQL.
Gather the requirements from the business and create detailed technical design documents and model data flows for complex ETL processes using Informatica PowerCenter
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 XMLFlat 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