We provide IT Staff Augmentation Services!

Informatica Lead Resume

0/5 (Submit Your Rating)

WaukegaN

SUMMARY

  • 5 years of IT experience in Analysis, Design, Development and Implementation of Data warehouse systems and Expertise in Teradata, Informatica, Oracle and Unix/Linux.
  • Worked on Teradata Client Utilities using BTEQ, Fast load, MultiLoad, TPT and Fast export.
  • Extensively worked in Designing, Coding and Testing phases of software development life cycle process, which includes implementing and supporting Teradata & batch - processing jobs.
  • Extensive experience in creating theMappings, Mapplets, Reusable transformations Workflows, Worklets,and scheduling theWorkflows and sessionsusingInformatica Power Center.
  • Worked in Analysis & Migrating SAS Code to Informatica and Teradata.
  • Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
  • Worked on queries for avoiding FTS in Teradata.
  • Involved in the design of Multi-Dimensional Data Modeling (Star, Snow Flake schema) using Erwin, MS-Visio.
  • Sound knowledge in Relational and Dimensional modeling techniques of Data warehouse concepts and principles - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization
  • Designed and developed complex mappings using different transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more
  • Excellent Knowledge of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle and Teradata using Informatica
  • Worked in conceptual, logical and physical data models using ERWIN.
  • Worked in SQL and PLSQL in Teradata and Oracle.
  • Worked on Design Docs, Unit Test Cases, QA Test Cases, QA Test Plan & Test Strategy.
  • Worked on Basic Administrative Activities in Teradata.
  • Worked on developing various test cases for testing Informatica code.
  • Worked with major Pharma Clients like Pfizer, Bayer, Abbott
  • Worked on Data modeling.
  • Experience in Life Sciences Domain.
  • Excellent communicational, interpersonal, analytical and problem solving skills.
  • Extensively worked on executing Bteqs through Shell scripts.

TECHNICAL SKILLS

Operating System: Windows 95/98/2000, Unix /Linux

Languages: SQL,C,plsql

Databases: Teradata 12 and 13, Oracle

Tools: & Utilities Informatica,Teradata Tools like BTEQ, Fast load, Multiload, Fast Export, TpT, Erwin, Toad

Domain Knowledge: Life Sciences

PROFESSIONAL EXPERIENCE

Confidential, Waukegan

Informatica Lead

Responsibilities:

  • Interacted with Functional teams to understand the requirements.
  • Data Profiling Activities.
  • As a Sr. Informatica developer, performed requirements gathering, developed Analysis & Design document, developed Project time line.
  • Involved with Business Analyst in requirements gathering, business analysis and project co-ordination
  • Analyzed existing SAS codes for conversion into Informatica ETL code.
  • Design, Development and Testing and coordination with Offshore Team.
  • Data comparison with SAS files and ETL output Files.
  • Involved in writing SQL scripts for unit and functional testing.
  • Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
  • Coordinated the project tasks with the team and ensured that the projects are completed on time.
  • Worked on Autosys Scheduling Tool for Scheduling and Monitoring of jobs.
  • Used Teradata utilities Fload,Mload, for loading tables and Fast export exporting data from table
  • Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
  • Documentation for the Informatica processes, naming conventions and best practices.

Environment: Informatica, Teradata, UNIX

Confidential, Waukegan

Informatica Lead

Responsibilities:

  • Interacted with Functional teams to understand the requirements.
  • Data Profiling Activities.
  • Analyzed existing SAS codes for conversion into Informatica ETL code.
  • Involved in all phases of SDLC from requirement, design, and development and testing. Performed business analysis and requirements per high-end users and managers and prepared design documents.
  • Involved in creating comprehensive Technical and Mapping Design documents for the project.
  • Responsible for coding of mappings and unit testing and integration testing. Prepared mapping specification documents for the same.
  • Involved in writing SQL scripts for unit and functional testing.
  • Had worked on calling bteq’s Through Shell scripts
  • Extensively worked on Informatica Power Center - Mapping Designer & Mapplets, and Transformations, Reusable Transformations, Workflow manager, Repository manager, Workflow Monitor, Sessions, workflows.
  • Responsible for coordinating with the offshore team.
  • Extensively worked on tuning and thereby improving the load time.
  • Used Teradata utilities Fload,Mload, for loading tables and Fast export exporting data from table.

Environment: Informatica, Teradata, UNIX

Confidential, Waukegan

Informatica Lead

Responsibilities:

  • Interacted with Functional teams to understand the requirements.
  • Data Profiling Activities.
  • Design, Development and Testing and coordination with Offshore Team.
  • Involved in writing SQL scripts for unit and functional testing.
  • Provided recommendations at query-level & also at Table-Level to improve the performance.

Environment: Informatica, Oracle, UNIX

Confidential

Informatica Lead

Responsibilities:

  • Interacted with development & Functional teams to understand the History Load requirements.
  • Performed Data profiling on the existing IDEA Sales Production data
  • Developed business models confirming to functional mapping-defined logical and complex joins for the dimension tables.
  • Responsible for History Load and Design, Interact with offshore for Development and Test and do Functional Testing.
  • Involved in writing SQL scripts for unit and functional testing.
  • Provided recommendations at query-level & also at Table-Level to improve the performance.
  • Interacted with Business users on analyzing their requirements.

Environment: Informatica, Oracle, UNIX

Confidential

Teradata/Informatica Developer

Responsibilities:

  • Interacted with development & Functional teams to understand the requirements.
  • Worked in Data Profiling by loading Files using FLOAD, Requirements gathering.
  • Design of Product Subject Area for Bayer Products.
  • Involved in Teradata architect activities.
  • Worked in porting Oracle code in Teradata for ITRAK Reporting Tool.
  • Prepared Design, UTC, STC and deployment document
  • Worked on Informatica tool for developing mappings.
  • Worked on Data modeling using Erwin.
  • Development and deployment of Database Objects
  • Used to support client for data extraction, fixing issues and reloading data
  • Worked on Reporting Queries for performance tunings on them.
  • Recommended better standards in Teradata to Team members
  • Coordinated with Team for any issue fixes they faced in Informatica and Teradata.
  • Data profiling from existing Data warehouse application.
  • Handled CR’s requested by Client.
  • Involved in Setting up Teradata and Informatica environment for our Project.
  • Worked Extensively on Teradata utilities to load Data in Our project Using FLOAD, Fast Export, MLOAD, and BTEQ, had worked on some basics Teradata administrator tasks.
  • Worked on Informatica tool for developing mappings.
  • Had worked on executing Bteqs through Shell scripts.
  • Worked on logical and physical data models ERWIN as Modeling Tool.

Environment: Informatica, Teradata 12 & 13, Oracle 10g, UNIX

Confidential

Informatica Developer

Responsibilities:

  • Gathered Requirements from functional team.
  • Worked in Design of Mappings and Development and Testing.
  • Reconcile with existing application
  • Load BU Product master details in Table.
  • Preparation of unit test cases
  • Interacted with onsite team, gathered requirements and shared it with offshore team
  • Performed Impact Analysis based on the Change request
  • Development and deployment of Database Objects
  • Prepared Design, UTC, STC and deployment document
  • Used Shell scripts to execute Bteq Queries.
  • Worked on Informatica tool for developing mappings.
  • Used Bteq,Fload,Mload, Fload as Teradata Load Utilities
  • Used Fast export for Exporting Data from database.

Environment: Informatica, Teradata, UNIX

Confidential

Informatica Developer

Responsibilities:

  • Design, Develop and Test the informatica code.
  • Load file till data marts and do reconcile HFM with MIC data.
  • Prepared Design, UTC, STC and deployment document
  • Development and deployment of Database Objects
  • Involved in Performance tuning activities on queries for avoiding FTS.
  • Interact with Functional team for any issues on HFM adjustments due to wrong map of products in Product cross- file and fix them.

Environment: Informatica, Teraadata, UNIX

Confidential

Developer

Responsibilities:

  • Had supported the application by fixing any data issue when job fails
  • Reconcile data among data marts.
  • Interacted with Users for the requirements.
  • Worked on Reporting Queries for performance tunings
  • Development and deployment of Database Objects
  • Prepared Design, UTC, STC and deployment document
  • ETL Coding and Job design implementation, which involved extensive use of different Transformations
  • Worked as a team member, managed team and coordinate with different teams to ensure successful delivery
  • Acquired the knowledge of business process flow.
  • Involved in Rejection recovery and reconciliation process
  • Mload, Fload were used as part of Teradata Loading Utilities.
  • Used to handle reconcile issues on products by tracing back the load.
  • Used to support client for data extraction, fixing issues and reloading data
  • Handled CR’s in system.

Environment: Informatica, Teradata, UNIX

We'd love your feedback!