PROFESSIONAL SUMMARY:

• Over 7.5 years of IT experience in Data warehousing and ETL tool using Informatica PowerCenter 10.1/9.x/8.x and Database.
• 3 Years of real - time data Warehouse development experience using CDC tool Informatica PowerExchange 10.1/9.0.
• Expertise in the Analysis, Design and Development of Software Applications and providing Data Integration/Warehousing solutions.
• Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing of Data warehouses using ETL.
• Strong Data warehousing experience using Informatica PowerCenter / Power Mart 9x/8x/7x and Utilities in Oracle 12c/11g, Teradata 14/13, DB2 UDB and SQL Server 2008/2000, Sybase databases.
• Experience in implementing the complex business rules by creating transformation, re-usable transformations (Expression, Aggregator, Filter, Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings, and SQL Stored Procedure, and Triggers.
• Developed Slowly Changing Dimension (SCD) Mappings of type I, II and type III (Flag, Version Number and Effective Date Range).
• Used Incremental Aggregation to update the values in reporting tables and optimized the process.
• Extensively worked on Oracle Function, Cursor, Store Procedure, and Package & Trigger.
• Experience on data modeling and create LDP and PDM for Star schema and Snowflake schema using MS Visio and ERWIN 7.1/4.5.
• Developed mapping using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
• Worked on Informatica Data Quality (IDQ) to profile the data, find and clean duplicates check.
• Having command on troubleshooting with the help of error logs generated by Informatica server.
• Experience with UNIX shell scripting for File validation, Data cleansing and archive logs.
• Practical understanding of Star Schema and Snowflake Schema Methodology.
• Hands on experience in writing, testing and implementing PL/Sql and created objects like Triggers, Stored Procedures and Functions at database level and form level using SQL.
• Involved in project documentation like HLD, ETL design docs, UTC docs and Run Book.
• Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files. Experience in Performance tuning of SQL.
• Have good experience in solving critical production problems and in taking critical business decisions. Worked as a team lead and Onsite/Offshore coordinator.
• Production support was done on a weekly routine basis.
• Good knowledge in Amazon Web Service (AWS), components - EC2, S3 Bucket

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, AIX, Linux, Windows 2007

ETL Tools: Informatica PowerCenter 10.1/9.x/8.x, Informatica PowerExchange 10.1/9.x, Informatica Data Quality 10.1

Data Modeling Tool: Erwin 3.5.2/4.0/4.2 , Microsoft Visio

Databases: Oracle 12c/11g, IBM UD2 DB2, MS SQL Server 2008/2012, MS Access 2000, Teradata 14/13, Netezza 7.1.

Languages: Java, SQL and PL/SQL, UNIX, Shell Script and XML

Data Warehouse Concepts: ODS, Star Schema, Snowflake schema, OLTP, OLAP

Mythologies: SDLC, Agile

OBIEE: 11g, BOXI

Testing Tools: Quality center, Test director

Database utilities: TOAD, SQL Developer, PL/SQL Developer, Putty & Telnet

Scheduling Tools: Dollar Universe, Web Restart Schedule & Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Mansfield, MA

Sr . ETL Informatica Developer

Responsibilities:

• Interaction with the Business Partners to understand the business of the application, gather requirements analyzed and put into technical design documents.
• Working with Data Analysts to understand the functional requirements. Involved in developing the technical documents from functional specs.
• Interact with Data Modelers to understand and finalize the conversion strategies.
• Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, Union Transformation, connected/unconnected Lookups, Update Strategy, and Router Transformation to transform and load the data from and to flat files and relational tables.
• Developed SDC type 1 and SCD type 2 mappings and tested them. Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Worked on Informatica Power Canter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Worked on ETL design and data flow and Conducted Design reviews with SMEs.
• Created and Configured Workflows and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in writing UNIX shell scripts to Transfer the files between multiple systems. Created pmcmd wrapper, wrote clean up log script and email alert scripts.
• Performed Informtica Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance. Tuned the transformation like Source Qualifier, lookup, aggregator, joiner. Worked on Informatica Partition and Cache customization.
• Performed data quality analysis to validate the input data based on the profiling & cleansing rules.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through SQL queries.
• Deployed the Informatica code to higher environments by creating deployment groups in the Repository Manager.
• Prepare the Prod Execution steps for the project. Prepare the run books for prod environments.

Environment: Informatica PowerCenter 10.1, Informatica Data Quality 10.1, Teradata 14, Oracle 12g, XML, Flat Files, SQL Assistant, Autosys, Toad, PL/SQL, Erwin, Unix shell scripting, DB2, Unix, Sun Solaris, Windows.

Client : Cigna Healthcare, Bloomfield, CT

Role : Sr ETL Informatica Developer

Responsibilities:

• Used heterogeneous files, Data Base and Webservices as source and designed to load from Landing to Stage to DataMart
• Design ETL jobs to load data in the data warehouse tables. Created the ETL framework for Reconciliation, Data formatting, Reference check and Error login & Cleansing.
• Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
• Worked on SQL developer to write the SQL code for data manipulation, Validation and Testing.
• Worked on Informatica versioned repository with check in and checkout objects feature.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Provided guidance to less experienced personnel. Conducted quality assurance activities such as peer reviews.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Extracted the data from the Flat Files, Oracle and MySQL into staging area and populated into data warehouse which is DB2.
• Created business rules in Informatica Developer and imported them to Informatica PowerCenter to load the standardized and good format of data to staging tables.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Worked on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developed Perl and UNIX shell scripting to extract Data from various Databases.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Worked with SQL*Loader tool to load the bulk data into Database.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.

Environment : Informatica PowerCenter 9.6, Informatica Data Quality 9.6, Oracle 11g, Linux, UNIX, SQL Developer, Putty, Ultra-Edit, Teradata 13, Windows XP, Toad, WinScp.

Confidential, Herndon, VA

ETL developer

Responsibilities:

• Understanding existing Business model, Customer requirements, develop design documentation & assist data base mapping fields.
• Using Informatica PowerCenter Designer, Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports.
• Worked on Informatica tool like Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used the transformations like Expression, Aggregator, Router, Sequence generator, Lookup transformations, Update strategy and stored procedure transformation to create mappings.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Develop complex mappings such Slowly Changing Dimensions Type II - Time Stamping in the Mapping Designer.
• Created and executed workflows using Workflow Manager.
• Involved in the development of Informatica mappings and trouble shootings.
• Involved in Data Extraction from SQL server, Flat files.
• Error Handling in Informatica mappings. Created and monitored the sessions and workflows.
• Daily ETL Load Process, BW Load Process, Master Data Matching, Tuning and Cleansing.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Developed Informatica Mappings and tuned for better Performance.
• Data Enhancements and deliverables done to QA Environment Successfully.
• Provided support and quality validation thru test cases for all stages of implementation.
• Post Production support is done to resolve Issues.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, SQL, DB2 Mainframe, PL/Sql, PERL, TOAD, Microsoft Visio, Autosys, Unix, SQL*Loader, SQL Server 2012, Linux, WinSCP.

Confidential, Irving, TX

ETL developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Worked with production support systems that required immediate support.
• Develop, execute and maintain appropriate ETL development best practices and procedures.
• Assisted in the development of test plans for assigned projects.
• Monitor and tune ETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
• Create mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and update strategy etc.
• Involved in unit testing of the mapping and SQL code.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design (star schema) and maintenance. Worked on delimited flat file sources.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformation, Rank transformation, Expressions, Aggregator, and Sequence Generator.
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations and mapplets confirming to the business rules.
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Designing the ETL process and Review, Implementation plan deliverables.
• Testing and Data Validation - each extract process will be validated, and data elements within each file will be reviewed to ensure data quality prior to passing the file to Risk Management.
• Created batch files to generate indirect file for indirect file load.
• Created the test cases as part of the unit testing and performed unit testing for all the components developed.

Environment: Informatica PowerCenter 8.6, DB2, Oracle10g/11g, Linux, Mainframe, SYBASE, Informatica PowerExchange 8.6, OBIEE 11g.