SUMMARY

• Sr. Informatica Consultant wif 8 years of extensive experience in Information Technology which includes thorough domain knowledge of Banking, Healthcare, Insurance & Telecom Industry playing various key roles in Development and Data Analysis.
• To serve an organization which offers scope for self - improvement and enhancement of knowledge to strive for betterment of teh organization which provides me opportunities to reach and exhibit best of my abilities to grow wif teh job and to enlarge my sphere of activity.
• Strong experience in Information Technology wif a strong background in Database development and Data warehousing.
• Created Good experience in designing, Implementation of Data warehousing and Business Intelligence solutions using ETL tools like Informatica Power Center 10.4/10.2/9.6.5.1 , Informatica Developer (IDQ), Informatica Power Exchange 10.4/10.2/9.6.5.1 and Informatica Intelligent Cloud Services (IICS).
• Good understanding about design, architecture and implementation of Informatica mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un - connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure, Unstructured data transformation, Sql transformation and more.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Experience working wif Informatica IICS tool TEMPeffectively using it for Data Integration and Data Migration from multiple source systems in Azure Sql Data warehouse.
• Good Understanding about Azure Sql Dwh concepts relating to storage, distribution, DWU units, resource user groups, connection strings etc
• Experience in developing Transformations, Mapplets and Mappings in Informatica Designer and creating tasks using Workflow Manager to move data from multiple sources to target.
• Experience working wif Informatica Data Quality tool to TEMPeffectively use Address validator transformation for Address doctor implementation.
• Worked in different phases of teh projects involving Requirements Gathering and Analysis, Design, Development, Testing, Deployment and Support.
• Good Knowledge on Database architecture of OLTP and OLAP applications, Data Analysis.
• Worked wif wide variety of sources like Relational Databases, Flat Files, XML files, Mainframes, Salesforce Objects, Unstructured data files and Scheduling tools like CA7, Control-M and Informatica Scheduler.
• Experience working wif various Informatica concepts like partitioning, Performance tuning, identifying bottlenecks, deployment groups, Informatica scheduler and more.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout teh Software Development life cycle (SDLC).
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes), UNIX Shell scripting and Windows Batch scripting.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Experience working in Production Support, Support for Emergency fix and migrating fix from lower environment to higher environment as per teh policies.
• Very good exposure to Oracle 12c/11g/10g/9i, MS SQL Server 2012/2008/2005 .
• Excellent Verbal and Written Communication Skills. Has proven to be highly TEMPeffective in interfacing across business and technical groups.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.2/9.6.1/9.6.5.1 , Informatica PowerExchange 10.2/9.6.1/9.6.5.1 , Informatica Intelligent Cloud Services (IICS) R29, IDQ 9.6.1

Databases: Oracle 12c/11g/10g/9i, SQL Server 2012/2008/2005 , Azure Sql Data Warehouse, DB2, Teradata

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

Scheduling Tools: Informatica Scheduler, Control M.

Reporting Tools: MicroStrategy, and Tableau 9.

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, WINSCP, MS-Office.

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Park, NJ

Senior ETL Informatica Developer

Responsibilities:

• Requirement gathering, Business Analysis and documentation Functional, Technical, Integration Documents, low level and high-level design documents.
• Involved in Requirement analysis in support of Data Warehousing efforts and Data Lake Implementation.
• Extensively worked wif various Active transformations like Filter, Sorter, Aggregator, Router, SQL, Union and Joiner transformations.
• Extensively worked wif various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplets Output transformations.
• Worked on Migration from PowerCenter 9.6.5 to PowerCenter 10.2 version.
• Worked on moving teh data using Informatica BDE to teh data lake using big data concepts.
• Worked wif source databases like Oracle, SQL Server, Teradata and Flat Files.
• Extensively worked wif Teradata utilities BTEQ, F-Load, M-load & TPT to load data into warehouse.
• Work independently on teh data migration tasks, backup and restore teh database, data comparison between databases, schema comparison, executing teh migration scripts etc.
• Involved in Unit testing, Smoke test, Functional testing, user acceptance testing and system integration testing.
• Created test plan, test data and executed test plan for business approvals.
• Created complex mappings using Unconnected and Connected Lookup Transformations using different caches.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata
• Experience working wif Member, pharmacy, patient, provider, encounters and claim data
• Experience handling company standard EDI files like 835, 837, HL-7, NCPDP files.
• Experience working wif parsing for structured and unstructured files using Informatica PowerCenter.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked wif various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Worked on loading data into Hive and Impala system for data lake implementation.
• Designed solution to process file handling/movement, file archival, file validation, file processing and file error notification steps using Informatica.
• Worked extensively wif update strategy transformation for implementing inserts and updates.
• As per business we implemented Auditing and Balancing on teh transactional sources so dat every record read is either captured in teh maintenance tables or wrote to Target tables.
• Implemented Informatica push down optimization for utilizing teh data base resources for better performance.
• Extensively used teh tasks like email task to deliver teh generated reports to teh mailboxes and command tasks to write post session and pre-session commands.

Environment: InformaticaPowerCenter 10.2, InformaticaPowerExchange 10.2, Autosys, IICS R29, CDC, Oracle 12c, DB2, Sql Server 2014, Hive, Impala, Teradata v15, Toad, Netezza, Unix.

Confidential, Marlborough, MA

Sr. ETL Informatica Developer

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 halp 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 me and SCD Type II development concept.
• Experience development of SCD Type me and Type II wif teh halp 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.

Environment: Informatica PowerCenter 10.2, Informatica PowerExchange 10.2, IDQ 9.6.1, IICS R29, Oracle 12c/11g, Sql Server 2012, DB2, flat files, XML files, Informatica IDQ, B2B data transformation, Informatica ICloud, Informatica Address Doctor, Batch Scripting, MicroStrategy.

Confidential, Franklin, TN

ETL Technical Lead

Responsibilities:

• Analyze teh business requirements and framing teh Business Logic for teh ETL Process and maintained teh ETL process using Informatica Power Center.
• Use EPIC Clarity tables for reporting and analytics purpose.
• 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 TEMPeffective 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-me, 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.
• Document and present teh production/support documents for teh components developed, when handing-over teh application to teh production support team.

Environment: Informatica 9.5.1, Oracle 11g, Sql Server 2008, Power Exchange 9.5.1, flat files, Mainframe, Teradata, Toad for Oracle 11, Windows Server, UNIX, Perl Scripting

Confidential, Farmington Hills, MI

ETL Informatica developer

Responsibilities:

• Worked wif Business analysts and teh DBA for requirements gathering, business analysis and designing of teh 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.
• Worked on Informatica PowerCenter - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup.
• Created events and tasks in teh workflows using workflow manager.
• Developed Informatica mappings and tuned them for better performance wif PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views and Sequences.
• Daily production supports for teh scheduled job and provide teh resolution related to failed job and fixed them.
• Created Stored Procedures, Functions and Indexes Using Oracle.
• Worked on batch processing and file transfer protocols.
• Performance tuning of teh workflow which are taking time.
• Analyzed teh enhancements coming from teh individual Client for application and implemented teh same.
• Creation of technical documents.
• Developed mappings for policy, claims dimension tables.
• 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.

Environment: Informatica PowerCenter 9.1/8.6, PowerExchange, PL/SQL, Oracle 10g/9i, SQL Server 2008/2005, Windows Server 2003, UNIX, Tivoli Scheduler, Toad

Confidential, Fremont, CA

ETL developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica PowerCenter 9.1.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for teh module using Informatica Power Center 9.1.
• Conducted performance tuning to increase performance of teh mappings, sessions & workflows.
• Used PL/SQL wif Informatica PowerCenter 9.1 for Oracle 10g database.
• Developed mapping document indicating teh source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Resolved issues and bugs raised by QA team.
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable tasks like E-mail.
• Involved in Data modeling team for developing Star Schema.
• Developed application using UNIX operating system including scripting.

Environment: Informatica PowerCenter 9.1, Mainframes, Oracle 10g, SQL Server 2005, Unix, Toad 9.5, SQL*Plus, Windows XP.