- 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.
-
Sr Informatica Consultant
4 days ago
ATRIBS METSCON Group Abu Dhabi, United Arab EmiratesInformatica 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 Integratio ...
-
Big Data Administrator
1 week ago
CLEARPEAKS Abu Dhabi, United Arab EmiratesClearPeaks is a leading BI, Big Data, Data Science & Analytics consulting firm, established in year 2000 and operating in global customers across the EU, USA, and Middle East. · Due to our constant growth and expansion both regionally and technologically, we are looking for talen ...
-
Mechanical Engineering
1 week ago
ghd Abu Dhabi, United Arab EmiratesConsultant - Data ETLDevelopment · location - Hyderabadexperience - 3-5years · mustExperience - Databases Tools: SQL, Oracle,Snowflake, etc. ETL Tools: Informatica(preferred), SAP DS, FiveTran (at least one)Cloud platform: AWS,Azure · Jobdescription The Consultant is a key play ...
-
Mechanical Engineering
6 days ago
ghd Abu Dhabi, United Arab EmiratesConsultant - Data ETL Development · location - Hyderabad experience - 3-5 years · must Experience - Databases Tools: SQL, Oracle, Snowflake, etc. ETL Tools: Informatica (preferred), SAP DS, FiveTran (at least one) Cloud platform: AWS, Azure · Job description The Consultant is a ...
-
Mechanical Engineer
6 days ago
Woopel Abu Dhabi, United Arab EmiratesConsultant - Data ETL Development · location - Hyderabadexperience - 5-8 years · must Experience - Databases Tools: SQL, Oracle, Snowflake, etc. ETL Tools: Informatica (preferred), SAP DS, FiveTran (at least one) Cloud platform: AWS, Azure · Job descriptionThe Senior Consultant ...
Sr Informatica Consultant - Abu Dhabi, United Arab Emirates - ATRIBS METSCON GROUP
Description
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.