SUMMARY:

• Having 12+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems in Data Warehouse/Data Mart Design, ODS, OLAP, BI Applications as a Database and ETL Developer for Telecom, HealthCare and Banking Sectors.
• Extensive work experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts Using Informatica Power Center 10.2, 9.6/9.1/8.6.1/8.1 (Repository Manager, Designer, Workflow Manager and Workflow Monitor) for Design, Development and Unit Testing.
• Involved in Informatica Performance tuning at source, target, mappings, sessions, and system levels and Experience in resolving on - going maintenance issues and bug fixes. Having good knowledge in (CDC) Change data capture using Power Exchange.
• Worked on Informatica B2B Data Transformation and used Parser, Serializer, Unstructured Data Transformation to intake/generate output of several formats for Healthcare Industry EDI X12 layouts 834, 837-I, 837-P and Banking Industry layouts.
• Parsed EDI 834 Enrollment File via PL/SQL programming language and Generated EDI 837-I and EDI 837-P File for Claim process.
• Proficient in Informatica administration work involves Informatica PowerCenter Object management and migration activities. Automate day to day Informatica components migration tasks. Automation of monitoring Informatica environments using UNIX Shell scripts.
• Extensive work experience in Oracle SQL, PL/SQL (procedures, functions, Triggers and Packages) and Unix Shell Scripting and Python Scripting.
• Expertise in working with relational databases such as Oracle 12c/11g/10g/9i, SQL Server 2008/2005 and Sybase Systems. Extensive knowledge on Oracle Database Architecture
• Experience in using Scheduling tools like Autosys, Mainframe JCL.
• Having strong experience in working with Facets Claims Processing systems. And worked on Facets Upgrade projects.
• Performed POC on IDQ transformations and knowledge on Address Validator (Address Doctor), Merge and consolidation, Labeler, Case Converter Transformations in IDQ.
• Hands on experience in Sagent Data Flow ETL for Data Integration from Various source systems into Data Warehouse System.
• Having good work exposure in Business Objects Reporting.
• Good Knowledge on Hadoop Cluster architecture and Hadoop Ecosystem. Having good knowledge on HIVE Partitioning and Bucketing options and performance concepts.
• Knowledge on AWS services like EC2, RDS, S3, REDSHIFT, etc.
• Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements. And Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling Teams.
• Managing schema objects like tables, Indexes, Views, materialized view, dblinks, Performs data purging and housekeeping activities. Have done Data Migration from CRS lower version to latest CRS version database.
• Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using JCL and AutoSys
• Support multiple Informatica environments, production and development, Support development teams with performance tuning and troubleshooting issues
• Review of Informatica ETL design, documents and working closely with development to ensure correct standards are followed
• Good team player with excellent communication skills and ability to help team gain knowledge.

TECHNICAL SKILLS:

Operating System: SUN SOLARIS, HP-UX, AIX, Windows 2008/2007/2000

ETL: Informatica 8.6.1, 9.1, 9.6.1, 10.2, Informatica B2B DT Studio, IDQ and Sagent ETL

Programing Languages: SQL, PLSQL, SHELL SCRIPTS, PYTHON

Database and Tools: Oracle 9i/10g/11g,12c, Sybase, SQL Server, Teradata, Hive, SQL Developer, Toad

Scheduling Tools: Autosys, Mainframe JCL

SCM Tools: JIRA, HP Quality Center, Bridge Clarify

Integration/Deployment Tools: BITBUCKET, GITHUB, ANSIBLE, UDEPLOY, JENKINS

Reporting Tool: Business Objects

Big Data Ecosystems: Hadoop, HDFS, Hive

Product: Facets (Trizetto Claims processing system) Healthcare Product for, Billing, Claim Processing.

WORK EXPERIENCE:

Confidential, Charlotte, NC

Informatica ETL Lead developer

Responsibilities:

• Understanding the Business Requirements. Discuss with Client and Business team for any clarifications. Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements
• Have done Design for ETL components and developed database objects.
• Following Agile SDLC process and 2 Weeks Sprint for every delivery.
• Designed and developed the Informatica Power Center mappings, workflow and tasks to load multiples Source Data into different tables in Data Warehouse Reporting System, Extract Files. Calling Informatica Workflow Using Informatica Web Service.
• Used IDQ Address Doctor Transformation to Validate and Load the Banking/Credit Card Customer data.
• Developed Python Scripts to process the Source input files, perform validation, record the event entry in Oracle DB and to process the FileStats, update status and archive Files.
• Developed shell scripts to run Informatica jobs using PMCMD command and Developed the shell scripts to Re-Start the Failed Autosys Jobs.
• Performed Unit testing for the code and produced the Unit test case document.
• Provide Support to SIT and UAT Testing. Fix the SIT Defects and Manage the Defects in JIRA.
• Deploying the Code to Higher Environments and Scheduling the Jobs through AutoSys Jobs.
• Manage All the Lower Environments, Sync the Informatica, Database Components and provide support for the SIT, UAT and Performance Testing.

Confidential, Charlotte, NC

ETL Lead Developer

Responsibilities:

• Understanding the Business Requirements. Discuss with Client and Business team for any clarifications. Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements
• Have done Design for ETL components and developed database objects.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Designed and developed the Informatica Power Center mappings, workflow and tasks to load multiples Source Data into different tables in Data Store, Extract Files.
• Used IDQ Address Doctor Transformation to Validate and Load the Home Branch Customer data.
• Parsed and generated EDI files using Informatica B2B Data transformations and generated EDI X12 Files for Partner Systems.
• Developed shell scripts to run Informatica job for each XML file using PMCMD.
• Have done the POC to capture the Change Data using Power Exchange in Oracle 11g Database.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Developed and tested Oracle PL/SQL Procedures, Functions, Triggers and Packages.
• Performed Unit testing for the code and produced the Unit test case document.
• Provide Support to SIT and UAT Testing. Fix the SIT Defects and Manage the Defects JIRA and HP ALM.
• Deploying the Code to Higher Environments and Scheduling the Jobs through AutoSys Jobs.
• Manage All the Lower Environments, Sync the Informatica, Database Components and provide support for the SIT, UAT and Performance Testing.
• Setup NDM (Network Data Mover), FTP (File Transfer Protocol) file transfer interface between partner systems
• Created ad-hoc reports based on the Customer requirements and operations Data Quality validation reports
• Executing and Monitoring the daily End of day Batch ETL process and resolve the issues if any and ensure data delivery to multiple interface systems

Confidential

Technical Lead, Informatica ETL Lead Developer

Responsibilities:

• Understanding the Business Requirements. Discuss with Client and Business team for any clarifications.
• Have worked on Multiple projects like Contract generations for Group and Individual members, Invoice modernization and Letter generation process.
• Have done Design for ETL components and developed database objects.
• Knowledge in SSIS ETL for Data Integration from Various source systems
• Created System Design Specification document for the complete process and Review with Client to get approval.
• Designed and developed the Informatica mappings, workflow and tasks to load multiples Source Data into different tables in Data Store, Extract Files.
• Developed complex mappings with XML’s as source, target and Messages over JMS queues.
• Having strong experience in working with Facets Claims Processing product systems. Worked on Facets product upgrade projects.
• Parsed and generated EDI files using Informatica B2B Data transformations
• Processed EDI 834 Enrollment files, 835 Validation and Load, Generated EDI 837-I, 837-P X12 files for HIPAA 4010 and 5010 standards.
• Used IDQ Address Doctor Transformation to Validate and Load the Subscriber Enrollment data into HealthCare System.
• Designed and developed data quality rules to evaluate and verify data transformations, Data Cleansing, Data Matching and error handling.
• Worked on POC for creating the Master data for Health Care data.
• Used Address Doctor Transformation to Validate and Load the Subscriber Enrollment data into HealthCare System.
• Source System Analysis and identify data anomalies, data cleansing opportunities (like identifying special character etc.).
• Used Address Doctor Transformation to Validate and Load the Subscriber Enrollment data into HealthCare System.
• Having good Knowledge in IDQ transformations.
• Analyzed and identified performance bottlenecks using session logs stats and have done performance tuning using Informatica partitions, lookups to handle huge data volume.
• Developed shell scripts to run Informatica job for each XML file using PMCMD command and if any error occurs while processing each XML, error details are send to given Email ID’s and continue to process the next XML file.
• Developed and tested Oracle PL/SQL Procedures, Functions, Triggers and Packages.
• Performed Unit testing for the code and produced the Unit test case document.
• Provide Support to SIT and UAT Testing. Fix the SIT Defects and Manage the Defects in HP ALM. Participate in DRB Calls to provide the Defects status updates.
• Deploying the Code to Higher Environments and Scheduling the Jobs through MainFrame JCL.
• Analyze the data, Generate the ad-hoc reports as per business team requests.
• Setup of Informatica Environment and its upgrade.
• Keep the Informatica service up and running for Dev., TEST and Production environments.
• Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
• In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.
• Coordinate with different administrative services like DBAs for the upkeep of the environment.
• Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
• Help projects in setting up the Informatica environment with us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices and Setup of Best Practices Standards.

Confidential

Senior ETL Developer

Responsibilities:

• Analysis, Design and Develop Informatica mappings, workflow and tasks for Telecom data.
• Interacting with different clients for Ericsson’s CRS product requirement and customization.
• Responsible for delivering many functionality enhancements projects to client.
• Load data into data stores which is used by AHR, CSHR and MINSAT applications and responsible to complete loading the data into DWH with in SLA.
• Designed and developed data quality rules to evaluate and verify data transformations, Data Cleansing, Data Matching and error handling.
• Performance Tuning on existing PL/SQL code for huge telecom data. Responsible for tuning the existing mappings so as to reduce the total data load run time.
• Support development teams with design, development, performance tuning and troubleshooting issues
• Provided support to Integration team for Data migration activity as part CRS upgrade projects, Documentation and handover.
• Enhanced the Business Objects Reports, migrate the code as part of upgrades and validate the report data
• Having knowledge on the Hive table partition and buckets
• Written Hive Queries for data analysis to meet the Business requirements.
• Having good knowledge on the Semi structured Hive Datatypes like MAP, ARRAY, STRUCT and
• UNION Types.
• Created shell scripts to process and load initial subscriber data from inbound system.
• Created System Design Specification document for the complete process. Involved in code review meetings with client and solved the defects.

Confidential

Senior ETL Informatica Developer

Responsibilities:

• Have done Design for ETL components and developed database objects.
• Created System Design Specification document for the complete process and Review with onsite Team.
• Designed and developed the Informatica mappings, workflow and tasks to load multiples Source Data into different tables in Data Store, Extract Files.
• Having strong experience in working with Facets Claims Processing product systems. Worked on Facets product upgrade projects.
• Developed complex mappings with XML’s as source, target and Messages over JMS queues.
• Parsed and generated EDI files using Informatica B2B Data transformations
• Processed 834 Enrollment files, 835-RA, 277-CA, Generated EDI 837-I, 837-P X12 files for HIPAA standards.
• Used IDQ Address Doctor Transformation to Validate and Load the Subscriber Enrollment data into HealthCare System.
• Analyzed and identified performance bottlenecks using session logs stats and have done performance tuning using Informatica partitions, lookups to handle huge data volume.
• Parsed EDI 834 File via PL/SQL programming language and Generated EDI 837 File for Claim process.
• Developed and tested Oracle PL/SQL Procedures, Functions, Triggers and Packages.
• Developed shell scripts to FTP the extracts, XML’s to destination server and send E-mail to users about the job status from Informatica job.
• Performed Unit testing for the code and produced the Unit test case document.
• Provided Support to SIT and UAT Testing. Fix the SIT Defects and Manage the Defects in HP ALM. Participate in DRB Calls to provide the Defects status updates.
• Co-ordinate with Onsite team and resolve the queries.

Confidential

Software Engineer/ETL Developer

Responsibilities:

• Developed Informatica mappings, sessions to load the data into ODS database and to generate the XML extract file.
• Used Oracle Materialized Views and Logs for retrieving (CDC) Change data from Oracle Database.
• Developed and tested Oracle PL/SQL procedures, functions and Packages
• Worked on Materialized View concepts for Data replication.
• Created the Shell Script to FTP the Inventory reports
• Performed testing for developed codes
• Used Bridge clarify tool to track the problem and incident tickets for Production Support activities.
• Participated in System Upgrade, Memory Upgrade and Oracle Database Maintenance Activities.