SUMMARY

• Over 11 years’ Experience with Informatica 10.x/9.x/8.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Modeling.
• Strong working experience in planning and carrying out of Teradata system Extraction, Loading Processes, Data Warehousing, MPP and Large - Scale Database Management and Reengineering.
• Experience with Snowflake Multi-Cluster Warehouses, Clone and Time Travel.
• Experience in Healthcare Application Facets in different modules like Claims, Membership, Provider and Billing.
• In-depth knowledge of Snowflake Database, Schema, Table structures and Data Sharing in Snowflake.
• Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems into Data warehouse.
• Experience in Teradata SQL, Tools & Utilities (FastExport, MultiLoad, FastLoad, Tpump and BTEQ).
• Experienced in Agile Development process for diverse requirements.
• Proficient in planning, building, and managing successful large-scale Data Warehouse and decision support systems.
• Experience in Advanced SQL programming to support Healthcare Financial Analytics in Medicaid, Medicare and Commercial.
• Experience in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse.
• Experienced in file transfers, job scheduling and error handling.
• Experience in SharePoint, Confluence, JIRA and source code version control SVN environment.
• Proficient in tuning the performance of SQL queries and ETL process.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Languages: C/C++, C#.Net

ETL: Informatica 10.x/9.x/8.6x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Exchange, Data validation Option (DVO)), B2B DX/DT, IDQ, IICS

Databases: Teradata 15.x/14.x/13.x/12.0, Oracle 10g/9i/8i, DB2, MS-SQL Server 2000/2005/2008/2012 , Snowflake, MS-Access.

Web Technologies: ASP, ASP.net 1.1/2.0/3.0, HTML, Flash, Photoshop, CSS, VBScript and JavaScript, Ajax, IIS6.0/7.0.

Operating Systems: UNIX, Red Hat Linux, Windows NT/95/98/2000/XP/VISTA, DOS, Windows 2003 server

Scheduling Tools: TIDAL, WLM.

Subversion: SVN Tortoise, BitBucket

Reporting Tools: SQL Server Reporting Services

PROFESSIONAL EXPERIENCE

Confidential

Sr Solution Lead Advisor

Responsibilities:

• Acted as the lead, oversee multiple projects, Managed resource & capacity planning for projects and responsible for delegating work to the developers.
• Implemented agile development practices according to the application requirements.
• Worked with business analysts for requirement gathering, analysis, testing and project- coordination.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Maintain and extend existing (Informatica, Snowflake/Teradata, Tidal) data warehouse by developing business-centric solutions in a timely fashion.
• Designed and implemented ETL using Informatica Intelligent cloud services (IICS) to load data into Snowflake cloud database from different vendors.
• Designed and implemented Data Synchronization from Oracle 12c to Snowflake database in Informatica intelligent cloud services (IICS).
• Processed Medicaid, Medicare & Commercial claims and applied front end edits to the claims.
• Used Informatica Power Exchange for capturing change data (CDC) from FACETS.
• Effectively using IICS Data integration console to create mapping templates to bring data into staging layer from different source systems like SQL Server, Oracle, Teradata, Flat Files.
• Worked with Informatica Powercenter 10.2 Mapping Designer, Workflow Manager, Workflow Monitor.
• Worked on enhancements of Bteq scripts which validated the Performance tables in the Teradata environment.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Created mappings for various sources like SQL Server, Oracle, etc to load and integrate the instrument level details to ware house.
• Informatica Debugger is used to test the mappings and fixed bugs.
• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Worked with Tidal enterprise scheduler to run and test ETL jobs in Tidal Dev, Tidal QA, and Tidal Prod respectively.
• Developed complex Stored Procedures and views to generate various reports using SSRS.
• Involved in System testing and User Acceptance Testing.

Environment: Teradata 15.1, Informatica Power Center 10.2, Informatica Intelligent Cloud Services (IICS), Informatica Power Exchange 10.2, AWS, Informatica B2B Data Exchange and Data Transformation, Oracle 10g, Snow Flake, Windows Server 2003, SSRS, SQL*Plus, XML, PL/SQL Developer, TIDAL.

Confidential

ETL Lead Informatica Developer

Responsibilities:

• Worked with Business Analysts to understand the functionality of the source and target systems.
• Suggested and created common format tables for the ease of development.
• Data integration with SFDC and Snowflake using Informatica cloud IICS.
• Worked with data cleansing team in order to identify the data inconsistencies and abnormalities.
• Created Design Documents for source to target mappings.
• Injected data from S3-Raw Bucket and loaded into Snowflake by using Informatica Cloud IICS.
• Performed end to end development side testing in order to ensure the proper migration of data.
• Creating and consuming Web Services, such as XML/XSD and SOAP.
• Maintaining version control using Git.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Applied the rules and profiled the source and target table's data using IDQ.
• Involved in column profiling of the tables using Informatica Analyst Tool (IDQ).
• Manage IAM roles and console access for EC2, RDS and S3 services.

Environment: Informatica PowerCenter 10.2, Informatica Intelligent Cloud Services (IICS), Informatica Data Quality, AWS, SQL 2012, Snowflake, Salesforce, Github, MS Office.