We provide IT Staff Augmentation Services!

Informatica Power Center Lead/developer Resume

Cary, NC

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

Hire Now