IT Central Station is now PeerSpot: Here's why

Badges

55 Points
6 Years

User Activity

Over 6 years ago
GaryM, I understand that automatic refresh can cause data mapping errors, but identifying the changes, notifying the users and letting the user decide how to apply the changes (update, ignore, create a copy of mapping and edit ...). When the object in DB changes, chances…
Over 6 years ago
With any DB, ETL plays a significant role. Being an ETL person, for me, NoSQL DB's compatibility with BI/ETL tools and it's connectivity matters most. Secondly NoSQL requires very good programming skills unless a GUI interface can be used to maneuver around the DB, so the…
Over 6 years ago
Apart from speed with which the data reflects the changes applied to DB, when you make a selection on the report, data related to only that particular selection should reflect in subsequent tabs or applications. For example: if i choose a product on products tab, it's sales…
Over 6 years ago
Hello Joop, Thank you for your comment. Unfortunately Informatica integration service does not interact with DB to pick up live feeds. So, anytime Insert/Update/Delete occurs on a DB object, it's corresponding definition in Informatica needs to be refreshed manually…

About me

Tech Lead with expertise in areas of Business Intelligence and Data Warehousing. Demonstrated experience utilizing ETL Tools like Informatica, SAP BODS, SSIS and Data Probe, Informatica as my primary tool of expertise. Strong Leadership experience mentoring interns, providing in-house training and managing/leading technical groups on BI/ETL standards and best practices.

Professional Developments: Trained with SAP on BODS and Trained with Truven Health on Data Probe.

Efficient in SQL Scripts and flexible with different Operating Systems.

Extensively used TOAD , Oracle Developer , SQL Navigator, i-Series Navigator, SQL Showcase Query 7.0 and i-series Emulator for Data Modelling, Data Analysis, Data Manipulation and Data Profiling.

Specialties::

Languages : C, C++, SQL, XML.

ETL tools : Informatica versions 7.1, 8.1, 8.6, 9.1, SAP BODS 3.x, SSIS, Power Exchange 8.X, Truven Health Data Probe.

Database : Oracle 9i/10g/11g, DB2 AS 400, SQL Server 2008, XML, Cobol/VSAM, Flat Files, mongoDB.

Database Tools : TOAD, Oracle Developer, Qlik View, Showcase Query, i-Series Nav and Emulator.

Systems : Windows 98/2000/XP/Vista, UNIX (Sun Solaris), MS-DOS.