SUMMARY:

• Over 8 years of IT experience in System design, development and maintenance.
• Experience in various stages of System Development Life Cycle(SDLC) and its approaches like Waterfall, Spiral, Agile, and Prototyping Model.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, also created Mappings and Workflow's for Claims in Healthcare Dept.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.
• Extensively worked on database applications using DB2, Oracle, SQL Server, T - SQL, PL/SQL, SQL*Loader.
• Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema.
• Experience working with various Heterogeneous Source Systems like Oracle … MS SQL Server 2008, XML, Flat files.
• Directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Extensively worked on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Strong experience in Slowly Changing Dimension Mappings of type I, II and III.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Primary keys, Sequence, Synonyms and Database Link.
• Expert in developing SQL, PL/SQL, Database Triggers, Exceptions, Packages, Stored Procedures and Functions.
• Experience in Performance Tuning techniques at various levels such as Source, Target, Mapping, and Session levels.
• Experience in SQL Performance Tuning using Explain Plan, Tkprof, Hints and Indexes.
• Exposure to Data Modeling, Reengineering and Logical & Physical database designs using Erwin.
• Used Autosys Scheduler in creating and scheduling the job's run timings.
• Effective communications skills (verbal and written) for both highly technical and non-technical audiences.
• Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.1.1/ 8.6.1/9.0.1/9.1.0/9.5/10.1.1, Informatica Analyst 9.6.1/9.1/8.6, Informatica Power exchange 9.1, Informatica DVO 9.5, Informatica Big Data Edition 9.6.1, Informatica MDM 10.1, SSIS.

Data Quality: IDQ 8.x/9.x/9.6.

Data Modeling Tools: Erwin 8.0, MS Visio

Programming Languages: SQL, Oracle PL/SQL, Java Script, Basic UNIX SHELL Scripting, HTML, Java

Management: Agile/Water fall model

Databases: Oracle 10/9i/8, MYSQL, MS SQL server, Netezza, Teradata, DB2, SOQL

BI Tools: Informatica Scheduler, Informatica Visio Data Stencil

Reporting Tools: Tableau,OBIEE,MS BI, COGNOS BI- Framework manager, Query studio, Report studio

Scheduler Tools: AutoSys, Tivoli work scheduler (TWS).

IDE’s & Utilities: Eclipse and JCreator

Web Dev Technologies: HTML, XML

Protocols: TCP/IP, HTTP and HTTPS

Web services: SOAP UI, Tomcat, Java, AWS.

Operating Systems: Linux, MacOS, WINDOWS 98/00/NT/XP

PROFESSIONAL EXPERIENCE:

Confidential - Maryland heights, MO

ETL Informatica Developer

Responsibilities:

• Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Involved in creating Logical and Physical design of data models using Visio.
• Actively involved in requirements gathering and complete life cycle of the project.
• Involved in Migration of Informatica 9.5 to Informatica 10.1
• Extensively worked on Informatica client tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Workflow Designer, Worklet Designer and Task Developer.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files etc. into the Staging table and then to the target database.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Developed new and maintaining existing Informatica mappings and workflows based on specifications.
• Created Mapplets, reusable transformations, Worklets and used them in different mappings, workflows.
• Used Source qualifier, Expression, Aggregator, Lookup, Router, Normalizer, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Performed trunk & Load process by using stored procedure transformation and load control table to stage the data.
• Worked on Slowly Changing Dimensions i.e. Type1 & Type2.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Developed PL/SQL scripts, stored procedures, Indexes, Constraints, partitions and triggers in Oracle.
• Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Created pass through session partitions to improve performance of reading source data.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Scheduled the entire process in Autosys.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
• Involved in designing and developing the reporting requirements by using Business Object Xi3.1, Business Objects Report Designer.

Environment: Informatica Power Center 10.1/9.5, Erwin, MS Visio, Oracle 11g/10g, SQL, PL/SQL, TOAD, MY SQL, SQL Server 2008, Mainframe, XML, Business Objects Xi 3.1, Autosys, UNIX Shell Scripting, MKS Integrity.

Confidential - Lincolnshire, IL

ETL Informatica Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.0.1.
• Interfaced with various members of the technical and business team to translate the business reporting and data maintenance requirements into functional ETL code.
• Involved in migrating of data from DB2 to Netezza, using Informatica 9.0.1
• Created Mappings to move ETL processes from various systems like DB2, Oracle, SQLServer to CBC's new Data Warehouse in Netezza.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables using Informatica Workflow Manager
• Worked with the DBA to modify SQL from DB2 to Netezza version for already existing code in DB2.
• Parsing high-level design specs to simple ETL coding and mapping standards.
• Extensively involved in data validation to ensure that the highest levels of data quality and data integrity are maintained.
• Experience with Informatica Admin Console.
• Created deployment groups to migrate code for one environment to another.
• Complete understanding of Pushdown Optimization Utility in Informatica.
• Used Informatica Partitioning to improve session performance.
• Used Aginity and WinSQL to run Queries, for testing and validation of data.
• Created mappings to write Infusion data, CPT HCPC codes etc to flat files for Care Centrix for reporting purposes.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, lookup, Rank, Joiner, Expression, Stored Procedure and Update Strategy to meet business logic in the mappings.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
• Used mapping parameters and variables.
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement.
• Migrated ETL code from Dev to QA and then from QA to Prod for new release cycles.
• Developed testing strategies and performed in-depth testing to ensure data quality.

Environment: Informatica Power Center 9.0.1, Oracle 11g/9i, DB2, PL/SQL, UNIX, Windows XP, Win SQL, Tidal.

Confidential - Dayton, OH

ETL Informatica developer

Responsibilities:

• Preparation of design document, development for loading data into the data warehouse.
• Designed, Developed and Deployed informatica mappings, workflows from Dev to testing and Production environments.
• Created New Staging tables in Staging DB to store data from client files (CMS, NY Medicaid Files etc.)
• Wrote Postgres SQL Queries to work with the data, being loaded from external client files into the Data Warehouse.
• Worked with Shell Scripts (UNIX).
• Worked with existing Python Scripts, and also made additions to the Python script to load data from CMS files to Staging Database and to ODS.
• Worked extensively on SQL Server 2008 and Postgres SQL.
• Worked extensively on Medicaid and Medicare and CMS files, and their corresponding file layouts.
• Prepared design, technical and functional documents from the business requirements gathered.
• Created Mappings to move data from Oracle, SQL Server to new Data Warehouse in Green Plum.
• Created different Transformations for loading the data into target like Source Qualifier,
• Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression,
• Router, Filter, Aggregator and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables using Informatica Workflow Manager
• Parsing high-level design specs to simple ETL coding and mapping standards.
• Involved in data validation to ensure that the highest levels of data quality and data integrity are maintained.
• Used Informatica Partitioning to improve session performance.
• Performed unit testing and Involved in tuning the Session and Workflows for better performance.
• Participated in status review team meetings.

Environment: Informatica 9.1, SQL Server Management Studio 2012, Idle Python GUI 2.5.4, PgAdmin3 (Postgres), PL/SQL, Windows XP, Unix.

Confidential

ETL Informatica developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power Center.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Creating source, target, lookups, transformation, session, batches and define schedules for those batches and sessions.
• Developed software to test the integrity of files by performing LINUX checksums on these files.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools.
• Scheduled the tasks using Autosys.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the legacy databases to SQL server.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Used Informatica Repository Manager to backup and migrate Repository in development, test and production systems.
• Administered & scheduled batches/sessions using server manager. Modify/Migrate the Informaticamappings (XML) from the Development to Test Server and Production server.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution

Environment : Informatica Power Centre 7.1, Oracle 9i, Win 2000 UNIX, Linux, Autosys, SSIS, XML.