EXPLORE


0.0
0.0
0%
$30 USD / Hour
・

India (10:38 AM)
・
Joined on June 3, 2012
$30 USD / Hour
・
• Over all 6+ years of Professional experience in IT Industry in which 3 + Years of experience using Informatica Tool, as a ETL Developer extensively used ETL methodology for Data Extraction, Transformation and Loading processing, in a corporate-wide-ETL Solution using Informatica. • Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplets Designer. • Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping. • 3 Years of Experience with complete recruitment life cycle of US IT Staffing.
No reviews to see here!
Experience
Informatica Developer
Feb, 2013 - Present
•
13 years, 5 months
HCL India
Feb, 2013 - Present
•
13 years, 5 months
Roles and Responsibilities: • Understand the business requirement as per the client requirement to create the mappings. • Developed ETL mappings, transformations using Informatica PowerCenter9.1 • Implemented source and target definitions in PowerCenter-Designer. • Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression. • Involved to design to cater the slowly changing dimensions. • Used various stored procedures in the mappings. • Developed several reusable transformations and mapplets that were used in other mappings. • Worked on the server manager to run several sessions and batches concurrently and sequentially. • Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation Logic. • Used workflow manager and monitor to create, schedule, monitor and send the message in case of process failures • Involved in ETL Testing to test the mapping before moving into production environment • Indentified the development error to before moving to UAT Environment • Working with client in meeting and calls • Schedule the mapping by using CTRL+M • Working with parameters and short cut key to increase the mapping performance
Feb, 2013 - Present
•
13 years, 5 months
ETL Developer
Aug, 2011 - Jan, 2013
•
1 year, 5 months
DELL
Aug, 2011 - Jan, 2013
•
1 year, 5 months
Roles and Responsibilities: • Check Informatica and make sure the Nightly, Weekly and Monthly mappings are in a running state (or at least haven’t aborted). • Reloading of the data incase of data miss-matches for a particular day/period. • Worked with Informatica corporation team for Informatica software support team if any server issues arise. • Working with Debugger, Pushdown optimization and Performance tuning • Working with tickets, work orders and change orders. • Performed transformations like cleaning, integrating of the data and loaded the cleaned data. • Restarting Informatica server based on client requirement • Monitoring mappings in Informatica mappings. • Working closely with 3rd Party vendors like Amdocs, Infor (Epiphany AS) and Sales Force for providing 2nd level support. • Working closely with other Application Support Teams to accept handover of new tasks.
Aug, 2011 - Jan, 2013
•
1 year, 5 months
Sr IT Recruiter
Jul, 2008 - Jul, 2011
•
3 years
Idexcel Technologies
Jul, 2008 - Jul, 2011
•
3 years
SUMMARY: 3+Years of Experience with complete recruitment life cycle of US staffing. • Recruited for Major clients like ,Verizon, Accenture, Cap Gemini, Capital one, ACS, HBO, CSC, WEBMD, Safeco, BP, BOA, JPMC, Fannie Mae, Merck pharmaceuticals, Boeing, New York State, etc • Responsible for the proactive recruitment for IT professionals and Administration, Worked with these consultants on W-2 & Corp2Corp.Experience in Visas – OPT, H1B, EAD, GC & USC • Proficient at successful sourcing of candidates via Internet sources and online resume database. • Assisted in recruiting efforts by screening and locating potential candidates for open requisitions. • Use of industry referrals, web based sourcing and internal recommendations. • Conduct all phases of the hiring process including initial screening, internal interviews and negotiation of wages and benefits. • Review and screen resumes received in a quick and decisive manner • Duties include importing and parsing resume in to database, reviewing job descriptions and matching with prospective candidates, corresponding with potential candidates via phone and e-mail. • Utilizing Monster, Dice, Computer Jobs and Career Builder for performing complex internet searches for sourcing individuals. • Source candidates for hiring manager specific requirements as well as for pipelining efforts, by utilizing various resources. • Developed and maintained database of IT professionals, utilizing various Internet research methods, job boards, networking groups, referrals and our database. Responsibilities: • Consistent producer in the team of 15+ recruiters and handled end-to-end recruitment involving sourcing, screening, evaluating, salary negotiations, HR interviews, and offer roll out. • Manage full life cycle of staffing services, which includes finding candidates through different sourcing techniques, screening of resumes, conducting interviews, salary negotiation, and closing the requirements. • Employed a variety of sourcing techniques to identify and contact new candidates, including Internet searches, referral networking, database prospecting, and job boards. • Involved in a group of recruiters for the IT and Management Consulting practice driving and managing the full life cycle recruiting process • Provided End to end Recruitment support for Various fortune clients across US • Interacting with the candidates, arranging for the interviews, following up for the feedback, through salary negotiation and final placement. • Employed a variety of sourcing techniques to identify and contact new candidates, including Internet searches, referral networking, database prospecting, and job boards. • Negotiated compensation packages, 1099, W2 and Corp to Corp rates also dealt with third party vendors and approved various vendors to work. • Maintain Recruiting Metrics to show daily and weekly progress.
Jul, 2008 - Jul, 2011
•
3 years
Education
MBA
2006 - 2008
•
2 years
2006 - 2008
•
2 years
Osmania University
2002 - 2005
•
3 years
Bachelor Of Commerce

India
2002 - 2005
•
3 years
Verifications