SUMMARY:

• 7+ Years of IT experience with hands on experience in ETL Development and Mainframe using Informatica PowerCenter 10.1.1/9.6.1/9.5.1/8.6.1/7.1, Power, Exchange 9.5.1/8.6, Data Warehousing, PL/SQL, Oracle, Teradata.
• Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 12c/11g/10g/9i, Teradata 14/13/12/V2R6, DB2 UDB and SQL Server 2012/2008/2000 databases.
• Hands on experience with Informatica administration and various upgrades.
• Experience of leading and managing mid - size team and coordination of Onsite-Offshore team.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center Client.
• Experience in Data Warehouse/Data Mart Development Life Cycle and worked on Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, Fact and Dimension tables.
• Experience writing and modifying ETL design documentation, test results documentation and standard operating procedures (SOP) documentation.
• Proven experience with writing and technical requirements analysis.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Knowledge of Software Testing and Quality Assurance.
• Excellent communication and writing skills and capable of working successfully both in teams and independently.
• Ability to self-manage time and task priorities to meet project timelines and identify potential project risks.
• Expertise in handling error, exception and performance issue in Informatica.
• Experience in Unix Shell Scripting for data manipulation and scheduling tasks.
• Hands on experience with third party scheduling tools like Autosys.
• Expertise in production support and handling production issues.
• Pleasant experience in first logic, normalization for database designs purpose.
• Provide support for problem resolution and service restoration.
• Coordinating the daily work between Onsite and Offshore.
• Coordinating the work and Mentoring the team for a timely/quality delivery of the deliverables.
• Communication with Business and other stakeholders on ongoing basis.
• Successful overseeing the entire system / application development life cycle to deliver complex, large-scale applications and systems per client requirements.
• Highly effective leveraging team relationships and programming languages to maximize performance across systems and applications.
• Excellent Analytical, Logical and Programming Skills.
• Capable to add values to the application with innovative ideas and creating tools to reduce the redundant manual efforts.
• Successful overseeing the entire system / application development life cycle to deliver complex, large-scale applications and systems per client requirements.
• Excellent team player with the strong interpersonal communication, analytical skills, ability to work on multiple tasks, Quick learner, meets the strict deadlines as well as fast-paced and demanding environment.

TECHNICAL SKILLS:

Key Skills: Informatica Power Center 10.1.1/9.6.1/9.5.1/8.6/8.1/7.1, Informatica Power Exchange 9.5.1/8.6

Data Warehouse: Multidimensional Model Design, Star Schema Developmen

Data Modeling: Star-Schema Modeling, Snowflake Modeling, MS Visio

Database: DB2, IMS DB, Oracle 12c/11g/10g/9i, MS SQL Server 2012/2008//2000, MS Access, Sybase, MySQL, Teradata 14/13/12/V2R6

Programming: C, C++, SQL, PL/SQL, HTML, JAVA, UNIX Scripting

Applications: MS Office, MS Project, FrontPage, Toad 9.2/8.6

Defect & Task Tracking: HP ALM (Quality Center), JIRA, Agile Central

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. ETL Informatica Developer

Responsibilities:

• Participated in business requirement walk through, design walk through and analysed Business requirements.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database.
• Involved in designing the process flow for extracting the data across various systems.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Extensively used ETL processes to load data from various source systems such as SQL Server, Teradata and Flat Files, XML files into target system SQL Server by applying business logic on transformation mapping for inserting and updating records when loaded
• Using the Power Exchange for Change Data capture option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables
• Worked with PowerCenter team to load data from external source systems to MDM hub.
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions.
• Used the database partitioning and Informatica partitioning for better performance when working with the huge data.
• ETL code was migrated to GFB servers as per the ETL standards of 9.6.1.
• Used CA7 scheduling tool for scheduling the Informatica workflows.
• Responsible to design, develop and unit test the mappings.
• Migration from DEV to QA using Repository Manager.
• Performed Unit and Integration Testing and validates results with Business Analyst and end users.

Environment: Informatica PowerCenter 9.6.1/9.5.1 (Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), MDM (Master Data Management), Oracle 11g, Toad, PL/SQL and SQL Server 2008, SQL, UNIX Shell Scripts

Confidential, New York, NY

Senior ETL/Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Developed naming convention document for various component of Informatica.
• Analyzed the systems, met with end users and business units to define the requirements.
• Conducted business requirements and source system analysis to arrive at optimal ETL designs.
• Develops new ETL applications from simple to moderately complex scope, works with basic applications systems design specifications; and utilizes Company standards, procedures, and techniques.
• Partnering with project managers and development resources to assist with design changes and design decisions.
• Used SQL developer to run the queries to verify the data with the existing GUI functionality.
• Involved in creation of test plan and test cases for testing the enhanced functionality of MBOX.
• Used Cron job to schedule the UNIX script and PL/SQL programs.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
• Build from the scratch and maintain PL/SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.
• Worked with creation of reports for decision support.
• Involved in analysis of the data in the development and test environment.
• Work with analog team to test the existing application.
• Involved in logging defects in JIRA and monitor the progress until it goes to UAT environment.
• Worked on prod support of real-time projects.
• Very strong in implementation of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Good skills in analyzing trend charts from score cards to analyze the threshold which is to be considered in further development
• Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Developed ETL code by the business logic defined in the Functional Design Document

Environment: Informatica PowerCenter 10.1.1, Oracle 12c, SQL Developer, TOAD, DB2 mainframe, Autosys, Visio, MS SQL Server 2012, Windows 7, JIRA, Harvest.

Confidential, Houston, TX

Senior ETL/Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Provided production support by running the jobs and fixing the bugs.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.
• Coordinated the Change Management process which involved driving the QA and production deployments.
• Involved in Information administration including creating inexperienced users and groups, backing up the repository and domain as well as handling various upgrades.
• Working on new projects to fulfill the business needs.
• Documented the scope of new development projects.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and provide solutions to the business users.
• Involved in providing the solutions for production support job failures at Tier-2 level.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.
• Provided 24X7 on call support which included monitoring morning and nightly jobs and emergency production fixes.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.5, DB2, Data Modeling, TOAD 9.2, Oracle,11g Unix, Mainframe, IMS DB, Oracle 11g, BTEQ, MS SQL Server7.0/2000, CDC.

Confidential, Bala Cynwyd, PA

Senior ETL/Informatica Developer

Responsibilities:

• A project of 5 months duration named NAV Dissemination Analysis implemented successfully. From the design to construction, Unit Testing, System Testing, UAT support, implementation and post implementation verification were performed by Arnab.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Provided effective guidance to offshore for performing Unit/ System Testing and UAT support.
• This was a short-term assignment. Two offshore members were working with me as I was responsible for all the deliverables.
• As UAT and business team are located at a different location, UK / Ireland, there was efficient coordination with UK / Ireland team as well as the technical team based in Pittsburgh, US to execute the project flawlessly.
• Production Support - Fixing and Resolving Production abends. After hours on call support.
• Root Cause analysis and preparing technical specifications for the required code changes.
• Technical/Functional Documentation
• Per-forming Peer Reviews
• Review of different SDLC phases of team members, tracking and monitoring of Project schedules
• Risk identification and planning
• Monitoring and reporting project and support metrics and service level agreements.

Environment: Informatica Power Center 9.1, Informatica Power Exchange 9.1, DB2, Oracle 11g Exadata, MySQL, TOAD 8.6, PL/SQL, MS Office, Unix, Linux, DB2, Crystal Reports, C, C++, Mainframe.

Confidential, Newport, CA

ETL/Informatica Developer

Responsibilities:

• Created business requirement and functional specification document.
• Requirement analysis, preparation of design documents, coding and Unit testing, and guiding team members during construction/delivery phase for FLEX and GIS application.
• Participating in requirement gathering and gap analysis.
• Estimation of distinct phases of the project.
• Involved in data mapping and table and schema analysis.
• Risk identification and planning
• Stage load process with extracting the data from the various sources.
• Smoothly handing the challenges for the formatting issues.
• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Delivery management with offshore coordination was a key role as an onsite team lead.
• Participating actively for the deployment and QA processes.
• Implementing projects, end to end testing, System testing and user acceptance testing.
• Review of different SDLC phases of team members, tracking and monitoring of Project schedules
• Involved in co-ordination and communication between the Offshore and Onsite team
• Participating as a key team member in planning and coordinating the testing of the products developed.
• Responsible for testing and sign off from various groups like Operations and Products.
• Implemented the plan for the rollover of this project to production.
• Managing the delivery
• Participate in Knowledge Management activities

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.6, DB2, Oracle 11g, Unix, Linux, Mainframe, Teradata 12, SYBASE, OBIEE 11g.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Extract the data from the application to staging area thru flat files and Tables.
• Upload the data from staging area into Destiny database
• Implemented Dashboards Analytics using Business objects Performance manager.
• Extract the data from the application to staging area thru flat files and Tables.
• Developed stored procedures for generic values instead of using the sequence generator transformations.
• Extensively used ETL to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.
• Extracted data from Oracle and SQL Server and load the data into target database.
• Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in creating the runbook and migration document (from Development to Production).
• Document the process for further maintenance and support.
• Worked on test cases and use cases creating Unit Test Plans & Unit Testing of Programs.
• Involved in the Software Development Life Cycle.
• Development & Modification/Bug Fixing of Programs
• Performing Peer Reviews
• Participate in Knowledge Management activities
• Monitoring and reporting project and support metrics and service level agreements.

Environment: Informatica Power Center 8.6/8.1/7.x/ DB2, Oracle 10g/9i/8i, Unix, Mainframe, MS Access, SQL/PL/SQL, UNIX, MySQL, Teradata V2R6.