We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Boston, MA

PROFESSIONAL SUMMARY:

  • Experience in Information Technology with a strong background in Informatica Power Center, Informatica Data Quality, Teradata,SQL,Data Warehousing, Databases and Data Modeling.
  • Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center, IDQ.
  • Strong experience in Data warehousing, Dimensional Star Schema and Snowflakes Schema methodologies.
  • Extensively worked on Informatica Power center Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
  • Expertise in designing and developing Informatica Data Quality transformations/rules like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Proficient in understanding business processes / requirements and translating them into Technical requirements.
  • Proficient level working on Creating ETL Documentation as per Business Specifications.
  • Expertise in designing and developing Informatica mappings from varied transformation logic using filters, expression, rank, router, aggregator, joiner, lookup, update strategy, stored procedure etc.
  • Experience in integration of various data sources like Teradata, Oracle, SQL Server, Flat Files into the data warehouse.
  • Experience in Creating Control Frame Work(CFW) and ETL Exception Design. Experience in Building framework using Informatica to dynamically generate queries by reading metadata.
  • Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
  • Experience in using the Informatica Utilities like Pushdown optimization and Session Partitioning to improve the performance of Informatica mappings.
  • Hands on experience in identifying and resolving bottlenecks in various levels like sources, targets, mappings and sessions.
  • Worked extensively on Error Handling, Performance Analysis and Performance Tuning of Informatica ETL Components and SQL Scripts.
  • Have performed various testing activities like unit testing, Integration-system Testing and user acceptance testing and ensured that the code is ideal.
  • Experience with UNIX Shell Scripting on UNIX & Linux platform.
  • Well-developed interpersonal and communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6, 9.5, 9.1, 8.6, (Designer, Workflow Manager, Workflow Monitor, Repository Manager)Data Quality: Informatica Data Quality (IDQ), DVO (Data Validation Option)

Operating Systems: Windows 7/10, Windows Vista/XP/2000, UNIX/Linux.

Databases: Oracle 8i/9i/10g/11g,Microsoft SQL Server 2008/2012/2014, DB2, Teradata V2R12, V2R6

Development tools: Toad, Teradata SQL Assistance, SQL Developer

Programming/Languages: SQL, PL/SQL, UNIX shell scripting

SDLC Methodologies: Agile/Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

  • Responsible for coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document
  • Analyses data and prepared low level design documents before the development begins.
  • Developed various Informatica Mappings & Mapplets to load data using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, Sequence Generator to load the data into the target tables.
  • Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modeling, which helps in structuring and organizing data in uniform manner where constraints are placed within structure major concept of Data modeling.
  • Developing mappings complete initial data profiling and removing duplicate data.
  • Designed, developed Informatica Power Center 9.6 mappings to extract, transform and load the data into SQL Server target tables
  • Based on requirements, developed Source-To-Target mapping document with business rules and also developed ETL documentation. Developed Validation rules during the staging to ODS loading.
  • Develop Control Frame Work (CFW) and Variables and Parameters.
  • Maintain ETL Exception as per business Specifications.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels
  • Used Informatica Workflow Manager to schedule workflows and created sequential and parallel loads and used workflow monitor to monitor the load process and trouble shouted the session failure getting log files
  • Created task like session, event waits, event raise, command, decision and control task using workflow manager and monitored the jobs in workflow manager
  • Working closely with business users and technical teams in a customer facing role to bring requirements together into a cohesive design
  • Provided data to the reporting team for their daily, weekly and monthly reports.
  • Used Debugger to test the mappings and fixed the bugs as per QA bugs.
  • Involved in Unit testing, System Integration testing, User Acceptance Testing.
  • Involved in Informatica Code Migration across various Environments
  • Involved in Production Support and Knowledge Transfer sessions

Environment: Informatica Data Quality 9.6.1, Informatica Power Center 9.6.1, Informatica DVO (Data Validation Option), SQL, PL/SQL, Oracle 11g, Teradata, DB2, Toad, SQL Assistant, Autosys, Flat files, XML Files, Agile/Scrum, UNIX

Confidential, Boston, MA

Informatica Developer

Responsibilities:

  • Responsible for coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document
  • Analyses data and prepared low level design documents before the development begins.
  • Developed various Informatica Mappings & Mapplets to load data using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, Sequence Generator to load the data into the target tables.
  • Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modeling, which helps in structuring and organizing data in uniform manner where constraints are placed within structure major concept of Data modeling.
  • Extensively worked on Informatica Power center/IDQ.
  • Developing mappings complete initial data profiling and removing duplicate data.
  • Designed, developed Informatica Power Center 9.6 mappings to extract, transform and load the data into Oracle 11g target tables
  • Based on requirements, developed Source-To-Target mapping document with business rules and also developed ETL Spec documentation.
  • Implemented / Developed incremental ETL mappings
  • Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading
  • Used Debugger to test the mappings and fixed the bugs
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels
  • Used Informatica Workflow Manager to schedule workflows and created sequential and parallel loads and used workflow monitor to monitor the load process and trouble shouted the session failure getting log files
  • Enhancements to the existing data sources to meet the customer’s requirements
  • Performance tuning in Informatica Mappings by identifying the bottlenecks and Implemented effective transformation Logic
  • Working closely with business users and technical teams in a customer facing role to bring requirements together into a cohesive design
  • Provided data to the reporting team for their daily, weekly and monthly reports.

Environment: Informatica Data Quality 9.6.1, Informatica Power Center 9.6.1, SQL, PL/SQL, Oracle 11g, Teradata, DB2, Toad, SQL Assistant, Flat files, UNIX

Confidential, Duluth, GA

ETL Developer

Responsibilities:

  • Design the physical model and ETL’s to source data from current systems.
  • Building the necessary staging tables and worktables on oracle development environment.
  • Designed a flexible ETL process to run as Incremental load or Full Load with minimal tweak.
  • Developed Mappings, Sessions and Workflows to extract, validate, and transform data according to the business rules.
  • Data migration from one environment to another environment using kettle ETL tool.
  • Used several transformations in Kettle to cleanse, validate and improve quality of data before loading it into target schemas.
  • Developed complex mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedures, Router and Mapplets.
  • Created High level/detailed level design documents and also involved in creating ETL functional and technical specification.
  • Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
  • Extensively worked in performance tuning of programs, ETL procedures and processes.
  • Worked on data cleansing and standardization using the cleanse functions in Informatica.
  • Coordinating with Business Analyst to get the requirement clear and re-solve queries and getting requirements freeze before the development activity starts.
  • Developed Mappings, Sessions and Workflows to extract, validate, and transform data according to the business rules.
  • Involved in implementing the Land Process of loading the customer/product Data Set into Informatica from various source systems.
  • Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
  • Created table pairs, generated and added tests on the table pairs and executed them.
  • Worked on performance tuning of programs, ETL procedures and processes.
  • Co-ordinate with the QA team in various testing phases and fix the defects reported by the testing team and coordinate with testing team.
  • Project and Team management, work allocation and status reporting.

Environment: Informatica Power Center 9.x, IDQ,Oracle 11g, DB2, SQL Server 2008, CDE (community dashboard editor),CGG (community graphics generator),Teradata V2R6, Tivoli, UNIX, HP Quality Center 10, Clear Quest

Confidential, Dallas, TX

Informatica Developer | IDQ Developer

Responsibilities:

  • Analyzed the technical requirements and data flows and prepared technical strategy documents.
  • Worked with heterogeneous sources, including relational sources and flat files.
  • Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
  • Data Profiling, Cleansing, Standardizing using IDQ and integrating with the Informatica suite of tools.
  • Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ
  • Worked on IDQ Analyst for Profiling, Creating rules on Profiling and Scorecards.
  • Developed IDQ rules in accordance with the Data governance specifications.
  • Built Physical Data Objects and developed various Mapping, Mapplets/rules using Informatica Data Quality based on requirements to profile, validate and cleanse the data.
  • Designed and developed Technical and Business Data Quality rules in IDQ and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst).
  • Worked on data cleansing and standardization using the cleanse functions in IDQ.
  • Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.
  • Used DVO to validate the data moving from Source to Target.
  • Used Demonstration Plans in IDQ and profiled the demo data, worked on Pre-standardization scorecards, standardized the generic data, name data & address data, and also matched demo data, consolidated data and viewed the consolidated data.
  • Developed complex mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, normalize, Router and Mapplets.
  • Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
  • Project and Team management, work allocation and status reporting.

Environment: Informatica Power Center 9.x, IDE/IDQ, DVO, Oracle 11g, Teradata, Control-M, UNIX

Confidential

Informatica Developer

Responsibilities:

  • Actively involved in understanding business requirements, analysis and design of the ETL process.
  • Used Informatica Power Center to extract, transform and load data from various source systems to staging and target Data warehouse.
  • Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in a batch process.
  • Tuned the performance of mappings by following Informatica best practices and also applied several methods to get better performance by decreasing the run time of the workflow.
  • Worked with the transformations like Lookup, Joiner, Filter, Aggregator, Source Qualifier, Expression, Update Strategy and Sequence Generator Transformations.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail of the workflow.
  • Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
  • Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
  • Worked with PMCMD to interact with the Informatica Server from command mode and execute the shell scripts.
  • Monitored the session logs to check the progress of the data load.

Environment: Informatica Power Center 9.x/8.x, Oracle 10g, Agile, TOAD, UNIX

Hire Now