We provide IT Staff Augmentation Services!

Etl(informatica) Architect/project Manager Resume

SUMMARY:

  • Over 14.5 years of professional experience in Information technology with progressive experience in development and implementation of various projects. Having more than 9years of experience in designing/architect and leading/managing teams.
  • 13.11 years of Data warehousing ETL experience and specifically has Demonstrated technical expertise in Informatica Power Center versions 6.2,7.1,8.1,8.6.1,9.1 and with fair knowledge on Informatica Data quality 8.5.Having Good Knowledge of Dimensional Modeling (Star and Snow flake) to build the Data warehouse.
  • Main areas of expertise are analyzing, developing and testing the data warehousing projects, data conversion projects and Integration Projects. Worked on Informatica - SAP and Informatica-Salesforce (SFDC)/Informatica cloud projects.
  • Experience/Manage in Agile SCRUM project methodologies in the highly competitive work environments at the client place.
  • Experience with project management methodologies and techniques, and their application in business and technical environment. Successful Release management experience on multiple business critical projects.
  • Performed project level design, data analysis and application performance analysis.
  • Strong functional and technical experience in Data Warehousing Technologies and ETL tool like Informatica, UNIX shell scripting and Database like SQL Server, Oracle and Teradata.
  • Proven experience in development and implementation of large-scale, enterprise data warehouse and reporting solutions. In-depth understanding of data warehousing concepts, Kimball methodologies adhered to the DW best practices for implementing SCD approaches.
  • Excellent Business Analysis skills, communication and problem solving skills.
  • Good exposure in all part of software development life cycle including requirement analysis, program design, development, debugging, testing, implementation & quality coordination, application maintenance.
  • Expert level understanding of Oracle Database Capabilities and DW best practices including appropriate use of Index, Partition, Materialized Views etc.
  • Expertise in Business/Client interaction and gathering business/functional requirements analysis thereby interpreting the same in technical language.
  • Demonstrated expertise in Agile methodology which includes understanding business requirements from users, creating user stories to scrum team, translate them into database and ETL designs with detailed mapping document, in conformance with CDW( Corporate Data warehouse) architecture standards.
  • Proven experience in handling onshore/offshore model. Ensuring the delivery from the projects adhered to the appropriate levels of quality, on time and within budget, in accordance with the plan and governance models.
  • Leading the initiative, aiming towards business process engineering to bring in improvements /productivity enhancements from the delivery perspective. Effective Issues and Risks management with status tracking and compliance with quality tools and standards.
  • Team management includes conflict resolution, issue management, individual appraisals and performance analysis, review. Track Issue Register and Risk Register and publish the updates as and when necessary to the stake holders.
  • Extensive experience in building the onshore/offshore high performance teams, delivery management, People management, Change management, Incident management, release management
  • Report Customers with exact and precise information during Monthly Review Meetings with the Leadership. Experience in coordinating, negotiating resources in support of time line and IT project deliverables.

TECHNICAL SKILLS:

Operating Systems: Windows XP, HP-UX, UNIX, Sun Solaris

Databases: Oracle 9i/8i/10g/11g, SQL Server and Teradata

Cloud Technologies: Azure ML, Informatica Cloud and AWS solution architect Trained

Data warehousing Tools: Informatica 7.x/8.x/9.x, Business Objects

Job Scheduling Tools: Toad, Tidal, Maestro, CTLM, Tivoli

Client Specific Tool: GIS (Genetron Integration system) Router tool, BMC Remedy Tool

CRM Tools: SAP PI, MM, HR, R/3, SFDC (Sales force)

PROFESSIONAL EXPERIENCE:

Confidential

Technologies: Informatica 9.5.1, UNIX, Oracle, DB2,SQL Server, SAS, Microsoft Project Plan(MPP)

ETL(Informatica) Architect/Project Manager

Responsibilities:
  • Collaborate with all stakeholders to clarify client requirements, business needs and project objectives.
  • Prepared the project plan and successfully delivering on-time, within scope and budget by monitoring and tracking the progress. Communicate with stake holders on regular basis.
  • Managed the resources from off shore/on site by ensuring resource availability and allocation.
  • ETL Designing for the project, setting up of the environment, converting functional requirement into technical requirement documents. Understand the current data model, ETL Process, configure and implement the solution.
  • Design/Develop and maintain all ETL mappings/scripts and physical data models.
  • Implemented the testing plan in SIT and UAT environment. Prepared UTC and UTR documents. Deployment of the code and scheduling.
  • Monitor day-to-day activities of the project team and ensure work is progressing as planned.
  • Team management includes conflict resolution, issue management, individual appraisals and performance analysis review.
  • Track Issue Register and Risk Register and publish the updates as and when necessary to the stake holders.
  • Report Customers with exact and precise information during Monthly Review Meetings with the Leadership.

Confidential

Technologies: Informatica 9.5.1, UNIX, Oracle, Tivoli, Microsoft Project Plan(MPP)

Project Lead/Architect/Manager

Responsibilities:
  • ETL Designing for the project, setting up of the environment, converting functional requirement into technical requirement documents. Understand the current data model, ETL Process, configure and implement the solution.
  • Design/Develop and maintain all ETL mappings/scripts and physical data models.
  • Implemented the testing plan in SIT and UAT environment. Prepared UTC and UTR documents. Deployment of the code.
  • Created Tivoli web forms for scheduling of informatica jobs thus included a design to have a near real time polling jobs for on demand INFA jobs. Bug fixing of the existing code and assigning task to offshore/onshore resources.
  • Responsible for the Code review and authorization of the build components and associated deliverables.
  • Coordinate with the onshore/offshore development team and track their status/progress during the build and integration testing activities.
  • Involved in project staffing. Management work and mentoring the team. Ensuring the delivery from the projects adhered to the appropriate levels of quality, on time and within budget, in accordance with the plan and governance models.
  • Manage schedules, budgets ($30,000 to $2 million), assets, and overall project organization to ensure requirements and project deliverable dates are clearly communicated, understood and executed.

Confidential

Technologies: Informatica 9.5.1, UNIX, Sales force (SFDC), CTLM, SFDC workbench,DB2

Sr Systems Analyst/Technical Manager/Architect

Responsibilities:
  • ETL Designing for the project, setting up of the environment, converting functional requirement into technical requirement documents.
  • Involved in project staffing. Management work and mentoring the team. Ensuring the delivery from the projects adhered to the appropriate levels of quality, on time and within budget, in accordance with the plan and governance models.
  • Development of the ETL code, Transition to team members from design to build phase by adding any value additions details to the detailed design.
  • Extensively worked on Informatica-SFDC/Informatica cloud integration components. Used Power exchange efficiently. Also worked extensively on web service consumer transformation.
  • Coordinate with the offshore development team and track their status/progress during the build and integration testing activities.
  • Created CTLM jobs for scheduling of informatica flows. Loaded data into SFDC using workbench for testing purpose. Used Lotus notes efficiently.
  • Responsible for the Code review and authorization of the build components and associated deliverables.
  • Responsible for the Informatica-specific defect triage and management process during the Initial Integration testing phase. Responsible for code migration from different ETL environment.
  • Assigning of task to the team members both onshore and offshore, co-ordinating, Developing the code and instruct offshore resources to develop and modify ETL mappings, create and execute tests (including test automation) to ensure quality and execution time performance.
  • Responsible for all the deliverables of the team.
  • In DC1 firebolt maintenance project for initial 2-3 months wherein was involved in monitoring activities, Analysis of errors and giving solutions to DEV team and send reports without missing the SLA’s daily and including weekends
  • Team management includes conflict resolution, issue management, individual appraisals and performance analy-sis, review. Track Issue Register and Risk Register and publish the updates as and when necessary to the stake holders.
  • Report Customers with exact and precise information during Monthly Review Meetings with the Leadership. Experience in coordinating, negotiating resources in support of time line and IT project deliverables.

Confidential

Technologies: Informatica 9.1, UNIX, Oracle,SQL Server

Project/Team Lead

Responsibilities:
  • Played the role of onshore lead developer/Delivary lead of my project .My role includes understand business requirements and user stories, translate them into database and ETL designs and detailed mappings, in conformance with CDW ( Corporate Data warehouse) architecture standards.
  • Created complex mappings using different sources and Target. Created CDC (Change data capture) mappings using MD5 mechanism of informatica.
  • Worked extensively and modified/created medium to complex PL/SQL stored procedures.
  • Assigning of task to the team members onshore and offshore, coordinating, Development and direct offshore resources to develop and modify ETL mappings, create and execute test plans (including test automation) to ensure quality and execution time performance as i was responsible for all the deliverables of my team.
  • Involved in the major migration of informatica 8 to informatica 9. My contribution in this project is highly appreciated from the client.
  • Created deployment plans, support deployments during all our monthly releases.

Confidential

Technologies: Informatica 8.6.1, SQL Server, DB2, Oracle, GIS Router, CTLM, SAP PI

Team Lead

Responsibilities:
  • Played the role of Team Lead/Developer of informatica objects and deployer for SAP PI objects.
  • Involved in getting the requirements from the client,preparing functional and technical document along with the developing of the code and testing of the same for Informatica interfaces.
  • Worked extensively on informatica-SAP integration code/mappings, extensively worked on XML transformation(XML Parser,XML Generator, XML source qualifier transformation)
  • Played the role of a deployer by deploying all the developed codes of Informatica and SAP PI objects by migrating to different environments.
  • Involved in project staffing.management work and mentoring the team.
  • Apart from the informatica work involved in the work for the client to create MFT jobs using Genetron Integration sytem(GIS) tool. Developed Informatica mapping using almost all the transformation.
  • Worked as an SME(Subject Matter Expert) in informatica for the project.
  • Tested SAP PI objects/communicating to clients by giving demo and getting approval for deployment by performing all the documentation.

Confidential

Technologies: Informatica 8.6.1, Teradata and UNIX

Team Lead

Responsibilities:
  • Worked as an SME(Subject Matter Expert) in this project, worked extensively on SCD's type1 and type2 mappings.
  • Delivered without any defects, following naming standards and approach as per the client.
  • Created UTP's,Code Review checklist and various documentation like ETL specification,LLD,HLD etc.
  • Partly worked as datamodeller for the design change and to get the requirements from the client.
  • Worked in a professional manner in the workplace helping the peers completing their work(objects) and mentoring the team.

Hire Now