Sr Informatica Consultant - Abu Dhabi, United Arab Emirates - ATRIBS METSCON GROUP

    ATRIBS METSCON GROUP
    ATRIBS METSCON GROUP Abu Dhabi, United Arab Emirates

    1 week ago

    Default job background
    Description
    1. InformaticaPowerCenter: Proficiency in designing developing anddeploying ETL processes using Informatica PowerCenter tool. Thisincludes knowledge of various components such as PowerCenterDesigner Workflow Manager Workflow Monitor and RepositoryManager.
    2. DataIntegration: Strong understanding of data integrationconcepts and methodologies including ETL (Extract Transform Load)processes data warehousing principles data migration and datasynchronization.
    3. SQLand Relational Databases: Proficient in writing complexSQL queries stored procedures and triggers. Experience working withrelational databases such as Oracle SQL Server MySQL orDB2.
    4. DataModeling: Familiarity with data modeling techniques andtools to design data structures define relationships and ensuredata integrity. Knowledge of dimensional modeling concepts for datawarehousing is aplus.
    5. DataProfiling and Cleansing: Ability to perform dataprofiling to analyze data quality issues identify anomalies andassess data completeness. Experience in data cleansing andtransformation to improve dataquality.
    6. PerformanceTuning: Skills in optimizing ETL workflows and SQLqueries for performance and efficiency. This includes tuningdatabase configurations query optimization and parallel processingtechniques.
    7. ScriptingLanguages: Knowledge of scripting languages such asPython Shell scripting or PowerShell for automation datamanipulation and integrationtasks.
    8. VersionControl Systems: Experience with version control systemslike Git or SVN for managing code repositories tracking changes andcollaboration with other teammembers.
    9. OperatingSystems: Understanding of operating systems such asUnix/Linux and Windows including shell commands file systems andbasic system administrationtasks.
    10. DataAnalysis and Reporting: Familiarity with data analysisand reporting tools like Tableau Power BI or QlikView for creatingdashboards visualizations and reports based on integrateddata.
    11. DataSecurity and Compliance: Knowledge of data security bestpractices privacy regulations (e.g. GDPR CCPA) and compliancestandards in handling sensitivedata.


    Informatica PowerCenter: Proficiency in designing, developing, anddeploying ETL processes using Informatica PowerCenter tool. Thisincludes knowledge of various components such as PowerCenterDesigner, Workflow Manager, Workflow Monitor, and RepositoryManager. Data Integration: Strong understanding of data integrationconcepts and methodologies including ETL (Extract, Transform, Load)processes, data warehousing principles, data migration, and datasynchronization. SQL and Relational Databases: Proficient inwriting complex SQL queries, stored procedures, and triggers.Experience working with relational databases such as Oracle, SQLServer, MySQL, or DB2. Data Modeling: Familiarity with datamodeling techniques and tools to design data structures, definerelationships, and ensure data integrity. Knowledge of dimensionalmodeling concepts for data warehousing is a plus. Data Profilingand Cleansing: Ability to perform data profiling to analyze dataquality issues, identify anomalies, and assess data completeness.Experience in data cleansing and transformation to improve dataquality. Performance Tuning: Skills in optimizing ETL workflows andSQL queries for performance and efficiency. This includes tuningdatabase configurations, query optimization, and parallelprocessing techniques. Scripting Languages: Knowledge of scriptinglanguages such as Python, Shell scripting, or PowerShell forautomation, data manipulation, and integration tasks. VersionControl Systems: Experience with version control systems like Gitor SVN for managing code repositories, tracking changes, andcollaboration with other team members. Operating Systems:Understanding of operating systems such as Unix/Linux and Windows,including shell commands, file systems, and basic systemadministration tasks. Data Analysis and Reporting: Familiarity withdata analysis and reporting tools like Tableau, Power BI, orQlikView for creating dashboards, visualizations, and reports basedon integrated data. Data Security and Compliance: Knowledge of datasecurity best practices, privacy regulations (e.g., GDPR, CCPA),and compliance standards in handling sensitive data.