PROFESSIONAL SUMMARY:

• 14+ years of IT experience in SDLC which includes requirement gathering, designing, implementing and testing.
• Over 8 years of Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL using Informatica Power Center 9.6/9.1/8.6, Informatica Power Exchange (PWX).
• Over 5 years of experience of leading multiple ETL projects of team members between 5-10 members.
• Worked with Onsite and Offshore model and lead the team.
• Good knowledge in interacting with HIVE, Python, MongoDB, Informatica DT and Data Validation Option.
• Very good proficiency in Informatica Data Quality 9.6.1, Informatica Metadata and Repository Management.
• Extensively worked on Informatica Analyst tool 9.6.1, Address Doctor as initial phase.
• Good knowledge in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in interacting with Business Managers, Product Owners, Analysts, and end users to correlate Business logic and specifications for ETL Development and documenting Source-to-Target Mappings, Unit Test cases and Deployment documents.
• Worked on both waterfall model as well as agile methodology projects.
• Worked on tools like HPQC for defect tracking.
• Production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
• Worked with the team to ensure deliverables on time.
• Involved in Unit testing, System testing, UAT to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Modified the shell scripts as per the business requirements.
• Good in Collecting, Analyzing and Interpreting Data in an organized way.
• Extensive experience in Production Support participating with disciplines of supporting the IT systems/applications which are currently being used by the end users. Involved in performance tuning.

TECHNICAL SKILLS:

Databases: Oracle 10g/9i, SQL Server 2016, Snowflake, Teradata

Operating Systems: UNIX, Windows 2000/NT/XP

Languages: Unix Shell scripts, HTML

ETL Tools: Informatica PowerCenter, Informatica Data Quality, Informatica Power Exchange(CDC), DVO, Informatica Cloud, Informatica MDM

BI Tools: Micro strategy

Tools: Visual Source Safe, IIS, SVN

Web: ASP, XML, VBScript, JavaScript

Design: Visio

Cloud Tools: Amazon S3, Redshift, CloudWatch, IAM

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. Informatica Developer/Lead

Responsibilities:

• Work with business analysts for requirement gathering, business analysis, and testing and project- coordination
• Responsible for development, support and maintenance of the ETL (Extract, Transform and Load) processes using Informatica Power Center
• Develop an ETL Informatica mapping in order to load data into staging area. Extract from flat files and databases and load into Oracle 10g target database
• Designed Mapping document, which is a guideline to ETL Coding
• Create mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure
• Complete work with various Informatica Power Center tools -Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations
• Use Slowly Changing Dimension Mappings of type II and I. Create the Multi-Dimensional data model (STAR Schema) and enhance it to meet the growing requirements due to corporate mergers
• Perform Dimensional Data modeling and create Star Schema and Snow Flakes Schema data model to meet the OLAP needs
• Configure, create, schedule and monitor the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager
• Finish work on DQ using Data profiling by initially assessing the data to understand its quality challenges
• Extensively use SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers
• Utilize PLSQL developer, TOAD to run SQL queries and validate the data
• Work on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies
• Install and configure Metadata Manager Service, Data Analyzer and Web Service Hub
• Finalize installation of Power Center software, administer repositories and provide application support for Institutional Business, Individual Business, Provide Power Center performance tuning and production support
• Implement and support Power Center development, test, quality assurance and production environments including object migrations. Manage Power Center security. Provide standards using Informatica velocity guidelines to application development teams
• Upgrade Power Center to version 9.1.0 from 8.6.1
• Perform work on Power Center Enterprise Grid using workflow and session-on-grid, adaptive load balancing, high availability, dynamic partitioning
• Extensively use Teradata utilities like Fast load, Multiload to load data into target database
• Document and present the production/support documents for the components developed, when handing-over the application to the production support team
• Prepare ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS
• Provide development of advanced reports using Report Studio - Using Tabular Objects, Sub reports, Cascading/customizing prompts and cross tabs, list, charts, Drill- through reports
• Customize data by adding Calculations, Summaries and Functions
• Experience in writing complex reporting using SQL performance tuning and providing operational support for OLTP and OLAP applications

Environment: Informatica Power Center 9.1.0, Teradata V2R6, Oracle11g/10g, SQL Server 2008, TOAD, Business Objects XI, Linux, Windows XP

Confidential, Houston, TX

Sr. Informatica Lead

Responsibilities:

• Worked closely with Business Analyst and the end users for understanding existing business model and customer requirements and involved in preparing the functional specifications based on the business requirement needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Expertise in building scripts using Transact-SQL for DDL and DML
• Developed stored procedures in T-SQL that were invoked to load dimensions and fact tables and also for Error handling during the ETL process
• Developed stored procedures in T-SQL that were invoked to load dimensions and fact tables and also for Error handling during the ETL process
• Used Tidal scheduler to get the source file from the server using Tidal flat file FTP connection as well as power center FTP connection.
• Ran the all workflows using the Tidal scheduler.
• Created Merge statement update else insert T-SQL jobs.
• Worked on Migration of mappings from Data Stage to Informatica.
• Installed and configured Informatica Power Exchange for CDC and Informatica Data Quality (IDQ).
• Used IDQ's standardized plans for addresses and names clean ups.
• Created custom plans for product name discrepancy check using IDQ and incorporated the plan as a mapplet into Power Center.
• Worked on retrieving data from FACETS repository for patient care program.
• Worked on identifying the entities and attributes in FACETS for eligibility, provider, plan etc.
• Worked on populating FACETS repository for patient billing, clinical documentation reporting.
• Did some MDM management using Informatica MDM tool?
• Worked on batch data process flows and consolidation flags in Informatica MDM.
• Designed & developed Informatica mappings, mapplets, worklets and workflows to create load-ready data files for loading Oracle E-Business Suite.
• Designed and developed Reports for the user Interface, according to specifications given by the Track leader.
• Created stored procedures (NZ-SQL).
• Scheduled the ELT load in Autosys.
• Debugged and corrected the xfr files developed by other ELT developers.
• Fixed numerous bugs with load issues.
• Optimized the NZ-SQL queries.
• Converted Oracle ddl's to Netezza ddl's.
• Scheduled the ELT load in Control-M.
• Lookup, Router, Filter Update Strategy, Joiner, Transaction Control and Stored Procedure etc.
• Created Process Control and Metadata for informatica jobs.
• Created the format of the unit test documents per Netezza Framework.
• Assisted ELT developers in creating the unit test documents.
• Managed user and folder permissions for the developers.
• Purged old repository objects weekly.
• Created shell script for repository backup weekly.
• Developed data Mappings between source systems to Landing and from Standardization to warehouse components using Mapping Designer.
• Did performance tuning on the ELT code developed by ELT developers.
• Debugged the framework error logs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Problem resolution involves resolving the issues raised by the client/actuarial users, validation of the data in the database or in the application functionality.
• Worked closely with QlickView Developers.
• Involved in performance tuning at source, target, mapping and session level.
• Loaded Oracle tables from XML sources.
• Configured Informatica for the SAP Connector.
• Extracted data from SAP and loaded into Oracle EBS
• Introduced the concept of Data Dashboard to track the technical details sighting the continuous requirement changes and rework needed.
• Optimized the BOXI dashboard SQL with aggregated and sub queries.
• Created and modified BO reports.
• Loaded the data into reporting layer based on the BOXI reporting requirements in facts and dimension tables.
• Supported Integration testing by analyzing and fixing the issues.
• Created Unit Test Cases and documented the Unit Test Results.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Did bulk loading of Teradata table using TPump utility.
• Resolved Skewness in Teradata.
• Analyzed some of the JCL scripts for job scheduling.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.
• Created the Cognos connections for web portal and content store.
• Developed a query subject in framework manager in Cognos.
• Used Informatica Data Quality tool for Standardization by referring to the database dictionary tables and populating the flat file dictionaries.
• Used Informatica web services to create work requests/work Items for the end user.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file.
• Supported Integration testing by analyzing and fixing the issues.
• Created Unit Test Cases and documented the Unit Test Results.
• Created Stored Procedures to validate and load the data from interface tables to the Oracle E-Business Suite internal tables.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.
• Staged data in Oracle E-Business Suite stage tables using Power Center in Informatica.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plans.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.1, IDQ, Cognos, Oracle 11g, MDM, Netezza TwinFin 6 (Production), Netezza TwinFin 3 and Netezza Skimmer (Non-production), Business Objects XI Edition (BOXI) Reporting tool SQL Server 2012/2008 R2, Flat files, TOADWindows XP, FACETS, Control-M, Mainframe, Tidal scheduler.

Confidential, Warsaw, IN

Informatica Lead

Responsibilities:

• Worked with Informatica 10 to create Source/Target connections, monitor, and synchronize the data with various systems.
• Troubleshoot the existing code as well as new code as the requirement changes.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Involved in different Team review meetings.
• Leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows.
• As a lead Data Quality developer in this team initiated the process of Data profiling by profiling different formats of data from various sources.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.

Environment: Informatica 10, IDQ, Oracle 10g, SAPHANA, SAPBW, MS SQL server 2012, Flat files.

Confidential, Baltimore, MD

Informatica Lead

Responsibilities:

• Worked with Informatica Cloud to create Source/Target connections, monitor, and synchronize the data in SFDC.
• Worked with Informatica cloud for creating source and target objects, developed source to target mappings.
• Troubleshoot the existing code as well as new code as the requirement changes.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Involved in different Team review meetings.
• Leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows.
• As a lead Data Quality developer in this team initiated the process of Data profiling by profiling different formats of data from different sources.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.

Environment: Informatica 10, IDQ, Informatica Cloud, Snowflake, Unix script, MS SQL server 2012, Flat files.

Confidential, Scottsdale, AZ

Informatica Lead

Responsibilities:

• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Extensively using Informatica client/Power exchange tools to extract data from different sources like SAP, SAP IDOC, SQL Server, AS/400.
• Troubleshoot the existing code as well as new code as the requirement changes.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Involved in different Team review meetings.
• Developed ETL mappings as per the development standards.
• Leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows.
• Building extensively IDQ mappings for customer and vehicle data cleansing and exporting to PowerCenter and using as normal transformations in building the logic.
• Implemented Real time Change Data Capture (CDC) using Informatica Power Exchange.
• Used Informatica 9.6 to load data into SAP CAR system using SAP IDOC and BAPI’s.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Involved in technical supporting, troubleshooting data warehouse application to meet Service Level Agreement (SLA's)
• Handling of CR's (Change Requests) and enhancements for existing application and followed change management process and created deployment documents.
• Ability to create ETL framework with reusable assets.
• Distribution of work to onsite and offshore team and follow-ups.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Used IDQ to complete initial data profiling and removing duplicate data.

Environment: Informatica 9.6/10, Informatica Power exchange (CDC), IDQ, SAP, AS/400, Flatfiles, PowerShell script, MS SQL server 2012.

Confidential, Torrance, CA

Informatica Lead/Data Analyst

Responsibilities:

• Reading through the data and present the findings and translate them into an understandable document.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Presented Data Cleansing Results and IDQ plans results to the OpCos SMEs.
• Worked with Informatica to load data into various target tables after performing the data quality.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for project coordination.
• Responsible for Detail design of each interface.
• Responsible for developing complex Informatica mappings using diverse types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Developed SDE mappings to load large amount of data from various sources to staging area, SID mappings for load the data from staging area to target system.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Created various tasks like Event wait, Event Raise and E-mail etc.
• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using PMCMD
• Tuning the Informatica mappings to increase the performance.
• Wrote test plans and executed it at UNIT testing and supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality.
• Created deployment documents for migration the code to higher environments.
• Developed Reusable codes which can be used thru out the application.
• As an Onsite Coordinator provided direction, feedback and coaching to build the capability of Off-shore project team and other onsite coordinators.

Environment: Informatica 9.1, Informatica Power exchange (CDC), IDQ, Oracle 11g, Data quality, Toad, PL/SQL, Erwin

Confidential, North Brook, IL

Sr. Developer

Responsibilities:

• Responsible for requirement gathering, data analysis, design, development, testing and systems implementation.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Extensively using Informatica client tools to extract data from various sources like flat files and oracle.
• Troubleshoot the existing code as well as new code as the requirement changes.
• Performed Unit Testing and Created UNIX Shell scripts and provided on-call support during the off hours.
• Did overnight schedule monitoring during critical month-end/quarter-end positions, source system upgrades and during integration/system tests.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Involved in different Team review meetings.
• Generated weekly and monthly report Status for the number of incidents handled by the support team.
• Leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows.
• Verify the data quality or data validation through Informatica data validation option tool (DVO) and Data Quality (IDQ).
• Created Reusable transformation and Mapplet based on the business rules to easy the development process and responsible for document the changes.

Environment: Informatica 9.1, Oracle, DVO, Toad, PL/SQL MS Visio, Windows 2000, UNIX.

Confidential

Sr. Developer

Responsibilities:

• Provide profiling, cleansing and validation reports in preparation for a data migration.
• Responsible for requirement gathering, design, development, reviewing, testing and systems implementation.
• Leading the team in coding, testing and code migration.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Assisted change management reviews and impact analysis with the Business team.
• Identify the stake holders, priorities the task items which could be delivered in the next cycle as per part of engagement.
• Involved on various HIPPA claims validation and verification process to understand the source data.

Environment: Informatica 9.1, IDQ, SQL, UNIX Scripting, Flat Files, Windows NT/2000.

Confidential

Sr. Informatica Developer

Responsibilities:

• Responsible for Design and Development of ETL and the reporting application.
• Communicated with the users to observe various business rules in implementing the data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Check in/Checkout the code, Test Plan, Test cases and unit test case.
• Creation, configuring, scheduling and running of Sessions, Worklets and Workflows.
• Preparing the unit test cases and perform Unit testing and peer reviews at the end of each phase.
• Trouble shooting and debugging the issues evolved during the project execution by providing the root cause analysis.
• Coordinating with the various levels of production support teams to provide quick analysis and problem resolution through data/code fixes.

Environment: Informatica 8.6, VBSCRIPT, Oracle9i, SQL, PL/SQL.