Harika Certified Senior ETL/Informatica Developer | Resume |

Good Afternoon.

 

Certified Senior ETL/InformaticaDeveloper AVAILABLE IMMEDIATELY

Request: please take aminute and add ravi@svk-inc.com in your mailing listfor current and future requisitions.

Please scroll down to know for other available consultant Technologies.

 

Consultant Name

Harika

Skill

Certified Senior ETL/Informatica Developer

Availability

Immediate

Total Exp

8 Years

Relocation

WI ,GA,IL,TX

Current Location

Little Rock AK 

 

  • Over all 8 years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional data modeling, Development, Testing, Implementation and maintenance of Data warehouse applications, Client Server applications and Web applications.
  • Expertise in translating business requirements into feasible technical ETL specifications, identifying key deliverables and defining timelines from an Enterprise perspective.
  • Extensive experience in Data Warehousing using Informatica PowerCenter 9.1/8.6 with expertise in design, development and implementation of Extraction, Transformation and Loading processes.
  • Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
  • Involved in the data analysis for source and target systems, good understanding of DataWarehousing concepts (Kimball/Inmon), DimensionalModeling using Star schema and Snow- Flakeschema for faster, effectivequerying and Business Analysis Requirements.
  • Experience in the successful implementation of ETL solution between an OLTP and OLAP database in support of Decision Support Systems/Business Intelligence with expertise in all phases of SDLC.
  • Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
  • Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
  • Good Working Knowledge in Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
  • Extensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server toolsInformatica Server, Repository Server manager.
  • Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
  • Expertise in implementing complex Business rules by creating complex mappings/mapplets, Re-usable transformations.
  • Worked with Pre-Session and Post-SessionUNIXscripts for automation of ETL jobs using ControlM/AutoSys scheduler and Involved in migration/conversion of ETL processes from development to production environment.
  • Extensively worked on various databases and followed SOA for Integration of various data sources like Oracle, SQL Server, DB2, Teradata, XML and Flat Files.
  • Experience in writing and tuning complex SQL queries.
  • Experience in writing PL/SQL stored procedures, triggers and functions
  • Experience in utilities like SQL*Loader, TOAD for transferring data.
  • Good experience in Data Cleansing, Data profiling and Data Analysis.
  • Good knowledge and understanding of Scheduling tool Control M,Tidal and Autosys.
  • Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts..
  • Comprehensive experience in analyzing end user requirements and problem solving skills with strong analytical background.

 

Technical skills:

 

 

ETL Tools

Informatica 7 / 8.6 /9.0.1(Power Center), Informatica Power Exchange, Metadata Manager, Web Services.

Reporting Tools

Business Objects XI r2/r1/6.5,IBM Cognos 8,SSRS

Data Modeling Tools

Erwin 3.x/4.x, MS Visio

Scheduling Tools

Autosys,  Tivoli, ESP, Control M

Databases

Oracle 11g/10g/9i, Teradata, DB2, MS SQL Server 2005/2008, MS Access, MS Excel

Database Utilities

Toad for Oracle10g, SQL*Loader, Embracedo Rapid SQL,SQL Navigator

Languages

 

C, C++, Visual Basic, SQL, PL/SQL, Perl, Shell Scripting.

Helpdesk Tools

Remedy, CCAT,ISQ

Operating Systems

Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Solaris, AIX).

Data Transfer Tools

 FTP

 

 

 

 

 

REQUEST: Kindlysubmit our consultants to your direct client's only, as we don't work withlayers ie: Prime vendors / Gate Keepers / Implementation partners of yourcompany. Violation of this clause gives us the right to withdraw the submissionfor that particular requisition without your consent.

 

 

Thanks & Regards

 

B RaviKumar

Sr.ITRecruiter

 

SVKSystems, Inc.

11465,Johns Creek Parkway,

Suite#180 Johns Creek, GA – 30097

Ph:678 824 7754  Fax: 404-601-9507

ravi@svk-inc.com : www.svksystems.com g-talk: svk.ravi007@gmail.com

 

 

If you do not want to receive email from me,please reply to this email with REMOVE in the subject

 

 



Safe Unsubscribe :
This email was sent to vikaschidura69.itstaffingus@blogger.com by ravi@svk-inc.com.
Instant removal with SafeUnsubscribe | Privacy Policy.
Email Marketing by
mailsonics.com
NOTE: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include the contact information for removal from our mailing list. To be removed from our mailing list please click above SafeUnsubscribe link or reply to Ravi Kumar: ravi@svk-inc.com with 'remove' in the subject heading and your email address in the body. Include complete address and/or domain/aliases to be removed.

If you still get these emails, please call us at the numbers given above, my sincere apology.