We provide IT Staff Augmentation Services!

Informatica Developer Resume

SUMMARY

  • 8+ years of software engineering experience with core expertise in all aspects of object - oriented design and development in Data Warehousing with 2+ years as Lead experience.
  • Expertise in Designing, and developing highly scalable, extensible, and maintainable software products and enterprise applications from the ground up.
  • Migrating existing applications to take advantage of newer/better technologies and platforms.
  • Leading and providing technical direction to development teams.
  • Interacting with business users to gather and convert requirements into design and implementation.
  • Expert in designing Reports and Dashboards using various reporting tools like IBM Cognos, Power BI & Tableau.
  • Strong experience in SQL Server Database design, Database maintenance, developing queries, stored procedures, views, functions using SQL Server.
  • Experience in development of various ETL workflows using Informatica Power Center and B2B services.
  • Good knowledge of R, Python, AWS.
  • Able to work independently and manage high-profile projects and experience in complete SDLC cycle.
  • Excellent written and verbal communication, with an outstanding ability to articulate complex problems (& solutions) in simple language.
  • Highly motivated, process driven engineer who can learn quickly and adapt to changes rapidly.

TECHNICAL SKILLS

  • Java, Python, R, JavaScript
  • JavaScript, jQuery, Angular 6/CLI, VBScript
  • MS SQL Server 2000/2005/2008/2012
  • Netezza, Oracle 10g/11g, My SQL, DB2
  • IBM Cognos, Tableau, PowerBI
  • Informatica PowerCenter
  • Informatica B2B
  • SharePoint, MS Visio, JIRA,
  • Waterfall, Agile/SCRUM

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

  • Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Designed, architected, and implemented a B2B solution solving a strategic business use case
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Onboarded new customers for a Healthcare client and created custom ETL processes based on business requirements
  • Developed new implementation code using DT for new EDI files and created the respective profiles in DX
  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.

Technologies: Informatica PowerCenter 10.2, Informatica B2B, Oracle

QA Lead

Confidential

Responsibilities:

  • Worked as test lead for implementation of a B2B solution solving a strategic business use case
  • Created and executed test cases for 834, 837 & NCPDP frameworks.
  • Produced, organized, and participated in a webinar highlighting the use case and solution built by Confidential - was able to have Informatica and the client speak on behalf of the solution
  • Created test report and the test strategy for 834, 837 and NCPDP framework.

Technologies: Informatica PowerCenter 10.2, Informatica B2B, MySQL

Data Management Consultant

Confidential

Responsibilities:

  • Designed, architected, and implemented a B2B solution solving a strategic business use case
  • Onboarded new customers and created custom ETL processes based on business requirements
  • Worked on production tickets and deployed the code to PROD after resolving the issue.
  • Produced, organized, and participated in a webinar highlighting the use case and solution built by Confidential - was able to have Informatica and the client speak on behalf of the solution
  • Developed new implementation code using DT and created the respective profiles in DX
  • Reviewed code from offshore development team

Technologies: Informatica PowerCenter, Informatica B2B, Jira, MySQL

Confidential

IT Analyst

Responsibilities:

  • Translated business user concepts and ideas and presented the prototype to the client for project approval
  • Gathered requirements & analyzed the wholesale banking data set to created Models, connecting various data sources, reports, sub queries, creating users, scheduler (AutoSys) and joins using Cognos Framework manager
  • Lead a team of 6 developers to develop 82 list, Crosstab and Chart reports with different functionality like conditional formatting, Java scripts to display reports in Dashboard, with Agile methodology
  • Created the Proposal document, Design document, Project flow document & Test case document for the project
  • Coordinated with onsite team and responsible for handling change requests to the existing Cognos reports in production environment & reduced the overall production incident count by 5% in HP ALM
  • Worked closely with business partners recognized key requirements, analyze business scenarios, define, and implement successful business strategies into Cognos.
  • Organized knowledge sharing and training sessions for the team and mentored 2 new team members

Technologies: Oracle, IBM Cognos 10.2, Informatica

Systems Engineer

Confidential

Responsibilities:

  • Analyzed 115 existing credit reports that were built in Cognos 10.1 and later migrated to PowerBI
  • Communicated with stakeholders to define business strategy to create centralized reporting capability for analytical and ad hoc reporting; wrote requirements specification documents and designed report mock-ups
  • Consolidated standard reports, eliminated duplicate functionality and reduced the number of standard reports
  • Restructured the data model which decreased the report run time of 22 reports by around 30 seconds each

Technologies: Netezza, IBM Cognos, MySQL, SQL, PowerBI

Hire Now