Informatica IDQ

Job Description

Experience - 3- 5 Max CTC - 9.25 LPALocation - Bangalore/Hyderabad Notice - Candidate must join before 21st May Responsibilities Good knowledge of Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE). Good knowledge of admin activities associated with configuring IDQ and IDE. Good knowledge of at least one Address Validation and Cleansing tool (Address Doctor, Trillium, etc.). Good knowledge of at least one ETL tool (Informatica Power Center, Data Stage etc.). Good knowledge of DBMS concepts, SQL, PL/SQL, and Java (desired). Experience in integrating ETL tools with Informatica Data Quality. Experience in integrating IDQ with downstream and upstream applications through a batch/real-time interface. Experience working in at least three end-to-end implementations of IDQ solutions. Experience in fine tuning match/merge process and troubleshooting performance issues in IDQ. Good knowledge of data quality concepts, data quality trends and other tools in market. Good knowledge of data profiling and data monitoring concepts. Good knowledge and experience in implementing SSO and SSL in informatica Managing the DEV/QA/UAT/PROD environments with High Availability. Build Informatica Data Exchange/Data Transformation (DX/DT) and Data Quality environments for various POCs or setting up the environments if required Perform Informatica Power Center 10.x System Administration and Power Exchange System Administration including Team Based Development administration Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using Control-M or AutoSys Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language Support multiple Informatica environments, production and development Support development teams with performance tuning and troubleshooting issues Handle day to day Informatica components migration tasks Scheduling and Monitoring Informatica repository backups Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed Scheduling jobs through Autosys/Control M for monthly and daily job cycles Creating new repositories from scratch, backup and restore On Call Support as required during the week ends and off hours Scheduling real time system jobs Root Cause analysis for ETL job failures/Data issues raised by business End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes.Senior Informatica Developer - No . of Position - 3Experience - 4.5- 8 Max CTC - 13 LPALocation - Bangalore/Hyderabad Notice - Candidate must join before 21st May REQUIRED TECHNICAL SKILL SET Must have : Informatica ETL, Oracle, Teradata, UNIX, Control-M, IDQ Nice to have : SSIS, SSRS, Tableau Responsibilities 1. Hands on Experience Informatica PowerCenter 10 and above version. 2. Provide technical knowledge of Extract/Transform/Load (ETL) solutions for Business Intelligence projects 3. Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end-to-end designs meet the business and data requirements. 4. Develop the task plan for ETL developers for a specific project. 5. Proficient with a database SQL language for user defined database extract or update statements. SQL and database skills are the two great building blocks for ETL work. 6. Experience in scheduling tools (Control M ) 7. Good understanding of performing file level verification tasks via UNIX Shell scripts and command-line utilities etc. 8. Ensure the ETL code delivered is running, conforms to specifications and design guidelines 9. Unit testing ETL code to ensure it can be delivered and run in a system testing environment. 10. Help with the analysis of issues raised during QA/UAT/PROD phases and Data Reconciliation 11. Onsite communications and co-ordination with clients on business requirements created 12. Good understanding of data mapping, data validation, data manipulation, and data analysis use cases. Key Skills: Informatica with IDQ - No. of position - 3 Experience - 3- 5 Max CTC - 9.25 LPALocation - Bangalore/Hyderabad Notice - Candidate must join before 21st May Responsibilities Good knowledge of Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE). Good knowledge of admin activities associated with configuring IDQ and IDE. Good knowledge of at least one Address Validation and Cleansing tool (Address Doctor, Trillium, etc.). Good knowledge of at least one ETL tool (Informatica Power Center, Data Stage etc.). Good knowledge of DBMS concepts, SQL, PL/SQL, and Java (desired). Experience in integrating ETL tools with Informatica Data Quality. Experience in integrating IDQ with downstream and upstream applications through a batch/real-time interface. Experience working in at least three end-to-end implementations of IDQ solutions. Experience in fine tuning match/merge process and troubleshooting performance issues in IDQ. Good knowledge of data quality concepts, data quality trends and other tools in market. Good knowledge of data profiling and data monitoring concepts. Good knowledge and experience in implementing SSO and SSL in informatica Managing the DEV/QA/UAT/PROD environments with High Availability. Build Informatica Data Exchange/Data Transformation (DX/DT) and Data Quality environments for various POCs or setting up the environments if required Perform Informatica Power Center 10.x System Administration and Power Exchange System Administration including Team Based Development administration Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using Control-M or AutoSys Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language Support multiple Informatica environments, production and development Support development teams with performance tuning and troubleshooting issues Handle day to day Informatica components migration tasks Scheduling and Monitoring Informatica repository backups Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed Scheduling jobs through Autosys/Control M for monthly and daily job cycles Creating new repositories from scratch, backup and restore On Call Support as required during the week ends and off hours Scheduling real time system jobs Root Cause analysis for ETL job failures/Data issues raised by business End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes.Senior Informatica Developer - No . of Position - 3Experience - 4.5- 8 Max CTC - 13 LPALocation - Bangalore/Hyderabad Notice - Candidate must join before 21st May REQUIRED TECHNICAL SKILL SET Must have : Informatica ETL, Oracle, Teradata, UNIX, Control-M, IDQ Nice to have : SSIS, SSRS, Tableau Responsibilities 1. Hands on Experience Informatica PowerCenter 10 and above version. 2. Provide technical knowledge of Extract/Transform/Load (ETL) solutions for Business Intelligence projects 3. Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end-to-end designs meet the business and data requirements. 4. Develop the task plan for ETL developers for a specific project. 5. Proficient with a database SQL language for user defined database extract or update statements. SQL and database skills are the two great building blocks for ETL work. 6. Experience in scheduling tools (Control M ) 7. Good understanding of performing file level verification tasks via UNIX Shell scripts and command-line utilities etc. 8. Ensure the ETL code delivered is running, conforms to specifications and design guidelines 9. Unit testing ETL code to ensure it can be delivered and run in a system testing environment. 10. Help with the analysis of issues raised during QA/UAT/PROD phases and Data Reconciliation 11. Onsite communications and co-ordination with clients on business requirements created 12. Good understanding of data mapping, data validation, data manipulation, and data analysis use cases.,

Keyskills :
end of liferoot cause analysissource system analysisinformatica power centerbusiness intelligence projectsetl tooletl toolsroot causeunit testing