SUMMARY:

• 13+ years’ professional experience in IT industry with special emphasis on design, development and testing of D Confidential base/D Confidential Warehousing applications using Informatica Power Center in various domains like Pharmaceutical, Financial, Health, Media & Entertainment.
• Strong experience in Informatica PowerCenter,PowerConnect for ETL (Extraction Transformation and Loading) of d Confidential from multiple source d Confidential base systems in both UNIX/Windows environment.
• Diversified Domain expertise implementing solutions to D Confidential Warehousing and BIG D Confidential Projects.
• Practical understanding and experience with D Confidential Mapping, D Confidential Validation and D Confidential Modeling (Dimensional & Relational) concepts such as Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Expertise in normalizing d Confidential .
• Solid experience in Informatica Power Center (versions 9.6/8.6/ 7.1) including Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console and Terad Confidential .
• Worked with Informatica D Confidential Quality (IDQ) toolkit, Analysis, d Confidential cleansing, d Confidential matching, d Confidential conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Expertise in Oracle,PL/SQL, Functions, Procedures, Packages, Triggers and Materialized Views.
• Excellent knowledge in Creating and Maintaining D Confidential base objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
• Experienced in RDBMS design, d Confidential modeling, d Confidential normalization and SQL tuning using Indexes and working with UTL Files.
• Extensively worked on UNIX shell scripting for creating and maintaining the parameter files, executing d Confidential base procedures, calling Informatica workflows, and job scheduling.
• Effectively communicate with business users, Business Analysts, project manager and team members.
• Strong ability to work within a demanding and aggressive project schedules and environments.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.
• Extensive experience in architecting, implementing, maintaining and migrating D Confidential Warehouse projects.
• Excellent hands of experience in monitoring bug status using Jira and maintaining project documentation using Share Point.
• Good knowledge on Java
• Good knowledge in D Confidential base Schema Designing ER-modeling and Multi-Dimensional D Confidential Modeling (MDDM) (Star, Snow Flake schema) using Erwin tool
• Extensively developed the complex stored procedures, functions to maintain and populate the d Confidential into the D Confidential marts, EDWH system and OLAP d Confidential base.
• Effective, independent and team player and self-starter with high adaptability to new technologies and a penchant to learn new things.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment.
• Excellent written and verbal communication skills blended with good analytical reasoning.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP,2003/2008 Server, Windows 7, UNIX

D Confidential bases: Oracle12c,11g,10g,9i,8i,MSSQLServer, MSAccess, Terad Confidential

Dimensional D Confidential Modeling: Dimensional D Confidential Modeling, D Confidential Modeling, Star and Snow flake schema Modeling, Physical and Logical D Confidential Modeling, Fact and Dimensions table

BI tool: Informatica Power Center, Informatica cloud, IDQ, OBIEE 11g.

Languages: Java 7/8,PL/SQL, HTML, XML, Shell Scripting, SQL *plus, SQL *loader

BIG D Confidential: HDFS, MapReduce, HIVE, PIG, Sqoop, SPARK & OOZIE.

PROFESSIONAL EXPERIENCE:

Confidential, VA, US

Team Lead

Responsibilities:

• Involved in leading a team of 12 members.
• Responsible for Business Analysis and Requirements gathering.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Worked with heterogeneous source to Extracted d Confidential fromOracle d Confidential base, XML and flat files and loading to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Performed tuning of SQL queries and Stored Procedures for speedy extraction of d Confidential, to resolve and troubleshoot issues in OLTP environment.
• Involved in building the ETL architecture and Source to Target mapping to load d Confidential into D Confidential warehouse.
• Involved in Dimensional modeling (Star Schema) of the D Confidential warehouse and used Erwin to design the business process, dimensions and measured facts.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business d Confidential in OLTP system..
• Developed mapping parameters and variables to support SQL override.
• Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
• Worked with Services and Portal teams on various occasion for d Confidential issues in OLTP system.
• Worked with the testing team to resolve bugs in ETL mappings before migrating to production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve d Confidential issues in Production d Confidential base of OLAP and OLTP systems.
• Designed Informatica Mappings and Workflows to be re-startable after a failure.
• Designed tables required for the execution of the ETL processes using ERwin.
• Extracted d Confidential stored in a multi-level hierarchy using Oracle Stored Procedures.
• Loaded Customer d Confidential in multiple levels (rows) using Oracle Stored Procedures and Cursors.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
• Provided excellent support during QA/UAT/Beta testing by working with multiple groups.
• Optimized the SQLs and Informatica mappings which handled millions of records.
• Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.
• Developed re-usable components in Informatica, Oracle and UNIX
• On-Call/Production Support provided during day-time and off-hours.
• Actively participated in Install/Deployment plan meetings.
• Proved accuracy in doing sanity checks, smoke tests after the install of new scripts used by ETL.
• Prepared D Confidential Mapping documents, process documents, Re-startability Matrix to help on-call team reduce the turnaround time when there is an issue.
• Efficiently handled multiple projects during resource crunch.
• Provided to the team with the functional and technical knowledge.

Environment: Informatica PowerCentre 9.6,Workflow Manager, Workflow Monitor,InformaticaPower Connect / Power Exchange, D Confidential Analyzer 8.1, Toad, SQL Developer, Oracle 11g, SQL loader, PL/SQL, Erwin,Linux,Terad Confidential, Micro Strategy and Tableau.

Confidential

Team Lead

Responsibilities:

• Involved in gathering requirements from business users. Participated in the detailed requirement analysis for the design of d Confidential marts.
• Actively interface with other teams to gather requirements, design, code, debug, document, implement and maintain various DB projects.
• Worked according to the specifications and restrictions of the company by strictly maintaining d Confidential privacy.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized d Confidential models for D Confidential warehouse supporting d Confidential from multiple sources.
• Worked with Informatica D Confidential Quality (IDQ 8.6.1) for d Confidential quality measurement.
• Involved in building the ETL Source to Target mapping to load d Confidential into D Confidential warehouse.
• Created mapping documents to outline d Confidential flow from sources to targets.
• Extracted the d Confidential from the flat files and other RDBMS d Confidential bases into staging area and populated onto D Confidential warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts using existing ETL standards.
• Worked on different tasks in Workflows like sessions, events raise,event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract d Confidential from various sources, transformed d Confidential, and loading into d Confidential warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load d Confidential from flat files to the d Confidential base tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Migrated the codes from Dev to Test and Test to Prod. Wrote the migration documentation in details for system compatibility, object and parameter files for smooth transfer of code into different environments.
• Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets (command, email, assignment, control, event wait/raise, conditional flow etc.) and configured them according to business logic & requirements to load d Confidential from different Sources to Targets.
• Created Pre & Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on d Confidential .

Environment: Informatica Power Centre,Workflow Manager,Workflow Monitor,InformaticaPower Connect/PowerExchange,Erwin,Toad,SQLDeveloper,Oracle11g,SQLloader,Linux,PL/SQL,Terad Confidential, Micro Strategy and Tableau

Confidential

Sr.Developer

Responsibilities:

• Extensively involved in requirements gathering, writingETLSpecs and preparing design document
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts
• Developed code to extract, transform, and load (ETL) d Confidential from inbound flat files and various d Confidential bases into outbound flat files and XML files using complex business logic
• Expertise in performance tuning of the mappings,ETLEnvironments, procedures, queries and processes
• Expertise in handling and loading high volumes of d Confidential into d Confidential warehouse in a given load window
• Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
• Extensive experience in D Confidential warehouses with strong understanding of Logical, Physical, and Dimensional D Confidential Modeling to Design Star and Snow flake Schemas.
• UtilizedInformaticaIDQ 8.6.1 to complete initial d Confidential profiling and matching/removing duplicate d Confidential .
• Used SCD (type1, type2 and type3) to Load present and Historical D Confidential to ODS, EDW.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Experience inETLprocess usingETLTools, creating and maintaining Repository, Source systems, Target D Confidential bases and developing strategies forETLmechanisms usingETLtools,Gathering and analysis, design, development, testing, performance tuning, and production support.
• Experience in Unix Shell scripting, scheduling cron jobs and also Job Scheduling on multiple platforms like Windows NT/2000/2003, Unix
• Strong technical skills in Oracle, SQL, PL/SQL, MySQL.
• Worked with architects and DBA in designing the rules engine and implementing the logical, physical and Dimensional model based on the rules and metad Confidential .
• Responsible for preparing the technical specifications from the business requirements

Environment: Informatica PowerCenter 9.1,Informatica Power Centre,Workflow Manager,Workflow Monitor, Oracle11g/12c, Toad, Sun Solaris11.1, Visual SourceSafe, SQL, PL/SQL,BO,Unix,AutoSys and Tableau

Confidential

Sr.Developer

Responsibilities:

• Extensively involved in requirements gathering, writing ETL Specs and preparing design document
• Designed and developed ETL mappings for d Confidential sharing between interfaces utilizing SCD type 2 and Confidential methodologies
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts
• Developed code to extract, transform, and load (ETL) d Confidential from inbound flat files and various d Confidential bases into outbound flat files and XML files using complex business logic
• Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes
• Expertise in handling and loading high volumes of d Confidential into d Confidential warehouse in a given load window
• Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
• Extensive experience in D Confidential warehouses with strong understanding of Logical, Physical, and Dimensional D Confidential Modeling to design Star and Snow flake Schemas.
• Utilized of Informatica IDQ 8.6.1 to complete initial d Confidential profiling and matching/removing duplicate d Confidential .
• Used SCD (type1, type2 and type3) to Load present and Historical D Confidential to ODS, EDW.
• Planned, created and executed SSIS packages to integrate d Confidential from varied sources like Oracle, DB2, flat files and SQL d Confidential bases and loaded into landing tables.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Experience in ETL process using ETL Tools, creating and maintaining Repository, Source systems, Target D Confidential bases and developing strategies for ETL mechanisms using ETL tools
• Gathering and analysis, design, development, testing, performance tuning, and production support.
• Experience in Unix Shell scripting, scheduling cron jobs and also Job Scheduling on multiple platforms like Windows NT/2000/2003, Unix
• Worked with architects and DBA in designing the rules engine and implementing the logical, physical and Dimensional model based on the rules and metad Confidential .

Environment: Informa Informatica PowerCenter 9.1,Informatica Power Centre,Workflow Manager,Workflow Monitor, Oracle11g/12c, Toad, Sun Solaris11.1, Visual SourceSafe, SQL, PL/SQL,BO,Unix,AutoSys and Tableau.

Confidential

Sr.Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center
• Develop Mappings and Workflows to generate staging files.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the d Confidential into target table.
• Created multiple Mapplets, Workflows, Tasks, d Confidential base connections using Designer, Workflow Manager
• Created sessions and batches to move d Confidential at specific intervals & on demand using Server Manager
• Used debugger to validate the mappings and gain troubleshooting information about d Confidential and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Responsibilities include creating the sessions and scheduling the sessions
• Extracted the d Confidential from Oracle, DB2, CSV and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Understanding the Functional Requirements.
• Designed the dimension model of the OLAP d Confidential marts in Erwin.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• Performed Unit testing and System integration testing. Preparing the documents for test d Confidential loading
• Troubles shoot the Productions failure and provide root cause analysis. Worked on emergency code fixes to Production.
• Created Mappings to extract the unique account numbers from the d Confidential warehouse tables, and updated them with tokens in PCCD/SKOUT/KOUT files and d Confidential warehouse tables.

Environment: Informatica PowerCenter 8.6.1 (PowerCenter Designer, workflow manager, workflow monitor), Oracle 10g, Windows XP, TOAD, SQL.

Confidential

Sr.Developer

Responsibilities:

• Responsible for Business Analysis and Requirements gathering.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized d Confidential models for D Confidential warehouse supporting d Confidential from multiple sources.
• Involved in building the ETL architecture and Source to Target mapping to load d Confidential into D Confidential warehouse.
• Involved in Dimensional modeling (Star Schema) of the D Confidential warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the d Confidential from the flat files and other RDBMS d Confidential bases into staging area and populated into D Confidential warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Invoked Unix Scripts through Command task, Under Session and Pre/Post session commands
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract d Confidential from various sources, transformed d Confidential, and loading into d Confidential warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load d Confidential from flat files to the d Confidential base tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 8.6.1 (PowerCenter Designer, workflow manager, workflow monitor), Oracle 10g, Windows XP, TOAD, SQL.

Confidential

Sr.Developer

Responsibilities:

• Involved in gathering requirements from business users. Participated in the detailed requirement analysis for the design of d Confidential marts and star schemas.
• Created Technical design specification documents based on the functional design documents and the physical d Confidential model.
• Extracted d Confidential from several source systems like Oracle, DB2, Flat files, XML files, etc. and loaded d Confidential into Enterprise D Confidential warehouse. Designed many Multi Source Single Target mappings and vice versa.
• Worked on Power Center Designer client tools like Source Analyzer, Target Analyzer, Mapping Designer and Mapplet Designer.
• Created reusable transformations by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the TransformationDeveloper
• Moved the d Confidential from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type 2 and type 1.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA during the runs.
• Informaticaworkflow manager was used to create, schedule, execute Sessions, Worklets, Command, E-Mail Tasks and Workflows. Performed validation and loading of the Flat files received from business users.
• Wrote several oracle stored procedures, functions and packages for build and deployment process.
• Wrote UNIX Shell scripts to schedule the workflows and also to extract the d Confidential from the various d Confidential bases and file systems
• Managed various d Confidential marts by collaborating with different organizations including IT teams and DBAs to build a quality system and adhering to standard operating procedures resulted in a highly available 24x7 system to business and product development consumers worldwide
• Used Parameter files to reuse the mapping with different criteria to decrease the maintenance.
• Used Autosys to scheduleInformatica, SQL script and shell script jobs.
• Identifying the issues and resolutions by coordinating with the QA team and acted as a point of contact between the Dev and the QA team.
• Trained and provided knowledge transfer to colleagues and technical consultants who developed applications and generated more than 300 reports and metrics utilizing the Engineering D Confidential Warehouse environment.

Environment: Informatica PowerCenter 8.6.1 (PowerCenter Designer, workflow manager, workflow monitor), Oracle 10g, Windows XP, TOAD, SQL.

Confidential

Developer

Responsibilities:

• Involved in Full life cycle of Business Objects reporting Application from requirements gathering to deployment of the reporting system to the production environment.
• Designed and developed Reports and Universes based on the specifications and assigned them to respective domains.
• Developed Transformation logic and designed various complex Mappings in the Designer for d Confidential load and d Confidential cleansing.
• Responsible for using the capabilities of PowerCenter namely list files, pmcmd, pmrep, Target override, Persistent lookup, Dynamic & Static lookup.
• Develop Logical and Physical d Confidential models that capture current state/future state d Confidential elements and d Confidential flows using Erwin.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• DevelopedInformaticaMappings, Re-usable Transformations, and Mapplets for d Confidential load to d Confidential warehouse and d Confidential base (oracle)
• Support betweendevelopersand end users, functional managers and Oracle regarding issues with d Confidential base software, SQL programming, tuning, releases and development with Oracle tools like Oracle Warehouse Builder.
• Involved in creatingETLmodel (snowflake schema), normalizing and documenting.
• Walked through the Logical and Physical D Confidential Models of all source systems for d Confidential quality analysis.
• Involved in XML parsing and loading XML files into the d Confidential base.
• Optimizing/Tuning mappings for better performance and efficiency.

Environment: Informatica PowerCenter 8.6.1 (PowerCenter Designer, workflow manager, workflow monitor), Oracle 10g, Windows XP, TOAD, SQL.

Confidential

Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and d Confidential specifications for Business Objects universes and reports.
• Created parameterized Crystal reports using Charts, Cross-Tab reports, sub-reports, Running Totals.
• Created mappings for dimensions and facts.
• Designing and creation of complex mappings involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Extracted d Confidential from various sources like Oracle, flat files and XML.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer, Warehouse Designer and Transformation Developer.
• Worked on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide d Confidential for reporting purposes
• Created complex mappings using different transformations such as Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expression and Aggregator transformations to pipeline d Confidential to D Confidential Mart. Also, made use of variables and parameters.
• Designed and created scripts for objects such as tables, indexes, views, sequences, object types and collection types.
• Used changed d Confidential capture type mappings to load slowly changing Type 1, 2 and 3 dimensions.
• Extensively used Power Center command line utilities such as pmcmd, Pmrep embedded in shell scripts to perform various administrative tasks such as migrations, repository backup scripts, start/stop scripts, statistics collections etc.
• Tuned inefficient queries using combinations of index creation, alternate indexing strategies, join strategies and query level optimization hints
• Developed Oracle PL/SQL Stored Procedures.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Involved in trouble shooting the issues faced in the production environment and serving as a point of contact in between the QA team and Production team, minimizing the loss by providing swift and immaculate solutions in a timely manner.

Environment: Informatica PowerCenter 8.6.1 (PowerCenter Designer, workflow manager, workflow monitor), Oracle 10g, Windows XP, TOAD, SQL.