Vishwadhar S
Sr. Informatica Cloud Integration Developer at Extreme Networks
- Role
- Sr Informatica Cloud Integration Developer at Extreme Networks
- Location
- Durham, NC, US
- LinkedIn followers
- 500 followers
About Vishwadhar S
Substantial experience in requirement gathering, analysis, design, development, testing, implementation, maintenance and support of Enterprise Data Warehouse systems for Banking, Telecom & Finance Industries.• Experience in Data Warehouse development working with (ETL) Extract, Transform and Loading data using Informatica Power Center 9.x or later versions.• Experienced in handling cloud data integration using Informatica Intelligent Cloud Services.• Proficient in writing PL\\SQL & T-SQL queries, creating indexes, functions (basic & Advanced Analytic), sub queries and SQL joins.•Proven expertise in translating business and functional requirements into Technical specifications and designs.•Proficiency in performance tuning, optimization & troubleshooting of SQL queries in various RDBMS environments such as Oracle 11g, SQL Server, and Teradata SQL Assistant.•Proficient Knowledge in implementing and maintaining Enterprise Data Warehouses.•Expertise in developing UNIX shell scripts, Windows Batch scripts and PowerShell scripts.•Extensive knowledge in troubleshooting of Informatica mappings, sessions, workflows and various sub-tasks.•Experience in dealing with large datasets which includes querying, gathering and analyzing data.•Experience in maintaining change management and release management processes and guidelines for production deployments.•Strong understanding and knowledge about conceptual, logical, and physical data modeling.•Proven expertise in translating business and functional requirements into database design, Database normalization, database object creation and into data mapping.•Extensive hands-on experience in working with job scheduling tools such as Autosys.•Experience in dealing with Banking & Financial sector data with good business knowledge of AML, Fraud and Risk concepts and terminologies.•Experience in working with Scrum framework in agile project environment.
Experience
Sr Informatica Cloud Integration Developer
Mar 2019 — Present · Raleigh-Durham, NC, US
Actively Involved in the POC of HR Cloud Migration project for determining the choice of tools & connectors->Designed & developed data integration tasks between various cloud sources comprising Oracle HCM Cloud, Jobvite, ServiceNow, Active Directory & on prem Oracle databases->Redesigned the existing HR provisioning/offboarding process by integrating Oracle HCM Cloud data with Servicenow using Rest APIs through IICS-> Extensively used Postman tool for validating the Webservice end points during the POC phase to understand the request/response structure & to compare them with the swagger file generated-> Worked extensively on various connectors such as SynQ, LDAP, HCM Cloud Connector for synchronizing Master Data across various sources->Incorporated Error handling mechanisms to ensure 100% data delivery across different applications without any loss of data->Participated in the SIT/UAT phase of the project & provided suggestions/ clarifications on the process to the business users->Actively Involved in migrating code, updating connections, deploying swaggers etc during production deployment.
Education
Jawaharlal Nehru Technological University
Bachelor of Technology (B.Tech.), Information Technology
2007 — 2011
University of South Florida
Master's degree, Management Information Systems
2014 — 2015
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.