We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Boston, MA

SUMMARY

  • Overall 8 years of extensive industry experience with proven expertise in Software development, Data Integration (Power center 10.1), Master Data Management (MDM), Data Quality assurance (IDQ) 10.1 and Powerexchange 9.5.
  • Strong experience in using Informatica Data Quality (IDQ) tool. Created IDQ Mapplets for address cleansing, telephone cleansing and SSN cleansing. Worked with most of the IDQ transformations (like standardizer, Parser, Exception etc.…) in Mapplets.
  • Experienced in using IDQ tool for Profiling, applying rules, Creating Scorecards and develop mappings to move data from source to target systems.
  • Extensively used all IDQ Developer transformations like Match, Exception, Association, Consolidation, standardizer and Parser etc.
  • Excellent knowledge of IDQ Address doctor/validator to correct addresses, identify deliverable address.
  • Worked on DVO (data validation option) testing, compare data migration between 2 databases (SQL server and oracle).
  • Experience in exporting the objects from IDQ to Power center and use them in PowerCenter Mappings and Mapplets.
  • Expertise in Using Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa.
  • Knowledge and Expertise on Master Data Management concepts, Methodologies and ability to implement this knowledge in building MDM solutions.
  • MDM Hub configurations - Data modeling, Data Mappings, Trust and validation rules, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
  • Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Developed, proposed, and contributed to implementation of data quality improvement processes.
  • Strong understanding of Dimensional Modeling, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.
  • Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic.
  • Worked on Performance Tuning Informatica Targets, Sources, Mappings and Sessions.
  • Experience in developing Informatica Reusable components for using them across the projects.
  • Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.
  • Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling.
  • Experience in Internet technologies like Java Script, HTML, XHTML, CSS and JQuery.
  • Created Business Requirement, functional, technical, and mapping design documents.
  • Worked on scheduling tools UC4, Control M to invoke Informatica workflows and jobs developed in developer tool.
  • Experience in resolving on-going maintenance issues and bug fixes, monitoring jobs as well as performance tuning of mappings and sessions.
  • Hands on experience in resolving the production issues in 24/7 environment.
  • Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

Informatica Tools: Informatica Power Center 10.1, Informatica Data Quality 10.1, Informatica Analyst 10.1(IDE), Business Glossary, Informatica Address Doctor, IDQ Cleanse functions, Master Data Management (MDM), Informatica Metadata Manager 9.6.1, Informatica Data Validation Option(DVO)

Database Technologies: Oracle 9i,10g/11g, Teradata, SQL server 2005/2008

Programming Languages: SQL, UNIX Shell Scripting, Python.

Web Technologies: CSS3, HTML5,JQUERY,JAVASCRIPT, ADOBE Creative Suite

Scheduling Tools: UC4, CONTROL M, Crontab, Autosys, Skybot

Tools: Toad, Teradata SQL Assistant, SQL plus, SQL Developer, Erwin, PL/SQL Developer, Putty, WINSCP, Jira, Rally

Operating Systems: Windows 9x/2000/XP/Vista/7/8,Linux/Unix, Ubuntu

S/W Methodologies: Agile, Waterfall models

PROFESSIONAL EXPERIENCE

Confidential - Boston, MA

Sr. Informatica Developer

Responsibilities:

  • Experienced to document Design/Architecture, Mapping Specifications, Knowledge Transfer Documents, Deployment documents, and Run Books Operational Support
  • Reusable transformations and Mapplets are built wherever redundancy is needed
  • Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
  • Work on data profiling & various data quality rules development using Informatica Data Quality.
  • Defined measurable metrics and required attributes for the subject area to support a robust and successful deployment of the existing Informatica MDM
  • Implement Exception Handling Mappings by using Data Quality, data validation by using Informatica Developer.
  • Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, SQL Server and Informatica.
  • Set and follow Informatica best practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica transformations, mapplets, mappings, reusable sessions, worklets and workflows.
  • Extracted consolidated golden records from MDM base objects and loaded into downstream applications.
  • Work on scheduling tools Control M to invoke informatica workflows and jobs developed in developer tool and Responsible for the maintenance and management of the Control-M environment that will support multiple applications.
  • Worked on data cleansing using the cleanse functions in Informatica MDM.
  • Working in UNIX environment, File Transfers, Job scheduling and Error Handling.
  • Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs, assisted in building the ETL source to Target specification documents by understanding the business requirements

Environment: Informatica PowerCenter10.1, Informatica Data Quality (IDQ)10.1, Informatica Analyst10.1, MDM, Informatica DVO 10.1, Unix, Shell Scripting, Uc4, Rally, Flat Files, HP ALM, Oracle 11g/10g, Oracle, SQL server 2017,SQL Developer, Teradata, Hive, HDFS.

Confidential - Philadelphia, PA

Sr. Informatica IDQ Developer

Responsibilities:

  • Work as IDQ developer with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
  • Work on data profiling & various data quality rules development using Informatica Data Quality.
  • Implement Exception Handling Mappings by using Data Quality, data validation by using Informatica Developer.
  • Develop Mappings using Informatica Power Center to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), and Aggregator, Update Strategy, Joiner, Filter and Sorter transformations.
  • Work on scheduling tools UC4 to invoke informatica workflows and jobs developed in developer tool.
  • Resolving ongoing maintenance issues and bug fixes monitoring jobs and as well as performance tuning of mappings and workflows. Hands on experience in resolving the production issues in 24/7 environment.
  • Experience in developing Informatica Reusable components for using them across the projects. Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards, Works on performance Tuning Informatica Targets, Sources, Mappings and Sessions.
  • Strong understanding of Dimensional Modeling, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts, Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic.
  • Create Business Requirement, functional, technical, and mapping design documents.

Environment: Informatica Powercenter 10.1,Informatica Data Quality (IDQ)10.1, Informatica Analyst10.1, Informatica DVO 10.1, Oracle 11g/10g, SQL server 2017, Oracle, SQL Developer, Teradata, Hive, HDFS, Unix, Shell Scripting, Uc4, Rally, Flat Files, HP ALM.

Confidential - San Jose, CA

Sr. Informatica Developer

Responsibilities:

  • Created Source to Target mapping document for various mappings and Rules developed for business line.
  • Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
  • Worked on data profiling & various data quality rules development using Informatica Data Quality.
  • Implemented Exception Handling Mappings by using Data Quality, data validation by using Informatica Developer.
  • Created the Rule Specifications and applied them on profiles Using Informatica Analyst.
  • Developed the Business/Technical Glossaries and loaded them using Informatica Analyst.
  • Extracted the Profile Statistics data from the Informatica repository tables and loaded them into the Fact tables.
  • Used IDQ Address validator transformation which can cleanse whole world address Data and enhanced by making some modifications.
  • Created the SQL Views, Table pairs and created the DVO jobs for validating the Source and Target Tables data as part of Automation Testing.
  • Developed Mappings using Informatica Power Center to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), and Aggregator, Update Strategy, Joiner, Filter and Sorter transformations.
  • Worked with Informatica Power Center Workflow Manager to create sessions, work flows and work-lets.
  • Created Workflows and monitored Sessions to execute Informatica mappings.
  • Worked on performance tuning of Informatica Jobs by optimizing all transformations.
  • Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
  • Schedule Informatica Jobs using UC4 Schedule Tool.
  • Created Data Validation document, Unit Test Case Document, Technical Design Document.

Environment: Informatica Powercenter 9.6.1/10.1,Informatica Data Quality (IDQ) 9.6.1/10.1, Informatica Analyst 9.6.1/10.1,Informatica DVO 9.6.1/10.1,Oracle 11g/10g, Oracle, SQL Developer, Teradata, Unix, Shell Scripting, Uc4, Rally, Flat Files, HP ALM, Informatica BDE 9.6.1, Hive, HDFS.

Confidential - Waltham, MA

Informatica IDQ Developer

Responsibilities:

  • Coordinating with clients for Requirements gathering and analysis.
  • Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
  • Worked with Informatica Data Quality (IDQ) tool kit, Analysis, data cleansing, data matching, data conversion, exception.
  • Used reference tables and rules created in Analyst tool.
  • Used various IDQ transformations like Standardizer, Address Validator, Match, Association, Parser, Weighted Average, Comparison, Consolidation, Decision, Expression
  • Implement Data Quality Rules using IDQ to check correctness of the source files and perform the data cleansing/enrichment.
  • Loading data into operational data store.
  • Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions(SCD)
  • Coding & testing the Informatica Objects & Reusable Objects as per the Client EBI standards.
  • Participating in peer review of Informatica objects.
  • Estimating volume of work & Deriving delivery plans to fit into overall planning.
  • Prepared ETL Build Peer Review Checklist’s and Unit Test Case Templates for different work packages.
  • Involved in Unit Testing, Integration Testing and System Testing.

Environment: Informatica Data Quality 9.5 (IDQ), Informatica Power center 9.5, SQL Server 2012, Oracle 11g, UNIX, CITRIX, Micro Strategy, JIRA, Flat Files, Skybot.

Confidential

Informatica Developer

Responsibilities:

  • Interacted with the Business Team to understand the requirements and prepared technical documents for implementing the solutions as per Business needs.
  • Configuration of Hub and creation of hub objects like landing tables, Staging tables and Base Objects, Queries and packages, mappings, Cleanse functions, Batch groups, message triggers
  • Data Model Creation based on requirements.
  • Load the data from flat files to Hub landing tables using various transformations.
  • Load data from landing tables to staging tables during stage process.
  • Performed Cleanse Operations during when data is loading into stage tables.
  • Enable delta detection on specific columns.
  • Defining Trust and validation rules for base tables while loading data from stage tables.
  • Configuration of Match, Merge rules.
  • Hub Data modeling along with hierarchy manager.
  • Import &Export of ORS using Metadata manager.
  • Compare repositories and generate change lists that describe differences between them using Metadata manager.
  • Validate the metadata in Informatica Hub repository and generate a report of issues.

Environment: Informatica MDM 9.1, Informatica Power Center 9.1, Oracle 11g, WebSphere, IDD, TOAD, SQL Server 2012, Flat Files.

Hire Now