We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

0/5 (Submit Your Rating)

Charlotte North, CarolinA

SUMMARY

  • An IT professional with 7+ years of experience in building Data warehouses, Data Marts, Data Integration, operational data stores and Extraction, Transformation, loading processes for clients in industries like Healthcare, Finance, Insurance and Retail.
  • Expert in using ETL methodologies, supporting Extraction, Migration, transformation and loading the data using Informatica Power Center 9.5/9.1.0/8.6.1/8.5/8.1/7 x. Designer, Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplets Designer, Workflow manager, and Workflow Monitor.
  • Experienced in development of Data Mart life cycle executing ETL procedure to load data from different sources into Data Mart.
  • Experience in Data warehouse, OLAP/OLTP implementations, grouped with project scope, Analysis, gathering requirements, Data Modeling, ETL Design, Development, system testing, implementation and production support.
  • Experienced Working on various software development methodologies such as waterfall and agile.
  • Strong experienced in Dimensional Modelling Techniques like Star schema and Snowflake schema, determining facts and Dimensions, physical and logical data modelling by using Erwin and MS Visio.
  • Expertise in Exception Handling Mappings using TOAD and PL/SQL for Data quality and Data validation.
  • Highly experienced in extracting, transforming, loading process and administering in creating Domains, Repositories and folders using Informatica Power Center.
  • Experienced in creating Mapplets, reusable transformations, look - ups, unions, ranks, normalizer transformations common functions, for better usability.
  • Expertise in developing and designing complex mappings from different transformations like Source Qualifier, Filter, Expression, Sorter, Union, Aggregator, SQL, Stored Procedure, Update Strategy, Unconnected and Connected Static and Dynamic Lookups.
  • Hands on experience on Relational Databases like Oracle 11g/10g, DB2 8.0/7.0, SQL Server 2008/2005, MS Access and Teradata.
  • Experienced working on various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files and Legacy systems.
  • Highly proficient in Teradata RDBMS, Teradata DBMS environment setup, using FASTLOAD, MULTILOAD, and Teradata SQL, Developing and production of DBA support and BTEQ Teradata utilities.
  • Knowledge in developing Stored Procedures, Functions, Views and Triggers, complex SQL queries using Oracle PL/SQL, SQL Server and TSQL.
  • Good knowledge in Views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
  • Good understanding in Data warehouse concepts especially in ETL and SDLC Life Cycle including requirement gathering, development, testing, Quality Analysis, debugging, deployment, documentation, production support.
  • Expert in identifying and resolving the performance bottlenecks in sources, Targets, Mappings and Sessions.
  • Experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
  • Used Power Center for Data integration and migration from various source systems to Salesforce.com.
  • Experienced using Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
  • Expert in performance tuning SQL Statements, databases and schemas.
  • Experience in Data Cleansing, Slowly Changing Dimensions.
  • Expertise in Informatica MDM and IDQ.
  • Expertise developing PDOs, LDOs, Reference tables, profiles and Scorecards using the IDQ tools.
  • Usage of Informatica Mapping variables and session variables.
  • Strong experience in UNIX Shell Scripting and Test Plans to ensure the successful execution of data loading process.
  • Knowledge of Oracle BI tool Insight and Seibel/Intouch.
  • Ability to adapt to different working environments having been exposed to a range of businesses each with its unique culture and client base.
  • Oracle PL/SQL Developer Certified Associate.
  • Oracle Database SQL Certified Expert.
  • Excellent Time management, Interpersonal and Communication skills with self-motivation initiative.
  • Good Analytical, problem solving skills, and quickly adopt latest technologies concepts and ideas.
  • Ability to work in a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1/7 x, Informatica Power Mart, Informatica Power Exchange.

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS Access,, Teradata, DB2

Data Modelling Tools: Dimensional Data Modelling, Star Schema Modelling, Snow Flake Modelling, Fact and Dimensions tables, Physical/Logical Data.

Designing Tools: Erwin, Visio, Power Designer

Scheduling Tools: Control - M, Autosys

Reporting Tools: Cognos Power Play Transformer, Business Objects Designer

Languages: C, C++, SQL, PL/SQL, XML, PERL, Unix Shell Scripting.

Operating Systems: Windows XP/7/8, Linux, Unix, Sun Solaris 7.

CRM Tools: Salesforce

Other Utilities: TOAD, BTEQ, FASTLOAD, MULTILOAD.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Sr. Informatica Developer

Responsibilities:

  • Involved in gathering business requirements, analysis, development, testing, and production support of client application.
  • Involved in discussions with business analysts for gathering requirements, understanding the requirements and explanation of technical probabilities and Application flow.
  • Collaborated with other teams to gain knowledge on the internal data flow.
  • Involved in developing Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows.
  • Involved in developing end -to- end ETL process for Trade Management Data Mart using Informatica.
  • Flexible and intuitive interface for accessing and validating data across many different databases and platforms.
  • Experienced using Simple Application Retirement Validation to differentiate data in archive against retired applications and perform full table or row or column validations.
  • Experienced in creating complex mappings efficiently for full target tables in Power Center Designer using Unconnected and Connected Look up, Update Strategy, Router and Union etc.
  • Involved in Extracting, Scrubbing, and Transforming data from various sources like Oracle, Sybase, SQL Server, DB2, Teradata, and Flatfiles and load the data into Oracle database using Informatica.
  • Experienced working with session partitions types such as Pass-Through, Keyrange, Hash-Auto keys and dynamic partitioning.
  • Worked on Using Debugger to validate the mappings and gained troubleshooting information about data and error conditions.
  • Experienced in importing the source from Legacy systems and Operational systems by using Informatica Power Exchange by applying the concept of Changed Data Capture (CDC).
  • Created re-usable transformations and Mapplets to standardize Business Logic.
  • Experienced in working on Identifying Facts and Dimensions and other dimensional modelling techniques like FASTLOAD, MULTILOAD AND FastExport used in Data warehousing projects.
  • Experienced in Performance Tuning by identifying bottlenecks at Sources, Targets, Mappings, and Sessions to provide efficiency and performance.
  • Involved in performance/ query tuning. Generation/ interpretation of explain plans and tuning SQL to improve performance.
  • Created complex mappings to load data using various transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filter, Sequence, Router, and Update Strategy.
  • Experienced in designing reusable transformations and Mapplets and use them in complex mappings.
  • Experienced Worked on BTEQ script to provide batch to import and export data and generate reports.
  • Experienced in designing conceptual, logical and physical Model based on normalization standards (Second Normal Form, Third Normal Form).
  • Worked with Data Modelers assisting in database design and successfully brought database to 2nd Normal Form.
  • Involved in Data Modeling, E/R diagrams, normalization and de-normalization as per business requirements.
  • Worked on Session Parameters and Mapping Parameters and variables.
  • Experience in using Deployment Groups to promote code from one environment to other and also prepared documentation describing the use of deployment groups.
  • Experience in testing developed application including Unit Testing, Regression Testing, Integration Testing and User Testing.
  • Involved in creating test plans, test cases to unit test Informatica mappings, sessions, and workflows.
  • Extensively worked with performance tuning of Oracle.
  • Used ANALYZE, DBMS Stats, explain plan, SQL trace, SQL hints and Tkprof to tune SQL queries.
  • Experienced in writing UNIX Shell Scripts for Informatica Pre-Session, Post-Session and to run the workflows.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Teradata, Oracle 11g SQL developer, SSIS, Mainframe DB2, PL/SQL, Flatfiles, TOAD, BTEQ, UNIX Shell, MS SQL Server, Sybase Adaptive Enterprise, XML Editor, Rational Clear quest, Attachmate Reflection 14.03, Reflection FTP client, Notepad++ 6.5.2.

Confidential, Columbus, Ohio

Sr. Informatica Developer

Responsibilities:

  • Involved in creating Mappings for initial load of Power Center Designer using different transformations like Expression, Router and Source Qualifier.
  • Experienced in working on Source Analyzer, Mapping and Mapplet Designer, Target Designer, Workflow Manager, and Workflow Monitor.
  • Worked on extracting the data from various sources like Flat files, XML files, Excel files, Oracle databases and populated into Teradata database.
  • Experienced in working with slowly changing dimension Type1 and Type2.
  • Extensively used windows Scripting and Scheduled pmcmd to communicate with Informatica Server via command mode.
  • Developed and Design ODC to Data Mart Mappings, Sessions, Workflows.
  • Validate data in warehouse and run SQL queries using TOAD.
  • Experienced in working with Informatica Data Quality (IDQ) to measure data quality, data cleansing and exception handling.
  • Worked on Teradata Utilities like Fast Export, Fast Load, and Multi Load to load the data from various sources like Flatfiles.
  • Worked on Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
  • Wrote Stored Procedures, Functions and Packages and used in different Forms and Reports.
  • Experienced in working with Informatica Debugger, Session logs and Performance Logs for error handling.
  • Used Salesforce as the data source to migrate data in to the BI environment.
  • Experienced using Notepad++ to edit the code in different ways.
  • Used Parameters in Pre-SQL, Post-SQL, Source Filter, Target-schema, Source-schema, source table name, target table name, SQL override etc.
  • Used WLM to automate the workflows in job-sets.
  • Worked on Sybase Adaptive server Enterprise.
  • Used File Zilla to look up files and navigate through the UNIX environment.
  • Created Shell scripts and parameter files using UNIX.

Environment: Informatica Power Center 9.1/8.6, Informatica IDQ/IDE, Informatica Metadata Manager, Teradata, Oracle 10g, SQL SERVER 2008, MS-Access, File-Zilla 3.7.3, Putty, Unix Shell Scripting, XML Editor, Rational Clear quest, Attachmate Reflection 14.03, Reflection FTP client, Notepad++ 6.5.2, Seibel/Intouch, Sybase Adaptive Server Enterprise, Window 7, SQL, PL/SQL,MS Visio.

Confidential, San Diego, California

ETL/Informatica Developer

Responsibilities:

  • Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
  • Worked with Re-useable Transformations, Mapplets and Aggregate Functions like Avg, Min, Max, First, last in Aggregator Transformation.
  • Experienced working with both Connected and Un-Connected Lookup.
  • Identify the bottlenecks and fix them with Performance Tuning.
  • Follow the client security policies and necessary approvals to move the code from one environment to other.
  • Used SQL Override function in Source Qualifier Transformation.
  • Extensively used PL/SQL programming Functions, Procedures packages to execute business rules.
  • Worked on Unit Testing of Mapping and Workflows.
  • Experienced working on extracting data from different sources like SQL Server, Oracle, MS Access, Flatfiles and Teradata.
  • Implemented different Loads like Daily, Weekly and Quarterly loads using Incremental Load Strategy
  • Experienced Using Mercury to log tickets about issues encountered, used the same to note the progress.
  • Verify data availability using oracle insight. worked on Standard and Custom Model in Informatica MM (Meta Data Management)

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, IDE, IDQ), SQL Server, Oracle 10g, Oracle Insight, TOAD, Mercury Data control, Lotus Notes, UNIX, Flatfiles.

Confidential, Phoenix Arizona

Informatica Developer

Responsibilities:

  • Worked on Dimensional modeling to design and develop STAR Schemas, Identify Fact and dimensional tables, and also used ERWIN.
  • Worked with source databases like Oracle, SQL Server, and Flat Files.
  • Created complex mappings using Connected and Unconnected Transformations.
  • Worked with various Active Transformations like Filter, Sorter, Aggregator, Router, and Joiner transformations.
  • Experienced working with passive Transformations like Expression, Lookup, Sequence Generator, Mapplet Input, and Mapplet Output transformations.
  • Implemented Slowly Changing Dimension Type 1 and Type 2 for change data capture.
  • Experience in working with various look up cache like Dynamic cache, Static Cache, Persistent Cache, Re cache from Database and shared Cache.
  • Extensive experience in Informatica Power center objects like Mappings, Transformations, Mapplet, Workflows and Session Tasks.
  • Involved in Performance Tuning of ETL process at Source level, Target level, Mapping level and Session level.
  • Worked with Update Strategy Transformation for implementing INSERT and UPDATE.
  • Experience in using Debugger to test the logic implemented in mappings.
  • Experience in performing error handling using session logs.
  • Involved in defining, developing, and testing of processes necessary to extract the data from client’s operational databases, transform, cleanse data and load it into data marts.
  • As per business requirements, we implemented Auditing and Balancing on the Transactional Sources so that every each record is either captured in the maintenance tables or wrote to target tables.
  • Experienced creating the reports using Business Objects functionality like Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail.
  • Responsible for sending audit table and EOD Snapshot of daily entry to distributed list to analyze if anything is unusual.

Environment: Informatica power center 7.3, Oracle 10g, SQL, PL/SQL, Business Objects 6.5 (Designer, Reporter), Sun Solaris, Query Analyzer, Cognos and windows XP.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

  • Developed complex mappings using transformations like Lookups connected and Unconnected, Rank, Sorter, Joiner, Aggregator, Filter, Router to transform the data as per the target requirements.
  • Worked on Informatica Designer and workflow manager. Design and developed various mappings in mapping designer and session and workflows in workflow manager to extract the data from sources and load it into oracle databases.
  • Extensive experience in working with various transformations like source qualifier, expression, rank, aggregator, lookup, stored procedure and update strategy.
  • Involved in creating and running preexisting and debug sessions in the debugger to observe and test the sessions prior to the normal run in workflow manager.
  • Experience in using workflow monitor to monitor tasks, workflows, and performances.
  • Tune mappings to enhance performance and efficiency.
  • Involved in creating reusable transformations and Mapplets objects.
  • Experience in developing shell scripts for running batch jobs and scheduling them.
  • Worked on creating test plans, test cases to unit test mappings, sessions and workflows.

Environment: Informatica Power center 8.1, Oracle 10g, Netezza Database, Tidal, SQL Server, MS Access, Flat files, UNIX, ERWIN, Toad, MS Excel, XML Files.

Confidential

ETL/Informatica Developer

Responsibilities:

  • Used Informatica Power Center Tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
  • Experienced in creating different transformations like Router, Expression, Update Strategy, Sequence Generator, etc.
  • Reviewed requirements, business processes, and recommendations related to proposed solutions.
  • Tested stored procedures and functions and handled integrated testing of Informatica Sessions and Target Data.
  • Experienced in production support in resolving issues and bugs and fix them using Debugger.
  • Designed and developed Informatica Mappings and workflows to load the data into Oracle Databases, SQL Server
  • Experienced in creating and maintaining UNIX Shell Scripts for Pre Sessions and Post Sessions.
  • Used System Procedures to verify data consistency with adherence to defined Data Models.
  • Backup and restoration of Repositories.

Environment: Informatica Power Center 8.0, Oracle, SQL Server, MS Access, UNIX, SQL Plus, TOAD, Windows XP.

Confidential

Informatica Developer

Responsibilities:

  • Analyzed project requirements, design specifications, and change in to business solutions.
  • Developed extraction, transformation and loading using Informatica Power Center 8.1
  • Extensively used ETL to load the data from Flatfiles which involved both fixed width and delimited.
  • Used ETL to load the data from Relational Databases like Oracle.
  • Experienced in developing different transformations like Source Qualifier, Filter, Expression, Update Strategy, joiner and Lookup.
  • Involved in analyzing session and error logs for troubleshooting sessions and mappings.
  • Used Update Strategy DD INSERT, DD UPDATE to insert and update the data for implementing the Slowly Changing Dimension Logic.
  • Designed and developed many ETL Scripts using Informatica, UNIX Shell Scripts.

Environment: Informatica Power Center 7X, ETL, Flatfiles, Oracle, SQL Server, UNIX, PL/SQL, Shell Scripting.

We'd love your feedback!