We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

Cleveland, OH

SUMMARY

  • 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica PowerCenter.
  • 4+ years of experience in using Informatica PowerCenter.
  • 1+ years of experience in Reporting tool COGNOS.
  • Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
  • Knowledge in Full Life Cycle development of Data Warehousing.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Experience with dimensional modeling using star schema and snowflake models.
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
  • Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
  • Developed OLAP applications using Cognos 8BI - (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio) and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
  • Strong with relational database design concepts.
  • Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
  • Strong business understanding of verticals like Confidential, Brokerage, Confidential, Mutual funds and Pharmaceuticals.
  • Independently perform complex troubleshooting, root-cause analysis and solution development.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
  • Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
  • Comprehensive technical, oral, written and communicational skills.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, HP-UX

Software / Applications: MS XP, MS, MS Word, MS Excel, MS Access, Outlook, PowerPoint.

Database: SQL Server, Oracle

ETL: Informatica PowerCenter, Informatica Power Exchange.

Modeling: Framework Manager, Powerplay Transformer

OLAP/BI Tools: Cognos 8 Series

Languages: Java, HTML, XML,SQL, PL/SQL.

Web/Apps Servers: IBM Web Sphere 4x, Sun I Planet Server 6.0., IIS, Tomcat

Tools: TOAD, Visio, Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

ETL Informatica Developer

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements.
  • Communicated with business customers to discuss the issues and requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Used Informatica file watch events to pole the FTP sites for the external mainframe files.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Involved in Designing of Data Modeling for the Data warehouse.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
  • Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
  • Involved in Requirement Gathering and Business Analysis.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Effectively worked on Onsite and Offshore work model.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Published packages and managed the distribution / setup of the environment.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Identified problems in existing production data and developed one-time scripts to correct them.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica, SQL Server, R2, HP-UX.

Confidential, Charlotte, NC

ETL Informatica Developer

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Used Query Studio for creating Ad-hoc Reports.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
  • Created complex mappings that involved implementation of Business Logic to load data in to staging area.
  • Developed data Mappings between source systems and warehouse components using Mapping Designer.
  • Used Informatica reusability at various levels of development.
  • Developed mappings/sessions using Informatica Power Center for data loading.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
  • Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
  • Building Reports according to user Requirement.
  • Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
  • Implemented slowly changing dimension methodology for accessing the full history of accounts.
  • Write Shell script running workflows in Unix environment.
  • Optimizing performance tuning at source, target, mapping and session level.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica, Oracle, SQL Server, HP-UX.

Confidential, Bloomington, IL

ETL QA Tester

Responsibilities:

  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Involved in extracting the data from the Flat Files and Relational databases into staging area.
  • Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Prepared Technical Design documents and Test cases.
  • Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
  • Involved in Unit Testing and Resolution of various Bottlenecks came across.
  • Implemented various Performance Tuning techniques.
  • Used Teradata as a source system.

Environment: Informatica Power Center, Teradata, Oracle, Windows NT.

Confidential

ETL QA Tester

Responsibilities:

  • Involved in design, development and maintenance of database for Data warehouse project.
  • Involved in Business Users Meetings to understand their requirements.
  • Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.
  • Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
  • Worked extensively with the connected lookup Transformations using dynamic cache.
  • Worked with complex mappings having an average of 15 transformations.
  • Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
  • Monitored Workflows and Sessions using Workflow Monitor.
  • Performed Unit testing, Integration testing and System testing of Informatica mappings.
  • Coded PL/SQL scripts.
  • Wrote Unix scripts, Perl scripts for the business needs.
  • Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process.
  • Created Universes and generated reports on using Star Schema.

Environment: Informatica PowerCenter, Oracle, UNIX.

Hire Now