SUMMARY:

• 8 Plus Years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica Power Center 10.2/9.6.1/ 9.5.1/9.1.1 /8.6.1 from various database sources.
• ­Strong work experience in ETL life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Power Center, Designer, Workflow Manager and Workflow Monitor.
• Involved in informatica upgrade projects from one version to another version.
• Involved in understanding of Business Processes, identification of dimensions and Facts for OLAP applications.
• Strong knowledge of understanding Data Modeling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle, Teradata, MS SQL Server, DB2, Mainframe, My Sql and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions, Triggers and Complex SQL queries
• Used Informatica Power Exchange for SAP to pull data from SAP R/3 .
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Good working knowledge of various Informatica designer transformations like Source Qualifier, Dynamic and Worked Extensively on ETL process using SSIS package. Static Lookups, connected and Un Connected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation.
• Extensively used Teradata Utilities like Tpump, Fast - Load, Multi-Load, BTEQ and Fast-Export.
• Involved in Tuning Sql performance Tuning.
• Worked on Performance Tuning , identifying and resolving performance bottlenecks in Informatica.
• Experience in integrating Hadoop with Informatica Power Center also involved in moving Hadoop process to Informatica process. We have done the end to end development for the data the client needed.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using pmcmd .
• Extensively used Autosys, Control-M and Maestro for Job monitoring and scheduling along with Production on call support.
• Use the Data Masking transformation to change sensitive production data to realistic test data for non-production environments.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using Agile methodologies & Waterfall Methodologies.
• Excellent interpersonal and communication skills.

PRIMARY SKILLS

• Informatica Power Center - 8 Plus Years
• Databases - Teradata, Oracle, DB2, My Sql, Sql Server, Informix, Flat File, XML
• Unix/Linux
• Performance Tuning
• Production Support

TECHNICAL SKILLS:

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

RDBMS: Oracle 12c/11g/10g/9i, Teradata 15/14/12, DB2, SQL Server 2018/2015/2008/2007 , MySQL, Sybase

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, Erwin, E-R Modeling, Microsoft Visio.

QA Tools: Quality Center

Operating System: Windows, Unix, Linux, MS-DOS

Reporting Tools: Cognos, Dash Board Reporting, Business Objects, Tableau

Agile Tools: Rally, Jira

Languages: SQL, PL/SQL, Java, XML, UNIX Shell Scripting, Perl

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. ETL Informatica/ Teradata Developer

Responsibilities:

• Involved in requirements gathering, analysis, function/technical specifications, development, deploying and testing.
• Coded, tested, implemented and maintained medium to highly complex ETL mappings and Shell scripts to build and maintain automated ETL processes.
• Coded the Informatica jobs for long term reliability, and accuracy.
• Worked with the existing application support team to help identify root cause of issues during the workflow runs, after identifying the issues took corrective actions and implemented long-term prevention plans.
• Prepare/maintain documentation on all aspects of ETL processes to support knowledge transfer to other team members.
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, Data Masking, Union, Stored Procedure and sequence generator.
• Used Data Masking transformation to secure the confidential claims data.
• Very good knowledge and Hands on experience on Flat file processing and ability to develop data validation mappings during the flat file loads and automating the ETL Load processes.
• Ability to identify and implement the parallel processing capabilities in the workflow sessions and use those capabilities to reduce the Workflow load times.
• Hands on experience on Performance Tuning using Session Partition, Lookup Properties, and Session Properties.
• Converted Hive QL, Sqoop and Map Reduce in Hadoop process to Informatica.
• Extensive experience working with Big Data Edition to extracting the data from Hadoop systems
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle 10g, Flat files, SQL Server, DB2 and to load data into staging tables first and then into Teradata.
• Responsible for creating the Migration requests from Development to Stage and then after cross checking the migrated code in Stage for successful migration of all objects, the code is moved from Stage to Production.
• Designed and developed PL/SQL Procedures, Triggers and Packages for implementing business logic.
• Ability to write the Shell Scripts based on the project requirements.
• Used Teradata Utilities - BTEQ, M-LOAD, F-LOAD & TPT for faster loads in to stage & Base.
• Expertise is writing M-Load & F-load scripting.
• Involved in tuning Teradata BTEQs for recurring production failures.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations based on the design specifications.
• Trouble shooted and Performance tuned complex ETL mappings to reduce the session run time.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, DB2, XML, Flat Files, Teradata 15/14, Hadoop, Hive QL, Maestro, UNIX, Windows, Toad.

Confidential, Plantation, FL

ETL Informatica/Teradata Developer

Responsibilities:

• Worked closely with the Business analyst to understand the various source data
• Used Informatica Power Center for migrating data from various OLTP databases & Files to the DWH
• Worked with different sources like Oracle, flat files, XML files, My Sql, SFDC and loaded in to Teradata.
• Created various Informatica mappings and mapplets to load the DWH.
• The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation (SCD Type-2).
• Used Teradata Utilities - BTEQ, M-Load, F-Load, and T-Pump.
• Involved in Performance tuning of BTEQ & ETL Mappings.
• Used Debugger to identify the errors in the mappings and fix them.
• Implemented several different tasks (Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control ) in the workflow
• Involved in writing UNIX scripts and used them to automate the scheduling process
• Worked with Teradata View point for monitoring Workload management.
• Implemented slowly changing dimensions (Type I and Type II) for customer Dimension table loading.
• Created UNIX shell scripts to kick off Informatica workflow in batch mode.
• Invoked Informatica using “pmcmd” utility from the UNIX script.
• Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica Power Center 9.6.1, Oracle, Sql Server, Axiom, Teradata 15/14.0, Flat File, XML, UNIX shell scripting.

Confidential, Racine, Wisconsin

ETL Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data Warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from various source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Warehouse Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future code development.
• Designed and developed the logic for handling Slowly Changing Dimension Table Type 1/ Type 2.
• Design and Development of ETL Mappings using Joiner, Expression, Aggregator, XML, Rank, Mapplet, connected and unconnected stored procedures and Lookups.
• Extensively used SQL Overrides in Lookups, Source filter and Source Qualifiers.
• Data flow management into multiple targets using Routers was extensively done.
• Involved and Executed Stored Procedures to transform the Data and worked extensively with PL/SQL for various needs of the transformations while loading the data into Oracle Database.
• Converted MS SQL Server DTS Packages logic into Informatica Mappings.
• Created Mappings with shared objects/Reusable Transformations/Mapplet using Mapping/Mapplet Parameters/Variables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Configured workflows with Email Task, which would send mail with session log file for Failure of a sessions and for Target Failed Rows.
• Designing the ETLs and conducting review meets Involvement in implementation of BTEQ jobs.
• Wrote appropriate code in the conversions as per the Business Logic using BTEQ, Fast Exports, Multi loads and Fast Load scripts.
• Coding using BTEQ Sql of Teradata to move data from stage to base.
• Worked with UNIX shell scripts for job execution and automation. Scheduled Informatica workflows using Control M to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, System testing, Integrated testing and User Acceptance Testing to check whether the data was loading into target, which was extracted from different source systems as per the business requirements.
• Involved in jobs scheduling, monitoring and production support activities in a 24/7 environment.

Environment: Informatica Power Center 9.5.1/9.6.1 , Flat Files, Oracle 11g, Teradata 14.0, SQL Server, SQL Assistant, PL/SQL, TOAD, Self - CAT, Unix, Putty Control-m, SVN.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Design, Develop and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, Mapplets, transformations, re-usable transformations.
• Involved in loading the data from Source Tables to ODS (Operational Data Source) Tables using Transformation and Cleansing Logic using Informatica.
• Worked with Repository Manager for managing of repositories and folders.
• Used Informatica Power Exchange to implement changes or updates on Source systems.
• Created different source definitions to extract data from Flat Files and Relational Tables for Power Center.
• Based on the logic, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, Lookup, Aggregator and Joiner were used.
• Created mappings in designer to implement the type 2 slowly changing dimensions.
• Involved in performance tuning of mappings, transformations and sessions to optimize session performance.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created Materialized views for summary tables for better query performance.
• Creating Test Documents for Unit Test, Integration Test and UAT to check the data quality
• Created UNIX shell scripts for automation.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Performed Error checking and debugging.

Environment: Informatica Power Center 9.5.1, Oracle 11g, PL/SQL, Autosys, SQL server, TOAD, Windows, UNIX.

Confidential

ETL Developer

Responsibilities:

• Designed and implemented appropriate ETL mappings to extract and transform data from various source to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Installed and Configured the Informatica Client tools.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Creation of mappings, sessions, workflows.
• Creating the stored procedure for Encryption/decryption of secured data of the customer.
• Documented the Development Process & Support Items and being a good team player.

Environment: Informatica 9.5.1/9.1.1 , Oracle, Flat Files, Unix, Windows, Toad.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.1.
• Extensively used ETL to load data from Flat file, MS Excel, which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, Lookup, sequence generator, joiner, Stored Procedure.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica 9.1.1/8.6.1 , Oracle 10g, Flat Files, SQL Programming, Unix, Windows, MS Excel, SQL *Plus, Toad.