EXPERIENCE SUMMARY:

• 10 + years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, and Telecom domain.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using D Confidential Warehouse/D Confidential Mart Design, ETL, OLAP, BI, Client/Server applications.
• Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Expertise in D Confidential Warehouse/D Confidential mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, d Confidential modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Terad Confidential and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions.
• Expertise in working with relational d Confidential bases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, MS Access, Terad Confidential and Netezza.
• Expertise in working with CRM platform Salesforce.
• Strong experience in Extraction, Transformation and Loading (ETL) d Confidential from various sources into D Confidential Warehouses and D Confidential Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metad Confidential Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server D Confidential bases.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, SQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in Installing and managing Informatica Power center, Metad Confidential Manager, D Confidential Explorer and D Confidential Quality.
• Experience in all phases of D Confidential warehouse development from requirements gathering for the d Confidential warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various d Confidential sources with multiple relational d Confidential bases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Terad Confidential and Flat Files into the staging area, ODS, D Confidential Warehouse and D Confidential Mart.
• Experience in using Automation Scheduling tools JAMS, Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Extensive experience in Extraction, Transformation and Loading of d Confidential from different heterogeneous source systems like Flat files, Excel, NETEZZA, DB2, Oracle, SQL Server and Terad Confidential .
• Extensively worked on migration of objects in all phases (DEV, QA and PROD) of project.
• Experience in Informatica D Confidential Quality, D Confidential Explorer and Power Exchange.
• Performed Unit testing, integration and System testing.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the d Confidential loading process.
• SAP ECC connectivity using Informatica BCI & ALE/IDOCS, BAPI/RFC.
• SAP BW connectivity with Informatica.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center HF & SSIS

D Confidential bases: Oracle 11g/10g, Netezza 7.1.0.x, SQL Server, Terad Confidential 13.0

Languages: SQL, PL/SQL, Unix Shell Scripting (ksh)

CRM: Salesforce (API version 36.0)

Environment: UNIX (AIX, Solaris, LINUX), Windows NT/XP.

D Confidential Modeling tools: Erwin, MS Visio

OLAP Tools: Cognos, OBIEE & Tableau.

Scheduling Tools: JAMS, Autosys and Control-M

Testing Tools: QTP and ALM ( Quality Center 11.0)

Project Tracking tool: JIRA & SNOW.

Big D Confidential: Hadoop (HDFS, Map Reduce, yarn), HIVE, PIG, Hbase.

Web Server: InternetInformationServer 5.1/6.0/7.0

Web Technologies: ASP.NET, Html, WPF, WCF, and MVC

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. ETL Developer/ Lead

Responsibilities:

• Interactive collaboration with business analysts and gathered functional requirements and designed technical design documents for ETL process.
• Operated Informatica Power Center to load d Confidential from different sources like flat files and Oracle, DB2 into IR.
• Worked on Confidential (Change D Confidential Capture) to implement SCD (Slowly Changing Dimensions).
• Analysis of the source system to determine elements needed for ETL designs and did extensive d Confidential profiling for ETL maps.
• Providing the JIL script to Autosys team and make sure to trigger the workflows accordingly.
• Developed shell scripts to kick off the work flows and verifying the file transfer through MFT.
• Developed Informatica Mappings and Workflows for D Confidential Integration.
• Organized the Workflows and Sessions for the Initial and Incremental D Confidential load runs.
• Prepared the Schedules for the Initial Load runs and Incremental Load runs.
• Designed test cases for initial and Incremental Load testing.
• Providing the updates to the team and involved in code review. Assigning the tasks to the team members.
• Making sure SFDC Bulk API, SFDC error file properties are enabled in session level when we are loading any d Confidential to salesforce.
• Interacting with TIBCO, PEOPLE SOFT teams for converting files as per their requirement and load the d Confidential into IR.
• Validating d Confidential and make sure to consume it by upstream and downstream systems.
• Create connections for salesforce, oracle and Netezza as standard format as per the requirement.
• Converted user defined functions of business process into Informatica defined functions.
• Developed and support the extraction, transformation and load process (ETL) for a D Confidential Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica
• Debug the Informatica mappings and validate the d Confidential in the target tables once it was loaded with mappings.
• Prepared and implemented d Confidential verification and testing methods for the D Confidential Warehouse as well as to design and implement d Confidential staging methods and stress testing of ETL routines to make sure that they don't break on heavy loads.
• Importing source & target objects from the d Confidential bases and CRM application.
• Executing SOQL queries in salesforce and validating d Confidential in salesforce.
• Tracking all the project issues in SNOW. Raising RFC ‘s for CAB approval to get the code from STG to PROD.
• Verifying the headers to make sure the client has sent right file lay out as per the submission guide.
• Worked on offshore/onsite model.
• Provided KT to support team about the interface and work flows.

Environment: Informatica Power Center 10.1.0, Salesforce, Oracle 11 g, MS Access, SQL Developer4.2.1,TOAD,SNOW, MS Excel., Confidential MFT, Salesforce accelerator, Informatica cloud, Aginity workbench 4.6, Salesforce Workbench API version 36.0, Putty, FileZilla, WinSCP, Confidential AS400, TIBCO, People soft, Autosys Scheduler and Tableau.

Confidential

Sr. ETL Informatica Consultant

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source d Confidential validation, developing particular logic and transformation as per the requirement and creating mappings and loading the d Confidential into Oracle, Netezza and Salesforce.
• Analysis of the source system to determine elements needed for ETL designs and did extensive d Confidential profiling for ETL maps.
• Developed Informatica Mappings and Workflows for D Confidential Integration.
• Organized the Workflows and Sessions for the Initial and Incremental D Confidential load runs.
• Prepared the Schedules for the Initial Load runs and Incremental Load runs.
• Designed test cases for initial and Incremental Load testing.
• Making sure SFDC Bulk API, SFDC error file properties are enabled in session level when we are loading any d Confidential to salesforce.
• Create connections for salesforce, oracle and Netezza as standard format as per the requirement.
• Converted user defined functions of business process into Informatica defined functions.
• Developed and support the extraction, transformation and load process (ETL) for a D Confidential Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica
• Debug the Informatica mappings and validate the d Confidential in the target tables once it was loaded with mappings.
• Prepared and implemented d Confidential verification and testing methods for the D Confidential Warehouse as well as to design and implement d Confidential staging methods and stress testing of ETL routines to make sure that they don't break on heavy loads.
• Importing source & target objects from the d Confidential bases and CRM application.
• Executing SOQL queries in salesforce and validating d Confidential in salesforce.
• Verifying the headers to make sure the client has sent right file lay out as per the submission guide.
• Executing various quries to make sure the source & target counts are matching or any drop off count .
• Sending emails & automated messages across the DIS team in case of emergency or app maintience support.
• Checking the d Confidential in sandbox as per the requirement also verifying the ETL code whether all the fields are appropriately populating to target system as per the S2T.
• Improved performance and fixed bottle necks for the processes which are already running in production. Also gained 3-4 hours load time for each process.
• Responsible for production supportof thesystemonRotabasis and monitoring critical jobs and escalating the issues to upper management in case of emergency.
• Worked on address doctor and validated the address and zip as per the requirement.
• Coordinating with DA’s, BA’s & PM’s in case of client enhancements and to make sure to having d Confidential in the mart. Adhere to HIPPA regulations and completed the HIPPA as per the org standards.
• Extensively involved in migration of Informatica Objects, D Confidential base objects from one environment to another.
• Communicate infrastructure needs and directions with management.
• Configured OS Profiles and LDAP Authentication.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group management.
• Write Repository Queries in support of developments and Production statistics.
• Ensures proper application of the licensing files.
• Developed shell scripts to auto run jobs in JAMS scheduler for picking up the files from one server to another, validating source files and arching files into path as per the requirement.
• Migration of Informatica Mappings/Sessions/Workflows from Sandbox to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the d Confidential loading process.
• Add and update ODBC and TNS entries.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Responsible for users & groups Management & Folder security.
• Provide Application support to ETL application development teams.
• Create, backup, restore and DR for Informatica Repositories.
• Handling space issues on UNIX servers to minimize the repository unavailability.
• Extensively worked on Informatica code deployments across different repositories.
• Record and maintain ETL software procedures.
• Worked on offshore/onsite model.

Environment: Informatica Power Center 9.5.1 HF4, Confidential Netezza7.1.0.x, Salesforce, Oracle 11 g, MS Access, SQL Developer4.2.1, HP Quality Center 11.0 (ALM), JIRA, MS Excel, Aginity workbench 4.6, Salesforce Workbench API version 36.0, Putty, FileZilla, WinSCP, JAMS Scheduler, Tableau and Health Care Solver.

Confidential, Houston, TX

Informatica Developer Lead/Admin

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• 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 on real time.
• Involved in building the ETL architecture and Source to Target mapping to load d Confidential into D Confidential warehouse.
• Created mapping documents to outline d Confidential flow from sources to targets.
• 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 onto D Confidential warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• 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.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Used Crontab for scheduling few of the jobs to auto run as per the requirement.
• 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.
• Used Debugger to test the mappings and fixed the bugs.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, Test, UAT to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the d Confidential loading process.
• Add and update ODBC and TNS entries.
• Responsible for users & groups Management & Folder security.
• Create, backup, restore and DR for Informatica Repositories.
• Handling space issues on UNIX servers to minimize the repository unavailability.
• Extensively worked on Informatica code deployments across different repositories.
• Perform independently with little direct supervision in administration of ETL.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• 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.
• Had played the role of an offshore ETL Technical Lead/Architect on this Project and was responsible for creating Technical Specs & Low Level Design for Offshore development.
• Was completely responsible for offshore delivery and the creation of WBS - Work Breakdown Structure for the offshore team.
• Played the role of a Project coordinator between various work streams within the project and create Unit Test and Integration Test Plans.
• Organize daily technical discussions with the Onsite team also including the individual offshore work stream leads and set expectations for offshore delivery.
• Provide Daily and Weekly Status Updates to the Project Manager .
• Was responsible in performing Integrating Migrated code and performing Integration Tests from Offshore and publish Test results to the onsite team.

Environment: Informatica Power Center 9.5.1, Workflow Manager, Workflow Monitor, Informatica Power Centre, Putty, FileZilla, D Confidential Analyzer 8.1, PL/SQL, Oracle 11g, Autosys, SQL Server 2005, UNIX, Toad 9.0, Cognos 8, Windows Server 2012,RFC,SAP ECC, SAP BW and Click software.

Confidential

ETL Developer

Responsibilities:

• Logical and Physical d Confidential modeling was done using Erwin for d Confidential warehouse d Confidential base in STAR SCHEMA.
• Using Informatica Power Center Designer analyzed the source d Confidential to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and Mapplets to transform the d Confidential according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Developed Stored Procedures and used them in Stored Procedure transformation for d Confidential processing and have used d Confidential migration tools.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Created and Configured Workflows and Sessions to transport the d Confidential to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system d Confidential base server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center 9.1.0, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix, Tera d Confidential, PL/SQL,SQL Developer, WinSCP and Putty.

Confidential

Informatica Administrator

Responsibilities:

• Installed, configured & upgraded InformaticaPowerCenter HF1/8.6.1 on Confidential -AIX platform.
• Assists team in defining solutions using Informatica.
• Plans and manages software upgrades and installation.
• Communicate infrastructure needs and directions with management.
• Installed and configured the following IDQ 9.1 components on AIX Server.
• Configured OS Profiles and LDAP Authentication.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group management.
• Write Repository Queries in support of developments and Production statistics.
• Ensures proper application of the licensing files.
• Configured Terad Confidential Parallel Transporter with Informatica 9.1 and created multi load, fast load and fast export connections.
• Migration of Informatica IDQ Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the d Confidential loading process.
• Add and update ODBC and TNS entries.
• Responsible for users & groups Management & Folder security.
• Provide Application support to ETL application development teams.
• Create, backup, restore and DR for Informatica Repositories.
• Handling space issues on UNIX servers to minimize the repository unavailability.
• Extensively worked on Informatica code deployments across different repositories.
• Record and maintain ETL software procedures.
• Perform independently with little direct supervision in administration of ETL.

Environment: Informatica Power Center 8.6.1, Oracle 10G, Confidential AIX, Terad Confidential, Ctrl M, Sybase.