Sr Informatica Consultant

1. Informatica PowerCenter: Proficiency in designing developing and deploying ETL processes using Informatica PowerCenter tool. This includes knowledge of various components such as PowerCenter Designer Workflow Manager Workflow Monitor and Repository Manager.
   

2. Data Integration: Strong understanding of data integration concepts and methodologies including ETL (Extract Transform Load) processes data warehousing principles data migration and data synchronization.
   

3. SQL and Relational Databases: Proficient in writing complex SQL queries stored procedures and triggers. Experience working with relational databases such as Oracle SQL Server MySQL or DB2.
   

4. Data Modeling: Familiarity with data modeling techniques and tools to design data structures define relationships and ensure data integrity. Knowledge of dimensional modeling concepts for data warehousing is a plus.
   

5. Data Profiling and Cleansing: Ability to perform data profiling to analyze data quality issues identify anomalies and assess data completeness. Experience in data cleansing and transformation to improve data quality.
   

6. Performance Tuning: Skills in optimizing ETL workflows and SQL queries for performance and efficiency. This includes tuning database configurations query optimization and parallel processing techniques.
   

7. Scripting Languages: Knowledge of scripting languages such as Python Shell scripting or PowerShell for automation data manipulation and integration tasks.
   

8. Version Control Systems: Experience with version control systems like Git or SVN for managing code repositories tracking changes and collaboration with other team members.
   

9. Operating Systems: Understanding of operating systems such as Unix/Linux and Windows including shell commands file systems and basic system administration tasks.
   

10. Data Analysis and Reporting: Familiarity with data analysis and reporting tools like Tableau Power BI or QlikView for creating dashboards visualizations and reports based on integrated data.
    

11. Data Security and Compliance: Knowledge of data security best practices privacy regulations (e.g. GDPR CCPA) and compliance standards in handling sensitive data.
    

Informatica PowerCenter: Proficiency in designing, developing, and deploying ETL processes using Informatica PowerCenter tool. This includes knowledge of various components such as PowerCenter Designer, Workflow Manager, Workflow Monitor, and Repository Manager. Data Integration: Strong understanding of data integration concepts and methodologies including ETL (Extract, Transform, Load) processes, data warehousing principles, data migration, and data synchronization. SQL and Relational Databases: Proficient in writing complex SQL queries, stored procedures, and triggers. Experience working with relational databases such as Oracle, SQL Server, MySQL, or DB2. Data Modeling: Familiarity with data modeling techniques and tools to design data structures, define relationships, and ensure data integrity. Knowledge of dimensional modeling concepts for data warehousing is a plus. Data Profiling and Cleansing: Ability to perform data profiling to analyze data quality issues, identify anomalies, and assess data completeness. Experience in data cleansing and transformation to improve data quality. Performance Tuning: Skills in optimizing ETL workflows and SQL queries for performance and efficiency. This includes tuning database configurations, query optimization, and parallel processing techniques. Scripting Languages: Knowledge of scripting languages such as Python, Shell scripting, or PowerShell for automation, data manipulation, and integration tasks. Version Control Systems: Experience with version control systems like Git or SVN for managing code repositories, tracking changes, and collaboration with other team members. Operating Systems: Understanding of operating systems such as Unix/Linux and Windows, including shell commands, file systems, and basic system administration tasks. Data Analysis and Reporting: Familiarity with data analysis and reporting tools like Tableau, Power BI, or QlikView for creating dashboards, visualizations, and reports based on integrated data. Data Security and Compliance: Knowledge of data security best practices, privacy regulations (e.g., GDPR, CCPA), and compliance standards in handling sensitive data.