We provide IT Staff Augmentation Services!

Informatica Developer Resume

Owings Mills, MD

PROFESSIONAL SUMMARY:

  • Determined, passionate, hard - working individual with 6 years of experience in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes for clients in Banking and Financial (Anti-Money Laundering, Line of Business, Operational Risk) and HealthCare (Providers, Customers, Organizations, Plans,) domains.
  • Strong aptitude in working with large scale Data Warehouse implementations, Data Analysis, Relational Database Principles, and SQL Programming.
  • Designing and writing the ETL code as well as the batch management and error handling processes.
  • Additional responsibilities include the documentation of technical specifications and project SDLC artifacts.
  • A good understanding of the concepts and best practices of data warehouse ETL design.
  • Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively.
  • Methodical and structured approach to design and development.
  • Possess self-learning and good interpersonal skills.
  • Ability to mentor team members and promote and champion best practice ETL development techniques.
  • Delivery focused with the ability to prioritize activities.
  • Flexible team player within a small, multi-disciplinary team.
  • Ability to translate functional specifications into elegant ETL design supported by detailed technical specifications

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/7.1/6, Informatica Cloud.

Cloud Computing Tools: Sales force Automation

Databases: Oracle 11g, 10g, MS SQL Server 2000/2005/2008.

Utility Tools: Toad, SQL Developer.

Reporting/OLAP tools: SAP Business Objects, Cognos

Scheduling Tools: Autosys, Mainframe Reflection.

Defect Management Tool: JIRA, HP ALM.

PROFESSIONAL EXPERIENCE:

Confidential - Owings Mills, MD

Informatica Developer

Responsibilities:

  • Gathered requirements from business to implement new business logic and small enhancements to meet the limitations in the real-time environment.
  • Responsible for technical design, development and unit testing the mappings and transformations.
  • Created transformations like Source Qualifier, Lookup, Unconnected lookup, Update Strategy, Expression, Router, Filter, Joiner, Union, Transaction control, Stored procedure, User defined functions, Mapplets to implement Slowly changing dimensions to capture historical changes in target Data Warehouse.
  • Used Informatica Power Center Workflow manager to create workflows, sessions and batches to run with the logic embedded in the mappings
  • Developed PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time and handled transactions between other downstream systems like TIBCO.
  • Provided L2/L3 support and performed incident analysis and resolved high priority incidents daily.
  • Resolved the Day-to-Day defects raised by QA team and logged the efforts in HP ALM.
  • Worked on enhancements and created system design specification documents for the code developed.
  • Migrated code from DEV to SIT environment and deployed components in Tortoise SVN.
  • Monitored Informatica jobs run in Mainframe scheduling tool -Reflection and done work around on the abended jobs.
  • Experienced in documenting Unit test plan, mapping sheet, SDLC artifacts.
  • Good experience in Change management tool like Serena Business Manager.
  • Setup calls for design walkthrough to Team, given KT sessions and mentored offshore team on development activities on daily basis.
  • Capable of handling more applications at one time and providing individual support on clarifications required by business.

Environment: Informatica Power Center 9.6.3, SQL developer for Oracle 11.6, Mainframe Reflection, Tortoise SVN, Windows, UNIX, HP ALM, WinSCP, Serena Business Manager, TIBCO

Confidential -Charlotte, NC

ETL Developer

Responsibilities:

  • Gathered requirements from business and created ETL mappings to extract data from source, transform by applying business logic in staging and load them into target database.
  • Experienced in developing transformation objects using transformations like Source Qualifier, Connected/Unconnected Lookup, Expression, Router, Joiner, Update Strategy, Normalizer, Mapplets.
  • Experienced in creating mapping parameters and variables to increase the reusability in the mapping.
  • Transferred the data to a combination of different target files like XML, Flat files to Oracle.
  • Configured the mappings to implement Slowly Changing Dimension Type I, II, Change Data Capture, Dynamic Lookup and worked on Data Marts to generate star schema, snow flake schema.
  • Implemented Informatica job scheduling using Autosys jobs for delta load, full load, stage load in Dev, QA and UAT environments.
  • Developed PL/SQL packages, procedures to implement ETL process and validations before loading into Staging area.
  • Migrated ETL code and deployed DB scripts, JIL scripts in SVN to migrate from lower environments to UAT and PROD.
  • Experienced in debugging the code and issues raised during QA and checked the source and target data for reconciliation.
  • Performed Unit testing and created Mapping documents, code review documents, Unit Test Plan documents to track the overall SDLC process.
  • Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and communicated Defect Status Reports to business in project meetings.
  • Creation of Conceptual, Logical data model, Unit Test Plan and Technical Specification documents.
  • Setup walkthrough calls and involved in various KT sessions and timely escalation of Project Risks for any scope/schedule changes.

Environment: Informatica Power Center 9.6, Toad for Oracle 11.6, Autosys, Tortoise SVN, Windows, U UNIX, JIRA

Confidential - Chantilly, VA

Data Integration Developer

Responsibilities:

  • As part of the Confidential team, involved in development and testing of mappings and transformations using Informatica 8.6.1.
  • Identified test data for various scenarios of component life cycle from various snapshots to validate the mappings and transformations.
  • Reviewed and fixed various development and unit testing artifacts related to the development of data migration.
  • Gathered requirements from the client and followed the ETL SDLC process.
  • Identified test data for various scenarios of component life cycle from various snapshots to validate the mappings and transformations.
  • Reviewed and fixed various development and unit testing artifacts related to the development of data migration.
  • Created workflows, sessions, mapping variables and mapping parameters and created UNIX wrapper script to execute the Informatica workflows.
  • Created Low level design documents like Mapping sheet, Unit Test Plan, code review checklist and issue tracker sheet.
  • Worked on SAP Business Objects including Universe Designer, Web Intelligence, Xcelsius/Design Studio/Dashboards and Explorer.
  • Resolved issues raised in QA environment and assisted the reporting team on their requirements.
  • Actively supported during project deployment and resolved issues raised by the production support team on the jobs.
  • Used AGILE testing methodology for achieving deadlines in UAT testing.
  • Worked with the System Test team and Integration Team to demonstrate and sign-off bug fixes and logged those bugs.

Environment: Siebel 8.1.1, Rational Requisite Pro, Informatica 8.6.1, Rational Clear Quest, Oracle10g/9i/11g/12g, Business Objects, XML, UML, TOAD, Clear Case, Clear Tools, Windows 2008, and UNIX.

Confidential

ETL Developer

Responsibilities:

  • In-depth understanding of processes involving data modeling and building data marts and translated the business processes into Informatica mappings.
  • Developed complex mappings using various transformations like Aggregator, Joiner, Union, Lookup, Expression, Filter, Update Strategy, Router and Transaction Control.
  • Developed ETL workflows, sessions for initial full loading and incremental loading.
  • Implemented entire ETL job scheduling using Autosys and monitored the Informatica jobs on daily basis and made a force start whenever job fails in DEV, QA and UAT environments.
  • Created shell scripts to FTP files from different server to Informatica server.
  • Worked on making session runs more flexible through the use of mapping parameters and variables and used parameter files and variable functions to manipulate them.
  • Performed Unit testing and created Mapping documents, code review documents, Unit Test Plan documents to track the overall SDLC process.
  • Experienced in Data Partitioning to improve performance of the mapping.
  • Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and communicated Defect Status Reports to business in project meetings.

Environment: Informatica Power Center 7.1.2, Toad for Oracle, PL/SQL, Toad for SQL Server, Autosys, Windows, UNIX.

Confidential

ETL Developer

Responsibilities:

  • Developed ETL mappings to retrieve data from database and flat files and worked on Source Qualifier, Lookup, Expression, Aggregator, Sequence generator transformations in Informatica.
  • Understood the business requirements and applied business logic in the ETL code.
  • Developed Stored Procedures to validate the user input data and implemented mappings to generate conformed dimensions.
  • Developed JIL scripts to schedule the ETL jobs and checked for target data load.
  • Tested ETL mappings by creating test queries in Oracle and executing the Informatica ETL mappings and finally comparing the results to generated reports on monthly basis.
  • Resolved issues raised by QA team and checked for data consistency at all times.
  • Prepared Low Level Design documents like Mapping Sheet, Unit Test plan, code review check list and other Technical Specification document.
  • Actively participated in all Client meetings and communicated well with the team members on daily basis.

Environment: Informatica Power Center 6, T-SQL, SQL Server Management Studio, Autosys, Windows, UNIX.

Hire Now