We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Richmond, VA

SUMMARY

  • 8 Plus Years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power Center 10.2/ 9.6.1/9.5.1 /8.6.1.
  • Strong expertise in Full Life Cycle development of Data Warehousing including requirements gathering, design, development, unit testing and documentation.
  • Expertise in working with databases Oracle 12c/11g/10g/9i, Teradata 15/14/13/12, SQL Server, DB2, My Sql, Sybase, SFDC, Flat Files and XML.
  • Experience in utilizing Teradata utilities like TPT, Fast Load, Multi Load, Fast Export and BTEQ scripts.
  • Solid Experience in Informatica and Teradata mix in DWH development.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.
  • Experience in working with Informatica Data Quality 9.5.1 (IDQ).
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Developed complex mappings using Informatica Power Center Transformations - Lookup Connected & Un Connected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Java, and Sequence Generator.
  • Expertise in implementing performance tuning techniques both ETL & Database level.
  • Experience in doing Unit testing & Documenting, working with QA for Integration testing also for UAT with Business Users.
  • Expertise in implementing ETL Standards & Code Development Procedures.
  • Extensive involvement writing UNIX shell scripts for automation.
  • Worked extensively with Change Data Capture (CDC) & Slowly Changing Dimensions Types (1 & 2).
  • Experience with Supporting Heavy Data warehouse applications using BMC & Service Now tools.
  • Experience in using different scheduling tools - Control-M, Auto Sys, Maestro/TWS & Cron Job.
  • Experience with Both Agile & Waterfall Methodology.
  • Self-Motivated and Ability to Drive Projects independently.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/ 9.6.1/9.5.1 /8.6.1.

Databases: Oracle 12c/11g/10g/9i, Teradata 15/14/13/12, DB2, SQL Server, MySQL, Sybase., SFDC

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, Erwin, Microsoft Visio, HOLAP, MOLAP, ROLAP.

Operating System: Windows, Unix, Linux

Reporting Tools: Cognos, Business Objects, Micro Strategy, Tableau

Languages: UNIX Shell Scripting, SQL, PL/SQL, T-SQL, Python.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Informatica Developer

Responsibilities:

  • Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and also load data into the Teradata using Teradata Utilities.
  • Involved in Requirement analysis in support of Data Warehousing efforts along with Business Analyst and working with the QA Team in Waterfall methodology.
  • Loaded data in to the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multi Load, and Fast Export and TPT.
  • Compliance to SDLC and SOX in all aspect of application development.
  • Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
  • Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations.
  • Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
  • Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
  • Writing scripts in Python for scheduling tasks.
  • Writing Teradata Macros and used various Teradata analytic functions.
  • Created detailed Technical specifications for Data Warehouse and ETL processes.
  • Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
  • Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
  • Successfully upgraded Informatica 9.6.1 and to 10.1 and responsible for validating objects in new version of Informatica.
  • Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
  • Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
  • Experience in using SVN as version control for migration.
  • Developed Schedules for daily and weekly batches using Maestro/TWS.
  • Managed enhancements and coordinated with every release with in Informatica objects.
  • Provided support for the production department in handling the data warehouse.

Environment: Informatica Power Center 10.2/ 9.6.1/9.5.1 , Oracle 12c/11g, DB2, Teradata 15/14, SFDC, Flat Files, Erwin 4.1.2, TWS, Sql Assistant, TOAD, Apex Explorer, UNIX, Windows, SVN.

Confidential, Plano, TX

Sr. Informatica/Teradata Developer

Responsibilities:

  • 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.
  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
  • Providing periodic update to customer on the coding, unit testing, release and act as Coordinator between development and business team.
  • Created mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
  • Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
  • Hands on experience in Informatica cloud in migrating data from Informatica cloud to Informatica Power Center.
  • Developed Schedules for daily and weekly batches using Maestro.
  • Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
  • Involved in production support when required.
  • Performed Proof of Concept forInformatica Data Quality (IDQ).
  • Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
  • Worked on loading Flat Files in to Data warehouse.

Environment: Informatica 9.6.1/9.5.1 , Informatica Data Quality 9.5.1 (IDQ), Teradata 14, DB2, Oracle, Flat Files, Maestro, Sql Assistant, UNIX, Windows.

Confidential, Amherst, NY

Sr. Informatica Developer

Responsibilities:

  • Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations
  • Developed Informatica mappings & tuning them for better performance
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Used most of the transformations such as the Source qualifier, Aggregators, Connected & Unconnected Lookups, Filters & Sequence Generator.
  • Provided 24 X 7 supports to all the applications.
  • Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Work with System/business analysis to eliminate various manual processes and permanent fix for various productions.
  • Created the reports for different regions and demands for future forecasting
  • Extracted data from various sources like relational databases Oracle, flat files.
  • Designed and created Fact tables and Dimensions
  • Scheduled and monitored automated daily, weekly, monthly jobs.
  • Optimized Query Performance, Session Performance and Reliability.
  • Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
  • Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
  • Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
  • Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.

Environment: InformaticaPower Center 9.1.1, Flat Files, Oracle 11g, Teradata 12/13, SQL, PL/SQL, TOAD, SQL Assistant, Windows XP, Unix, Perl, Maestro.

Confidential, Orlando, FL

ETL Developer

Responsibilities:

  • Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Worked on all phases of SDLC from requirement gathering, design, development, testing and support for production environment.
  • Extensively used Informatica Client tools like Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager andInformaticaWorkflow Monitor.
  • UsedTeradata utilities FASTLOAD, MULTILOAD, TPUMPto load data.
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Provided 24x7 supports for Production environment for Extraction, Loading and transformation of data by remote monitoring.
  • Created Sources, Targets in shared folder and developed re-usable transformations, mapplets and user defined function (UDF) to re-use these objects in mappings to save the development time.
  • Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
  • Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
  • Experience with high volume datasets from various sources like Oracle, Text Files and Teradata Tables and XML targets.
  • Used debugger extensively to identify the bottlenecks in the mappings.
  • Modified PL/SQL stored procedures for Informatica mappings.
  • Created Sessions and Workflows to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
  • Configured the session properties i.e. high value for commit intervals to increase the performance.
  • Involved in unit testing, Integration testing and User acceptance testing of the mappings.
  • Involved in Migrating the Informatica objects using Unix SVN from Dev to QA Repository.
  • Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
  • Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures usingInformaticasession logs.
  • Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Environment: Informatica Power Center 8.6.1/9.1.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 10g, SQL Server 2008, Erwin, UNIX, Windows 2000, TOAD

Confidential

ETL Developer

Responsibilities:

  • Extensively used ETL to load data from Flat Files, XML, and Oracle to oracle.
  • Project Analysis and documenting the requirements.
  • Involved in Designing of Data Modeling for the Data warehouse.
  • Involved in Requirement Gathering and Business Analysis.
  • Developed data Mappings between source systems and warehouse components using Mapping Designer.
  • Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
  • Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
  • Created, launched & scheduled sessions.
  • Involved in the Performance Tuning of Database and Informatica.
  • Improved performance by identifying and rectifying the performance bottle necks.
  • Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
  • Analyze, design, build, test and document complex data conversion and integration solutions
  • Performed Unit testing and maintained test logs and test cases for all the mapping
  • Work with business groups to develop and implement business rules to be used for ETL processes

Environment: Informatica Power Center 8.6.1/9.1.1 , Oracle 10g, UNIX, Windows, UNIX Shell Programming, PL/SQL, TOAD Quest Software

Confidential

ETL Informatica Developer

Responsibilities:

  • Used ETL to extract and load data from Oracle, Flat Files to Oracle DWH.
  • Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).
  • Created Various Complex Transformations such as Update Strategy, Look Up, Filter and Router Transformations.
  • Created basic and aggregate levels of Fact Table mapping and optimized them for incremental Extraction and Aggregation using Parameters and variables to pass values during workflow execution.
  • Created and Monitored Work Flows using Workflow Manager and Work Flow Monitor.
  • Involved in the development and implementation of the Enterprise Data Warehousing (EDW) process and Data Warehouse.
  • Created Workflows / Worklets and scheduled them using workflow manager.
  • Developed Mapping to load data in Slowly Changing Dimensions.
  • Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads).
  • Performed Unit testing and maintained test logs and test cases for all the mapping
  • Perform data validation tests using complex SQL statements.
  • Perform Tuning of Sessions and Mappings.

Environment: Informatica Power Center 8.6.1, Oracle 10 g, UNIX, Windows.

Hire Now