SUMMARY:

• Around 4 years of experience in the IT industry with a strong background in software development and 2+ years of experience in leading Development, Architecture and Testing Business Intelligence solutions in data warehouse and decision support systems using ETL tool Informatica PowerCenter 9/8 and other BI solutions
• Excellent understanding on full software development life cycle (SLDC) of ETL process including requirement analysis, design, development, support of testing and migration to production.
• Experience in Data migration and integration with various domains like Utilities, Finance & Retails
• Extensively worked with large Databases in Development, Testing and Production environments.
• Experience with advanced ETL techniques including staging, reusability, data validation, change data Capture (CDC), Real time.
• Strong in Data warehousing methodologies of Star /Snow Flake schemas of Ralph Kimball, Bill Inman.
• Experience in developing Informatica Mappings, Sessions, Workflow and Tasks.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, SQL Transformation and XML Parser.
• Expertise in implementing complex business rules using different transformation, Mapplets and Worklets
• Experience with code migration from between repositories and folders.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Well versed with different SQL Development Tools like TOAD, SQL Developer & Dbeaver
• Good experience in ETL technical documentation.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9/8

Cloud: Informatica Cloud, Amazon Web Services Certified Solution Architect (Associate)

RDBMS: Oracle 11g/10g/ & SQL Server

Methodologies: Star schema and Snowflake schema

Languages: SQL & basic shell

Operating system: Windows XP, RHCL

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, Chicago

Responsibilities:

• Developed various mappings and mapplets to load data from various sources using different transformations like Router, Aggregator, and Joiner, Lookup, Update Strategy, Source qualifier, Filter, Expression and Sequence generator etc., to store the data into the target table.
• Implemented Slowly Changing Dimensions (Type 2: Date & Time) to update the dimensional Schema (Facts & Dimensions).
• Responsible for overall delivery of High and low level technical designs, data models, ETL codes & test result
• Design, Build, Test, Deploy & Support ETL Solution.
• Requirements Analysis, Identify Data Elements.
• Design & Deploy Data Model.

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Worked on highly visible financial Application which creates BI Dashboards differentiating between good loans and bad loans.
• Worked Solely as ETL Developer on a Time Constraint and highly visible project.
• Design ETL Framework for the project.
• Worked with disparate sources systems, including Flat Files, Oracle, SQL Server 2008 Teradata, SAS, MS Excel etc..
• Extracted Data from SAP source system using SAP plugins in Informatica.
• Worked closely with Business Analyst and QA Engineer throughout the project.
• Created Technical Specification and various document throughout the project.
• Coordinated with Offshore and Onsite Developers & Testers to Assign task and resolve any roadblocks during the CUT (Coding and Unit Testing) Phase.
• Worked on Informatica Powercenter 8.6, Powerexchange 8.6 and Mainframe TSO.
• Worked closely with Business Teams and Third Party Vendors to take sign off on Various Documents.
• Worked with Teradata Utilities like T - pump, Mutliload, Fastload and a little bit understanding of Bteq Scripting.
• Worked extensively with UC4 Job Scheduler and experience with Tivoli & AutoSys .

Confidential

Data Modeler/ Test Lead

Responsibilities:

• Analyze Scorecard requirements and design ETL solution
• Data Modeler on Scorecard project
• Conducted UAT with business and got their approvals
• Provide guidance to offshore personnel

Confidential, Milwaukee, WI

Senior Application Developer

Responsibilities:

• Worked on highly visible and time constraint projects.
• Worked on quarterly based projects.
• Created more than 30 mappings / workflows and worked on 20 existing mappings.
• Created ETL Specification documents, Unit Test Case documents, Detail Design Documents and Metadata update documents for the multiple iterations.
• Performed the analysis and profiling of fact and dimension tables
• Improved the performance of the jobs by identifying the bottlenecks and by eliminating them.
• Worked with Teradata Control Frame Work Architecture for Error Processing.
• Worked with flat-file, Oracle, Teradata and DB2 data sources.
• Worked on IBM Mainframes to create setup and trigger jobs.
• Imported the Legacy DB2 tables into Informatica PowerCenter by making use of Informatica Power Exchange.
• Created and edited UNIX scripts for various jobs.
• Performed extensive Unit Testing and provided support to QA and Production teams.
• Interacted with various team for performance related issues.
• Created and implemented logic for Delta loads.
• Worked closely with Project Lead, System Analyst and projects Manager to accomplish project completion in a given timeline.