EXPERIENCE SUMMARY:

• 7+ 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) andMaster Data Management (MDM).
• 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.
• Experience in Performance Tuning of Targets, Sources, Sessions, Mappings, Transformations, re - usable components like mapplets /worklets etc.
• Expertise in creating Mappings, Trust and Validation rules, MatchPath, MatchColumn, Matchrules, Mergeproperties and BatchGroup creation.
• Worked on exception handling mappings for DataQuality, DataProfiling, Data Cleansing and Data Validation and Address Doctor.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Good exposure in Informatica IDQ, MDM where Data Cleansing, De-duping and Address correction were performed using Address Doctor.
• 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

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

Informatica IDQ Developer

Environment: Informatica IDQ 9.0.1, Informatica Power Center 9.5.1, 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.
• Created Source to Target mappings.
• Unit test plans to test end to end flow.
• 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.
• Planned, organized and developed technical support protocol, maintained code, responded to system users, evaluated software, system problems and potential solutions to application systems requirements.
• 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

Informatica Developer

Environment: Informatica MDM 9.0.1 (formerly Siperian XUSP2), Informatica

Responsibilities:

• Coordinating with the ETL and Siperian developers in the team, assigning TTs and CRs to the team members, managing delivery and client communications.
• Finalizing changes relating to Base Objects, Landing Tables, Lookups, Configuring Mappings, Cleanse Functions, Batch Groups and Tuning Match Rules and Trust & Validation Rules etc.
• Worked on the Informatica PowerCenter mappings
• Created Low Level Design Documents
• Bug fixing and enhancements relating to IDD, HM (Hierarchy Manager), Cleanse Functions,
• Migration of Metadata and code changes from one environment to another using Informatica Metadata Manager.
• Writing User exit using Dynamic SQL, calling Batch and individual Jobs by using Oracle PL/SQL Procedures.
• Maintenance and Administration of the environments (like managing log files, archiving and cleaning temp files etc).
• Worked with Informatica Product Support team for analyzing Product related bugs and enhancement requests.

Confidential

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

Informatica MDM Developer

Environment: ETL (Informatica Power Centre) and Data Quality, Informatica MDMOracle.

Responsibilities:

• Creating ORS, Landing, Staging and base object tables.
• Creating mapping according to business logic and address doctor as per client requirement.
• Adding trust, match rules, creating batches for staging and loading.
• Adding batches for match and merge.
• Deployment to other environment and promoting the changes.
• Designed, coded, tested, debug and documented as per the Business requirements.
• Planned, organized and developed technical support protocol, maintained code, responded to system users, evaluated software, system problems and potential solutions to application systems requirements.
• Taking server down and up and bug fixing.
• 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, Washington DC

Informatica Developer

Responsibilities:

• Extensively used ETL methodologies for supporting data extraction, transformation and loading process, in a corporate-wide-ETL solution using Informatica Power Center.
• Worked on various Informatica Data Integration components - Repository Manager,
• Workflow Manager/Server Manager, and Designer
• Continuous Production support for eDM (eCommerse 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.

Confidential, Washington DC.

Senior Informatica Developer / Production Support Analyst

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

Responsibilities:

• Job responsibilities include Using Informatica Power Center, 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.