Sr. Informatica Developer Resume
Richmond, VA
PROFESSIONAL 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 teh Teradata using Teradata Utilities.
- Involved in Requirement analysis in support of Data Warehousing efforts along with Business Analyst and working with teh QA Team in Waterfall methodology.
- Loaded data in to teh 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 teh performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
- Involved in Initial loads, Incremental loads and Daily loads to ensure dat teh data is loaded in teh 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 teh data into teh targets according to teh requirement.
- Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested teh 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 teh 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 teh production department in handling teh 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 teh 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 teh 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 teh transformations such as teh Source qualifier, Aggregators, Connected & Unconnected Lookups, Filters & Sequence Generator.
- Provided 24 X 7 supports to all teh 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 teh 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 teh performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
- Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned teh 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 teh development time.
- Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing teh deleted records in teh 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 teh bottlenecks in teh mappings.
- Modified PL/SQL stored procedures for Informatica mappings.
- Created Sessions and Workflows to load data from teh SQL server, flat file and Oracle sources dat exist on servers located at various locations all over teh country.
- Configured teh session properties me.e. high value for commit intervals to increase teh performance.
- Involved in unit testing, Integration testing and User acceptance testing of teh mappings.
- Involved in Migrating teh 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 teh 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 teh requirements.
- Involved in Designing of Data Modeling for teh 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 teh performance tuning of teh Informatica mappings and stored procedures and teh sequel queries inside teh source qualifier.
- Created, launched & scheduled sessions.
- Involved in teh Performance Tuning of Database and Informatica.
- Improved performance by identifying and rectifying teh 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 teh 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 teh 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 teh development and implementation of teh 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 teh 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.