SUMMARY:

• 8+ years in the Information Technology and wide range of experience in Software development, Data Integration, Unit testing with tools Informatica Power Center, Informatica Data Quality (IDQ)
• Expertise in ETL (Extraction, Transformation and Loading) of data from various sources into EDW, ODS and Data marts using Data Integration tool Informatica Power Center.
• Expertise on Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Hands on experience in Performance tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
• Worked on exception handling mappings for DataQuality, DataProfiling, Data Cleansing and Data Validation and Address Doctor .
• Good knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations
• Hands on experience on Migration Projects from Netezza to Exadata, changing source DB’s and Target DB’s.
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Worked on Slowly Changing Dimensions - Type 1, Type 2 and Type 3 in different mappings as per the Business Requirements.
• Excellent exposure to Technical documentation like Mapping Specs, Technical Specification Documents / Release Plans / Unit Test plans etc. as per the Client requirements.
• Possess very good experience working in Agile methodology in fast paced environment handling sprints and coordinating with multiple teams as needed.
• Possesses unique combination of business and technical acumen, strong leadership and people skills, analytical, negotiation and problem-solving abilities.

TECHNICAL SKILLS:

Data Warehousing Tools: Informatica Power Center 9.x/8.x, Informatica Data Quality (IDQ)V9.x, Informatica Master Data Management V9. x.

Languages: C, SQL, PL/SQL, CORE JAVA

Databases: Oracle 11i/10g/9.x, Microsoft SQL ServerV 2014/2012/2008, Nexus

Development Tools: Toad, SQL Developer, SQL* Plus

Scheduling Tools: Autosys / Tidal / Control- M

Configuration Tools: Team Foundation Server 2010, VSS, Quality Centre

PROFESSIONAL EXPERIENCE:

Confidential, Massachusetts

Informatica Developer

Environment: Informatica Power Center 9.5.1, Oracle, PL/SQLAutosys, MS-Office, UNIX OS

Responsibilities:

• Followed Agile Methodology, involved in daily scrum meetings of a sprint.
• Extracted data from different Government Reporting Data Stores GRDS, CMS, CWDS -Crown-Web data store system to Staging Area -> Dev and loaded the data to the target database by ETL process using Informatica Power Center.
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Created STTM’s (Source to Target mapping documents) to outline data flow from sources to targets.
• Applied Database Tuning and Optimization, Normalization in the new database design.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed complex mappings in Informatica to load the data from various sources.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Worked on creating and extracting data into Stage/Landing, Dimensions, Facts tables.
• Created Test cases for the mappings developed and then created integration Testing Document.

Confidential, Worcester, Massachusetts

Informatica Developer

Environment: Informatica IDQ, Informatica Power Center, Oracle, PL/SQLAutosys, MS-Office, UNIX OS

Responsibilities:

• Worked with Systems Analysts to prepare detailed specs from which programs was written.
• Worked on the Workflows, sessions and Informatica mappings.
• Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD).
• Created Source to Target mappings.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ application for matching and merging process.
• Integrated Informatica applications as Mapplets within PowerCenter Mappings.
• Completed system testing utilizing toolsets of Mercury quality center.
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Designed, coded, tested, debug and documented as per the Business requirements.
• Performance tuning is performed Confidential the Mapping level as well as the Database level to increase the data throughput.
• Written all the Technical Specification documents related to the multiple releases and changes as per the new releases.
• Performed Unit Testing for the code developed. Conducted Systems Integration Testing (SIT) along with the BSA team.

Confidential, New York, NY

Informatica/ IDQ Developer

Environment: Informatica IDQ 9.0.1, Informatica PowerCenter 9.x, Oracle, PL/SQLTidal scheduling tool, MS-Office, Unix OS

Responsibilities:

• Created Mappings using transformation like Expression, Standardizer, Decision transformation, Sequence Generator etc.
• Worked with Address Doctor for quality check of addresses.
• Creation of WSDL and web Service consumer transformation
• Used Labeler transformation (Token based and Parser based) extensively.
• Created Services like Model Repository service, Integration service, Content Management Service

Confidential, Bothell, Washington, DC.

Informatica Developer

Technology: Informatica Power Centre 8.6, Netezza, Oracle, Nexus Query Chameleon, UNIX, SAP Business Objects BI Platform, Toad.

Responsibilities:

• Extensively used ETL methodologies for supporting data extraction, transformation and
• Loading process, in a corporate-wide-ETL solution using Informatica Power Center.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Continuous Production support for eDM (e-commerce Datamart) from 3 data center’s Allen(Texas), Lynnwood(WA), Bothell(WA) that is heavily used to track various data including clickstream, order, fulfillment and subscriber metrics for att.com.
• Used Informatica PowerCenter, Netezza, SAP Business Intelligence (BI) tools and Reporting Tools (Business Objects) for day to day tasks.
• Perform a weekly BI 8-Clustered Production Servers Reboot.
• (Restarting - Apache/Tomcat and Web Intelligence services.)
• Recover ETL-Go jobs failures like Character width exceeded, constraint violation, null values, pg atio, and spool space issues within the SLA time given.
• Monitor and respond to requests for assistance of various kinds. Work with users, Project Managers, and ETL developers to design and implement new subject areas in the appropriate tool.
• Monitor Netezza Server Administrator to give best performance during data loading time by Killing/Aborting the long running queries.
• Changing priorities of ad-hoc queries running in Netezza on client request using Stored procedures.
• Work independently and as a part of a team, Onsite-Offshore with clients, building a relationship with and interacting with client team members to ensure project success.
• Vertica POC Testing: Involved in POC testing on Vertica v/s Netezza to migrate from Netezza to Vertica. Done Sequential, concurrent testing in BO.

Confidentia, Bothell, Washington DC.

Informatica Developer / Production Support Analyst

Environment: Informatica8.6, Toad, Oracle, UNIX, Windows.

Responsibilities:

• Job responsibilities include Using Informatica Power Center, Unix, Reporting Tools (Business Objects)
• Zodiac Testing: Validating the data from DEV and PROD systems coming from different data centers.
• Supporting daily loads and work with business users to handle rejected data.
• To be successful, a critical role on the team by acting not only as a Support Engineer but also as a liaison with business clients and technical team members.
• Used SQL tools like TOAD and SQL Developer for developing and executing the SQL queries to understand data flow.
• Monitor and respond to requests for assistance of various kinds. Work with users, SME’s and ETL developers to design and implement new subject areas in the appropriate tool.
• Monitoring and validating Webtrends profiles where all the Clickstream data is processed and loaded in 39 profiles which runs 4 cycles/day.
• Scheduling shell scripts using cron-jobscheduling.
• Checking the Netezza SPU’s and SPA’s health and killing the hung queries.

Confidential, Washington DC.

Informatica Developer

Environment: Informatica8.6, Toad, Oracle, UNIX, Windows.

• Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Involved in developing multidimensional data modeling using star schema and snow flake schema.
• Used Informatica to extract and load data from Oracle database and flat files to Oracle tables.
• Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
• Created Mapplets using Mapplet Designer to reuse in different mappings.
• Created FTP connections, database connections for the sources and targets.
• Created and Monitored Sessions using Session Manager.
• Handled performance tuning by checking bottlenecks also created partitions, SQL override in Source qualifier.
• Wrote stored procedures, functions and triggers using Oracle PL/SQL.
• Designed the reports and Universes as per the requirements