SUMMARY:

• 6+ years of focused experience in Information Technology with a strong background in Data warehousing and ETL experience using Informatica PowerCenter 9.6/9.5/9.1/8.6.0/8.5.1 /8.1 on RDBMS databases
• Developed Data Warehouse/Data Mart systems using various RDBMS (Oracle, MS - SQL Server).
• Expertise includes Data Analysis, Data Modeling, Data Cleansing and Transformation, Integration and use of ETL tool Informatica.
• Experienced in working with all Informatica Designer tools and worked extensively with Informatica Workflow manager and Workflow monitor to build and run workflows.
• Expertise in Informatica ETL tool to develop, test and tune mappings, sessions and workflows.
• Extensive experience with analyzing and validating the data, Logical and Physical data modeling using ERWIN, Embarcadero.
• Advanced knowledge in Informatica loading, change data capture (CDC) and performance tuning
• Good Experience and understanding of the SDLC in all phases.
• Experienced using RDBMS oracle, Teradata, SQL server, DB2.
• Experience in writing with Pre-Session and Post-Session UNIX scripts.
• Experience in writing stored procedures, triggers, functions in Oracle PL/SQL and also SQL Queries/reports and scripts.
• Proven experience and Solid understanding of Data Warehousing, Decision Support Systems (DSS), OLAP and Business Intelligence skills.
• Preparation of business and functional specifications, analysis of current and planned systems, workflow and business process documentation, utilization of use case analysis and UML models.
• Experienced in Physical, Logical database implementation, indexing and performance tuning for development, test and production environments.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User defined Functions, User profiles, Relational Database Models and Data Integrity, SQL joins, indexing and Query Writing.
• Good knowledge on the Pharmaceutical and Insurance domains
• Excellent understanding of Software Development Life Cycle and dimensional modeling techniques using Star and Snow-flake Schema Modeling.
• Proven problem-solving skills with excellent analytical, communication and interpersonal skills.
• Team player, motivated and dynamic with excellent oral and written communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.6/9.5/9.1/8.6/8.5/8.1/7.1/6.2 , Informatica Power Exchange

Reporting Tools: Business Objects 6.0/5.0, Cognos 6.0/7.0

Data Modeling: Erwin 4.1/3.7, ER Studio

Database Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2012/2008/2006 , DB2, Teradata 4.0, MS Access 2000/7.0/6.5

Utilities: SQL Assistant, Query man, TOAD

Operating Systems: Microsoft Windows XP/2003/2000/NT, Windows 2000/2003 Server, UNIX, Sun Solaris 5.8

Programming Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, HTML

Data Cleansing: Informatica Data Quality 8.6.2/8.5Informatica Data Explorer 8.6.1 /8.5

Other Tools: SQL*Plus, SQL Loader, TOAD, MS Visual Studio

Business Domains: Federal Government, Insurance, Health care, Finance

Scheduling Tools: DAC, Tivoli, Zena

PROFESSIONAL EXPERIENCE:

Confidential, IL

Informatica Developer

Responsibilities:

• Analyzed business requirements with the business analyst to develop ETL procedures that are consistent across all applications and systems.
• Involved in Designing ER models (logic/physical) for Oracle database to store data retrieved from flat files and XMLs.
• Created mapping/sessions and workflows for Initial/Bulk load process using informatica version 9.6.
• Created CDC mappings (Delta Loads) to capture only the changed data.
• Heavily used Pre-Post SQL and Pre-Post commands to archive data using informatica sessions as part of automation.
• As part of change control, updated mappings as per functional specifications to incorporated updated logics.
• Used different types of tasks like Decision, Timer and Events wait and Command to maintain the dependencies between the sessions and load balancing within Informatica Workflow.
• Worked with various transformations like Router, Expression, SQL, Lookup, Normalizer, Aggregator in building complex mapping.
• Coordinate with the DBAs for migrating tables and schema changes to different environments.
• Involved in performance tuning the mappings and sessions to perform optimally.
• Created Unit Test documents and performed Unit Tests on the ETL mappings.
• Actively supported the testing team and involved in defect triage and defect fixing.

Environment: Informatica Power Center 9.6.1, Informatica Power Exchange, Oracle 11g.

Pacific Gas and Electric, San Francisco, CA

Informatica Developer/Data Integration Developer

Responsibilities:

• Analyzed business requirements with business analyst to develop ETL procedures that are consistent across all systems.
• Created mappings/sessions and workflows for Initial/Bulk load process using Informatica version 9.6.1
• Created the Salesforce connections in Informatica Power Center
• As part of change control, updated mappings as per functional specifications to in corporate updated logics.
• Integrated data from Sales Force, Workday, Concur into Oracle using Informatica cloud on demand.
• Created connections to AWS, SFDC, Oracle for Informatica cloud on demand.
• Used different types of tasks like Decision, Timer and Event wait and Command to maintain the dependencies between the sessions and load balancing within Informatica Workflow.
• Worked with various transformations like Router, Expression, SQL, Lookup, Normalizer, Aggregator in building complex mapping.
• Loaded data into Interface tables of Oracle EBS.
• Wrote extensive validation scripts before loading the data into Oracle EBS.
• Involved in performance tuning the mappings and sessions to perform optimally.
• Created Unit Test documents and performed Unit Tests on the ETL mappings.
• Actively supported the testing team and involved in defect triage and defect fixing.
• Worked closely with business analysts to understand and document business needs for decision support data.
• Created the ETL performance expectations document based on the source data profile results.
• Captured the data volumes, upserts/truncate and load strategies etc. in Integration design document.
• Extensively used Workbench, Force.com, SOQL queries to unit test the mapping.
• Validated the salesforce target data in force.com application.
• Used Bulk API to load large amount of data in Salesforce org.

Environment: Informatica PowerCenter 9.6.1/9.5.1 HF3, Informatica Power Exchange, Informatica Cloud, Sales Force, force.com, Oracle 11 g, Oracle EBS R2.

Micron Technology Inc

Design Verification Intern

Responsibilities:

• Worked on Mediterraneo which is a 45 nm Serial Peripheral Interface (SPI) flash memory device.
• Duties involved were to develop testbenches using System Verilog for coverage driven verification.
• Find the bugs in the Black box and Bus Functional Model (BFM) and report them to concerned owner.
• Coverage Driven verification involved verifying every command in every possible way in Mediterraneo.
• Debugging and fixing the BFM which is a Verilog behavioral model of the Mediterraneo.