We provide IT Staff Augmentation Services!

Project Lead (informatica) Resume

Fremont, CA

PROFESSIONAL SUMMARY:

  • 9+ years of IT experience with Data Warehousing & ETL tools like Informatica power center.
  • Strong fundamentals in data warehousing & ETL Experience of using Informatica 9.1/8.6.1 Power center client tools - Mapping designer, Repository Manager, Workflow Manager, Workflow monitor.
  • Extensive experience in writing complex SQL queries using Oracle as Database.
  • Experience in troubleshooting and resolving complex production issues and bug fixes.
  • Strong problem solving and interpersonal skills including team efforts, delegation of work and technical acumen in a high technology environment.
  • Core competency in software development life cycle which includes requirement gathering, analysis, design, development, testing, debugging and implementation.
  • Excellent technical, logical, code debugging, performance tuning and problem solving capabilities.
  • Having experience in schema and database migration projects. Worked as tech lead for migration project.
  • Worked as Support lead for my project to handle multiple applications from support services.
  • Worked as analyst for Code migration project to migrate Oracle codebase to Informatica mappings, sessions and workflows.

TECHNICAL SKILLS/TOOL SUMMARY:

Languages/ETL Tools: INFORMATICA, SQL, PLSQL, UNIX shell scripting

Databases: Oracle 9i, 10G

Tools: used: Informatica power center clientToad,sql developer, Dollaruniverse,UC4,Tidal,Teradata ClientSSH Tectia shall client, Serena change man version managerKintana workflow migration toolRemedy Incident management tool

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Project Lead (Informatica)

Responsibilities:

  • Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.
  • Provided expert advice, counsel and technical expertise to the project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices
  • Conducting workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
  • Responsible for defining the scope and business rules of the project, gathering business requirements, and document them textually or using models. Interacted with cross functional teams to facilitate gathering of business requirements
  • Participated in the Incident Management and Problem Management processes for root cause analysis, resolution and reporting.

IT Analyst

Confidential, San Jose, CA

Responsibilities:

  • Participated in requirement gathering, to understand functional specifications of business requirement.
  • Understand the Business process flow to map it to technical level design.
  • Prepare Functional scope document. Get it reviewed with business and take their signoff before implementing changes as per FSD in production.
  • Participated in technical design phase, which involved converting function specification to High level technical documentation.
  • Validate change result implemented by Development team to get sign-off for production deployment.

Application Support Lead

Confidential, San Jose, CA

Responsibilities:

  • Managed 10+ customized applications on different platforms under managed services portfolio.
  • Led onshore and offshore teams to increase productivity and meet deadlines.
  • Worked across IT departments including Operations, QA and Development team to coordinate system testing, implementation and Production Deployments.
  • Review application performance issues and proposed resolutions to upper management.
  • Improved overall performance of ETL's by identifying specific areas for error and performance improvements and presenting viable solutions in a timely fashion.
  • Responsible for incident and problem management, and escalation procedures.
  • Implemented ITIL standards and best practices regarding incident, problem, and change management.
  • Documented business processes which were dependent on information technology. Serve as a leader in executing daily fieldwork, and informing the IT managers of engagement status.
  • Managed creation of ETL Playbook that decreased the amount of time required to bring new ETL resources up to productive capacity.

Project Lead

Confidential, San Jose, CA

Responsibilities:

  • Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
  • Extensively used Informatica Transformation like Source Qualifier, Router, Filter, Lookup, Joiner, Aggregator, Sorter etc. and all transformation properties.
  • Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
  • Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
  • Performed complex defect fixes in various environments like UAT, SIT etc to ensure smooth delivery of the developed jobs into the production environment.
  • Attended daily status call with internal team and weekly calls with client to update the status report.

Developer

Confidential, San Jose, CA

Responsibilities:

  • Understand architecture and process flow for Teradata.
  • Understand the Job control design and flows for Extract Truncate reload logic.
  • Design Informatica mapping, sessions and work flows to extract data from Teradata into flat files and from flat file to Oracle tables.
  • Design Dollar U job to execute Informatica workflows on scheduled interval for data refresh.
  • Prepare sql data audit script and perform data validation in Teradata and Oracle environment.
  • Provide production support post Go live, for bug fix or user queries.

Analyst/Developer

Confidential

Responsibilities:

  • Gather information from cross functional teams to identify impacted applications with schema migration.
  • Co-ordinate with cross functional teams to prepare technical design document and execution plan.
  • Prepare sql scripts, to migrate objects from one schema to another schema and take care of grant revoke access for respective applications.
  • Change the code for batch job and Migrate it to new schema.
  • Participate in unit testing and integration testing.
  • Provide production support post Go live, for bug fix or additional enhancement requests.

Developer

Confidential

Responsibilities:

  • Understand existing code written in plsql and pro*c.
  • Understand business functionality, Develop mappings, and sessions in informatica to replicate functionality without impacting business flow.
  • Design the workflows, and schedule as per the data refresh requirements from client.
  • Participate in unit testing and integration testing.
  • Provide support, post go live, resolve user specific issues and GAP analysis to capture enhancement requests.

Hire Now