SUMMARY

• Over 9 years of experience as Informatica Developer with main area of expertise in data warehouse projects.
• Started as ETL developer then moved to Sr. Informatica developer and additionally taking care as Scrum Master and certified as PSM. Progressed towards full time Scrum Master / Agile Coach.
• As Informatica Developer, extensive experience in implementation of Informatica Powercenter components like Source analyzer, Target Designer, Mappings / Mapplet /Transformation Designer, Workflow manager /worklet, Workflow Scheduling and Monitoring.
• Extensively worked in Informatica Powercenter Transformations such as Source qualifier, Application /XML/MQ Series Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update strategy, Rank, Aggregator, Stored procedure, Sorter, Sequence generator, Transaction control, XML Parser, XML Generator, Web services Consumer and CDC Flexible Target Key.
• Experience in using data sources Oracle, Teradata, DB2, MS SQL Server, Flat files, XML files, Message Queues and Mainframe files
• Experience in writing complex SQL queries, stored procedures and functions using PL/SQL programming.
• Experience in performance tuning in identifying and fixing bottlenecks also tuned the complex Informatica mappings for better performance.
• Implemented Type1, Type 2, Type3, Incremental and CDC Logic according to the business requirements.
• Experience with Informatica XML Sources, Targets and XML transformations. Worked with Informatica Webservices by enabling informatica as a webserver and accepts requests from client applications. Also created informatica mappings to call other application webservices.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Certified Scrum master from scrum.org and worked on JIRA tools for tasks tracking.
• Participated on continuous integration/continuous delivery and deployment tasks using Jenkins
• Organizing and attending meetings with stakeholders and team.
• Worked on documentation on important actions and decisions and provided presentations required for meetings.
• Experience on project plans, project schedules, work hours and performance improvement.
• Worked on product test reviews after deployment.
• Worked as a ETL developer of system release to production environment.
• Enforced Kanban principles as a scrum master that resulted in reduction of Cycle time by 20% thus increasing team's throughput in less than 8 weeks.
• Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased customer satisfaction.
• Facilitated agile adoption Retrospective for the organization with the leadership and guided teams with outcome resulting in enhanced performance.
• Removed obstacle for the team by escalating an issue to leadership resulting in early delivery of customer issue solution. Customer provided positive feedback.

PROFESSIONAL EXPERIENCE

Scrum Master and Integration Developer

Confidential

Responsibilities:

• Performed the roles of Senior ETL Informatica developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, designing end - to-end ETL flow, building complex ETL procedures, developing strategy to move existing data feed into the Data Warehouse (DW) and additional target data warehouses.
• Collaborated with data architects, BI architects and data modelling teams during data modelling sessions.
• Involved in functional design reviews and lead technical design reviews.
• Extensively used Informatica transformations - Source qualifier, expression, joiner, filter, router, update strategy, union, sorter, aggregator and normalizer transformations to extract, transform and load the data from different sources into Oracle.
• Extensively worked on performance tuning of Informatica mappings.
• Created reusable components, reusable transformations and mapplets to be shared among the project team.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP messages using XML parser transformation, created XML files using XML generator transformation.
• Worked extensively with Oracle external loader - SQL loader - to move the data from flat files into Oracle tables.
• Coordinated with QA team during QA environment build, reviewing test cases, test execution and defect assignments.
• Assisted in preparing implementation documents for every release, worked on initial loads and data catchup process during implementations and provided on-call support for first few days of execution.
• Extensive experience in PL/SQL programming, stored procedures, functions and triggers.
• Built UNIX Linux shell scripts for running Informatica workflows, data cleansing, purge, delete, and data loading and for ELT process.
• Created Procedure Document for Implementation procedures for every release for all the UNIX, Informatica Objects and if any catch-up process needed to be done.
• Guiding our scrum teams towards sprint goals across different locations and time zones - Teams are working in IST, PST and EST.
• Organized PI planning and Sprint planning sessions to understand team goals.
• Organized and facilitated all scrum events like Daily standups, Spring Planning, Review, Release planning, Retrospective, PI Planning
• Coordinated with stakeholders and PMO team for project status and review meetings.
• Extensively used JIRA and guided team in organizing daily tasks and sprint goals.
• Coordinated and guided teams in using Code repository using Bitbucket and CI/CD using Jenkins.
• Assisted team to remove impediments by understanding overall control and release process.
• Assisted with internal and external communication, improved transparency and radiated information.
• Updated Agile-tracking system using Trello Card system tool to provide transparency on product and sprint backlogs.
• Supports the team on time sheet management and closely worked with HR team and allocating hours to team.
• Provided the guidance to team about importance of sprint backlog commitments.
• Organized product implementation demos and release planning calls.
• Involved in roadmap sessions for sprints and prioritized the backlogs, to accomplish the sprint goals.

Informatica Developer

Confidential

Responsibilities:

• Performed the roles of Senior ETL Informatica developer on data warehouse initiatives and was responsible for requirements gathering, preparing mapping document, designing end-to-end ETL flow, building complex ETL procedures, developing strategy to move existing data feed into the Data Warehouse (DWH).
• Extensively used Informatica transformations - Source qualifier, expression, joiner, filter, router, update strategy, union, sorter, aggregator and normalizer transformations to extract, transform and load the data from different sources into DB2, Oracle and SQL Server targets.
• Created reusable components, reusable transformations and mapplet to be shared among the project team.
• Used XML & MQ series as the source and target.
• Refreshing the mappings for any changes/additions to source attributes.
• Collaborated with data architects, BI architects and data modelling teams during data modelling sessions.
• Extensive experience in building high level documents depicting various sources, transformations and targets.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP messages using XML parser transformation, created XML files using XML generator transformation.
• Worked extensively with Oracle external loader - SQL loader - to move the data from flat files into Oracle tables.
• Extensively used Enterprise ControlM Scheduler tool to automate jobs for loading tables whenever a new environment/application/jobs are created.
• Extensively used JIRA & ServiceNow for creating requests for access, production migrations, component migrations & production related service requests.

Confidential

Offshore project Lead

Responsibilities:

• Working with PO and understand requirements.
• Works independently for the assigned tasks and develop ETL components.
• Support offshore in sharing the knowledge of scrum and review offshore tasks.
• Created Informatica Powercenter components, Mappings, sessions and workflows
• Worked on Performance improvements on the existing jobs for better SLAs.
• Provided warranty support and Knowledge transfer to Dev teams on the new applications and coordinated with the PO for changes to existing backlogs.
• Worked closely with team and product owners for timelines and daily status through scrum daily standup calls.
• Daily tasks and time are managed through Agile stories, tasks and defects.
• Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations.
• Protect development team from outside distractions, impediments, or team conflicts, and maintain focus on product backlog project timeline.
• Work closely with project owner in backlog management and continuous delivery of features.
• Educate and reinforce scrum methodology and agile framework to team members and stakeholders.
• Worked with Jira application