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

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