We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Washington, DC

SUMMARY:

  • 9 +years of IT experience in development of various projects using Data Warehousing tools like Informatica, Data Modeling Tools like Erwin and Databases like Oracle, MS SQL Server,DB2.
  • Extensive experience in Integrated Informatica environment which comprises of Power Center, IDQ, Metadata Manager, Analyst (IDD), B2B Dx and B2B DT and Informatica Cloud.
  • Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Support, Testing and Documentation.
  • Data Warehouse experience using Informatica Power Center (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, and Transformation Designer) as ETL tool on Oracle, SQL server Databases.
  • Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACTs and Dimensions tables.
  • Experience in integration of data sources like Oracle, DB2, COBOL, SQL Server, XML, CSV and Flat Files.
  • Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
  • Knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, 3NF & Dimensional modeling.
  • Extensive experience in ETL processes in extracting data from Operational and Legacy Systems to Data Warehouse using Informatica.
  • Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type 3) mappings.
  • Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
  • Experience in using Informtica DQ (IDQ) tool for creating Profiles and Data Quality Rules and Reference tables.
  • Knowledge in IDQ 9.3 standards, guidelines, best practices, Scorecards.
  • Experience in Data Profiling with Informatica Data Quality.
  • Experience in creating and configuring custom models and using custom metadata configurator in Informatica Metadata Manager.
  • Experience in debugging mappings in both Powercenter and Developer tool, by analyzing the data flow, evaluating transformations and sessions.
  • Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence.
  • Experience in Modeling Transactional Databases and Data Warehouses.
  • Experience in Data Architecture and Data modeling in Dimension Data Modeling, Erwin Modeling (CA Erwin 4.5/4.0/3.5.5/3.5.2 ), Star Schema Modeling, Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling, Oracle Designer.
  • Knowledge in using Teradata Database.
  • Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
  • Experience in Autosys Job scheduling.
  • Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6,9.1,8.6,7.3, IDQ 9.6.1, Informtica Analyst (IDD) 9.6.1, Informatica MetaData Manager 9.6.1, Informatica B2B Data Transformation

DBMS: Oracle 11g; Oracle 9i; Oracle 8, SQL Server 2005, 2012

BI Tools: Cognos, QlickView, JasperSoft

Languages/ Scripting: PL/ SQL, TOAD, UNIX, LINUX, PowerShell

Programming Languages: Visual Basic 6.0, Java

Utilities: MS Word and MS Excel

Project Design Tools: Visual Source Safe, MS Visio, MS PowerPoint and MS Project

Operating Systems: Windows 2000 Server, Windows NT, Windows XP, Windows 95, 2012 HP - UX (HP UNIX), LINUX

Version Control Tools: VSS, Perforce, Documentum, Sharepoint

SFTP Client and SSH Client: WinSCP, PuTTY

Others: CA Erwin 4.5/4.0, Amazon Web Services

WORK EXPERIENCE:

Confidential, Washington, DC

Sr. Informatica developer

Responsibilities:

  • Re-designed and modified some of the old mappings to improve the performance.
  • Modified certain mappings from SCD Type2 to SCD Type1 as per the new requirements.
  • Responsible to monitor workflows daily and fix if there is any failure.
  • Migrated mappings from development to testing and then to Production environments.
  • Developed shell scripts for scheduling the sessions in Informatica.

Environment: Informatica Power Center 9.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), TOAD 12.x, Oracle 12g, SQL Server 2016, Flat files, LINUX, Windows XP, WinSCP 4.9.1.

Confidential, Washington, DC

Sr. Informatica developer

Responsibilities:

  • Collaborated with Application/System owner teams (Customer and other IT teams) and other Stakeholders to accurately define the current data flows.
  • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 9.6.1 to extract the data from multiple source systems such as Salesforce, flat files, and databases like Oracle 10g, SQL Server 7.2 to the Staging Data base and then to the Data Marts.
  • Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Salesforce Lookup, Router, Rank, Sorter, Transaction Control, Filter, Expression, Aggregator, Joiner, Sequence Generator, Union, Update Strategy, SQL Transformation, Stored Procedure, UDT(Unstructured Data Transformation) and more.
  • Created reusable components like mapplets, worklets.
  • Extensively worked with Slowly Changing Dimension (SCD) Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture (CDC).
  • Used Informatica Data Transformation Studio to transform unstructured to structured forms.
  • Used Parser component in Data Transformation Studio for conversion of PDF data files to XML files and then used Unstructured Data Transformation in PowerCenter to load the data into DB tables.
  • Involved in fixing the data parsing issues while processing the PDFs.
  • Involved in maintaining the processing of XML files using Informatica B2B Dx and Informatica PowerCenter.
  • Developed mapplets, mappings, workflows and applications using Informatica IDQ to validate Data Quality Rules set in Informatica MetaData Manager.
  • Developed Human Task objects to populate the Exception Tasks in Informatica Analyst tool.
  • Involved in fixing the issues of exception tasks population, Human Tasks in the Informatica Analyst tool.
  • Experience in deploying the Applications created/updated in IDQ to the Data Integration Service (DIS).
  • Configure the current data flows / lineage in the Informatica Metadata Manager using available connectors or as custom resources
  • Experience in creating custom models and Custom resources in Informatica Meta Data Manager.
  • Experience in associating custom Objects with the custom models created within Informatica Metadata Manager.
  • Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
  • Developed and maintained Database Views and procedures in SQL Server 2012 which are used in Jaspersoft (Business Intelligence Tool).
  • Performed Unit and Integration Testing.
  • Created the Deployment Plan and Involved in code migration from Dev to UAT and from UAT to Production environments.
  • Reviewed the technical design specification documents and provided feedback for Informatica PWC and IDQ mappings, mapplets, and sessions.
  • Participated in providing the project estimates of the development team efforts.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Confidential, Waukegan, IL

Sr. Systems Analyst (Informatica developer)

Responsibilities:

  • Converted business requirements into technical documents and created Source to Target mappings as needed.
  • Extracted data from sources like Oracle, XML files, and Flat files.
  • Worked with Power Center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
  • Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
  • Extensively used Informatica transformations like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, XML, Normalizer, Sorter etc., and related transformation properties.
  • Extensively used SCD’s to handle the Incremental Loading of Dimension and Fact tables.
  • Worked on Performance Tuning to optimize the Session performance by utilizing Push down optimization, Index Cache, Data Cache, incremental aggregation, Target load plan, constraint base loading and partitioning.
  • Worked on Debugging and Troubleshooting and utilized Informatica debugger.
  • Developed UNIX shell scripts to automate manual job runs.
  • Modified existing shell script to suite the existing business logic and developed the utility script to archive, move and copy files and also to automate the batch jobs.
  • Worked with DBA and infrastructure team to implement the DDLs, refresh data, create DB links, setup environment and delete the log files from the UNIX boxes.
  • Created and scheduled Data Synchronization tasks to separate Dev Jobs, Test Jobs, and Production jobs.
  • Created different views for Activity Logs such as Failed Tasks, Warning Tasks, and Successful Tasks.
  • Extensively used both Connected and Unconnected Lookup Transformations.
  • Responsible in writing SQL queries for Unit Test scenarios.
  • Helped the QA team in developing their protocols for validation activities.
  • Involved / Engaged in Tier 1 Production Support.
  • Automated the Daily Job runs using AutoSys tool.
  • Responsible to provide the code migration plan/scripts to the System Admins.

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), TOAD 11.0, QlikView, Erwin 4.2, Oracle 11i, SQL Server, Flat files, XML Files, SQL/PLSQL, LINUX, Windows XP, WinSCP 4.9.1, AutoSys, PTC Integrity tool.

Confidential, Temecula, CA

Informatica developer

Responsibilities:

  • Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
  • Worked with Power Center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
  • Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
  • Extensively used Informatica transformations like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc., and all transformation properties.
  • Hands-on experience with Java transformations and integrating Informatica with Java.
  • Extensively used both connected and unconnected Lookup transformations.
  • Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
  • Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
  • Worked with Session logs and Work flow logs for Error handling and troubleshooting in development environment.
  • Used Debugger wizard to troubleshoot data and error conditions.
  • Involved in designing and implementing Change Data Capture techniques like Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type3).
  • Worked extensively with session parameters, mapping parameters, mapping variables and parameter files for incremental loading.
  • Worked with workflow System variables like SYSDATE and WORKFLOWSTARTTIME.
  • Used Various Data Cleansing and Data Conversion Functions in various transformations.
  • Involved in data quality operations using IDQ (Informatica Analyst and Developer tool).
  • C omplex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL and Real-Time consideration.
  • Worked with Shortcuts across shared and non-shared folders.
  • Created shortcuts for source and target and also created Reusable transformations in Shared folder.
  • Developed PL/SQL procedures, functions, and packages.
  • Developed materialized views for aggregate data information.
  • Worked on SQL tuning, and also used Explain plan.
  • Responsible in writing UNIX shell scripting as needed.
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
  • Involved in code migration activities using Perforce.

Environment: Informatica Power Center 9.1/8.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), IDQ 8.6, TOAD 11.0, 11.5, Erwin 4.2, Oracle 11i, 10g, SQL Server, Flat files, SQL/PLSQL, Java/J2EE, UNIX, Windows XP, Perforce.

Confidential, Santa Clara, CA

Informatica Developer

Responsibilities:

  • Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
  • Requirement analysis in support of Data Warehousing efforts.
  • Involved in creation of Logical and Physical models for Warehouses using Erwin.
  • Developed overall data transformation and extract design and strategy.
  • Worked on Power Mart Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Creation of Transformations like Sequence Generator, Lookup, Joiner, Update strategy and Source Qualifier and Java transformations in Informatica Designer.
  • Created Complex mappings using Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
  • Created Mapplets and used them in different mappings for maintaining the standards.
  • Created events and tasks in the Workflows using Workflow Manager.
  • Developed Informatica mappings and also tuned them for better performance.
  • Created PL/SQL packages and procedures to build business rules to load data.
  • Transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
  • Designed strategy and coded procedures to extract daily incremental data.
  • Created UNIX shell scripting for file handing and archival and also to run the workflows for Informatica mappings.
  • Involved in Performance Tuning of Informatica mappings, SQL Query, views etc.
  • Involved in developing the technical documents from functional specifications.
  • Provided assistance and support to MIS team in understanding of data and designing Cognos reports.

Environment: Informatica Power Center 8.6, Oracle 9i/10g, PL/SQL, TOAD, Erwin, UNIX & Autosys.

Confidential, Temecula, CA

Systems Developer

Responsibilities:

  • Created ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
  • Involved in Data modeling and design of data warehouse in star schema methodology with Confirmed Dimensions and FACT tables.
  • Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
  • Responsible for writing interface document and mapping documents (velocity document) in compliance with the company procedures.
  • Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
  • Extensively interacted with user and involved in requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Data base design document, requirement traceability matrices etc.
  • Worked on the customer core master inbound files which consists data provided by the 3rd party sources and internal systems
  • Used mapping parameters and variables.

Environment: Informatica Power Center 8.6, XML, Flat Files, HP UX, Windows NT, Oracle 9i, SQL*, Toad.

Hire Now