Exellent Sr. Datawarehouse Developer / Informatica ETL Developer available - Open for all locations in US.
Vinay Sawant
Dear Partners,
I HAVE RAJENDRA ALLURI SR.DATAWAREHOUSE DEVELOPER/ETL INFORMATICA DEVELOPER IMMEDIATELY FOR YOUR CLIENT REQUIREMENTS. HAS WORKED FOR COMPANIES LIKE T-Systems (Volkswagen and Audi), Janssen Cilag, (JnJ group), Farmers Insurance Group, TATA Teleservices Limited ETC.
HE IS IN DETROIT, MI RIGHT NOW AND HE IS OPEN FOR ALL THE LOCATIONS. PLEASE LET ME KNOW IF YOU HAVE ANY POSITIONS FOR HIM.
EXPERIENCE: 7+ YEARS
LOCATION: DETROIT, MI
RELOCATION: OPEN
AVAILABILITY: IMMEDIATE
********PLEASE SUBMIT ONLY TO YOUR DIRECT CLIENTS*********
PROFESSIONAL SUMMARY
· Around 7+ Years of extensive experience in design, development and testing in medium/large scale data warehousing applications.
· Expertise in Informatica Power Center (versions 6.1.2/7.1.2/8.1.1), Power Exchange CDC, PowerConnect.
· Created ETL solutions for high volume environment by creating Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, FACT Tables, Dimension Tables, Star Schema Modeling, OLTP, and OLAP.
· Extensive experience with Data Extraction, Transformation, and Loading from disparate Data sources into a common reporting and analytical Data Model using Informatica.
· Hands on experience in Siebel e-Pharma CRM 7.8 and implemented Siebel Data Warehouse.
· Hands on experience on SIEBEL ETL methodologies on OLTP-to-OLAP.
· Handled SIEBEL EIM,ETL data loading activities.
· Hands on experience Siebel analytics reporting application.
· Experience in using Siebel Data warehouse application console (DAC) to automate and schedule ETL tasks.
· Extensive experience in pharmaceutical, Auto and telecom industries.
· Good understanding of overall data warehouse design principles and best practices.
· Expertise in performance tuning of Informatica mappings and sessions for better performance and moving the objects from development to production environment.
· Experience in data Cleaning, analysis, profiling and modeling.
· Experience in writing test cases, Test Scripts and TCM’s for Informatica mappings.
· Good at Informatica installations, restoring and upgrading repositories.
· Good experience of UNIX, PERL and shell scripting.
· Good experience in job automation and scheduling tools like TIVOLI and AUTOSYS.
· Good knowledge on Informatica integration with Java applications.
· Expertise in Data Warehousing concepts, RDBMS concepts SQL server 2005 and oracle.
· Strong experience in PL/SQL, Oracle tuning as part of Partitioned tables and Indexes, function based indexes and optimizing the SQL to improve the performances.
· Hands on experience on Teradata database and its utilities viz. Mloads, Fastexport, BTEQ, Tpump and Fastload.
· Experience with Business Intelligence tools like Business Objects and Siebel Analytics.
· Strong planning, analytical and problem solving skills.
· Excellent Written/Verbal communication skills.
· Experienced in working in a team or independently.
Education
· BS in Computer Science
Technical Skills
ETL Tools: Informatica 8.x/7.1.2/6.2/6.1/5.1 (Power Center, Power Mart, Power Connect, Designer, Workflow Manager, Repository Manager, Administration) Siebel warehouse using Informatica, Siebel DAC, SIEBEL EIM
OLAP Exposure: Business Objects XI R2, Siebel Analytics
Databases: Oracle 8i/9i/10g, SQL Server 2000, DB2, MySQL, Teradata
DB Tools: TOAD, PL/SQL Developer
Programming Languages: C, C++, VB, PL/SQL, Base SAS programming
Operating Systems: Windows 95/98/NT/2000/XP, UNIX (Sun Solaris)
Reporting Tools: Crystal Reports 5.0/6.0, Oracle Forms 6i & Reports 6i
Vinay Sawant
Technical-Recruiter
|
Source One Professionals |7340 East 82nd street | Indianapolis, IN-46256 Phone 317-348-4345 Ext. 225 |(Fax) (317) 245-2368 vsa...@sourceonepro.com|www.sourceonepro.com |
Yahoo IM: vinay_sop