PROFESSIONAL SUMMARY:

• Over 9+ years of IT experience in Planning, Analysis, Design, Implementation, Development, Maintenance and Support for production environment in different domains like Insurance, Healthcare, Financial, Retail with a strong conceptual background in Database development and Data warehousing.
• Highly proficient in Development, Implementation and Support of ETL processes for Large - scale Data warehouses by Using Informatica Power Center 9.6/9.5/9.1/9.0/8. x/7.x.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Experienced with industry standard methodologies like Agile, Scrum and Waterfall methodology within the Software Development Life Cycle (SDLC).
• Extensive knowledge on Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools - Informatica Server, Repository Server.
• Prepared detail documentation, created and developed complex mappings using various transformations such as Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Router, Union, Rank, Update Strategy, Source Qualifier and Sequence Generator.
• Experienced and comfortable working on Master Data Management(MDM) using various databases like Oracle 12c/11g/10g/9i/8i, MS SQL Server, IBM DB2, XML, Flat Files, Sybase, Teradata and Netezza.
• Created and maintained Database Objects like Tables, Views, and Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link.
• Worked on optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets, SQL scripts and triggers and PL/SQL stored procedures.
• Experience in Oracle database Performance Tuning of SQL statements and in SQL * Loader Imports/Exports.
• Knowledge in Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
• Strong conceptual skills in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling using Erwin.
• Implemented Data extracting, Data profiling, Data cleansing, Data integration, Data transformation and loading into Data marts using Informatica.
• Implemented Data extracting, Data profiling, Data cleansing, Data integration, Data transformation and loading into Data marts using Informatica.
• Good knowledge in interacting with Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) for the data management and data cleansing activities.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target and created Post UNIX scripts to perform the operations like copy, remove and touch files.
• Expertise in using Scheduling tools like Active Batch V9, Informatica Job Scheduler, Control-M, Tidal, Autosys to automate running of Informatica Workflows on a daily/ weekly/ Monthly Batch Jobs.
• Extensively worked on Facts, used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) tables Type-1, Type-2.
• Worked extensively on JIRA for issue tracking and project management.
• Successful code migration from Development to Testing & Production environment.
• With both On-site and Off-shore model experience have developed skills in system analysis, troubleshooting, debugging, deployment, Team management, prioritizing tasks and customer handling.
• Excellent Documentation Skills, Team problem solving ability, Analytical and Programming skills in High speed, Quality conscious and multitasked environment.
• Outstanding communication and interpersonal skills, ability to learn quickly, high compliance to new technologies and tools.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6(PC and IDQ)

Languages: SQL, PLSQL,UNIX

Methodology: Agile RUP, SCRUM, Waterfall

Databases: Oracle, DB2, SQL SERVER

Operating Systems: Windows, UNIX, Linux and Solaris

IDEs: Eclipse, PL/SQL Developer, TOAD, Teradata SQL Assistant

Reporting Tools: Tableau, SSRS Report Builder, Risk Assessment Toolbox(Program Risk Review Tool, Risk Ranking Tool and Risk Ranking Tool Webinar)

Control: m, Autosys

PROFESSIONAL EXPERIENCE:

Sr. ETL Informatica Developer

Confidential, blue shield

Responsibilities:

• Involved in complete SDLC phase in collecting and documenting requirements. Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Extensively used Informatica Power Center 9.6.1 as an ETL to extract data from sources like MS SQL Server, Flat files, Oracle, IBM DB2 and load into target database.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Master Data Management(MDM), Data Marts / Decision Support Systems using Informatica Power Center ETL tool. knowledge on Informatica Power Exchange that brings the data from mainframe structure to the target.
• Worked in a competitive Agile environment to develop standard ETL framework and reusable mappings and Mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup and Filter.
• Created Reusable Transformations, Worklets, and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.
• Implemented standards for naming Conventions, Mapping Documents, Technical Documents, and Migration form.
• Experienced in delivering the Technical process flow for different Line of Business. Gathered, analyzed & documented business requirements.
• Extensively worked on developing Informatica Mapplets, Mappings, Sessions, Worklets and Workflows for data loading.
• Experienced Working on different tasks in Workflow Manager like Sessions, Event wait, Decision, E - mail, Command, Assignment, and Scheduling of the workflow.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily by using Autosys.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly changing Dimension tables
• Used Pushdown Optimization and Partition techniques to push the mapping logic to Source and target to increase session performance.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Used various Informatica Error handling techniques to debug failed session.
• Used JIRA-Agile project management tool to plan, track and manage progress of the project and also track bugs, tasks and requests.
• Performed Informatica code migration from development to testing and production environment
• Handled Production Support for the monitoring of daily, weekly and Monthly jobs
• Worked with the testers closely in determining both medium and high severity defects that would potentially affect the downstream systems before the release of the project and fixed the defects before moving the jobs into production.

Environment: Informatica Power Center 9.6.1, Informatica PowerExchange, Oracle 12c/11g, IBM DB2, Flat files, TOAD, SQL/PLSQL, Autosys, Cherwell, JIRA, UNIX, Windows.

Sr. Informatica Developer

Confidential

Responsibilities:

• Experience in Dimensional data modelling techniques, Slow Changing Dimensions (SCD), Software Development Life Cycle (SDLC) and Data warehouse concepts - Star Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Worked on implementing the new Kansas Modular Medicaid system.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Develop or make performance tuning on Informatica Mappings/ Mapplets / session/ Workflows/ Worklets for optimum performance.
• Create Batch jobs through Active Batch V9, Tidal tools for auto-run on daily/weekly/ Quarterly basis.
• Check for appropriate stages of the change record and deploy components like Informatica SHELL's and other objects, SQL Scripts from Databases like SQL Server, DB2, Netezza, & Oracle, UNIX shell scripts.
• Design and develop data loading programs to support real time data loading to Netezza Data Marts.
• Developed PL/SQL procedures/packages to load the data into Oracle 11g.
• Worked on IDQ parsing, IDQ Standardization, matching, IDQ web services.
• Involved in massive data profiling using IDQ prior to data staging.
• Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets (command, email, assignment, control, event wait/raise, conditional flows, etc.) and configured them according to business logics & requirements to load data from different Sources to Target.
• Streamlined the Change Management process through standardized documents to meet the stakeholder's expectations.
• Involved in creation and maintenance of basic Informatica administration such as creating users and privileges, folders, optimizing server settings, deployment groups etc. Extracting data from mainframes using file aid utility to compare with data coming from Greenplum database.
• Used Hadoop (HDFS) to provide high-throughput access to application data for processing huge data set.
• Created and maintained the shell scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Worked extensively on JIRA for issue tracking and project management
• Migrated the codes from Dev to Test, Test to Prod environment and wrote up the Team Based Development technical documents to the smooth transfer of the project.
• Prepared ETL technical Mapping documents along with test cases for each Mapping for future developments to maintain SDLC.
• One core responsibility to coordinate with offshore team for Technical implementation of BRD, Design data modeling and Mapping, integrate work procedure and migrating of the code document.

Environment: Informatica Power Center 9.5/9.1.0, SQL Server 2008, DB2, Netezza, PL/SQL, IDQ, Active Batch V9, Tidal (Scheduling Jobs), DM Loader, Greenplum, HADOOP, Service Now, JIRA, UNIX Shell Scripting.

Informatica Developer

Confidential

Responsibilities:

• Worked extensively in full System Development Life Cycle like participating in requirement gathering, business analysis, user meeting.
• Prepared data marts on policy data, policy coverage, claims data, client data and risk codes.
• Developed Naming Standards, Best Practices for ETL development.
• Extensively used Informatica Power Center 9.1 to extract data from various sources, which included flat files, XML Files, Oracle, SQL Server, Sybase, Teradata, MS - Access.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Worked on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Union, Normalizer.
• Created Mapplet, Parameter Files wherever necessary to facilitate reusability of business logic.
• Involved in Development and Deployment of Source Code between the Various Repositories (Dev, QA, Prod).
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions
• Created Reusable Transformations, Worklets, and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.
• Developed override SQL statements in Source Qualifier and Lookups to suit extraction of desired data from desired region.
• Used SSIS to take data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.
• Developed test cases for Unit Testing of the Mappings, and was involved in the Integration Testing.
• Scheduling jobs using Autosys to automate the Informatica Sessions.
• Written Unix Shell Scripts to perform several operations on text files and developed for data cleaning and loading process.
• Analyzed and remediated the existing Informatica mapping logic for load processes and system standards.
• Implemented Error Processing for Informatica Mappings and Workflows.
• Used TOAD to develop and debug oracle PL/SQL Functions, Procedures and Packages.
• Monitored and improved query performance by creating views, indexes and hints.

Environment: Informatica Power Center 9.1/9.0, SSIS 2005, Data Explorer, Data Quality, PL/SQL, Oracle 10g, SQL Server 2008 R2, TOAD for SQL Server, Flat Files, Teradata, Sybase, Cobol, UNIX Shell Scripting, Autosys.

Informatica Developer

Confidential

Responsibilities:

• Analysis of business requirements with the help of BRD and HLD documents and by attending design review meetings.
• Analysis of external/internal data sources and various systems, creation of data dictionary of various tables within the Data Mart.
• Actively participated in interactions with business users, technical architects, DBAs and technical manager to fully understand the requirements of the system.
• Participated in the development of a data quality framework including scorecard and dashboard.
• Analyzed and reviewed Stored procedures, user defined functions, views, SQL scripting according to the complex business logics used in the reporting and cross verify the results with business users.
• Extensively used joins and sub - queries for complex queries involving multiple tables from different databases and optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Wrote several SQL Scripts such as finding tables that have identity columns, finding tables that do not have primary keys etc.
• Reviewed drill through report and data blending in case of merging different sources in Tableau.
• Performance Tuning in SQL Server 2008 using SQL Profiler and Data Loading.
• Responsible with data analysis tools for data lineage, metadata, and data profiling.
• Created indexes on selective columns to speed up queries and analyzed in Database and reduced overhead successfully by avoiding unnecessary use of the UNION statement & using the top operator to limit the select statement in Queries.
• Perform data cleansing and data masking while creating table views for business users maintaining privacy guidelines.
• Created views for restricting access to data in OLTP tables for maintaining the security guidelines.
• Responsible in creating and presenting informational reports for management based on SQL data.
• Participated in tasks to make changes to the SQL database that would prevent data corruption.
• Raise defects using HP ALM Quality Center on the issues faced and tracking the defects.
• Attend the daily team meetings on project status and delivery status.