SUMMARY:

• Over 7+ years of successful professional experience in Data warehousing development with different domains.
• Excellent Knowledge of Data Warehousing concepts.
• Expertise and experience in the following areas - Analysis, ETL design, ETL Testing, ETL Performance tuning, DB Sql.
• Extensive experience in developing strategies for Extraction, Transformation and Loading (ETL)mechanism using Informatica Power Center in Windows and UNIX environment.
• Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experience using Different Databases such as Oracle, Teradata, DB2, MySQL, SAP, and SFDC.
• Experience in developing complex Mapplets, re-usable Tasks, re-usable mappings and Slowly Changing Dimensions technique ( Type I, II, III using Informatica Power Center).
• Used UNIX shell scripting, FTP, file management.
• Data modeling experience using Dimensional Data modelling, Star Schema & Snow Flake Schema, Fact & Dimension tables, Physical &logical data modeling.
• Good understanding of Business/Functional/technical requirements and compliance rules.
• Experience in work allocation, status tracking and Coordinating with teams to keep them focused on the deliverables.
• Extensively worked on databases including Oracle, Teradata, SQL Server, Sybase and DB2
• Experience in functional, performance, integration, regression testing, Verification and Validations.
• Develop test cases from requirements, execute, raise defects and coordinate with cross functional or off shore team and updating the defect status.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions and validations based on design specifications for unit testing, system testing.
• Excellent problem-solving skills and bug fixing with a strong technical background and good interpersonal skills.
• Good Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS), and Rational Unified Process (RUP) and OLAP, ETL tools.
• Experience working in Both Agile & Water Fall Methodologies & tracking tools.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, MDM, IDQ

Databases: Oracle, DB2, Teradata, MySQL, Sybase, SFDC.

Operating Systems: Windows, UNIX (Linux) and MS DOS.

Languages: SQL, PL/SQL, UNIX Shell

Other Tools: Toad, SQL *Plus, PL-SQL Developer, Sql Assistant, Putty, Winscp, Autosys.

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential, Chicago IL

Responsibilities:

• Interacted with the Business Analysts to understand the business & gather technical requirements.
• Interacted with Architect to understand the High-level Design.
• Helped in creation of mapping specs for better code processing.
• Abstracted relational and delimited text file to local environment and developed the code in Dev environment.
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities
• Checking the file formats for the source flat files using UNIX shell scripts thereby ensuring input file formats are same as specified.
• Designed IDQ mappings which is used as Mapplets in Power center
• Created Mapplet for error handling process to deal with null records.
• Involved in DevOps migration/automation processes for build and deploy systems.
• Developed code for landing environment and then for staging and finally developed Incremental load populate the target tables for atomic model.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Worked on PowerCenter real time edition to run the Real-time workflows.
• This normalized model was used as a staging area for the dimensional model which was Netezza based Data Warehouse.
• Worked on Aginity workbench to process all the relational objects of Netezza.
• Importing the IDQ Mapp let’s to Informatica and using them in the Informatica mappings.
• Data analysis and Datatype analysis was done on Aginity workbench for Netezza objects.
• Created mappings to load backload and clean data to Netezza staging environment.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Used truncate load to load Netezza tables.
• Created Netezza Sql scripts to test the table loaded correctly.
• Created Reusable sessions in Task Developer.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Used Informatica scheduler to run the workflows in Dev Environment.
• Worked on Informatica Power Center tool - Source Analyzer, Mapping Designer and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used SQL Developer to check if data is properly loaded into target systems by writing SQL Queries.
• Loading Flat File Data into Teradata tables using Unix Shell scripts.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used Debugger in troubleshooting the existing mapping.
• Developed stored procedures, functions, triggers and packages using PL/SQL.
• Performed Unit test and Integration test for the process created in Informatica and all the test cases were well documented for process improvements.
• Created test scripts and Unit test plan documents.
• Experience in Agile methodology and worked with offshore team.
• Created Deployment Document for Migration of code from Dev to Test and from Test to Production environment.
• Involved with testing team to test the code and Fix the code.

Environment: Informatica PowerCenter, IDQ, B2B DT studio, Teradata, Oracle, Cognos, SQL developer, Putty, Winscp, Unix shell scripting, PL/SQL, Netezza, Agile.

Environment: Informatica Power Center, Microsoft SQL Server, PL/SQL, Teradata, Agile, TFS, IDQ Cognos, Control-M, JIRA for work status tracking.

ETL Informatica Developer

Confidential, Jersey City, NJ

Responsibilities:

• Responsible for business analysis and requirements collection.
• Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
• Involved in Unit testing of the Reports, Forms and PL/SQL Stored procedures.
• Documented data conversion, integration, load and verification specifications.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Extensively used ETL to load data from wide range of sources such as flat files and Oracle 9i
• Used transformations like Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Java Transformation, Router and Sequence generator.
• Imported the IDQ address standardized mappings into Informatica Designer as a Mapplets.
• Involved in Development of the applications by using PL/SQL tools like cursors and exception handlers, Loops and records. SQL Queries.
• Developed, documented and executed unit test plans for the components.
• Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions.
• Created pre-session and post-session shell scripts and mail-notifications.
• Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
• Used TOAD to develop oracle PL/SQL Stored Procedures.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.
• Creating the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Excellent knowledge on Agile Methodology.
• Responsible for the data management and data cleansing activities using Informatica data quality(IDQ).
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.

Environment: Informatica Power Center, Agile, Oracle, Flat Files, SSRS, IDQ TOAD, Informatica Shell Scripts, UNIX, Windows XP

ETL Informatica Developer

Confidential, Charlotte NC

Responsibilities:

• Interacted with Business Analysts in order to gather the requirements.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL's for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Worked with Power Center Designer tools in developing mappings to extract and load the data from XML files into different Flat File formats.
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed and Developed mappings by using Lookup, Expression, Filter, Update Strategy, Aggregator, Router transformations to implement requirement logics while coding a Mapping.
• Developed Error handling & data quality checks in Informatica mappings.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.

Environment: Informatica Power Center, Oracle, Flat files, Shell Scripting, SSRS, Data Modeling, windows XP, MS office Suite.

ETL Developer

Confidential

Responsibilities:

• Interacted with Data modelers for the data modeling changes based on the requirement.
• Worked closely with Data architect to build dimensional Models.
• Designed ETL process from source system to final DataMart’s and created ETL documents in Visio to assign work to off shore team.
• Developed new mappings with reusable transformations and mapplets based on business requirements.
• Developed numerous Informatica mappings to loads stage, dimension and fact tables.
• Worked with Informatica admin team for the code deployment and version controlling.
• Coordinating with source system owners for day-to-day ETL progress monitoring.
• Worked on performance tuning of Informatica objects.
• Worked on shell scripts to handle flat files which include files from source system and transferring files to downstream systems.
• Understanding Business Requirements and Functional Specifications.
• Involved in Peer reviews of the Design document as well as code walkthrough.
• Involved in Reviewing of Checklists and Project Deliverables.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing router, Lookups, Expression, Aggregator, Update strategy and stored procedure transformation.
• Worked on Remedy tool to create Service Requests, Incidents for the changes in Database.

Environment: Informatica power center, Oracle, PL/SQL, Flat Files, Unix Shell Scripting, Data Modeling, windows XP, MS office Suite.