SUMMARY:

• IT professional with comprehensive technical skill set and expertise in data warehouse, process improvement, systems integration, requirements analysis, workflow design, leadership, process modeling, testing/quality assurance and customer service.
• Performed duties as a Informatica Developer, Administrator and Project Onboarding and Support.
• Excellent communication, presentation, project management skills, quick leaner, multi - tasking, a very good team player and self-starter with ability to work independently and as part of a team.
• Proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
• Involved in various stages of Software Development Life Cycles (SDLC) including requirements analysis, design, development, testing and implementation with Agile and Waterfall methodologies.
• Experienced in creating prototypes and mock-ups for user interface designs with MS Visio.
• Experienced in creating Test Cases, Test Plan, and Test Data. Performed Integration Testing, System testing, User Acceptance Testing (UAT) working with team members.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance and Data Integration.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional modeling (Star Schema, Snow Flake Schema, Data Vault, FACT & Dimension Tables) OLTP and OLAP.
• Experience in using various Transformation like Filter, Expression, Joiner, Sorter, Aggregator for designing and developing complex mappings.
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers, Views, Indexes, Joins, Sub-Queries to implement business rules and validations.
• Sound knowledge of Data Warehousing Concepts: Star schema, Fact/Dimension modeling, ETL (Extraction Translation and Load), Operational Data Store (ODS), data mapping and data conversion techniques.
• Outstanding abilities at improving all aspects of development lifecycle to include coding, testing, debugging, and final rollout. Creative and enthusiastic self-starter, team player with excellent organization skills to assess needs, set priorities and meet deadlines.
• Strengths include excellent interpersonal and communication skills, client interaction, analytical and problem solving capabilities. Very strong mix of academic and professional experience in the related area, demonstrated through the implementation of successful projects and diverse roles.
• Flexible team player in rapidly changing environments with the ability to accept new ideas, concepts, methods and technologies. Motivated achiever who guides organizations in applying technology to business settings, provides benefit, and creates project deliverables in a timely manner.

TECHNICAL SKILLS:

Database: Oracle, MS SQL, MySQL, MS Access, Teradata.

ETL: Informatica PowerCenter 10.2/9.6.1

Programming Languages: SQL, PL/SQL, Shell Scripting, Python, Java, Swift, JavaScript, HTML5, CSS3.

Business Tools: MS Visio, MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Project.

Reporting Tools: BI Tableau, Power BI, Cognos.

Database Tools: Toad, Oracle Enterprise Manager, SQL*PLUS, SQL*Loader, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Informatica Developer/Administrator

• Performed duties as a Informatica Developer, Admin and Project Onboarding and Support.
• Documented source to target data mappings, business rules, and business and data definitions.
• Performed business request analysis, creating business request response, source system analysis, Trust/Match strategy design, MDM performance/load count monitoring, User Acceptance Testing.
• Involved in Data Profiling and Data Quality Analysis of the data given by customer to find out anomalies in the data and highlighting the effectiveness of the Informatica Products.
• Developed test cases and performed UAT testing for all the files and reports also performed Facets regression testing.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• Performed as key member of a data warehouse team. Duties include: requirements gathering, source system analysis, data modeling, Informatica development/administration, performance tuning, coordinating with team/other teams on various tasks.
• Worked closely with development team and downstream teams for bug fixes, escalations, database changes, optimization and new enhancements. Involved in designing the procedures for getting the data from various source systems to EDW.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Performed Data Analysis on unclean data, presented the scenarios, and helped data stewards to find appropriate solution.
• Defined, documented, developed and delivered quality ETL design using development techniques that lead to an operationally efficient, maintainable, and high quality process. Mentored junior-level Informatica developers, as well as independently perform complex troubleshooting, root-cause analysis, solution development and implementation of ETL processes.

Environment: Informatica Power Center 10.2/9.6.1, Informatica Data Quality 10.2, SQL Server.

Confidential

ETL Developer

• Designed and implemented Collections data warehouse on loan servicing data. Translated business rules and functionality requirements into ETL solutions. Used Informatica to create mappings and workflows, to extract the data, to monitor and schedule workflows.
• Participated in daily SCRUM meetings during the Sprint Development as a part of Agile Methodology. Also, captured and addressed concerns from IT to Product Management or Business Team as needed.
• Performed the GAP analysis to find the Root Cause of the issues.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Developed schemas for extraction, transaction, and loading (ETL) to expedite data integration between systems.
• Worked with QA testing teams, while interacting with business users and gathering user's requirements to develop necessary Test plans, Test Cases and Test script.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Troubleshoot the issues by checking sessions and workflow logs.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Optimize SQL queries for better performance.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels. Provided technical support and training for new developers and permanent team on Informatica.

Environment: Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, SQL Server.

Confidential

Informatica Developer

• Performed unit and integration testing on complete ETL loads. Followed Informatica velocity methodology in creating test plans for testing all the mappings. Involved in performance tuning, historical data fixes and enhancements.
• Created reusable mapplets, worklets and implemented efficient Error Handling method throughout the mappings. Involved in fixing invalid mappings, testing of stored procedures and functions.
• Designed ER diagrams, logical model and physical database for Oracle as per business requirements using Erwin.
• Extracted and loaded data from flat files and Oracle sources to Oracle database using Informatica mappings.
• Involved in developing complex mappings and used various transformations (Filter, Router, Joiner, Lookup, Update Strategy, Expression, and Aggregator) on the extracted data according to the business rules.
• Involved in writing stored procedures and Shell Scripts for automating the execution of jobs in pre-and post-sessions to modify param files, prepare data sources.
• Involved in developing data warehouse, which integrates several functional areas like corporate financial, cost management, Human resources and project spending.
• Worked on Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc. Developed number of complex mappings, mapplets and reusable transformations to facilitate daily, monthly and yearly loading of data.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into Informatica mappings.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis.
• Scheduled daily SCRUM meetings in an agile environment, retrospective meetings for issues, incorporated suggestions & decisions in code development.

Environment: Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, Oracle 11g, SQL Developer