نبذة عني
Informatica MDM Developer at Cognizant with experience in real-time data integration, data quality management, and master data processing. Hands-on experience with Informatica PowerCenter, MDM Hub, IDD, SQL, PL/SQL, Apac…
Informatica MDM Developer at Cognizant with experience in real-time data integration, data quality management, and master data processing. Hands-on experience with Informatica PowerCenter, MDM Hub, IDD, SQL, PL/SQL, Apache Airflow, BigQuery, Hive, Hadoop, Spark, Python, and cloud fundamentals.
الخبرة
Informatica MDM Developer
Worked on Levi's-Eprise-MDM SS real-time data integration for Levi’s and Strauss master data.
Used Informatica PowerCenter, MDM Hub, IDD, MySQL server, and Shell.
Implemented base objects, staging tables, and landing tables to load data from upstream systems.
Implemented data quality processes and transformations within Informatica PowerCenter to cleanse, standardize, and enrich data.
Implemented foreign key relationships, static lookups, dynamic lookups, queries, and packages to achieve smooth data processing.
Used SQL and PL/SQL programming skills in Oracle/SQL Server databases.
Wrote packages, stored procedures, triggers, views, indexes, and query optimization.
Created IDD application and subject areas, subject area groups, deployed and tested IDD application, and worked with cleanse functions, export and import master data.
Informatica Developer
Levi's-Eprise-MDM SS - Real time Data Integration for Levi’s and Strauss Master data.
Informatica Powercenter, MDM Hub, IDD, MySQL server, Shell.
Implemeted the Base objects, Staging tables, Landing tables to load the data from Upstreams
systems.
Data Quality Management : Implemented data quality processes and transformations within
informatica PowerCenter to cleanse, standardize, and enrich data, ensuring its accuracy and
consistency across systems.
Implemented foreign key relationships, static lookups, dynamic lookups, queries, packages to
achieve smooth data processing.
Strong SQL, PL/SQL programming skills in Oracle/SQL Server databases. Proficient inwriting
packages, Stored Procedures, Triggers, Views, Indexes and query optimization.
Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application,
cleanse functions, export and import master data.
Big Data/GCP Internship
Worked on CHN Campus Interns project involving Big Data, Hadoop, Spark, Hive, Airflow, Python, and Cloud Fundamentals.
Wrote and optimized SQL scripts to extract, transform, and analyze data from relational databases.
Used complex joins, subqueries, and aggregation functions.
Worked with Apache Airflow to design, schedule, and monitor data workflows DAGs for orchestrating complex data processing tasks.
Queried and analyzed large datasets using Google BigQuery.
Optimized query performance in Google BigQuery.
Used Apache Hive for querying and analyzing large-scale datasets stored in Hadoop Distributed File System (HDFS).