We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

SUMMARY:

  • Around 8 years of in IT Industry with emphasis in Data warehousing tools in ETL Development using industry accepted methodologies and procedures.
  • Strong understanding of the principles of Data warehousing using fact tables, Dimension tables, Star, and Snowflake schema modeling.
  • Experience in Data warehousing, Data Extraction, Transformation and Loading ( ETL ) data from various sources like Oracle, SQL Server, Microsoft Access, Microsoft Excel and Flat files into Data Warehouse and Data Marts using Informatica Power Center 10.X/9.X
  • Worked with various Power Center/Power Mart components like Informatica Server and Client tools like Designer, Workflow Manager, Repository Manager and Workflow Monitor.
  • Involved in all phases of the Software Development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Extensively worked in Client - Server application development using Oracle 11g, 10g, 9i, PL/SQL and SQL*Plus.
  • Experience in using various Oracle utility tools like SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
  • Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Power Center.
  • Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Extensive knowledge on Informatica MDM concepts.
  • Extensively worked on ETL Informatica Transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
  • Extensively used ETL methodology for supporting Data Extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica Powercenter Designer, DataStage, MSBI, SAS, SSIS, and Oracle ODI.
  • Extensively used the Reporting tools like Tableau and OBIEE.
  • Worked on Informatica Cloud Services, Salesforce.com, and Salesforce transformations.
  • Extensively worked in areas of Retail, Health Care, Pharmacy, Banking domains.
  • Having good Analytical and inter-personal skills.
  • Good experience in using SQL, PL/SQL, Indexes, Functions, Procedures, Triggers and Cursors.
  • Good Experience in developing Unix Shell Scripts for automation of ETL process.
  • Efficiently communicate and handle on-site & offshore project teams.
  • Ability to work under tight deadlines and open to learn any new technologies.

TECHNICAL SKILLS:

ETL tools: Informatica Power Center 9.x, DataStage, MSBI, SAS.

BI Tools: Tableau, OBIEE.

Languages: SQL, PL/SQL, Unix Shell Scripting.

Databases: Oracle10g, MS SQL server, Teradata.

Database Tool: TOAD, SQL Developer.

Operating Systems: Windows, UNIX, LINUX.

Version Control Tools: SVN, GitHub.

Others: Jira, HP ALM, CA Rally, Azure

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Informatica Power Center, Informatica Cloud, DVO, Salesforce Oracle 11g, MS SQL, PL/SQL.

ETL Informatica Developer

Responsibilities:

  • Interacting with business analysts and developers to discuss the requirements for new and modified business rules.
  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems.
  • Developed design strategy to extract data from flat files and Oracle, and to load the data into the target database.
  • Worked on Informatica Cloud to create Source /Target SFDC connections, monitor and synchronize the data in SFDC and Oracle.
  • Extracted data from different sources like Oracle, SQL Server, DB2 and Flat files loaded into DWH.
  • Worked on Informatica Cloud Services (ICS) to load data from Azure db to Azure db and Oracle
  • Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
  • Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
  • Scheduled to automate the update processes and Informatica Workflows.
  • Wrote PL/SQL procedures for processing business logic in the database.
  • Tuned SQL queries for better performance.
  • Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.
  • Involved with the testing team to build the Test plans.

Confidential

Environment: Informatica Power Center, Putty, WinSCP, Linux, AWS.

Informatica Developer

Responsibilities:

  • Analyzing the requirements and having a discussion with BA Team on understanding of the business process.
  • Involved in creation of High-Level design documents based on BRD/FRD and got those reviewed by customers along with detailed project time lines.
  • Involved in building the ETL architecture using Informatica 9.6.1/ 9.5.1 and Source to Target mapping to load data into Data warehouse.
  • Preparing the complex SQL queries based on the requirement.
  • Created Stored procedures, collections and packages.
  • Created mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
  • Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
  • Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
  • Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
  • Created Reusable transformations, Mapplets, Worklets using Transformation Developer and Designers.
  • Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
  • Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
  • Attending daily status calls and providing solutions to the issues/requirement.
  • Working with BA Team in case of any clarifications on the requirement.

Confidential

Environment: Unix, Informatica, Oracle and Teradata

ETL Developer

Responsibilities:

  • Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
  • Worked to identify different source systems and performed data analysis to determine the best approach of procuring source data using Informatica Power Center 9.x
  • Interacting with different Business teams and Technical development teams to discuss the requirements for the new and modified business rules.
  • Developed Source to Target Mappings using Informatica Power Center Designer to load data from various source systems like Oracle and Flat files to target database, implementing the business rules.
  • Worked on issues involved in migrating the dev objects from Dev Repository to Test repository.
  • Created snapshot for the transactional tables in distributed databases and created Triggers, Procedures and Functions for the backend development.
  • Created shared folders, local and global shortcuts to reuse metadata MDM.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
  • Performed Performance tuning in RDBMS sources by implementing complex SQL query over rides in Source Qualifier transformation, which reduced unwanted data to be processed, thereby increasing the data processing speed.
  • Used Informatica workflow monitor to check the status of the jobs.
  • Create new batch jobs for Informatica. Designed and developed UNIX scripts to load tables and for scheduling the jobs.
  • Used Informatica to run the sessions and workflows.
  • Integrated the data with Tableau/OBIEE reporting tools to present to the business users.
  • Escalate the issues to Project Manager which needs attention.

Confidential

Environment: Informatica Power Center, PL/SQL, UNIX, XML.

Informatica Developer

Responsibilities:

  • Understanding Client requirement & involve into scrum meeting to be a part of planning.
  • Extracted data from SQL Server and Oracle tables.
  • Extensively used SQL loader to load data from flat files to the database tables in Oracle.
  • Involved in detail design and development of mappings using Informatica Power center.
  • Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router in ETL mappings.
  • Used Informatica to load the data from different sources to target as per the mapping requirement.
  • Created and Monitored Sessions and various other tasks such as Event-Raise Task, Event-Wait Task, Decision Task, Command Task etc. in Informatica workflows .
  • Modified existing mappings for enhancements of new business requirements.
  • Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
  • Reporting to the onsite coordinator about the status of the test activities daily.

Hire Now