PROFESSIONAL SUMMARY

• 7+ years of Professional experience as ETL developer in Data Warehouse work environment. Proficient with Agile and Waterfall development methodology.
• Experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL Informatica PowerCenter 9.x and older.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and using Informatica PowerCenter - Designer, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Extensive experience in data migrationfrom various legacy sourcesandrelationalsystemsto OLAPand decision support targetsystems.
• Good understanding ofInformaticaServers, Repository Services - Installation, configuration, maintenance & administration in Dev, Test & Prod environments.
• Experience in Supporting Production support Projects.
• Experience in Performance Tuning, Error Handling, debugging of mappings, Partitioning and Pushdown Optimization.
• Used Business intelligence report tools like OBIEE for warehouses and data marts.
• Worked with Application servers such as IBM Websphere Server and Oracle Weblogic Server.
• Strong experience in handling Incident management tickets such as ServiceNow, Remedy, and SharePoint IM
• Good experience in UNIX work environment forfile transfers,job scheduling.
• Experience in Distributed systems for integration of various data sourcesincludingOracle, SQL server,DB2, Teradata, and MS access andnon-relational sources like flat files, XML, and Excel filesinto staging area.
• Excellent debugging and trouble-shooting skills.
• Practical noledge of Data warehouse concepts, Data modeling principals - Star Schema, Snowflake, Normalization/De-normalization.
• Excellent communication skills and co-ordination with project managers, business analysts, architects, DBA’s and Developers.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6.1/9.1/8x, Informatica Data Quality 8.5

Incident Man: ServiceNow, Remedy, and SharePoint Incident Management

App Server: IBM Websphere 7.x/6.x, Oracle Weblogic Server

Databases: Oracle 9i/10g/11g/12c, DB2 8/9, MySQL 4.1/5.0, SQL Server 2012, TeraData

DBMS Tools: DBVisualizer, TOAD, SQL Developer, SQL Plus, SQL Assistant

Job Scheduler: AutoSys, Control MReporting Tools: Oracle Business Intelligence

Languages: SQL, PL/SQL, Unix Shell Scripting, XML

Operating Sys: Linux, Windows Server, Windows XP, 7,8,10

Others/Tools: Putty, WinSCP, Erwin, JIRA

UML Tools: Rational Rose, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Washington, Dc

Sr. Informatica /BI Developer

Roles and Responsibilities:

• Took part in JAD sessions to define the Business requirement specifications and Functional specifications by directly interacting with the users and proposing corresponding deliverables.
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Imported Sources and Targets to create Mappings based on business logic and develop Transformations using PowerCenter Designer- Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter, Sequence Generator and Update strategy transformations.
• Used Workflow Manager to create workflows using various tasks like command task, assignment task, event raise, event wait task, session task, Timer, Control, etc.
• Involved in the Development and documentation of complex Informatica Mappings/sessions and system testing as per the business requirement.
• Reviewed ETL Mappings/Sessions etc developed by team members.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst.
• Created Reports and Dashboards in OBIEE 11 g

Environment: Informatica PowerCenter 9.6.1, SQL Developer, Toad,Windows 8,Oracle 11g,Microsoft Visio, PL/SQL, Control-m, OBIEE 11G.

Confidential, Charlotte, NC

Informatica Developer

Roles and Responsibilities:

• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the Data Mart with only required information.
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing Error Handling method .
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Wroked in the UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows).
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Supported the Production support project .

Environment: Informatica Power Center 8.6/9.1, Autosys, Teradata, Oracle 10g,SQL Assistant, SQL Server 2008, Postgres, PL/SQL, SQL, Oracle, UNIX, Shell scripts.

Confidential,Denver, Co

Informatica Developer

Roles and Responsibilities:

• Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
• Performed Informatica, non-Informatica code migration between environments (DEV/QA/PRD).
• Handled huge volumes of data at Enterprise Data Warehouse about 25 Tera Bytes.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Developed reusable transformations, mapplets, sessions, and worklets to make code very modular and reused it as required.
• Created and Configured Workflows and Sessions to transport the data to target warehouse, Oracle tables using Informatica Workflow Manager.
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA.
• Developed strategies for Incremental data extractions as well data migration to load into the Oracle (EDW). And also assisted in designing Logical/Physical Data Models.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2.
• Created the Test cases and Captured Unit test Results, Developed and tested all the Informatica mappings, sessions and workflows involving several Tasks.

Environment: Informatica Power Center 9.1/9.6.1, Power Exchange, Crystal reports, Toad, Teradata,Oracle 10g/11g,SQL Server 2012,Unix, PL/SQL, DB2, OBIEE.

Confidential, Corner, VA

Informatica Developer

Roles and Responsibilities:

• Worked heavily with Business Analyst to understand the business and to design the architecture of the data flow.
• Designed the metadata tables and created mappings to populate the same.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the Data Mart with only required information.
• Created reusable transformations to clean the data, which were used in several mappings.
• Tested stored procedures, functions and packages in PL/SQL
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing Error Handling method .
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 8.6/9.1, Autosys, Teradata, Oracle 10g,SQL Assistant, SQL Server 2008, PL/SQL, SQL, DB2, UNIX, Shell scripts.