We provide IT Staff Augmentation Services!

Sr Informatica Developer Resume

3.00/5 (Submit Your Rating)

Pittsburgh, PA

SUMMARY

  • 8+ years of experience in Informatica Power center, Informatica MDM, IDQ, Data Warehousing in various domains like finance, Insurance and healthcare industries
  • Proficient in Development, Implementation and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center.
  • Worked extensively on ETL process using Informatica PowerCenter10.x/ 9.x/8.x
  • Extensively used ETL methodologies for supporting Data Extraction, Transformation and Loading process, in a corporate-wide-ETL solution using Informatica Power Center.
  • Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads.
  • Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in E-commerce software, Utility, Pharmaceutical,Health Care, Insurance, Financial and Manufacturing industries.
  • Experience in development and maintenance of SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexesand triggers.
  • Experienced in IDQ (9X, 9.5.1) handing LDO’s PDO’s & some of the transformation to cleanse and profile the incoming data by using Standardizer, Labeler, Parser, Address Validator Transformations.
  • Experience in using different versions of Oracle database like 11g/10g/9i/8i.
  • Excellent working knowledge of c shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
  • Experience in ETL development process using Informatica for Data Warehousing, Data migration and Production support.
  • Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse.
  • Experience in both Waterfall and AgileSDLC methodologies.
  • Experience with TOAD, SQL Developer database tools to query, test, modify, analyze data, create indexes, and compare data from different schemas.
  • Worked on Slowly Changing Dimensions (SCD's) Types -1, 2 and 3 to keep track of historical data.
  • Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data.
  • Proficiency in data warehousing techniques for data cleansing, surrogate key assignmentand Change data capture (CDC).
  • Experience in integration of various data sources like Oracle, DB2, Flat Files and XML Files into ODS and good knowledge onTeradata 12.0/13.0, SQL Server 2000/2005/2008 and MS Access 2003/2007.
  • Optimized the Solution using various performance-tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Indexes, partitioning, Materialized Views, Procedures and functions).
  • Extensively used Autosys and Tidal for scheduling the UNIX shell scripts and Informatica workflows.
  • Extensive knowledge in all areas of Project Life Cycle Development.

TECHNICAL SKILLS

Databases: Oracle 19c/11g/9i/11i/R12, DB2, MS SQL server,Teradata, MySQL

OLAP/Reporting Tools: SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS)

ETL Tools: Informatica PowerCenter 10.x/9.x/8.x, Informatica cloud, Informatica Power Exchange, Informatica Data Quality Suite 9.6, SQL Server Integration Services (SSIS)

SQL Server Tools: SQL server Management Studio

Other Tools: Microsoft Office, Visual Basic 6

Scheduling Tools: Tidal, Autosys, Active Batch, Windows Scheduler

Data Quality Tools: Informatica Analyst, Informatica Data Quality, Informatica Developer

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr Informatica Developer

Responsibilities:

  • Worked on requirements gathering, architecting the ETL lifecycle and creating design specifications, ETL design documents.
  • Responsible for Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
  • Schedule the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data.
  • Designed and developed transformation rules to generate consolidated (fact/summary) data using Informatica ETL tool.
  • Involved in creating queries and packages in the MDM HUB Console.
  • Involved in converting specifications to data mapping in an ETL Informatica Cloud environment.
  • Design, Development, Testing and Implementation of ETL processes using Informatica Cloud.
  • Convert specifications to programs and data mapping in an ETL Informatica Cloud environment.
  • Used various sources to pull data intoPower BI such as SQL Server, Oracle, SQL.
  • Involved in Informatica MDM hub configuration, IDQ cleanse function implementation, Hierarchy Configuration in MDM hub.
  • Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
  • Developed and maintained ETL mappings to extract the data from multiple source systems like Oracle, XML, SQL server and Flat files and loaded into Oracle.
  • Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
  • Design, Development, Testing and Implementation of ETL processes using Informatica Cloud.
  • Involved in design, implement and perform administration functions for Enterprise data integration environments including Informatica PowerCenter and Informatica Data Quality (IDQ)
  • Proficient in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
  • Proficient in designing and scheduling SSIS Packages for transferring data from multiple data sources to SQL server.
  • Prepared ETL Specifications and design documents to help develop mappings.
  • Worked on staging the data into worktables, cleanse, and load it further downstream into dimensions using Type 1 and Type 2 logic and fact tables which constitute the data warehouse.
  • Project based on Agile SDLC methodology with 2 weeks of software product release to the business users.
  • Take part in daily standup and scrum meetings to discuss the project lifecycle, progress and plan accordingly, which is the crux of Agile SDLC.
  • Provide post release/production support.

Environment: Informatica Power Center 10.2, Informatica cloud, IDQ, MDM Power exchange, Data stage, Oracle Database 11g, SQL server, Toad for Oracle, Autosys, Unix Shell scripts, Teradata.

Confidential, Austin, TX

Informatica Developer

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer.
  • Developed mapping parameters and variables to support SQL override.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 10.2, Informatica cloud, IDQ, MDM, Oracle Database 11g, SQL server, Toad for Oracle, Autosys, Active Batch, Unix Shell scripts, Teradata.

Confidential, Parsippany, NJ

ETL / Informatica Developer

Responsibilities:

  • Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Productively used Informatica tools - Informatica Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
  • Using the concept of Slowly Changing Dimensions, complex mappings were created. Involved implementation of Business logic and capturing the deleted rows in the source origination.
  • Worked extensively with the connected lookup transformations with the dynamic cache enabled.
  • Developed several reusable transformations and Mapplets, which were used in other mappings.
  • Transformed the data according to the requirement and loading into the data warehouse.
  • Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
  • Involved in requirement analysis, ETL design and development for extracting data from the source systems like sales force, Mainframe, DB2, Oracle, flat files and loading into Netezza.
  • Worked extensively on different complex mappings using transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer, joiner, Aggregator, Update strategy.
  • Experienced in optimizing the SQL queries to improve the performance.
  • Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas and ER modeling.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Transferred data from various data sources/business systems including DB2, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc.
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Analyzed Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.

Environment: Informatica Power 9.6 (Workflow Manager, Workflow Monitor, Mapplets), Oracle, Teradata, SQL.

Confidential, Santa Clara, CA

ETL Developer/Analyst

Responsibilities:

  • Involved in business analysis and technical design sessions with business and technical staff to develop
  • Requirements document and ETL specifications.
  • Involved in designing dimensional modeling and data modeling using Erwin tool.
  • Created high-level Technical Design Document and Unit Test Plans.
  • Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
  • Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
  • Responsible for creating workflows. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager
  • Prepared user requirement documentation for mapping and additional functionality.
  • Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle.
  • Analyzed the existing systems and made a Feasibility Study.
  • Analyzed current system and programs and prepared gap analysis documents
  • Experience in Performance tuning & Optimization of SQL statements using SQL trace
  • Involved in Unit, System integration, User Acceptance Testing of Mapping.
  • Supported the process steps under development, test and production environment

Environment: Informatica Power Center 8.1.4/7.1.4 , Oracle 10g/9i, TOAD, Business Objects 6.5/XIR2 UNIX, clear case.

We'd love your feedback!