SUMMARY:

• Senior ETL Developer with extensive experience in all phases of development life cycle across multiple domains, including banking, insurance and healthcare.
• Three years of experience performing business analysis duties under a PMO from a developer perspective, which includes analyzing data, gathering requirements, forecasting the deliverables and translating requirements to technical personnel.
• Develop Informatica mappings from source to target loading by using Informatica Power center tools.
• Tuned Informatica mappings to improve the execution time by applying suitable partitioning mechanisms and tuning individual transformations inside the mapping.
• Utilize Informatica B2B Data Transformation to extract the source data which was in unstructured format to transform into the desired business rule format.
• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical Specification Documents for data warehouse and ETL processes.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1, 9.x/8.x, Informatica Power Exchange, IDQ

Data Modeling: Star Schema, Snowflake Schema, Dimension Data Modeling

Databases: Oracle11g/10g/9i, SQL Server 2008/2005/2000, IBM DB2, Teradata 13.1/V2R5, V2R6,MS Access

Scheduling Tools: Control - M, CA7 Scheduler, Autosys, and Informatica Scheduler

Reporting Tools: Crystal Reports, Business Objects XI R2/XI 3.3, OBIEE 11g R1 (11.1.5)

Programming: SQL, PL/SQL, Transact SQL, HTML, DHTML, XML, C, C++, Shell

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Southfield, MI

Sr. ETL Informatica Developer

Responsibilities:

• Create high level documents, Source-to-Target mapping document and detailed design level document for the entire ETL process.
• Maintain good understanding of business requirements, technical specifications, source repositories and physical data models for project activities.
• Extracted/loaded data from/into diverse source/target systems like Oracle, Sql Server, Salesforce, HL-7, EPIC, XML and Flat Files.
• Project involves usage of most of the 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.
• Perform extensive implementation of Incremental/Delta loads with the help of various concepts like mapping variable, mapping parameter and parameter table concept.
• Develop Informatica mappings for source to target loading from BODI to TP.
• Create ETL code in such a way to support implementation of full loads for the initial run and incremental/delta loads for next daily runs.
• Integrate various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, and XML Files.
• Develop mappings to load data into landing layer, staging layer and publish layer with extensive usage of SCD Type I and SCD Type II development concept.
• Develop SCD Type I and Type II with the help of MD5 hash function.
• Utilize Informatica B2B Data Transformation to extract the source data which was in unstructured format to transform into the desired business rule format.
• Work with advanced Informatica transformations like unstructured data transformation for parsing HL7 data file.
• Work in Informatica Data Quality to create a Mapplet for validating and cleansing address’s using Address Validator transformation.
• Created UNIX shell scripting to trigger the daily, monthly jobs, auditing entries with logic of Concurrent workflows.
• Created macro to generate the dynamic sql to generate the complex sql.
• Created Dynamic stored Proc to call in post sql based on the target tables.
• Export the Mapplet from IDQ into Informatica PowerCenter to use the Mapplet in various mappings for implementation of Address doctor.
• Developed data processors (streamers, parsers, serialized and transformers, etc.) to read mainframe and xml source data through Informatica B2B.
• Hands on experience working on profiling data using IDQ.
• Extract and load data directly into Salesforce objects using Informatica PowerCenter.
• Experience working with various session properties to extract data from Salesforce object using standard API, Bulk API.
• Create new and enhance the 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.
• Created reusable transformations, Mapplet and worklets using Transformation Developer, Mapplet Designer and Worklets Designer.
• Loaded data from Unstructured file format using unstructured data transformation into Oracle database.
• Tuned Informatica mappings to improve the execution time by applying suitable partitioning mechanisms and tuning individual transformations inside the mapping.
• Created complex PL/SQL scripts to compare the universal reports generated vs target data.
• Worked on the performance tuning of SQL, ETL and other processes to optimize session performance.

Technical Environment: Informatica Power Center 10.1, Teradata, Oracle 11g,DB2,BODI, Sql Server 2012, flat files, XML files, Informatica IDQ, B2B data transformation, Informatica ICloud, Informatica Address Doctor, Batch Scripting, Microstratergy

Sr. Informatica Developer/Data Specialist

Responsibilities:

• Worked with Business Analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Involved in creating Logical and Physical Data Models and creating Star Schema Models.
• Assisted in designing Star Schema to design dimension and fact tables.
• Involved in developing Star Schema Model for target database using ERWIN data modeling.
• Created Complex mappings using Unconnected and Connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different mappings.
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various Oracle Staging Tables.
• Used Sorter transformation and newly changed dynamic lookup.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Scheduled Informatica B2B Data Transformation by defining the timings rules based on the rule setup on the data profiles.
• Created events and tasks in the work flows using Workflow Manager.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created schema objects like Indexes, Views and Sequences.
• Provided daily production support for the scheduled job and provided the resolution related to failed jobs and fixed them.
• Created Stored Procedures, Functions and Indexes using Oracle.
• Worked on batch processing and file transfer protocols.
• Designed and developed sophisticated workflows and data transformations involving Informatica B2B components DX Data Exchange and DT Data Transformation.
• Performed performance tuning of workflows which were moving slow.
• Analyzed the enhancements coming from the individual client for application and implemented the same.
• Created technical documents.
• Developed mappings for policy and claims dimension tables.
• Worked with 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 the testing process.

Technical Environment: Informatica Power Center 9.1, DB2, Power Exchange, PL/SQL, Oracle 11g, SQL Server 2005/2000, Windows Server 2003, UNIX, Control-M, Toad

Senior ETL/BI Developer

Responsibilities:

• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical Specification Documents for data warehouse and ETL processes.
• Involved in design phase of logical and physical data model using Erwin 4.0.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, Update Strategy and Stored Procedure.
• Developed mappings to load Fact and Dimension Tables, SCD Type I and SCD Type II dimensions and incremental loading and unit tested the mappings.
• Prepared low level technical design document and participated in build/review of the BTEQ scripts, Fast Exports, Multi loads and Fast Load scripts.
• Reviewed Unit Test Plans and System Test cases.
• Created new and enhanced the existing stored procedure SQL used for semantic views and load procedures for materialized views.
• Created BTEQ scripts to extract data from EDW to the business reporting layer.
• Developed BTEQ scripts for validation and testing of the sessions, data integrity between source and target databases and for report generation.
• Loaded data from various data sources into Teradata production and development warehouse using BTEQ, Fast Export, multi load and Fast Load.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and controlling the systems.
• Addressed many performance issues on ETL jobs, semantic views, stored procedures, reporting and Ad-hoc SQL.
• Involved in creating different types of reports including OLAP, Drill Down and Summary in BO.
• Worked on the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Created reusable transformations, Mapplet and worklets using Transformation Developer, Mapplet Designer and Worklets Designer.
• Tuned Informatica mappings to improve the execution time by applying suitable partitioning mechanisms and tuning individual transformations inside the mapping.

Technical Environment: Informatica Power Center 9.1, Informatica Power Exchange, Oracle 10g, PL/SQL, SQL Server, DB2, Teradata 13.10, Clear Case, Erwin, Business Objects Info view, Windows, UNIX

Confidential, Cleveland, OH

Informatica ETL Prod Support Developer

Responsibilities:

• Designed, developed and documented the ETL (Extract, Transformation and Load) strategy to populate the Data Mart from the various source systems.
• Worked extensively with Informatica 8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in design and development of complex ETL mappings.
• Implemented partitioning and bulk loads for loading large volume of data.
• Based on the requirements, used various transformations like Source Qualifier, Normalize, Expression, Filter, Router, Update Strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplet, worklets and reusable transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Performance tuning by session partitions, dynamic cache memory and index cache.
• Developed Informatica SCD type-I, Type-II mappings.
• Extensively used almost all of the transformations of Informatica including Complex Lookups, Stored Procedures, Update Strategy, Mapplet and others.
• Implemented Update Strategies, Incremental Loads, Data Capture and Incremental Aggregation.
• Created Stored Procedures in PL/SQL.
• Created UNIX Shell Scripts to automate the process.
• Developed documentation for all the routines (mappings, sessions and workflows).
• Involved in scheduling the workflows through Autosys Job Scheduler using UNIX scripts.
• Played a key role in all the testing phases and responsible for production support as well.

Technical Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g, TOAD 10.1 for Oracle, DB2, Flat Files, PL/SQL, OBIEE 11g, ERWIN, Windows 2000, UNIX PERL scripting, Autosys

Informatica Developer

Responsibilities:

• Interacted with business analysts, data architects and application developers to develop a data model.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica PowerCenter 8.5.x tool.
• Created sessions, database connections and batches using Informatica Server Manager/Workflow Manager.
• Optimized mappings, sessions/tasks, source and target databases as part of the performance tuning.
• Designed ETL mappings and workflows using Power Center Designer and Workflow Manager.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Developed various mappings, Mapplet and transformations for data marts and data warehouse.
• Used Shell scripting to automate the loading process.
• Used VBA Macro excels to compare data to show proof of concept for unit testing.
• Used pipeline partitioning feature in the sessions to reduce the load time.
• Analyzed and created facts and dimension tables.
• Used Informatica features to implement Type I and II changes in slowly changing dimension tables.
• Used command line program pmcmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed processes to extract, transform and load data to the data mart.
• Performed impact analysis, remedial actions and documentation on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes.
• As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Technical Environment: Informatica Power Center 8.x, ETL, Oracle 9i, SQL Server2000, MS Access, SQL, PL/SQL, Windows NT