Shiv Noliyan

Shiv Noliyan

ETL Developer
India
English, French

نبذة عني

With nearly 3 years of expertise, engaged in Analysis, Design, Development, Implementation, Testing, and Support of ETL processes, Data Warehousing, and Data Integration Solutions using Informatica with a team of 5 for C…

الخبرة

ETL Developer

Cognizant Technology Solutions
Jun 2021 - حتى الآن · 5 سنوات

Designed and developed ETL processes using Informatica, improving data processing speed by 25%.
Strong experience in Informatica PowerCenter and IICS to create complex mappings, sessions, and workflows, using transformations like Lookup, Joiner, Router, Aggregator, Rank, Union, Sorter, Union, Sequence, etc.
Knowledge of cloud-based solutions such as ADF, Data Lake Store, Blob Storage, Azure Synapse, and Snowflake.
Proficient in developing SQL with various relational databases such as Oracle and MS SQL Server.
Effectively applied SCD Type I and SCD Type II to handle the delta loads.
Involved in performance tuning using Partitioning and Pushdown Optimization to remove source and target bottlenecks.
Worked on optimizing the mappings by creating reusable transformations, Mapplets, and Worklets.
Debugged mappings and used session log files to trace errors that occurred while loading.
Knowledge of Informatica scheduler and Control-M for automation of ETL Jobs.
Provide support for Data migration across Dev, QA, PROD environments and other production support activities.
Involved in Unit Testing, SIT, and UAT phases of the project with tools like Jira, ServiceNow, and HP ALM.
Created and maintained system documentation on Confluence, improving team productivity by 15%.
A team player, motivated, and able to grasp things quickly with analytical and problem-solving skills.

ETL Informatica Developer (Associate)

Cognizant Technology Solutions

Designed and developed ETL pipelines using Informatica, improving data processing speed by 25%.
Strong experience in Informatica PowerCenter and IICS to create complex mappings, sessions, and workflows, using transformations like Lookup, Joiner, Router, Aggregator, Rank, Union, Sorter, Union, Sequence, etc.
Knowledge of cloud-based solutions such as ADF, Data Lake Store, Blob Storage, Azure Synapse, and Snowflake.
Proficient in developing SQL with various relational databases such as Oracle and Microsoft SQL Server.
Involved in performance tuning using Partitioning and Pushdown Opt. to remove source and target bottlenecks.
Worked on optimizing the mappings by creating reusable transformations, Mapplets, and Worklets.
Also used Informatica scheduler, and BMC Control-M for ETL jobs.
Provide support for Data migration across Dev, QA, PROD environments and other production support activities.
Involved in Unit Testing, SIT, and UAT phases of the project with tools like Jira, ServiceNow, and HP ALM.
Created and maintained system documentation on Confluence, improving team productivity by 15%.

GenC (Generation Cognizant)

Cognizant Technology Solutions

Get Hands-on Experience on technology like ETL, SQL, Python, Unix, Data warehouse, Java and Front-end Technologies like HTML, CSS, PHP and JavaScript.
Under the guidance of Trainer, made a Timesheet Web app for associates which can be managed by Admin.

المهارات

أوراق الأنماط المتتالية (CSS) دمج وتحويل البيانات باستخدام ETL (ETL) تطوير JavaScript جيرا بايثون (لغة برمجة) قاعدة بيانات SQL يونكس (نظام تشغيل) منصة GitHub للتعاون على تطوير البرمجيات أدوات ETL من إنفورماتيكا Powercenter مايكروسوفت أزور (خدمة حوسبة سحابية) ريأكت جي أس (إطار عمل لتطوير واجهات المستخدم) كونفلوينس كنترول-إم إتش بي إيه إل إم إتش تي إم إل 5 بي إل/إسكيوإل باور بي آي سيرفس ناو استوديو إدارة خادم SQL Informatica PowerCenter SQL SSMS Informatica Intelligent Cloud Services (IICS) Winscp Unix Shell Scripting JIRA Microsoft Azure Data Factory Snowflake Service Now HP ALM Quality Center Git Data modelling Debugging Scheduling Deployment Troubleshooting HTML ReactJS RestAPI Analytical skill Collabaration Problem Solving Teamwork Time Management Communication
الإبلاغ عن هذا الملف الشخصي؟