Shwetha H

Shwetha H Email and Phone Number

ETL Consultant @ Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & Texas
Owings Mills, MD, US
Shwetha H's Location
Owings Mills, Maryland, United States, United States
About Shwetha H

•I have experience in Analysis, Design, Development, Testing, Implementation, Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter.•Proficient using Data Warehousing, Informatica Power Center 9.x/ 8.6.1 ,scheduling tool CA•Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD•Experience in integration of various data sources like Relational Data sources( Oracle, SQL Server, Sybase) and flat files.•Extensive experience in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Parameter files.•Extensive experience in error handling and problem fixing in Informatica, designed complex Mappings and expertise in Performance Tuning.•Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session.•Involved in Implementing Slowly Changing Dimensions SCD II, SCD I ,SCDIII and Star Schema modeling - FACT tables, Dimension tables.•Knowledge of Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion capabilities of IDQ 10.0•Knowledge and Experience in Business Intelligence with QlikView, Tableau.•Experience on databases like Oracle9i/10g/11g, SQL Server, Sybase,Greenplum,Teradata utilities ( Multiload , Fastload, T-PUMP), and DB2 etc.•Extensive Experience in UNIX and Windows Operating system.•Extensively used Unix Shell scripting, SQL and PL/SQL•Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking able to work independently and as a member of a team.•Excellent communication, analytical and interpersonal skills,q uick learner and adaptive to new and challenging

Shwetha H's Current Company Details
Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & Texas

Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas

View
ETL Consultant
Owings Mills, MD, US
Shwetha H Work Experience Details
  • Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas
    Etl Consultant
    Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas
    Owings Mills, Md, Us
    View
  • Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas
    Etl Consultant
    Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas Jan 2017 - Present
    Baltimore, Maryland Area
    ● Developing new business applications and enhance existing business applications usingInformatica Power Center, Oracle SQL and Unix Shell Scripting.● Involved in client meetings for understanding and analyzing the business requirements.● Worked with analysts and other developers to design a reporting infrastructure to meet organizational and operational requirements. Support existing tools and adoption of standard strategic tools to support the Data Warehouse.● Extensively used Transformations like Router, Aggregator, Filter, Joiner, Expression, Source Qualifier, connected and unconnected Lookup, Update strategy and Stored Procedure.● Involved in supporting the existing applications by resolving the abends, suggested code changes and knowledge transfer to new team members.● Responsible for creating plans for the code migration using SVN as a version control tool following security policy.● Wrote UNIX shell Scripts for FTP of files from remote server and backup of repository and folder.● Used JCL scripts for scheduling the Informatica workflows.● Responsible for providing daily status report for all Informatica applications to customer, Monitoring and tracking the critical daily applications & code migration during deployments.● Responsible for reloads of Informatica applications data in production and closing user tickets and incidents.● Responsible to design, develop and unit test mappings.● Performed Unit and Integration Testing and validates results with Business Analyst and end users.● Conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.● Created documentation on the design, development, implementation, daily loads and process flow of the mappings.
    View
  • Brillio
    Sr Software Engineer
    Brillio Mar 2014 - Feb 2015
    India
    •Analyzing the Business Requirements and functional specifications•Extracted data from flat files , staged into a oracle database and applied business logic to load them in the central Sybase database.•Used Informatica Power Center 9 for extraction, transformation and load (ETL) of data in the data warehouse•Extensively used Transformations like Router, Aggregator, Normalizer,Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.•Worked closely with Client partners•Developed complex mappings for SCD2, SCD3 in Informatica to load the data from various sources•Extensively used Toad for SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.•Handling activities at every stage of development process right from conception to make it ready for End users.•Preparing estimates for work in conjunction with the Lead•Deploying and monitoring the ETL code in various (UAT/SIT) environments, preparing design and test case documents.
    View
  • Mphasis
    Software Engineer
    Mphasis Nov 2010 - May 2014
    Bangalore,India
    Analyzing the BRD (Business Requirement Documents), understand the ETL specifications and preparing SRS (Software Requirement Specification) Document.•Worked extensively with transformations like Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner,Sequence generator,Source Qualifier,normalizer, Update Strategy.•Extensively worked on tuning of Informatica mapping for better performance.•Handling activities at every stage of development process right from conception to make it ready for End users.•Deploying and monitoring the ETL code in various (DEV/QA/UAT) environments
    View

Frequently Asked Questions about Shwetha H

What company does Shwetha H work for?

Shwetha H works for Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas

What is Shwetha H's role at the current company?

Shwetha H's current role is ETL Consultant.

Not the Shwetha H you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.