SUMMARY:

• Teradata 12 Basics Certified, Oracle Certified Associate and ITIL v3 Foundation Certified
• Sr. ETL developer, Team Lead, Informatica Admin, MFT developer/admin for Cleo VLTrader
• Around 8 years of experience in the Analysis, Design, Development, Implementation, testing and support of Database & Data Warehousing applications
• Experienced in understanding the Business requirements and translating them into detailed design along with Technical specifications
• ETL solution implementation for Healthcare, Life sciences and Retail clients
• Experienced in using Informatica Power Center 9.x 10.1, IDQ, Informatica Administration, Oracle, MS SQL, Netezza, TERADATA utilities (BTEQ, SQL Assistant), Cleo VLTrader
• Completed trainings working on HIVE, PIG
• Well versed in all the Data Warehousing concepts with all the stages of its Life Cycle
• Having good experience in working with source system changes, Multi Country roll outs, handling different language characters in Informatica and database
• Good experience in working with onsite - offshore model and experienced in client handling
• ETL coding guideline standardization, mapping development, performance tuning, scheduling and production support, expertise in Extraction, Transformation and Loading technologies - Designer (Source Analyzer, Mapplet designer, warehouse designer, transformation developer, mapping designer), Repository Manager, Workflow Monitor, Workflow Manager (Workflow Designer, worklet designer, Task Developer) and PMCMD.
• Good knowledge and experience in fine-tuning SQLs, make use of indexes, hints and execute in parallel for improving performance.
• Worked on Projects to Pull data from sources like Service Now, Sales force etc.

TECHNICAL SKILLS:

Technologies: Informatica Power Center(8.6,9.x,10.1), Informatica data Quality, Informatica Administration

Databases: Teradata, Oracle, MS SQL, Netezza

MFT: Cleo VL Trader

Scheduling: Control M, Tidal, WLM, Informatica Scheduler

Operating Systems: MS Windows 9.x,7,10 Server 20101, 2013, Unix

Tools: Putty, WinScp, Toad, Clear Case

Project Development Methodology: SDLC, Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, Arizona

Sr ETL Informatica developer/Support Lead, Informatica and MFT Administrator

Role and Responsibilities

• Designed and developed the data pull from Service Now to Netezza DB using Informatica
• Developed and Scheduled all ETL, Oracle, Unix, Windows jobs in TIDAL
• Analyzing all the business requirements, source and target system behavior. Provide the time, resource and cost estimation. Prepare the HLD and LLD documents.
• Informatica Administration activities and MFT focal point of contact.
• Interact with Business Users and Managers in gathering business requirements.
• Design, Develop and support Informatica, Oracle, Netezza, MS SQL coding objects
• Gather MFT requirements from vendors across geographies and configure the MFT set ups as applicable
• Establish ETL coding standards and perform Informatica coding reviews and bug fixes.
• Support 80+ applications currently running in EDW and carry out CSI activities
• Worked with team to develop all the code (Informatica mappings/workflows, UNIX Shell scripts, SQL scripts).
• Conducting Code review/Code walkthrough meetings to better understand the process flow & make sure there are no issues in production post-go Live.
• Worked on Unit testing, System Integration testing, QA/UAT to thoroughly test the new platform's functionality.
• Preparation of migration plan and coordinate among different team to execute the migration plan to migrate the code (WF/Mapping, UNIX Shell scripts, SQL scripts) from QA/UAT to Production environments.
• Supported day to day jobs running in production environment and Provided Technical support for production tickets.
• Fine tuning the existing Informatica Mappings which are delaying the nightly batch cycle by significant amount of time.
• Involved myself in identifying the bottlenecks of the Informatica mappings and tuned the mappings and increased the performance of the mappings.
• Developed various complex SQL quires, creating and modifying PLSQL code, Workflow and Mapping for various adhoc requests

Environment: MS Windows 7, 10, 2013 Server, Informatica Power Center, Cleo VL Trader, TIDAL, JIRA, Service Now, Netezza, Oracle, MS SQL server, TIDAL

Confidential, Bridgewater NJ

Sr. ETL Informatica developer/Support Lead

Role and Responsibilities

• Analyze business requirements and work closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interact with Business Users and Managers in gathering business requirements.
• Design and implement the business solutions for the source master data change.
• Establish ETL coding standards and perform Informatica mapping reviews.
• Liaison with offshore team and clients for requirements coordination
• Design the flow and implement performance improvement measures for the onboarding of new applications.
• Worked with team to develop all the code (Informatica mappings/workflows, UNIX Shell scripts, SQL scripts).
• Conducting Code review/Code walkthrough meetings to better understand the process flow & make sure there are no issues in production post-go Live.
• Worked on Unit testing, System Integration testing, QA/UAT to thoroughly test the new platform's functionality.
• Preparation of migration plan and coordinate among different team to execute the migration plan to migrated the code (WF/Mapping, UNIX Shell scripts, SQL scripts) from QA/UAT to Production environments.
• Used pmcmd command in UNIX to kick off Informatica workflow from UNIX environment.
• Implemented SCD type 1 and type 2 dimensions.

Environment: MS Windows 7, 10, Informatica Power Center, Oracle, MS SQL server, Control M, ALM, Toad SQL, MS Office

Confidential

Sr ETL Informatica developer/Support Lead

Role and Responsibilities

• Analyze business requirements and work closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Establish ETL coding standards and perform Informatica mapping reviews.
• Track the SLA of the production incidents and Ensure on time resolution of incidents and work orders
• Identify and implement CRQs by coordination with business teams, development teams and support teams
• Identified and redeveloped code pieces for performance optimization at the IDS and EDM layers
• Liaison with offshore team and clients for requirements coordination
• Provide weekend support for critical business issues
• Ensure knowledge transition of new applications is provided to the Support team
• Control M job monitor and Schedules, check for abends, resolve and complete Load cycles
• Created ETL requirement after discussed with business partners, get the requirement sign off from business.
• Worked with team to develop all the code (Informatica mappings/workflows, UNIX Shell scripts, SQL scripts).
• Conducting Code review/Code walkthrough meetings to better understand the process flow & make sure there are no issues in production post-go Live.
• Worked on Unit testing, System Integration testing, QA/UAT to thoroughly test the new platform's functionality.
• Preparation of migration plan and coordinate among different team to execute the migration plan to migrated the code (WF/Mapping, UNIX Shell scripts, SQL scripts) from QA/UAT to Production environments.
• Fine tuning the existing Informatica Mappings which are delaying the nightly batch cycle by significant amount of time.
• Involved myself in identifying the bottlenecks of the Informatica mappings and tuned the mappings and increased the performance of the mappings.

Environment: MS Windows 7, 10, Informatica Power Center, Oracle, MS SQL server, Control M

Confidential

Sr ETL Informatica developer, Informatica Administrator, Support Lead

Role and Responsibilities

• Worked on All major and minor enhancements requests.
• Work with Project teams to help them in understanding the requirement, Provide Exiting data for Analysis and Design, Validate the Development and Testing.
• Analyzing all the business requirements, source and target system behavior. Provide the time, resource and cost estimation. Prepare the HLD and LLD documents.
• Created ETL requirement after discussed with business partners, get the requirement sign off from business.
• Worked with team to develop all the code (Informatica mappings/workflows, UNIX Shell scripts, SQL scripts).
• Conducting Code review/Code walkthrough meetings to better understand the process flow & make sure there are no issues in production post-go Live.
• Worked on Unit testing, System Integration testing, QA/UAT to thoroughly test the new platform's functionality.
• Preparation of migration plan and coordinate among different team to execute the migration plan to migrated the code (WF/Mapping, UNIX Shell scripts, SQL scripts) from QA/UAT to Production environments.
• Closely interacted with the business team to gather the requirements on how to handle the source data and design accordingly the ETL process.
• Worked closely with the data architect on the data model for building the pure wellness model.
• Developed EDW mappings based on the mapping document.
• Coded reusable transformations and mapplets which can be used for multiple mappings.
• Written complex SQL queries using sub queries to pull the data from the database.
• Created UNIX scripts for requirement purposes and for automation purposes.
• Closely worked with the QA team to fix any mapping related issues.
• Used error handling strategies for trapping errors in a mapping which sent errors to an error table.
• Migrated Informatica programs from one environment to another environment.
• Client Interaction: For formulating and implementing business rules one of the responsibilities included to have client interaction for analysis, development and issue clarification as well interact with business user to derive potential business inputs and requirement.
• Production Support: The project involved Critical jobs/application which would run in the production environment. My utmost responsibility was to ensure adequate support to address any issues.
• Set up a ticketing system for the support team, so as the development teams can raise their issues and assign it to the support team.
• Level 1 for Infrastructure support for Development and Application management team, and coordinate with GIS team as needed (Level 2 & 3)
• Capacity planning and optimization of all the servers under GBS IT reporting factory.
• Informatica Administration activities and support

Environment: MS Windows 7, Informatica Power Center, Informatica Data Quality, Oracle, MS SQL server, Informatica Administration, Usage of Human task in Informatica data Analyst services, Unix Putty

Confidential

Sr ETL Informatica developer, Informatica Administrator, Support Lead

Role and Responsibilities

• Worked closely with the business analyst and solutions consultant to understand the requirements.
• Worked on documenting business specification documents. Worked with the lead developer to understand mapping specification documents.
• Worked on High level and low level design document.
• Worked on existing ER model. Developed reusable mappings, mapplets using various transformations and developed workflows and worklets, session mapping.
• Developed PLSQL packages that loads the data from staging, applied business rules and loaded data into data warehouse fact and dimension tables.
• Used PLSQL collections and Bulk collect mechanism to load into the Data warehouse tables.
• Created Oracle External tables for use in loading with fixed width and delimited data from ASCII files to Oracle database tables.

Environment: MS Windows 7, 10, Informatica Power Center, Oracle, Unix Putty

Confidential

ETL developer, Teradata Developer

• Design and develop Teradata Scripts (BTEQ, Fast Load) to extract load and transform data for EDW
• Onshore and Offshore coordination.
• Perform Unit Testing and support and Recursion testing
• Enhancing the BTEQ Scripts used for Incremental Data Load.
• Deploy and implement the go live process
• Worked closely with the business analyst and solutions consultant to understand the requirements.
• Worked on documenting business specification documents. Worked with the lead developer to understand mapping specification documents.
• Worked on High level and low level design document.
• Provide Production and warranty support. Post the go live

Environment: MS Windows 7,Teradata BTEQ and Fast Load, MS Excel, MS Access, Unix Putty, Clear Case, WLM