SUMMARY:

• Innovative professional with around 9 years of progressive experience within the IT industry and the skills to manage all aspects of IT Application Services for Banking, Insurance and Retail clients.
• Proficient in Informatica PowerCenter 9.x, SQL, Oracle, Teradata, Unix/Linux shell scripting, Maestro, Tivoli.
• Extensive experience in Data Warehouse applications using Informatica PowerCenter on Windows and UNIX platforms.
• Expertise in working with relational databases such as Oracle 11g/10g, Teradata and File systems such as Hadoop.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources such as Hadoop files, Oracle, Teradata and formats like flat - files, COBOL files, XML files using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor) and load into targets such as Oracle and Teradata.
• Experienced in Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets and Workflows using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Performance tuning of Informatica mappings using PushDown Optimization.
• Experienced in parameterizing ETL flows using Unix/Linux shell scripting.
• Experienced in scheduling ETL jobs using Shell scripts, Maestro and Tivoli.
• Experienced to work in Development, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects in all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experienced in working for the post development cycle and applications in Production Support.
• Experienced in documenting High Level Design, Low level Design, Unit test plan, Unit test case and post development documents.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Ability to handle multiple tasks simultaneously.
• Good interpersonal and team co-operation skills.
• Proactive leader with refined acumen and exemplary people skills.
• Facilitate a team approach to achieve organizational objectives, increase productivity and enhance employee morale.
• Quick study, with an ability to easily grasp and apply to the application with new ideas, concepts, methods and technologies. Dedicated, innovative and self-motivated team player/builder.
• Exceptional leadership, organizational, oral/written communication, interpersonal, analytical, and problem resolution skills. Thrive in both independent and collaborative work environments.
• Avid learner and adaptable to any new technology.

TECHNICAL SKILLS:

Tools: Informatica Power Center 9.6/9.1, Teradata SQL Assistant 13.0, Advanced Query Tool 10.0.1

Databases: Oracle 11g/10g, DB2, Teradata 13.0

File System: Big Data Hadoop

Languages: SQL, PL/SQL, Unix/Linux shell scripting, JCL

Database Tools: HIVE, SQL Developer

Operating System: Windows 7/8/10, OS 390, Unix, Linux

Tools: Quality Center, JIRA, Tivoli, Advanced Query Tool, Maestro

PROFESSIONAL EXPERIENCE:

Confidential, Cary NC

Informatica Power Center Lead/Developer

Responsibilities:

• Gather requirements from the business owner and perform requirements analysis.
• Understand Mapping documents and Non-functional requirements to create detailed design specifications.
• Using Informatica Power Center Designer analyze the source data to Extract & Transform from source systems by incorporating business rules using different objects and functions that the tool supports.
• Created mappings, mapplets and User defined functions to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Normalizer, SQL, Router, Filter, Expression, Aggregator and Update Strategy.
• Created and Configured Workflows and Sessions to load the data from Big Data source to Oracle staging tables.
• Created shell scripts as per the project requirement to schedule workflows.
• Used Maestro as a scheduler to run the UNIX scripts.
• Constantly interacted with business users to discuss and clarify the requirements.
• Assigned and monitored work allocated to the team.
• Attended everyday status meetings and ensured the work is delivered as per the schedule agreed.
• Overseeing quality procedures for the project and ensuring process adherence.
• Review of deliverables, Implementation & verifying final results.
• Preparation of Work status and process improvement related reports.
• Worked with dependent teams to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/Worklets /workflows from development to Test Repositories and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Unit testing and Integration testing. Resolved issues identified in QA, UAT and promoted the code to Production.
• Prepared required documents for handling post development issues.

Environment: and Tools: Informatica Power Center 9.6, Oracle 11g, Hive, SQL, SQL Developer, Unix, Linux, Flat files, Maestro, Advanced Query tool.

Confidential, Detroit MI

Informatica PowerCenter Developer

Responsibilities:

• Involved in gathering and analyzing the business requirements.
• Designed and developed mappings by using Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, Joiner transformations to implement the mapping.
• Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from Teradata marts and flat files and transformed it in accordance with the Business logic and loaded data into Oracle data marts using ETL tool.
• Involved in creating Teradata staging table structures and modifying existing tables as per the design specifications.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica PowerCenter.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Created Unix shell scripts to execute the Informatica Workflows.
• Involved in Performance Tuning of mappings in Informatica.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: and Tools: Informatica PowerCenter 9.5, Oracle 11g, Teradata 13.0, Teradata SQL Assistant 13.0, SQL, SQL Developer, UNIX, Flat files.

Confidential, Glendale CA

Informatica Developer/Support

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created mappings as per the technical design to load data from Oracle Marts to Teradata Marts.
• Used various transformations like Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement the business logic as per the mapping sheet.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Tables, views of the Teradata data marts required for staging and loading data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used Informatica Workflow Manager to create workflows, sessions and scheduled the workflows to execute the mappings.
• Checked Sessions and error logs to troubleshoot problems and also used debugger to resolve the issues of existing logic.
• Did performance tuning to improve Data Extraction, Data process and Load time of developing/existing mappings.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Confidential

Informatica Power Center Developer

Responsibilities:

• Followed Agile-Scrum methodology to design, develop, test and deliver the code.
• Designed ETL flows to implement using Informatica Power Center as per the mapping sheets provided.
• Involved in creating databases, views of required Teradata datamarts to represent the source tables & staging data marts.
• Involved in ETL development, creating required mappings for the data flow using Informatica.
• Used transformations like Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.
• Involved in developing the mapplet, reusable transformations and User defined functions according to the data flow requirements.
• Performance tuning done by implementing all mappings to come under (PDO) Push down Optimization.
• Used BTEQ to create and edit Teradata table/view definitions.
• Used Fast Export to export data from Teradata tables to Flat files.
• Used Fast Load to load data from Flat files to Teradata tables.
• Teradata Parallel transporter connection was used for loading data into Teradata data marts.
• Developed UNIX scripts to schedule the workflows.
• Used mapping & workflow parameters to make the ETL process more flexible.
• Validated the output according to the mapping sheet specifications.
• Developed Mainframe jobs to schedule the UNIX scripts which run the Informatica workflows as per the business requirements.
• Enhancements in existing mappings according to the business logic.
• Attended daily scrum calls to post the required status update.
• Testing the data against the existing logic and defect fixing by correcting the ETL logic.
• Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.

Environment: and Tools: Informatica PowerCenter 9.1, Teradata SQL Assistant, SQL, JCL, Oracle 11g, Teradata 13.0, UNIX, SQL Developer, JCL

Confidential

Informatica Power Center Developer

Responsibilities:

• Followed Agile-Scrum methodology to design, develop, test and deliver the code.
• Designed ETL flows, mapping sheets by analyzing the XML data to implement the same in Informatica.
• Involved in creating equivalent Teradata datamarts to load the data of each product.
• Involved in ETL developing, creating required mappings for the data flow using Informatica.
• Used transformations like XML source qualifier, Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.
• Involved in developing the mapplet, reusable transformations and User defined functions according to the data flow requirements.
• Developed UNIX scripts to schedule the workflows.
• Developed Mainframe jobs to schedule the UNIX scripts which run the Informatica workflows as per the business requirements.
• Validated the output according to the specifications.
• Attended daily scrum calls to post the required status update.
• Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.

Environment: and Tools: Informatica PowerCenter 9.1, Teradata SQL Assistant, SQL, JCL, Teradata 13.0, Unix, JCL, JIRA

Confidential

IBM Content Manager Developer/Support

Responsibilities:

• Responsible for the management of Development and Maintenance related projects directed towards strategic business and other organizational objectives.
• Client Interaction on new requirements.
• Analysis of client specifications, design of business artifacts.
• Involved in Development project with emphasis on Requirements gathering, Design specifications, estimations and supporting in all phases of SDLC.
• Work allocation to team members and guiding them.
• Net meetings and calls with users as part of resolution of requests.
• Incident Management and On call - Adhering to SLA
• Coach, mentor and lead personnel within a technical team environment.
• Overseeing quality procedures for the project and ensuring process adherence.
• Review of deliverables, Implementation & verifying final results.
• Preparation of Work status and process improvement related reports.
• Testing activities involve Unit Test Plan Preparation, Unit Testing and UAT.

Environment: and Tools: IBM Content Manager, File Aid, Endevor, TWS-OPC, JIRA, COBOL, JCL, DB2

Confidential

Mainframes Developer/Support

Responsibilities:

• Enhancements to the existing functionality.
• Support tasks for answering user queries and provide the required information to the users in the format that they requested.
• Analysis of issues encountered in Live environment and taking responsibility to resolve them by providing best solutions, either by code changes or database changes and track them till closure.
• Solving Batch incidents.
• Analyzing and solving user & problem tickets within the described SLA.
• Preparing monthly reports on tickets resolved and tracking the progress of all the team members.

Environment: and Tools: File Aid, Easytrieve, CA-7 Scheduler, JCL, COBOL, IMS