SUMMARY:

• Highly proficient, versatile and resolution focused ETL Architect/Lead Developer offering expertise in d Confidential warehousing architecture especially using Informatica Suite and experience in software analysis, design, development implementation and management of technical solutions.
• 12+ Years of professional IT experience in D Confidential warehousing and implementing development projects. Having good abilities in development and support for successful execution of projects using industry leading D Confidential warehouse technologies and tools such as Informatica Power Center 10.x/9.x/8.x/7.x, Informatica Power Exchange 10.x/9.x, Informatica D Confidential Quality 9.x(IDQ), Terad Confidential 14x/12x, Oracle 11g/10g, SQL Server, Confidential DB2, ERWIN and UNIX Shell Scripting.
• Have worked in different projects in Banking, Insurance, Life Sciences and Retail domains at various client locations across Globe.
• 11+ years of extensive experience in Requirement gathering, ETL Architecture, Writing ETL Specifications, Dimensional D Confidential Warehouse Design, Application Integration, D Confidential migration, D Confidential analysis and implementation of D Confidential Warehousing solutions using ETL concepts and tools.
• 11+ years End - to-End SDLC experience including analysis and scoping, design, development, QA, deployment, and maintenance.
• 11+ years’ experience in using D Confidential warehousing ETL tools like Informatica Power Center, Informatica Power Exchange, 2+ year experience in using Informatica D Confidential Quality(IDQ) tools (Developer and Analyst) and 1+ year experience in using Informatica Cloud services (ICS and ICRT)
• Having good understanding on Informatica REST API guidelines to access and pass information to Informatica Cloud organization.
• Experienced in creating and publishing processes in Informatica Cloud real time (ICRT) process designer using service connectors (Ex: REST API)
• Experienced in using Informatica cloud REST API to access and perform Informatica cloud tasks.
• Experienced in Developing, maintaining and enhancing Informatica Cloud Mappings, Task Flows, and processes (D Confidential Synchronization, D Confidential replication)
• Experienced in integrating SAP Systems such as SAP ALE, SAP BAPI/RFC, SAP BI/BW & SAP R/3(ECC) using Informatica Power Exchange.
• Experienced in integrating Salesforce and WebServices using Informatica Power Exchange and Informatica Cloud.
• Experienced in using Informatica D Confidential Quality (IDQ) tool kit for Profiling, Analysis, Standardizing, Cleansing, Matching, Conversion, Exception Management and defining DQ Rules.
• Having very good knowledge on Informatica Master D Confidential Management(MDM) components, such as:
• Creation and configuration of Landing, Staging, Base Objects, Hierarchies, Foreign Key Relationships, Queries, Query Groups and Packages.
• Identification of Golden Record (BVT) by analyzing d Confidential, cleansing the d Confidential and merging duplicate records coming from different systems.
• Defining Match and Merge Rules in the MDM Hub by creating match path components, match strategy, match columns and rules.
• Execute Stage Jobs, Load Jobs, Match and Merge Jobs using Batch Viewer and Batch Groups.
• Experienced in using XML sources/targets in Informatica Power Center.
• Having very good knowledge on Big D Confidential concepts and technologies including HDFS, MapReduce, PIG and HIVE.
• Having hands on experience in writing UNIX Shell Scripting, PL/SQL Procedures/Functions and Terad Confidential Stored Procedures, Macros and BTEQ Scripts.
• 5+ years of experience in using Terad Confidential SQL & Terad Confidential utilities like Multiload, FASTLOAD, and TPUMP.
• Familiar with the usage of HP QC for defect tracking.
• 10+ years of experience in RDBMS and performance tuning of queries.

MANAGEMENT SKILLS

• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Having good experience in working onshore: offshore model.
• Effective communication skills and record for coordination between globally located teams.
• Having good experience in driving projects when time lines are stringent, high pressure and ambiguous conditions.
• 7+ years of experience in project planning, project estimations and resource loading.
• Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables.
• Adept in providing Analytical Support to key business Applications /solutions.
• Having good experience in preparing best practices and co-ordinate sessions for team.
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Acted as liaison between business users and development team in translating requirements, resolving issues and handling escalations.
• Managing reports, analysis and decision: making for a change request.
• Project Management, Project Schedule, Project Tracking and Team Management.

TECHNICAL SKILLS:

D Confidential warehousing Tools: Informatica Power Center 10.x, 9.x Informatica Power Exchange 10.x, 9.x Informatica D Confidential Quality(IDQ) 10.x, 9.x Informatica Cloud (ICS and ICRT) Informatica Master D Confidential Management(MDM) 9.x

BI Tools: MicroStrategy Developer 10.3.0

RDBMS: Oracle, DB2, Terad Confidential 14/12, and MS-SQL Server

D Confidential Modeling Tools: Erwin 4.2/4.0, MS Visio

Programming Languages: Core JAVA, SQL, PL/SQL and UNIX Shell Scripting

Operating Systems: Linux, AIX, UNIX, HP-UX, Sun Solaris Windows and MS DOS

Other Tools: SAP GUI, HP QC, Aqua Studio, Force.com(Salesforce), Terad Confidential SQL Assistant, WinSQL, Toad, SQL Developer & Putty, PVCS

Scheduling Tools: Confidential TWS, Tidal, StoneBranch and Autosys

WORK EXPERIENCE:

Confidential

Sr. Informatica/DQ Developer

Responsibilities:

• Involved in analysis, requirement gathering and designing activities.
• Collaborated with various business and technical teams to gather requirements and created design documents.
• Analyzed source d Confidential received from various source systems (WAM, iTRACKER, PTS, WSUS, Past Due Patches, QVRu etc.) using join and enterprise discovery profiling methods to identify primary Confidential .
• Created DQ Rules and score cards using profile results.
• Created DQ mappings for d Confidential cleansing and validations, using different transformations and Integrated with power center mappings.
• Created/Modified file validation, file creation (indirect) and file archival scripts using UNIX shell scripting.
• Participated in creating d Confidential model and performance tuning of ETL process.

Environment: Informatica Power Center 10.2, IDQ 10.2, MicroStrategy 10.3.0, Oracle, Putty, WinScp, SQL Developer, UNIX scripting, and Tivoli Workload Scheduler (TWS)

Confidential, NJ

Sr. Informatica Cloud Developer

Responsibilities:

• Created and published processes in Informatica cloud real time (ICRT) process designer using REST API.
• Designed and developed service connectors, connections and processes in ICRT to consume the changes in Confidential system and update in Salesforce.
• Developed Informatica Cloud Mappings, task flows and processes (D Confidential Synchronization, D Confidential replication) in batch mode to capture the changes in Salesforce(veeva) to Confidential system.
• Created error reporting for inability to access receiving systems.

Environment: Informatica Cloud Services and Real Time Services (ICS and ICRT)

Confidential

Sr. ETL Informatica/IDQ Lead/BI Consultant

Responsibilities:

• Contributed in the development of system requirements and design specifications.
• Created ETL specification documents using functional documents.
• Participated in the design and development of Dimensional modeling.
• Participated in creating d Confidential base scripts using Erwin forward and reverse engineering techniques.
• Extracted d Confidential from SAP R/3(ECC) using ABAP integration with Informatica Power Exchange
• Created ETL framework to reuse the code across all plants.
• Created DQ Rules, d Confidential /custom profiles and score cards using profile results.
• Created DQ mappings for d Confidential cleansing and validations, using different transformations.
• Integrated DQ mappings with power center mappings.
• Created Informatica objects and Scheduled in Confidential TWS.
• Created and modified UNIX shell scripts to run the jobs using framework.
• Created d Confidential base Views, MV’S and Stored Procedures to refresh the MV's, as and where needed.
• Participated in D Confidential base objects, ETL and Tivoli Jobs migration to QA and Production environments.
• Interacted with various business teams, users and provided support in all the phases of project.

Environment: Informatica Power Center 10.x, 9.x, Informatica Power Exchange for SAP NetWeaver, IDQ 10.x, MicroStrategy 10.3.0, Unix Shell Scripting, SQL Server, Oracle, SAP R/3, Putty, WinScp, SQL Developer and Tivoli Workload Scheduler(TWS)

Confidential, NJ

Sr. SAP-Informatica Integration/IDQ Consultant

Responsibilities:

• Extracted Sales files residing in Burgeon server and transmitted ARReceipt files to Burgeon using SFTP.
• Created/Modified Unix scripts to invoke SFTP process and to upload/extract d Confidential from/into Informatica Server.
• Created ETL Inbound and Outbound mappings to generate IDOCs using SAP/ALE Integration with Informatica Power Exchange.
• Created SAP/ALE IDoc Preparer and Interpreter Transformations to process the segment d Confidential from upstream/downstream transformations.
• Extracted d Confidential from SAP R/3 systems to generate Checks and Charge back files using Informatica Power Exchange ABAP Integration.
• Extensively used Informatica d Confidential quality tools (Developer & Analyst) for analyzing, standardizing, cleansing, matching, conversion, exception management, reporting and monitoring the d Confidential .
• Created custom profiles and score cards using Informatica Analyst tool.
• Created DQ rules using expressions and mapplets and reused in multiple profiles.
• Created mappings in developer for duplicate analysis and profiling
• Integrated Informatica developer mappings with power center client.
• Created jobs in workflow manager and scheduled using Tivoli.

Environment: Informatica Power Center 9.1.0, Informatica Power Exchange 9.1.0, Informatica Developer Tool 9.1, UNIX Shell Scripting, SAP GUI, Putty, Tivoli. Flat Files.

Confidential

Sr. Informatica Developer

Responsibilities:

• Designed ETL mappings/sessions/workflows for the monthly feeds to extract d Confidential from Confidential and generate files to provide to EDH.
• Involved in Logical / Physical d Confidential modeling of the Banks HQA DWH.
• Interacted and worked closely with HQA Business users in d Confidential validations and reconciliation of OFSA 4.5 and OFSAA 6.5 systems.
• Involved in SIT, UAT, Pre and Post PROD deployment activities.
• Scheduled and Monitored workflows on the TIDAL server.
• Worked on performance tuning of the existing ETL framework (OFSA 4.5)

Environment: Informatica Power Center 9.1.0 Unix Shell Scripting, DB2, Oracle, TOAD, Putty and Tidal.

Confidential, NJ

Sr. SAP-Informatica Integration Consultant/DQ Developer

Responsibilities:

• Responsible for understanding requirements in Interface Control document (ICD) and creating ETL design documents.
• Responsible for ETL coding, unit testing and UNIX shell scripting.
• Developed d Confidential integrity reports through Column Profiling using Informatica Analyst and mappings in Informatica Developer.
• Have used different Informatica Developer (IDQ) transformations like Case, Comparison, Confidential, Match, Parser, Standardizer, Weight, Exception, Rule Based Analyzer, Lookup, SQL, Expression etc. and created IDQ mappings.
• Imported mapplets and mappings from Informatica developer (IDQ) to Power Center.
• Generated XML target files using Informatica Power Center.
• Have used Informatica Web Services Consumer transformation and Power Center Web Services Hub concepts to interact with Web Services CLOUD applications/clients using WSDL files in the form SOAP messages.
• Have used Informatca Cloud applications to pull the Salesforce d Confidential (Accounts, Customers specifically) into Oracle Staging area.
• Responsible for code reviews and deployment activities.
• Responsible for providing support in SIT, Pre-Production and Production environments.

Environment: Informatica Power Center 9.5.1, Informatica Developer\Analyst 9.5.1, Informatica Power Exchange for Web Services, XML, Oracle 11.2.0, UNIX Shell Scripting, Oracle SQL Developer and Putty.

Confidential

ETL Architect/Sr. Informatica Developer

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Responsible for providing requirements, functional knowledge and design documents to ETL team for development
• Responsible for converting requirements into comprehensive detail design specifications (Integration, d Confidential bases, d Confidential flows, transformations, interfaces etc.) for solutions
• Responsible of creating project plan and working with customer on regular basis to show the progress at each stage
• Responsible for all ETL deliverables in SDLC methodology such as integrated functional specification, source to target mapping sheet, design, coding, unit testing and deployments
• Integrated Informatica with SAP R/3 system using ABAP programs in extracting d Confidential
• Integrated Informatica with SAP BI system in extracting d Confidential from Open Hubs using power exchange
• Integrated Informatica with Salesforce Cloud in extracting Customer flags and RFM d Confidential .
• Integrated Informatica with Web Services using Power Exchange in extracting d Confidential .
• Other source systems majorly used are Terad Confidential, Oracle, SQL Server, XML and Flat Files
• Extensively used Terad Confidential utilities MULTILOAD, FASTLOAD, TPUMP, TPT and BTEQ Scripts to load d Confidential into D Confidential warehouse.
• Created UNIX shell scripts to run the Informatica workflows, Dynamic parameter files creation, indirect file creation, file watcher and email notification etc…
• Responsible code reviews and d Confidential validations.
• Responsible for driving the team to meet the objective of the project by proactively taking decisions.
• Responsible for proactively identifying risks, assumptions, issues and providing solutions\suggestions on time.
• Responsible for preparing migration plan and coordinating with respective teams.

Environment: Informatica Power Center 9.1, Informatica Power Exchange 9.1 for SAP NetWeaver, Terad Confidential, Unix Shell Scripting, Sources ( SAP BW, Share Point List, MS SQL Server, Flat files & Oracle ), Terad Confidential SQL Assistant, Salesforce, Force.com, Putty, Autosys & Soap UI

Confidential

ETL Informatica Developer

Responsibilities:

• Understood the requirements from Requirements Definition Report (RDR).
• Created understanding document and LLD’S.
• Developed mappings, mapplets, re-useable transformations and unit test case plans.
• Extensively used various Informatica transformations like Expression, Filter, Router, Sorter, Joiner, Aggregator, Union and Update Strategy transformations.
• Have used performance tuning techniques to increase the session performance.
• Moving Infa objects (mappings, mapplets, sessions and workflows) to pilot and prod environments.
• Responsible for Unit testing and creating migration plans.
• Created Shell Scripts to automate the Pre-Session and Post-Sessions jobs.
• Coordinated with the QA team for integration testing.
• Involved in Support Handover of Project to Support People.
• Interacted with onsite team for requirement modifications and for project updates

Environment: Informatica Power Center 8.1/7.1, DB2 UDB, Oracle, SQL, PL/SQL & UNIX Shell Scripting.