SUMMARY:

• 9 + years of experience in a Sr. ETL Developer that includes Informatica Power Center in all phases of Analysis, Design, Development, Implementation and Production support of Data Warehousing applications using Informatica PowerCenter 9.x/8.x/7.x, IDQ, Informatica ETL Developer etc and also Software Quality Assurance inSFDC, Mobile and ETL Testing.
• Worked with Pre - Session and Post-Session UNIX scripts for automation of ETL jobs using scheduling tools like AutoSys & Control M and Involved in migration/conversion of ETL processes from development to production environment.
• SDLC: Have good experience in a Full life cycle of Software Development (SDLC) including Business Requirements Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance and Documentation
• Well versed with all types of testing and actively involved in all the phases of software development life cycle and held responsible positions in software testing and implementation process.
• Extensive ETL testing Experience using Informatica power center ETL Tool.
• Hands on experience working with the leading automation tools - HP Quick Test Professional (QTP), Selenium, Web Driver & Quality Center - ALM.Expertise Skill in Test Management and documentation like Test Plan, Test Cases, Detailed defect reports. Actively participated in Business requirements reviews, defect triage meetings, and sessions.
• Experienced in Test applications in languages including ETL and any suite of open-source products which provide data integration, Migrating data between applications or databases and Exporting data from databases to flat files.
• Ability to write and understand complex SQL queries.
• Good knowledge on EMR systems and working experience of industry standards such as HIPAA, HL7, Six Sigma and SOX, ICD-9, ICD-10 coding, EDI (835,837) transaction syntax like ANSI X12 and QNXT claims processing
• Strong SQL scripting / ETL testing skills, Web application testing experience. Highly experienced in testing the User Interface and backend modules of the applications in both web based and client server technologies and involved in all types of testing like business functionality testing, integration testing, end to end testing, compatibility testing, regression testing and also support real-time users during the UAT phase.
• Good knowledge and working experience in ETL and reporting tools like Informatica (10.X), SSIS, Tabelau, SSRS.
• Experience in Creating Roles, Profiles, Email Templates, Page Layouts, Workflows, Workflow Actions and Approval Process, Reports and Dashboards.
• Experienced in E-Commerce, Insurance,Health, and Financial domain Projects. Coordinated and transferred knowledge to the offshore team.
• Experience in creating detailed process documentation and deployment process on issues for Future Follow ups.
• Full implementation life cycle experience of many complex projects with Water Fall, Iterative and Agile (SCRUM). Organized UAT sessions and supported the UAT teams to perform the application
• Testing phases of projects, related to industries like Financial (Capital Market Banking, Trading and Wealth Management)
• Involved in supporting the real-time users during the User Acceptance Testing (UAT) phase and contributed in successfully delivering the application within the deadlines

TECHNICAL SKILLS:

Data Warehousing / ETL/Data Quality: Informatica Power Center, Informatica MDM, Informatica IDQ 10.x/9.x, Analyst, Metadata Manager,ERWIN, SSIS, Alteryx,Tableau Prep

Reporting Tools: Tableau- 10.x,2019.x,Power-BI 2.x, SSRS,OBIEE, Cognos

Databases: Oracle 12c/11g, PL/SQL, Teradata, SQL Server, Netezza,NoSQL,MysqlCloud - Azure and AWS, SnowFlake 3.x

Operating Systems: Windows 95/98/2000/2003/ NT/XP, Linux, UNIX

Programming: Perl, Shell, Python,C#, SQL, PL/SQLSQL Tools: SQL * Plus, SQL *Loader, SQL Navigator, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr ETL Consultant

Responsibilities:

• Good knowledge and working Experience with Informatica PowerCenter IDQ, Worked in testing for next hospital/site go lives. Other responsibilities include completion of assigned service now break fix tickets, optimization requests and end user .
• Responsible for documentation of build and maintenance requests specific to orders, procedures, Appointments using Crystal and Caboodle. Used EPIC Hyperspace for validating, importing and exporting repo data from development environment to testing environment.
• Worked on Data Migration testing from Oracle to AWS, validated the Table structure and Metadata.
• Wrote SQL queries to validate the business logic of the application in Power BI reports.
• Experience with design, develop, mapping and delivery of ETL process using Alteryx.
• Designing BI solutions with Microsoft SQL Server BI Visual Studio. Created SSIS packages using SQL Server Integration Services (SSIS) in order to automate the process of loading data into a database
• Involved in requirement gathering and performed ETL Process.
• Created Dimension Tables and Fact Tables based on the warehouse design. Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates Integrated various sources into the Staging area in Data warehouse to Integrate and for Cleansing data.
• Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema Created the Source and Target Definitions in SSIS.
• Converted and developed reports from Power BI to Tableau. While design the Power Bi reports and dashboards, the measures are created using DAX programming language. Converted all the calculations using DAX formulas.
• Lead the Tableau workbooks and data source release management to deploy from Dev to UAT to Prod environment.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Provided SQL Performance optimization for Caboodle ETL, OLAP SlicerDicer reporting clients in SQL Server and Oracle by analyzing the Execution plan, Statistics to find bottle neck in IO/Memory/Sort/Index scans, fixing recursive hash joins
• Analyzed data flow pipelines through the various Epic systems viz Health connects, Clarity, Caboodle and Slicer Dicer for implementing various custom business requirements and created new data flows
• Created Reusable Transformations to use in Multiple Mappings Developed and updated documentation of processes and system.Actively participated in enhancement meetings, project review meetings, Weekly status meetings and various other meetings which were focused on making the application more effective.

Confidential

Sr ETL Analyst

Responsibilities:

• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Handled with PHI/PII healthcare data & working with DBA to create Audit/Redaction policies, HIPPA rules on sensitive data tables.
• Involved in the installation and configuration of Informatica PowerCenter 10.1 and evaluated Partition concepts in Power Center 10.1. Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Worked on various Healthcare payers, including the Centers for Medicaid and Medicare Services (CMS), are banking on informed, engaged consumers to play an increasingly important role in driving down healthcare costs.
• Worked extensively in extracting data from QNXT claim processing systems.
• Designed data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
• Created stored procedures, views, user defined functions and common table expressions.
• Generated underlying data for the reports through SSIS exported cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse. Coordinated and Participated in Disaster Recovery of Data Quality and Informatica Data Integration HUB
• Assisted with migrating Autosys jobs into production and Monitor jobs to ensure successful execution.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in IDS Services like building Business logics, analyzing the structure and data quality, creating a single view of data etc.
• Assisted customers in troubleshooting issues with their applications in AutoSys and trained the teams to use WCC interface.
• Worked on Informatica cloud for creating source and target objects, developed source to target mappings.
• Involved in importing the existing Power center workflows as Informatica Cloud Service tasks by utilizing Informatica Cloud Integration. Involved in Data integration, monitoring, auditing using Informatica Cloud Designer.Worked on Data Synchronization and Data Replication in Informatica cloud and informatica MDM
• Wrote PL/SQL scripts, created stored procedures and functions and debugged them.Created Mapp lets, reusable transformations and used them in different mappings. Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads and Developed reports based on issues related to the data warehouse.
• Used different Informatica Data Quality transformations in the Developer and Configured match properties match paths, fuzzy match key, fuzzy and exact match columns.
• Created profiles, rules, scorecards for data profiling and quality using IDQ.
• Used Informatica Data Quality for addresses and names clean-ups and developed error handling & data quality checks to pull out the right data. Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and resolved the production support tickets using remedy.
• Developed monitoring scripts in UNIX and moved Data Files to another server by using SCP on UNIX platform.
• Involved in HIPPA compliance lifecycle from GAP analysis, mapping & testing for processing of Medicaid claims.Used Teradata Utilities like Fast-Load, Multi-Load, BTEQ & Fast-Export.
• Created Teradata External loader connections such as M Load, Upsert and Update, Fast load while loading data into the target tables in Teradata Database.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.

Environment: Informatica 10.2, Oracle 12C, DB2,, Cerner Epic, Hyperspace (Migration Project ), Clarity, Business Object 4.1, HP ALM, UFT 11.5,Windows, Unix, MS Excel, MS Word, Putty, TOAD, Office Communicator,SharePoint.SSIS

Confidential

BI Engineer

Responsibilities:

• Performed daily job monitoringand checking batch processing using AUTOSYS. Involved in Troubleshooting any performance or infrastructure issues across environment.
• Worked with upstream / downstream partners in case of delay or data issues.Scheduled the batch jobs in Autosys and created the appropriate batch shell scripts.
• Processed programming and scheduling changes as per request.
• Monitored and resolved processing problems using problem management tools.
• Analyzed the issues and resolving the same, proposing a workaround to maintain business continuity and ensuring minimum business downtime. Identifying the critical issues and taking prompt and effective actions spontaneously.
• Monitored and verified file transmissions Prepared and executed Test Cases manually according to the BRD, Technical Specification, Functional Design and Use Case documents, identifying applications functionality, test requirements and coverage.
• Performed regression testing against the various builds of the application.
• Wrote SQL queries and tested front end developed data in the databases.
• Worked on Member and provider portal on Medicaid application.
• Testing all tickets and incidents from Service now and updating it.
• Attended daily standup meetings and walk through meetings with BA and developers to get details on user stories.
• Involved in creating Test Plan, Test Cases, and Test Data using Use Cases and Test Strategy for Incentive Program, Registration, Attestation, Payment, Reporting,Eligible Professional (EP) and Affiliated ACE branches.
• Developed Test plan and test cases and executed the test cases.
• Used Splunk to verify the results using Query.
• Written positive and negative test cases based on requirements, and specifications, flow charts, process diagrams and executed them.
• Participated as SME in onboarding applications by gathering information for transitioning to production environment with Development team.
• Maintained issue tracker which contains problem ticket numbers, work request numbers change request number detailsto track reoccurring and new issues.
• Communicated workarounds to be followed to L1 and L2 till the issue/work order gets complete/resolve. Raising issues to the development team and working with them closely for permanent fixes through calls. Managed test cases, defects in Quality center / ALM

Environment: Informatica, SSIS, SQL, HP Quality Center 10, MS Excel, MS word, Oracle 11g, TOAD, Putty.

Confidential

ETL/QA Analyst

Responsibilities:

• Participated in user story reviews and involved in test plan/design, execute test cases and defect management for the ETL & BI systems
• Writing and execute detailed ETL related functional, integration and regression test cases, and documentation
• Responsible for testing the entire application for GUI, Functionality, Business Logic and Use case adherence.
• Validation of data transformations and perform End-to-End data validation for ETL & BI systems.
• Experience in validating and analyzing Hadooplog files.
• Strong in ETL data validation using Informatica in ETL environments.
• Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data warehouse / BI applications.
• Ability to write and understand complex SQL queries, Hands on SQL scripting / ETL testing skills, Web application testing experience.
• Test applications in languages including ETL and any suite of open-source products which provide data integration
• Played active role in allocation of responsibilities,, and organizing the testing team efforts.
• Participated in the testing effort at all the stages of SDLC (Agile model) and executed test cases and documented the test results using HP Quality Center and ALM.
• Defect Reporting, Tracking and interacting with the development team and the real-time users to implement the entire Test Management. Reporting Bugs using Jira.
• Participated in defect triage meetings and worked with all the associated teams to validate the resolved defects and regression testing.
• Published testing status reports periodically to reflect the progress and also generated customized reports as per management requirements.
• Used SQL for extracting the required data related to testing, test dataset creation and verification.
• Automated the key functional scenarios using QTP to support regression testing and managed the entire test efforts in an integrated QC-ALM environment. Participated in weekly status meetings and interacted with the developer team to discuss technical issues.
• Organized UAT sessions and supported the UAT teams to perform the application testing.
• Supported User Acceptance testing and also conducting production verification tests for every release cycle.
• Coordinated the test efforts of on-site and off-shore teams and reported directly to the QA Manager.

Environment: ETL - Informatica Power Centre (9.6), XML, Visual Basic, UNIX, Win NT/XP, 2000, MS-SQL Server, Share Point, TFS, QTP and Quality Center 9.0/10.0. Application Life cycle Management (ALM), Tableau, Jira, Confluence, MS-Office.

Confidential, New York.

Sr ETL Consultant

Responsibilities:

• Responsible for creating completetest cases,test plans,test data, andreporting statusensuring accurate coverage of requirements and business processes.
• Performed Gap Analysis to show the current and proposed functionalities of the system
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflows, Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Involving in Testing Oracle BI Reports for the data validation in the Project
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in SQL Server Management Studio to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scriptsCreated, maintained, and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web-based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Creating traceability relationship between requirements in the same module and between different modules.
• Extensively used Quality Center for documenting, organizing, and tracking requirements.Involving in formulating the test plan, procedures and Wrote test cases.

Environment: UNIX, Oracle, SQL SERVER 2014, Informatica Power Center 9x, PL/SQL, Microsoft Office tools, SharePoint, Jira