We provide IT Staff Augmentation Services!

Lead Informatica Developer Resume

4.00/5 (Submit Your Rating)

New, YorK

SUMMARY:

Results - driven professional with 10+ yrs of total overall IT experience and 6 plus years of progressive experience in Informatica Development, Oracle, and SQL Server with a versatile and strong analytical and project management capability, relentless in customer-focus orientation and developing strong relationships at all levels, seeking a position as a Data Warehouse/ETL Developer Analyst

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/ 8i/ 8/ 7.x, MS-Access, SQL Server 2005/2008

Web Servers: Oracle Application Web Server 4.x/3.x/2.x, IIS 4.0.

DW/OLAP TOOLS: Informatica Power Center 5.0/5.1/6.0/6.1/7.1/8.6.1/9.1, SSIS,Cognos, Business Objects, Access Manager, Crystal Reports V 10.

Tools: Developer 2000, SQL*Plus, SQL*Loader, OEM, AutoSys, Erwin,SQL Navigator

Languages: C, C++, Java, HTML, ASP, JSP, SQL, PL/SQL, XML.

OS: Windows NT /4.0/3.51, Windows 7/XP/ 2000/98/95/3. x, HP-Unix 11.0/10.20

PROFESSIONAL EXPERIENCE:

Confidential, New York

Lead Informatica Developer

Responsibilities:-

  • Responsible for Analysis and Design.
  • Coding and Deployment.
  • Developed unix scripts to convert a semi-structured flat files into a structure one so that it can be consumed by Informatica .
  • W rote stored procedures in Oracle 11g for data conversion and loading.
  • Informatica resource person for developing maps/workflows/scheduling workflows etc.
  • Designed and wrote portions of the Informatica supporting framework.
  • Developed Resusable Transformations/Mapplets/Sessions for Group.
  • Supported and enhanced script wrapper using command line Informatica and scripts
  • Involved in data integration and testing. Coordinated with the testing team and provided documentation and test scripts on how unit testing was performed. Also, provided testing team insights on how to fail the process, in an effort to make the process as robust as possible.
  • Involved in the release process from development to Informatica production.
  • Trouble shooted informatica as well as performance enhancements.
  • Developed reports in OBIEE.
  • Also, responsible for complete documentation of each phase of the project and for the complete project life cycle.

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL Server 2014, Control-M, DB2, UNIX, MS Access, Excel, XML, windows 8 / Toad 10.6, OBIEE, SVN (Versioning Software).

Confidential

Lead Informatica Developer

Responsibilities:

  • Responsible for getting requirements from business analysts and translating those requirements into transformations specs and subsequently into Informatica Maps && Workflows.
  • Responsible for developing the sample database for development and testing purpose.
  • Responsible for database & application tuning. Performed optimization both at the mapping level and at the session level and used partitioning techniques in Informatica to speed up load time. Also, partitioned database tables which resulted in quick retrieval of records.
  • Wrote stored procedures in Oracle 11g for data conversion and maintenance
  • Conduct Data Integration and Testing as part of making an enterprise wide Client database.
  • Developed unix scripts to automate Informatica workflows.
  • Documented the process.

Environment: Informatica Power Center 9.1, Oracle 11g, MS Access, Excel, XML, Unix/Windows 8 / Toad 10.6, Tidal

Confidential, New Jersey)

Lead Informatica Developer

Responsibilities:-

  • Documented the transformation specs via excel sheets and also through SQL queries.
  • The above transformation specs were developed by interacting with the user and also obtaining logic from existing stored procedures.
  • Worked in conjunction with the architect on the DATA MODEL.
  • Identified the source tables and was responsible in identifying the GAP Analysis.
  • Also, was responsible in the naming of tables and maps that conform to Confidential standards.
  • Used INFORMATICA 8.6/9.1 to extract data from flat files/relational and load it into relational target (SQL SERVER 2008)/FLAT FILES.
  • Developed sessions using Power Center, Workflow Manager for loading the data into target database
  • Worked on Performance Tuning of various mappings.
  • Developed sessions using Workflow Manager for loading the data into target Database / flat files.
  • Developed stored procedures and implemented them in the Maps using the Stored
  • Procedure Transformation.
  • Wrote UNIX and PL/SQL scripts for pre & post session processes and to automate daily loads
  • Developed unit test /integrated testing scenarios which were used to obtain the UAT’s.
  • Developed validation queries which were also used to develop reports as specified by the users.
  • Developed narratives that describe the technical process in business terms.
  • Performed data quality checks for all the columns as suggested by the business.
  • Confidential is moving from INFORMATICA to SSIS, I was responsible in converting all Informatica maps to SSIS packages. SSIS packages were created using components from Task Factory.

Environment: Informatica Power Center 8.6/9.1, SQL Server 2005/2008, MS Access, Excel, XML, Unix/Windows XP, SSIS

Confidential, New York

Sr Informatica Developer

Responsibilities:

  • Modified and developed the maps/workflows for three data feeds viz ADMARC /TAS (BOSTON GLOBE)/INSI.
  • Documented the transformation specs via excel sheets and also through SQL queries.
  • Reverse engineered and corrected the existing functional specs.
  • Used INFORMATICA to extract data from flat files/mainframes and load it into relational target (ORACLE)/FLAT FILES.
  • Responsible to tune ETL procedures and star schemas to optimize load and query performance.
  • Developed sessions using Power Center, Workflow Manager for loading the data into target database
  • Worked on Performance Tuning of various mappings.
  • Developed sessions using Workflow Manager for loading the data into target Database / flat files.
  • Developed stored procedures and implemented them in the Maps using the Stored
  • Procedure Transformation.
  • Wrote UNIX and PL/SQL scripts for pre & post session processes and to automate daily loads
  • Developed source and target reconciliation queries to test and validate the maps in order to ensure the maps function in accordance to the business rules.
  • Developed validation queries which were also used to develop reports as specified by the users.
  • These reports were categorized into pre - transformation, cross-reference table reports (look up tables) and post-transformation reports: more like a before and after picture so that the users can know what to expect.
  • Developed narratives that describe the technical process in business terms.

Environment: Informatica Power Center 7.1.3/ 8.1 Power Exchange, Oracle 10g, SAP IS MEDIA, MS Access, Excel, XML, Unix/Windows XP

Confidential, New York

Sr Informatica Developer

Responsibilities:

  • Modified and developed the existing data model using ERWIN.
  • Designed and developed the maps/workflows for two data feeds viz daily / monthly.
  • Used INFORMATICA to extract data from flat files and load it into relational target (ORACLE).
  • Used Java Messaging Services to trigger the workflow in Informatica. (A message I(JobID) is sent to
  • Trigger the workflow, if there is no jobid sent within a particular timeframe the workflow will be aborted else it will proceed and data will be loaded in all the desired target tables.
  • Responsible to tune ETL procedures and star schemas to optimize load and query performance.
  • Developed sessions using Power Center, Workflow Manager for loading the data into target database
  • Worked on Performance Tuning of various mappings.
  • Developed sessions using Workflow Manager for loading the data into target Database / flat files.
  • Developed stored procedures and implemented them in the Maps using the Stored
  • Procedure Transformation.
  • Wrote UNIX and PL/SQL scripts for pre & post session processes and to automate daily loads
  • Developed source and target reconciliation queries to test and validate the maps in order to ensure the maps function in accordance to the business rules.
  • Documented the transformation specs via excel sheets and also through SQL queries.

Environment: Informatica Power Mart/Power Center 7.1.4, Oracle 9i/10g MS Access, Excel, XML, Toad 8.6.0.38, Erwin 4.0, HTML, Unix/Windows XP, Java Messaging Services (JMS).

Confidential, New York

Sr Informatica Developer

Responsibilities:

  • Worked with the Business Analyst and developed the technical specification on how business rules should be incorporated in the Maps.
  • Used INFORMATICA to extract data from the database ORACLE.
  • Responsible to tune ETL procedures and star schemas to optimize load and query performance.
  • Developed sessions using Power Center, Workflow Manager for loading the data into target database
  • Worked on Performance Tuning of various mappings.
  • Developed sessions using Workflow Manager for loading the data into target Database / flat files.
  • Developed stored procedures and implemented them in the Maps using the Stored
  • Procedure Transformation.
  • Wrote UNIX and PL/SQL scripts for pre & post session processes and to automate daily loads
  • Developed source and target reconciliation queries to test and validate the maps in order to ensure the maps function in accordance to the business rules.
  • Documented the transformation specs via excel sheets and also through SQL queries.

Environment: Informatica Power Mart/Power Center 8.1, Oracle 9i/10g MS Access, Excel, XML, Toad 8.6.0.38, Erwin 4.0, HTML, Unix/Windows XP.

Confidential, San Francisco

Sr Informatica Developer

Responsibilities:

  • Used INFORMATICA to extract data from the database (ORACLE), MAINFRAME and flat files.
  • Developed Complex Mappings using Transformations (Filter, Router, Lookup, Update Strategy, Normalizer and Expression) on the extracted data according to the Business Rules and Technical Specifications.
  • Over riding the default query in the Source Qualifier by in co-operating customized SQL queries and Extracting only those rows that are necessary to the specified target.
  • Developed Mapplets for maps that in corporate the same logic and have similar target columns as output. This helped to improve code readability and reusability.
  • Worked on Performance Tuning of various mappings.
  • Developed sessions using Workflow Manager for loading the data into target Database / flat files.
  • Involved in creating Unit test Procedures, to ensure the map performs according to the business rules mentioned.
  • Modification of Stored Procedures.
  • Involved in fixing invalid mappings using the INFORMATICA DEBUGGER and the SESSION LOG.
  • Documentation of mappings and sessions involved in the ETL process.
  • Involved in obtaining information directly from the users and translating these requirements into system solutions for the creation of operational reports.
  • Developing reports according to the user’s needs and specifications using Crystal Report V10.
  • Involved in migration of maps/sessions from development to testing.
  • Played a vital role in both string and system integrated testing.
  • Coordinated with other test teams, on how to go about the testing process .Also, in identifying invalid data and notifying defects in maps.
  • Supported users with word processing and spreadsheets mainly for the documentation of Unit test Procedures and Quality analysis.
  • Exposed to composite software(EII).

Environment: Informatica Power Mart/Power Center 6.2.1/7.1, Power Exchange 5.2.1,Oracle 9i/10g,IBM Mainframe A3, Crystal Reports V10, MS Access, Excel, XML, Toad 7.6.0.11, Erwin 4.0, HTML, Unix/Windows NT/2000. TNS 3270

Confidential, Portland, Oregon

Informatica Developer

Responsibilities:

  • Used INFORMATICA to extract data from the database (ORACLE) and flat files.
  • Developed mappings in accordance to the business rules and technical specifications.
  • Worked on Performance Tuning of various mappings.
  • Developed sessions using Workflow Manager for loading the data into target Database.
  • Overriding the default query in the Source Qualifier whenever required.
  • Involved in testing of Stored Procedures and Functions, Unit Testing of Informatica Sessions, Batches, Workflows and the Target Data.

Environment: Informatica Power Mart/Power Center 6.1/7.1,Oracle 9i/10g, MS Access, MS Excel, SQL Navigator 4.3, Unix/Windows NT/2000.

Confidential, NJ

Informatica Developer

Responsibilities:

  • Extensive interaction with users to understand their requirements, coordination with other project teams to arrive at synergy and unified development plan.
  • Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
  • Extensively used INFORMATICA 6.2.1 client to extract data from the database (ORACLE) and load it into a single data warehouse repository (GMDW) (ORACLE).
  • Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the
  • Data Warehouse from the various source systems feeds using Informatica Power Center, PL/SQL.
  • Translated user requirements into system solutions.
  • Developed Complex Mappings using Transformations (Filter, Router, Lookup, Update Strategy, and Expression) on the extracted data according to the Business Rules and Technical Specifications.
  • Over riding the default query in the Source Qualifier by in co-operating customized SQL queries and applying the business rules at the source itself to improve efficiency and avoid cumbersome transformations.
  • Involved in fixing invalid mappings using the INFORMATICA DEBUGGER.
  • Developed sessions using Workflow Manager for loading the data into target Database.
  • Involved in Testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches, Workflows and the Target Data.
  • Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
  • Documentation of mappings and sessions involved in the ETL process.
  • Supported users with word processing, spreadsheets, databases and presentation software.

Environment: Informatica Power Mart/Power Center 6.2.1/7.1, Power Exchange 5.2.1,Oracle 9i/10g, MS Access, Excel, XML, Axio, Toad 7.3, Erwin 4.0, HTML, Unix/Windows NT/2000

We'd love your feedback!