SUMMARY

• Extensive experience working wif Data Warehouses and Data Marts using Informatica Power Center 7.x, 8.x, 9.x, 10.x (Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• Responsible for interacting wif different Business Partners, Vendors & Customers to identify information needs and business requirements for reports.
• Knowledge in designing Dimensional models for Data Mart and Staging Database.
• Extensive noledge in designing functional and detailed design documents for data warehouse development.
• Experience in writing UNIX Shell scripts.
• Performance tuning of Oracle using SQLtrace, SQLplan, SQL hints, Oracle partitioning, indexes and join types.
• Working noledge of a variety of Relational DBMS products, wif experience in designing and programming for relational databases, including Netezza, SQL Server, DB2.
• Extensive experience in using various Informatica Designer tools like Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De - Normalization Concepts.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, XML, Stored procedure in Informatica Power Center.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling and Dimensional modeling techniques, Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Skilled in developing Test Plans, Creating and Executing Test Cases.
• Experience in working wif EDI files X12, 837, NCPDP format.
• Hands on mapping teh EDI X12 files as per teh HIPAA guidelines for various EDI Transactions.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experience in creating Reusable Transformations, User defined functions, Mappings, Sessions, Mapplets and Workletsto avoid redundancy.
• Worked wif various departments wifin teh agency and managed small level projects.
• Experience working as ETL analyst and created various test case scenarios for data quality purpose.Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Experience working Agilemethodology. .
• Performing code reviews of teh peers as per teh industry standards.
• Experience in developing information security policies in compliance wif NIST standards.
• Knowledge in teh development of strategic security plans and programs dat ensure remediation and audit control techniques address control deficiencies and meet identified goals of an organization.
• Reliable, responsible, hardworking and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2, 9.6.1/9.5.1/9.1/8.6. x/8.1.x, Informatica Power Exchange 9.5.1, Informatica developer 9.6.1, Informatica DT/B2B

Data Modeling: Star Schema, Snowflake Schema, Erwin 4.0, Dimension Data Modeling.

Databases: Oracle11g/10g/9i, SQL Server 2012/2008/2005 , Teradata.

Scheduling Tools: Informatica Scheduler, Tidal Enterprise Scheduler

Reporting Tools: Crystal Reports, Microstratergy, and Hyperion Essbase.

Programming: SQL, PL/SQL, Transact SQL, HTML, XML, Java, Shell, Perl, Batch

Operating Systems: Windows 7/XP/NT/2000, DOS, UNIX and LINUX

Other Tools: SQL*Plus, Toad, SQL Developer, Putty, MS-Office.

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

Senior ETL Informatica Developer

Environment: Informatica Powercenter 9.5.1/10.2, Oracle 11g, Sql Server 2012, fixed width & delimited flat files, XML files,NCPDP, HL-7 file, EDI Files, Perl Scripting, informatica IDQ

Responsibilities:

• Developed a process to extract, transform and load pharmacy NCPDP files. Created Informatica Work Flows to read teh different versions of NCPDP files and load them in different databases.
• Worked effectively on maintaining current Informatica workflows dat load EDI 835, 837 files in database.
• Worked on building enhancements dealing wif EDI 835, 837.
• Informatica B2B to read different modules of EDI system. Convert files from EDI into readable file format through Informatica.
• Extensively involved in understanding HIPAA validations, EDI systems, and facets systems.
• Exporting teh Mapplets from IDQ into Informatica Powercenter to use teh mapplet in various mappings for implementation of Address doctor.
• Hands on experience working on profiling data using IDQ.
• Extensive implementation of Incremental/Delta loads wif teh help of various concepts like mapping variable, mapping parameter and parameter table concept.
• Creating ETL Code in such a way to support implementation of full loads for teh initial run and incremental/delta loads for next daily runs.
• Developed a file process wif multiple error validations check, creating an error report wif detail error information. And if their are no errors loading teh files in teh target.
• Developed a file tracking process which will keep track of all teh files we loaded, wat time we loaded etc.…
• Used various sources as Informatica source like relational databases, flat files, XML etc... And used complex transformations to transform teh data according to business need and loaded them in various targets.
• Leaded a new market implementation from teh scratch. Worked wif teh business teams on defining teh layouts, providing them solution on how to define fields. Parsed teh file to make sure Infomatica reads it right. Loaded multiple files of same format in a single table and created separate views to avoid redundancy of work.
• Involved in migration of all teh workflows from Informatica Powercenter 9.5.1 to Informatica Powercenter 10.2. Made sure all teh connections and integration services are properly created.
• Monitored production jobs using proper alerting system.
• Worked wif various other tools to bolster my work like Enterprise Tidal Scheduler, Enterprise Jira, and Tortoise SVN.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Developed complex stored procedures for reconciliation of paid claims using multiple tables and complex joining conditions.
• Worked on creating secure views. Worked effectively on creating security roles dat will allow only teh right accounts to access tables and views.
• Worked parallel wif other team members to make sure of fast and swift development in an Agile environment.
• Effectively used all transformations including some advanced transformations like Java transformation, dynamic lookup.
• Worked closely wif BA’s and Manager to calculate teh level of effort dat would take for a project to build from scratch.
• Created Schema objects like Indexes, Views, Sequences, Stored Procedures and Constraints.
• Automating Informatica Jobs in Production using EnterPrise tidal scheduler.

Confidential, Grand Rapids, MI

ETL Informatica Developer

Environment: Informatica Powercenter 9.6.1, Oracle 11g, Sql Server 2012, fixed width & delimited flat files, XML files, HL-7 file, Unix Shell Scripting, Perl Scripting

Responsibilities:

• Worked wif Business analysts and teh DBA for requirements gathering, business analysis and designing of teh data mart for an application portal which is primary source for ETL feed in this project.
• Involved in creating Logical and Physical Data Models and creating models by defining integrity between tables.
• Working closely wif BA’s to draft teh requirement from source to target as per teh business requirements and creating standard documents for design, review and development.
• Involved in complex development wif agile timelines for business delivery.
• Created mappings involving concept of full/incremental loads, type 1 and type 2 loads.
• Developed interfaces to report teh data to/from DWH which involved development for constraint based loading, dimension and fact loads.
• Effectively used all teh standard transformations and advanced transformations like Java transformation, Address validator transformation, transaction control transformation, Sql transformation, and dynamic lookup transformation.
• Worked on Parsing and marking unstructured files wif HL-7 format and reading teh data through Informatica power center wif effectively using unstructured data transformation.
• Informatica B2B to read different modules of EDI system. Convert files from EDI into readable file format through Informatica.
• Extensively involved in understanding HIPAA validations, EDI systems, and facets systems.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files
• Created Mapplets/Worklets and used them in different Mappings/Workflows.
• Created command tasks to automate scripting, Decision task, File Watcher in teh workflows.
• Implementation of generic audit mappings to effectively use it wif each load.
• Developed perl script to call teh workflows in all teh environments rather TEMPthan manually triggering teh job.
• Experience working wif putty terminal to Create. Edit, Move parameter files/source files/lookup files and target files.
• Experience working on identifying bottleneck, performance tuning for better customer delivery.
• Data analysis/Code validation in production environment to ensure any future failures/anomalies.
• Creating Deployment group for Informatica code migration to higher environments.
• Created Schema objects like Indexes, Views, Sequences, Stored Procedures and Constraints
• Daily production supports for teh scheduled job and provide teh resolution related to failed job.
• Worked on batch processing and file transfer protocols using scripting techniques.
• Analyzed teh enhancements coming from teh individual Client for application and implemented teh same.
• Automating Informatica Jobs in Production using TWS.
• Resolving any defects, issues by tracking it in JIRA.
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into teh testing process.

Confidential, Mather CA

Sr. ETL Informatica Developer

Environment: Informatica Powercenter 9.6.1, Oracle 11g, Sql Server 2012, flat files, XML files, Informatica IDQ, B2B data transformation, Informatica ICloud, Informatica Address Doctor, Batch Scripting, Microstratergy.

Responsibilities:

• Good Understanding of business requirements, technical specifications, source repositories and physical data models for project activities.
• Experience in creating high level documents, Source to Target mapping document and detailed design level document for teh entire ETL process.
• Extracted/loaded data from/into diverse source/target systems like Oracle, Sql Server, Salesforce, HL-7, EPIC, XML and Flat Files.
• Project involved usage of most of teh transformations like Transaction Control, Active and Passive look up transformation, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Unstructured data transformation, SQL transformation and more.
• Extensive implementation of Incremental/Delta loads wif teh help of various concepts like mapping variable, mapping parameter and parameter table concept.
• Creating ETL Code in such a way to support implementation of full loads for teh initial run and incremental/delta loads for next daily runs
• Developed mappings to load data into landing layer, staging layer and publish layer wif extensive usage of SCD Type I and SCD Type II development concept.
• Experience development of SCD Type I and Type II wif teh help of MD5 hash function.
• Experience working wif B2B data transformation concept of Informatica.
• Experience working wif advanced Informatica transformation like unstructured data transformation for parsing HL7 data file.
• Experience working in Informatica Data Quality to create a mapplet for validating, cleansing address’s using Address Validator transformation.
• Exporting teh Mapplets from IDQ into Informatica Powercenter to use teh mapplet in various mappings for implementation of Address doctor.
• Hands on experience working on profiling data using IDQ.
• Experience working wif extracting and loading data directly into Salesforce objects using Informatica Powercenter.
• Experience working wif various session properties to extract data from Salesforce object using standard api and Bulk api.
• Creating new and enhancing teh existing stored procedure SQL used for semantic views and load procedures for materialized views
• Addressed many performance issues on ETL jobs, semantic views, stored procedures, Reporting and Ad-hoc SQL.
• Worked in teh Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Loaded data from Unstructured file format using unstructured data transformation into Oracle database.
• Tuned Informatica mappings to improve teh execution time by applying suitable Partitioning mechanisms and tuning individual transformations inside teh mapping.

Confidential, Chicago, IL

ETL Technical Onsite Lead

Environment: Informatica 9.5.1, Oracle 11g, Sql Server 2008, Power Exchange 9.5.1, flat files, Mainframe, Toad for Oracle 11, Harvest Version Control tool, Windows Server, UNIX, Perl Scripting and CA7 Scheduler

Responsibilities:

• Analyze teh business requirements and framing teh Business Logic for teh ETL Process and maintained teh ETL process using Informatica Power Center.
• Work extensively on various transformations like Normalizer, Expression, Union, Joiner, Filter, Aggregator, Router, Update Strategy, Lookup, Stored Procedure and Sequence Generator.
• Develop an ETL Informatica mappings in order to load data into staging area. Extracted data from Mainframe files, flat files, Sql Server and loaded into Oracle 11g target database.
• Create workflows and work lets for Informatica Mappings.
• Write Stored Procedures and Functions to do Data Transformations and integrate them wif Informatica programs and teh existing applications.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for teh validity of teh data from different data sources.
• Developed workflows for dimension loads, fact loads based on daily/monthly runs.
• Developed code to archive monthly data into history tables and effective use of teh history table to load teh data back into teh system for a particular past month.
• Developed Audit tables to keep teh track of ETL Metrics for each individual run.
• Experience working wif Audit Balance control concept to create teh parameter files dynamically for each workflow before its run.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions. Experience dealing wif partitioned tables and automating teh process of partition drop and create in oracle database.
• Involve in migrating teh ETL application from development environment to testing environment.
• Perform data validation in teh target tables using complex SQLs to make sure all teh modules are integrated correctly.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of teh transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Involve in performance tuning for better data migration process.
• Analyze Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Create UNIX shell scripts for Informatica pre/post session operations.
• Automated teh jobs using CA7 Scheduler.
• Worked on Direct Connect NDM process to transfer teh files between servers.
• Document and present teh production/support documents for teh components developed, when handing-over teh application to teh production support team.

Confidential

ETL Informatica developer

Environment: Informatica Power Center oracle 9i/10g, SQL Server 2008, Oracle, Toad 7.0, Flat files, SQL *Loader, PL/SQL, XML,, Unix Shell Scripts, DB2, Business Objects XI, O/S, UNIX.

Responsibilities:

• Designed and developed ETL process using InformaticaPower Center and involved in process of enhancing teh existing Informatica and PL/SQL code and bug fixing.
• Involved in implementing change management process while fixing teh existing code to enhance teh code or bug fixing
• Collection of data source information from all teh legacy systems and existing data stores and involved in Data Extraction from Oracle, Flat files using Informatica.
• Developed mappings using multiple sources, transformations and targets from different databases and flat files and worked extensively on Oracle database, SQL Server and flat files as data sources.
• Wrote UNIX shell scripts to work wif flat files, to define parameter files and to create pre and post session commands.
• Designed and developed complex mappings dat involved Slowly Changing Dimensions, Error handling, Business logic implementation
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL Override, Sorter, and Filter in teh Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in teh Joiner Transformation.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Installed and configured teh Informatica version in Unix/Sun Solaris for development, test and production environments which are compatible for smooth migrations and maintenance.
• Developed shell scripts dat automates teh process of deducing delimited flat files.
• Involved in teh Design, Development and Unit Test of teh ETL code as per teh requirements.
• Created technical specifications to create teh mappings according to teh business specifications given.
• Involved in Unit, Integration, system, and performance testing levels.