vicky2 Posted February 15, 2011 Report Posted February 15, 2011 Repu naku interview undi for informatica developer position (Financial Client), ippativaraku nenu oka project chesanu (Health Care Client) and i am familiar with Health Care Data like Claim Processing and Provider information, In the interview client will concentrate on my financial experience (which i mentioned in my resume), so now what i need to know is How to explain my financial experience?Please anybody can help me in this regard? thankyou thankyou
jamesbond Posted February 15, 2011 Report Posted February 15, 2011 sorry baa nenu kooda Health side ee HIPAA compliance..... All the best. Evaro okkaru ostaaru le sHa_high5ing
vicky2 Posted February 15, 2011 Author Report Posted February 15, 2011 thankyou alllGoogling chesthunna kani effective information dorukuthaledu.Any How i will try till last min
vijay rocking Posted February 15, 2011 Report Posted February 15, 2011 [quote author=vicky2 link=topic=155862.msg1845281#msg1845281 date=1297731989] thankyou alllGoogling chesthunna kani effective information dorukuthaledu.Any How i will try till last min[/quote]Antha pedda difference emi undadu...ee points mention cheyeOLTP systemsolap systemsods(operational data store) data, daily refreshedw(enterprise data ware house) weekly or monthly refresh. maintains historycubesdata marts(star,snowflake)PM me if you have any questions....
graham Posted February 15, 2011 Report Posted February 15, 2011 [quote author=vijay rocking link=topic=155862.msg1845460#msg1845460 date=1297733720]Antha pedda difference emi undadu...ee points mention cheyeOLTP systemsolap systemsods(operational data store) data, daily refreshedw(enterprise data ware house) weekly or monthly refresh. maintains historycubesdata marts(star,snowflake)PM me if you have any questions....[/quote]you rock you rock
jamesbond Posted February 15, 2011 Report Posted February 15, 2011 [quote author=vijay rocking link=topic=155862.msg1845460#msg1845460 date=1297733720]Antha pedda difference emi undadu...ee points mention cheyeOLTP systemsolap systemsods(operational data store) data, daily refreshedw(enterprise data ware house) weekly or monthly refresh. maintains historycubesdata marts(star,snowflake)PM me if you have any questions....[/quote] @gr33d @gr33d you rock you rock sSc_hiding2
vijay rocking Posted February 15, 2011 Report Posted February 15, 2011 [quote author=vijay rocking link=topic=155862.msg1845460#msg1845460 date=1297733720]Antha pedda difference emi undadu...ee points mention cheyeOLTP systemsolap systemsods(operational data store) data, daily refreshedw(enterprise data ware house) weekly or monthly refresh. maintains historycubesdata marts(star,snowflake)PM me if you have any questions....[/quote]some Financial words.... just google theseBorrowers(primary borrower, co-borrower)loan, lienunderwriteraprmortgage loanschecking accountcapital marketscorrespondent dataltvcltvetc etc..........
vicky2 Posted February 15, 2011 Author Report Posted February 15, 2011 [quote author=vijay rocking link=topic=155862.msg1845460#msg1845460 date=1297733720]Antha pedda difference emi undadu...ee points mention cheyeOLTP systemsolap systemsods(operational data store) data, daily refreshedw(enterprise data ware house) weekly or monthly refresh. maintains historycubesdata marts(star,snowflake)PM me if you have any questions....[/quote] @gr33d But,What i mean to say is, i need to explain them high level Data Architecture, ETL Process and i need to use financial terminology for ex( Mutual Funds, general ledger, wealth management ect)For Ex in Health Care (we use to have vendor called Argus , who use to process pharmacy and provider claims. we use to get daily and monthly flatfiles, we use to validate the flatfiles and prepare a filelist, there is a TIBCO process it will process the flatfile and load the data into Data Aqicition layer and from there the etl process will apply tranformation rules and bussiness logic and load the data to Tactical Data Store (ODS))
vijay rocking Posted February 15, 2011 Report Posted February 15, 2011 [quote author=vicky2 link=topic=155862.msg1845645#msg1845645 date=1297735368] @gr33d But,What i mean to say is, i need to explain them high level Data Architecture, ETL Process and i need to use financial terminology for ex( Mutual Funds, general ledger, wealth management ect)For Ex in Health Care (we use to have vendor called Argus , who use to process pharmacy and provider claims. we use to get daily and monthly flatfiles, we use to validate the flatfiles and prepare a filelist, there is a TIBCO process it will process the flatfile and load the data into Data Aqicition layer and from there the etl process will apply tranformation rules and bussiness logic and load the data to Tactical Data Store (ODS))[/quote]use the words mention above and explain same project.Get the data from AS/400 systems(most of the banks use this), and flat files from citi bank, which is in encrypted format, we use java classes and java tranfrormation to decrypt those flat files and load into bank's datawarehouse oracle tables.worked on integration project, which the data comes from capital markets and correspondent systems.and this is financial, should be daily refresh....and extract the data from bank's different data sources. Create comma delimited flat files, encrypt them and send it to different financial vendors through secure ftp
vicky2 Posted February 15, 2011 Author Report Posted February 15, 2011 Thanks dude for your suggestion and i will try to gather information as much as possible
Recommended Posts