SUMMARY

• Data warehousing and ETL Solutions Developer with over 9years of development and design experience.
• Excellent knowledge of building DW and OLTP systems and applying ETL methodologies in VLDB (multiple terabytes) environments in the pharmaceutical, Retail, Healthcare, finance, and Insurance industries.
• As designer and developer, delivered numerous high - performances ETL Solutions built on integrated, scalable, and extensible platforms. Can quickly understand business requirements and provide end to end innovative solutions for the same.
• Dedicated professional with strong technical, analytical, oral, problem solving, written skills and a committed team player, always involving in performance tuning of Informatica mappings and sessions.
• Experienced in loading data into Data Warehouse/Data Marts using informatica, Oracle, SQL Server and SQL * Loader.
• Extensively used Erwin to design Logical/Physical Data Models, forward/reverse engineering modeled the Data Warehousing Data marts using Snow/Star Schema.
• Experienced in Client/Server technology area with Oracle Database, SQL Server and PL/SQL for the back end development of packages, Stored Procedures, Functions and Triggers.
• Experienced in Big Data technologies and concepts on a Hadoop platform (e.g. Scoop, Hive, Pig, NoSQL, etc…) and willing/adapting to future technologies
• Experience in analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.
• Excellent Team player and can work on both development and maintenance phases of the project.
• Developed processes for IDQ, Transforming, Extracting, Integrating and Loading data with use of Informatica Power Center.
• Self motivated, Adaptive to new and challenging technological environments.
• Worked with the team in ILM which helps to understand life cycle and improve the standard and performance using informatica.
• Worked in Agile environment and rendered Production support 24 hours.
• Determines Customers Business Requirements and establish a strategy / road map for DW/ETL solutions.
• Provide ETL Implementations from inception to final implementation to meet Clients deliverable and deadlines.
• Executed Client Assessments, Designs, Specifications, Data Mapping and Test plans/scripts.
• Performance tuning and Optimization techniques.
• Extensively worked on Informatica tools Repository manager, Designer, Work-flow manager, Work-flow monitor.
• Hands on databases like Oracle 11i/10g/9, MS SQL server 2005/2008, DB2, Green Plum, AWS and Big Data Distributed Processing tools (HDFS, Hive, Sqoop, Spark, PySpark).
• Use of Database tools such as SQL*Plus, Toad, SQL Navigator, SSIS.
• Experience in usage of Operating Systems such as UNIX, WINDOWS XP/NT/2000/98/95.
• Hands on languages such as C, SQL, PL/SQL, XML.
• Created mappings using the transformations like Source qualifier, SQL, Aggregator, Expression, look-up, Router, Filter, Update Strategy, Joiner, Stored procedure and etc. transformations.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Informatica Lead Developer

Responsibilities:

• Created mappings to actively load data from various sources like DB2, Flat Files, XML, Oracle databases into Schemas like MIPDC, MIPS, JDEE1, COUPA, TRDM for RF China, NAPAC& RF US projects.
• Worked on Confidential prestigious project to load data into POS server from various source system which includes accommodation of prices from many countries.
• Perform various API calls to load data into TPM/JDE network as well as outside Confidential .
• Created active reports for the users when Enhancements and Adhoc requested.
• Worked with business closely in getting requirements and thoroughly understanding requirements and created a design data flow.
• Preparing all SDLC documents which includes IDM, IFS, IQOQ, Unit testing document, IDD and then load the same in Documentum and Share Point.
• Performed various smoke tests with business in Test and UAT environment.
• Worked on providing data related to Inventory balances, Reconciliation, Purchase orders, Invoices, Units on replenishments for Retail Stores
• Involves in maintenance issues, analyzing data discrepancies, enhancements and providing resolution for technical issues.

Environment: Informatica Power Center 10.2, Power Exchange, SQL Server 8.0, Oracle 11g, Toad 11g, Visio ALM Version 11, Unix Script, IBM CDC, ISeries DB2

Confidential, Cary, NC

Informatica Lead Developer

Responsibilities:

• Used Informatica to actively load data from various sources like Oracle, SQL Server, Flat files, Iseries DB2.
• Perform various API calls to load data into MetLife network.
• Created active reports for the users when Enhancements and Adhoc’s requested.
• Worked with business closely in getting requirements and thoroughly understanding requirements and create a design data flow.
• Coordinate with offshore team regularly and asses them in development activities and also review code to see if it met all the requirement needs.
• Preparing all SDLC documents which includes IDM, IFS, IQOQ, Unit testing document, IDD and then load the same in Documentum and Share Point.
• Create, update and delete Binders, EDLs for Study, Site and Country into Veeva vault cloud.
• Create Meetings and Attendees related to meeting into CVENT and Amex team for events which helps planner to co-ordinate and make arrangements for meeting.
• Involves in maintenance issues, analyzing data discrepancies, enhancements, escalation and providing resolution for technical issues.

Environment: Informatica Power Center 9.6, SQL Server 8.0, Oracle 11g, Toad 11g, SSIS, Maestro, Rods.

Confidential, Stamford, CT

ETL Developer

Responsibilities:

• Involved in doing low level design documentation with the team and also analyze high level flow of the data with the requirements provided.
• Worked as team in integration of the workflows and represented team in coordinating the same to next level superiors as necessary.
• Worked from staging to hub doing an incremental load of data using parameters both at session level and also at workflow levels.
• Was responsible in doing unit testing and migrated informatica mappings and sessions to various environments such as testing and productions, and also resolved after production issues for existing mappings according to users needs.
• Worked on creating headers and footers for the flat files and also worked on checking the quality (IDQ) of data based upon the tolerance levels assigned according to company standards to accept the data into relational tables or to refuse the data.
• Worked on Account management, Product management, territory management for the sales rep and do necessary changes with data for new reps recruited and also updated changes of territories for existing sales reps.
• Worked on slowly changing dimensions like type 2 and 3 and also assign flags for logical deletes in the mappings.
• Enhanced ETL routines to maintain current and history data in major base tables by using CDC(Change Data Mechanism) with informatica Type-2 logic.
• Worked in creating web Intelligence reports individually and with team using business object.
• Understand and analyze universe with different relations to the various entities and their join conditions.

Environment: Informatica Power Center 9.0.1, SQL Server 8.0, Oracle 11g, Toad 11g, Salesforce one, Autosys

Confidential, Madison, WI

ETL Developer

Responsibilities:

• Worked on Actively interacting with teams to discuss on having Data Model and ETL Spec Walkthrough before start of any Mapping.
• Loading data into SAGE Platform based upon SCD Type 2 load into oracle database by doing full and delta loads for each feed.
• Calling Store procedure for all mapping to make entries into Process log tables for doing Inserts (IP) and Updates (SU) for every run and also create Run ID’s and Feed ID’s for each Feed.
• Loading target tables and also making entries of data with discrepancy into Exception log and Exception Attribute log respectively by calling store proc at post sql.
• Create Unix Scripts and execute the workflows for testing and load data thus avoiding in creating Metadata for running the workflows manually.
• Involve in creating Deployment groups by creating both Static and Dynamic deployment for each mapping and do deployment of mapping from DEV to SIT and to UAT and PROD Respectively.
• Involved in doing Smoke Test after deployment of mappings to one environment to other environment and make sure the mappings are performing correctly once after deployment.
• Fixing Defects and also assigning back for Ready to retest in ALM for all the defects raised by Testing Team.
• Provided all time support to mappings in production environment and also worked on improving performance to existing mappings in production environment.

Environment: Informatica Power Center 9.1, Visio Oracle 11g,, Toad 11g, Erwin 7.2, ALM Version 11, Unix Script.

Confidential

ETL Developer

Responsibilities:

• Worked on creating new mappings to load the fact tables keeping referential integrity with the dimension tables based upon the study ids.
• Loading the history tables in parallel to the fact tables based upon SCD type 2 with new timestamps and existing timestamps.
• Optimizing the existing mapping before sending to production by checking sorted inputs when getting tables from multiple databases at joiner transformation and also checking sequence of columns to find the checksum when working on CDC.
• Loading the data into EDW schemas from CAL components RDM and CDM and putting the timestamps for those records.
• After successful loading of Edw schemas they are subsequently loaded into ODS schemas based upon incremental loading.
• Refactoring of the sql query for loading tables in various environments R3 to R4 based upon the business requirements.
• Dynamically created Parameters in target directory and used them at workflows for various session when doing an incremental load.
• Deployed mappings using deployment groups or export/ import from Dev. to Test for further testing and finally to Prod at the Informatica Repository Manager.
• Understand the sql query sent and respectively created mapping based upon those queries, also improve performance of the mapping by balance the load to database and Informatica respectively.
• Worked in creating web Intelligence reports individually and with team using business object
• Understand and analyze universe with different relations to the various entities and their join conditions.

Environment: Informatica Power Center 9.5, Visio Oracle 11g, SQL/PLSQL, ControlM, Toad 11g, Erwin 7.2, SQL server

Confidential, Hartford, CT

ETL Lead Developer

Responsibilities:

• Developing the Informatica Mappings, sessions and workflows required to load the data into Data Warehouse from flat files and staging tables
• Involved in development of UNIX scripts necessary in ETL processes
• Expertise in data validation operations in middle of ETL processes
• Writing the test cases for unit and integration testing
• Expertise in unit test, integration test of Informatica components
• Creating source to target mappings and developing the ETL mappings using Informatica Power center
• Expertise in tuning the mappings and sessions to optimize the performance.
• Involved in performance tuning the SQLs to optimize the run time in mappings
• Preparing unit test cases and documentation.
• Involved in implementation support
• Responsible for automating all ETL process that can be automated

Environment: Informatica Power Center 9.0.1, Visio Oracle 10g, OWB, SQL/PLSQL, Toad, Business objects 4.0.