SUMMARY:

• Seasoned professional with 7+ years experience working on data warehousing projects in varied roles including Analysis, Design, Build, Test, Maintenance Support.
• Experience with Data flow diagrams, Database normalization theory and Entity - relation modeling
• Developed strategy for ETL solutions.
• Used Informatica MDM and collected Metadata from various data integration environments
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Effectively using Table Functions, DML statements, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Dynamic SQL, Records, PL/SQL Tables, Oracle supplied packages, Ref Cursor, External Tables.
• Experience in SQL performance tuning using Execution plans and Hints
• Created various BI reports, dashboard using OBIEE and Tableau
• Well versed working with UNIX /Shell Scripting
• Experience in OBIEE 10g and 11 g. Worked on Answer Reports and Dashboards.
• Experience in test planning, test execution and test results analysis.
• Good experience in Manual, Functional, System Integration (SIT) and User Acceptance Testing (UAT).
• Experience in Agile development environment
• Involved in collaboration & team building skills and activities with proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.
• Extensively worked on Informatica client tools Admin Console, Repository manager, Designer, Workflow manager, Workflow monitor and worked extensively with application teams on complex mappings using different transformations to debug mappings/work flows for error handling and recovery strategies in Informatica ETL environments.
• Experience in Master Data Management concepts (MDM), Metadata injection and ability to apply this knowledge in building business solutions.
• Decent knowledge and trained in Pentaho, SAP business objects.

TECHNICAL SKILLS:

Software tools: Informatica PowerCenter, Informatica MDM, Oracle SQL Developer, Oracle-BI (OBIEE Plus), Control - M, Oracle Data Integrator(ODI), Data Admin Console (DAC), Siebel EIM, Siebel Tools, TOAD, Tableau, Pentaho

Source/Target: Salesforce.com, Siebel, Flat /XML Files

Programming/Scripting Languages: PL/SQL, UNIX Shell scripting, PowerShell, HTML, XML

DBMS/RDBMS: Oracle 10g, Oracle 11g, Microsoft SQL Server 2008/2012, MySQL, Greenplum

Operating Platform: UNIX, Windows 2000/2008/2012 R2 Server, Microsoft SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley Heights, NJ

Senior Informatica Developer

Responsibilities:

• Worked on Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems and flat files, which includes fixed-length, as well as delimited files.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation and Aggregator Transformation.
• Created Mapplets, reusable transformations and used them in different mappings.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Performed performance tuning of source level, target level, mappings and session.
• Worked with UNIX scripts for automation of ETL Jobs using Control M Scheduler.
• Created UNIX Shell scripts to FTP the files.
• Responsible for creating and modifying the PL/SQL procedures, functions according to the business requirement.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individual developed mappings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Worked towards data modeling, baseline the data model to accommodate all business specific requirements and configured Informatica MDM Hub Server, Lookup Adapter, Cleanse Server, Cleanse Adaptor and Resource Kit.
• Planned, created and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• As per the client architecture understand the customer/vendor/item (MDM) data model.
• Performed unit testing in all stages of MDM and ETL from where data releases.

Environment: Informatica PowerCenter, Oracle 11g, Oracle PL/SQL, TOAD, Control-M, MDM

Confidential, Palo Alto, CA

Informatica Lead Developer

Responsibilities:

• Leading the EDW Team of 4 members and supervising the all the tasks within the team.
• Integration and ETL of data from sources like Salesforce.com, D&B, Oracle Apps, Flat files etc.
• Analyzed existing Data Model and accommodated changes according to the business requirements.Resolved inconsistent and duplicate data to support strategic Goals with Multi-domain MDM
• Preparing the Deployment docs and Test Plan Doc for every Month Release.
• Use Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Perform data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Worked on Informatica PowerCenter 8.6 tool - Source Analyzer, Mapping and Mapplet Designer and Transformation Designer. Developed Informatica mappings and in tuning of mappings for better performance.
• Create PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Prepare documentations for application developed
• Writing database objects such as functions, stored procedures, packages and triggers to meet the fun Create Complex ETL Packages
• Create Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database
• Perform operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Writing database objects such as functions, stored procedures, packages and triggers to meet the functional requirements using Oracle PL/SQL and T-SQL
• Write complex SQL queries using analytical queries, statistical functions, model queries, and regular expression and use built-in packages supplied in PL/SQL.
• Checked Sessions and error logs to troubleshoot problems and used debugger for trouble shooting.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCD's (Type 1/Type 2) loads.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Create MDM mappings using best practices to capture the errors and have a clean load using Informatica power center.
• Worked on Metadata injection to solve repetitive ETL workloads like loading of text files, data migration.

Environment: Microsoft SQL, Informatica PowerCenter, Oracle 11g, Oracle PL/SQL, TOAD & MDM.

Confidential, Palo Alto, CA

Senior Analyst Programmer

Responsibilities:

• Experience in setting up of new Informatica environments Installation, configuration, upgrade/ migration from older version, applying patches, Bug Fix and Hot Fixes, for Informatica Power Center.
• Experience in Native authentication for user management along with strong hands on in security administration, creating and managing users, groups and roles for assigning privileges accordingly to users and folders.
• Regular communications with client and opening bridge calls (lifeline call) for blocking issues to get them fixed within minimum time frames.
• Perform software development activities associated with ETL mappings.
• Root Cause Identification of the critical production load and data issues.
• Proficient in Data analysis. Worked as Informatica Administrator involved in Host migration activity.
• Responsible for user creation, Informatica installation on server and shut-down / Start up process.
• Finding bugs, reproducing them (environment checks) and then reporting them on Helpzilla Once fixed, updating clients and other people.
• Coordinating during Deployment activities with various Development teams.
• Was responsible for migration of Informatica and DB objects.
• Interacting with the end users to understand the issues faced and suggesting them the correct approach.
• Perform data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Worked on Informatica PowerCenter 8.6 tool - Source Analyzer, Mapping and Mapplet Designer and Transformation Designer. Developed Informatica mappings and in tuning of mappings for better performance.
• Coordinating with development teams for design changes in production.
• Monitor Production data feeds and extract in daily basis and troubleshoot if any issues come arise.
• Read UNIX server log to find out any issues related to data feeds and extract generation
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: Microsoft SQL Server Integration Services, Informatica PowerCenter, Oracle BI Publisher, Oracle 11g, Oracle PL/SQL, TOAD, DAC, Control - M, Oracle Data Integrator.

Confidential

Senior Informatica Developer

Responsibilities:

• System analysis, physical data model design and logical data model design using Erwin
• Prepare documentations for change managements
• Writing database objects such as functions, stored procedures, packages and triggers
• Perform operations like Data reconciliation, validation and error handling
• Work closely and interact directly with business, technology and product stakeholders to define and document business intelligence solution requirements
• Perform SQL and PL/SQL tuning and Application tuning using various
• Write complex SQL queries using analytical queries, statistical functions, model queries, regular expression and use built-in packages supplied in PL/SQL.
• Data mapping and design integration solutions
• Writing ad hoc queries to get different information scattered in various database and tables.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX
• Design star schema, snowflake schema.
• Worked on the existing Mappings as well as build of the new o bjects from technical design to the unit testing of the object.
• Created the Technical Design Documents, Migration documents, Unit test documents of the components assigned for build.
• Doing the build for both the Facts and Dimension mappings (SDE and SIL) and have experience increating the SCD2 mappings.
• Involved in the OBIEE testing of reports and Dashboards.(Adding and removing the columns and validating the data on the in database and also have performed the c osmetic changes in the report.)
• Good experience in OBIEE Answers Reports and Dashboards.

Environment: Oracle 10g, Oracle PL/SQL, TOAD, Informatica, OBIEE10g.

Confidential

ETL Developer

Responsibilities:

• Worked as Informatica Developer in the Interface Data Load Team.
• Prepare requirements and functional specifications
• Prepare high level and detailed design documents
• Prepare ER diagrams and data models
• Writing SQL queries, functions, stored procedures and triggers
• Work in a team in all the phases of SDLC
• Perform various unit tests to check validity of applications
• Create user Documentation and technical documentation
• Data extraction, data preparation and data loading from various sources to SQL Server database and Oracle 10g database for creating fast report
• Involve in the backup database, data migration, restoration and recovery
• Performance tuning of the database and system
• Developed familiarity with Siebel Data Model, Siebel tools and Siebel EIM which were integrated with Informatica, in a quick span of time to take care of the Development, ST, UAT and Deployment Phase of multiple projects.
• Loading the data for ST,UAT and Production phase for various releases and also debugging the issues during the Load.
• Database installation, and upgrading

Environment: Oracle 10g, PL/SQL, TOAD, Informatica, Sibel tools and Sibel EIM.