SUMMARY:

• 5.5 years of professional experience in System Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL Integration, OLAP, Client/Server applications in Insurance and Banking domain.
• Exposure on POCs and hands on towards Bigdata technologies like HDFS, Map Reduce, Hive,Oozie,Spark(with Scala),Spark SQL,Flume,Sqoop,Kafka,Spark streaming,Hbase,Pig and go od understanding on Cloudera Manager and HortonWorks Ambari platform.
• Have end to end experience in Development, Testing, support and Maintenance for many applications to ensure daily/weekly/monthly processes completes to meet business report SLA and have worked for complete lifecycle of many applications.
• Extensive experience in using Informatica ETL tool ( Informatica 8.6/9.01/9.6 ) using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations), Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in writing unit test cases and conducting testing for Unit testing using mocked up or real time data.
• ETL and data integration experience in developing ETL mappings and shell scripts using Informatica Power Center 9.x/8.x and Teradata, Oracle, Unix and Control - M.
• Profound knowledge on UNIX shell scripting, Oracle(10g/11g), Teradata (13,14), Control-M and Informatica Power center .
• Worked on developing reusable shell scripts which have BTEQ, TPT and SFTP functionalities and are being currently used across multiple projects in Chase Integrated Data Warehouse platform.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Strong skills of Informatica Power center - Designer, Workflow manager, monitor, various transformations available in 8.6, 9.01 and 9.6. Have expertise in working across various Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalize and Union and others.
• Knowledge in Full Life Cycle development of Data Warehousing
• Experienced in preparing the design documents, mapping/reverse engineering documents and best practices for mapping.
• Ability to work on multiple projects/tasks simultaneously to meet deadlines.
• Experienced in taking knowledge transitions from other vendors.
• Proficient in Break fix, Production ticket analysis and resolution through HP Service manager tool, downstream/upstream ticket management and follow ups for critical production issues/failures for existing applications.
• Highly motivated individual and team player with excellent communication, interpersonal skills and an attitude to learn the new cutting edge technologies.
• Good understanding of Data warehousing Concepts, Star Schema and Snowflakes Schema methodologies, understanding business process/requirements.
• Experience in Enterprise Data Warehouse to ensure that reporting, business intelligence, and analytic data needs are met and with iterative approach methodology. Perform any other job related instructions, as requested.
• Experience in SQL performance tuning related to Complex views and in PDO (Push down optimization) generated queries related performance issue.
• Used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers .
• Sound knowledge of views, Synonyms, Indexes, Partitioned Tables, Joins and Sub-Queries.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, DB2, Mainframe systems and Flat files
• Experience in Agile, Waterfall methodology

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6.1/9.01 / 8.6

Reporting tools: Business Objects

Bigdata Tools: HDFS, Map Reduce, Hive,Oozie,Spark(with Scala)Spark SQL,Flume,Sqoop,Kafka,Spark streaming,Hbase, Pig, Cloudera manager, Hortonworks(Ambari)

Scheduler: BMC Control-M Workload Automation, ESP CA Workload Automation

Data bases: Teradata 13/14, Oracle 10g/11g

Database Tools: SQL Assistant, Toad, SqlDbx(Oracle), SQL * Loader, SQL * Plus

Office Tools: MS Word, Excel, Access, Outlook, Power Point

Operating Systems: Windows XP/2002/2003/7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Develop working solution to extract data for five different Underwriting companies that Nationwide acquired over the time.
• Identify the development approach and design of certain requirements by working with business team and work towards getting signoff on the design.
• Creating Claims with Exposures, Payments, Reserves, Recoveries - the responsibilities being carried out by Adjusters. This is needed for Unit and Integration test data creation.
• Conduct Code review sessions for the developed code and Exit Amigo session for Testing team to work on the defects/work requests.
• Participate in Retrospective meetings and Iteration Planning Meeting to discuss about future enhancement options and to provide estimates to manage Release Iterations effectively in a complete agile mode of project execution.
• Claimcenter ETL Integration project acts as a bridge between Nationwide and its underwriting companies (Allied, Titan, Nwag, Harleysville). Co-ordinating with these teams for any PROD defects/issues for the ETL batch run.
• On-call PROD Support activities both in weekdays/weekends to support PROD batch runs, PROD implementations and any PROD outage batch support activities.

Environment: Informatica Power Center 9.6.1, Repository Manager, Designer, Work Flow Manager, EBCEDIC Files, ASCII Files, CSV Files, Oracle-11g, Mainframe, Windows 7, Unix, ESP CA Workload Automation

ETL Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, transform and cleanse data, and load it into Data Warehouse using Informatica PowerCenter.
• Worked with the Business analysts and the data architects for requirements gathering, business analysis, testing, and metrics and project coordination
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Teradata in accordance with requirements and specifications
• Developed complex Teradata views to identify incremental changes for full extract data sources
• Implemented database objects in Teradata for database objects.
• Used HP ALM for all the defect tracking during development and QA phase of the project
• Performed Unit Testing and tuned the mappings for better performance.
• Participated in Development, debugging, testing, BAU support, On-Call support on weekends and holidays, break fix releases, Emergency fixes (if any) and among other activities.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer
• Extensively worked on tuning views and informatica mappings to gain performance in applications with larger data.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Used parallel processing capabilities, session-partitioning and target table partitioning utilities.
• Developed the Run book, Playbook and other technical documents to support BAU activities and need by L1/L2 PROD Support team. Worked on Teradata, tested the target data against source system tables by writing some QA Procedures.
• Experience in working on cross impact projects where a change impacts various line of business and needs proper co-ordination and change management to address any outstanding bottlenecks.
• Used workflow manager for session management, database connection management and scheduling of jobs
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Performed Unit Testing and assisted QA team in Quality Assurance Testing, Load Testing and UAT, Performance estimation testing

Environment: Informatica Power Center 8.6, 9.01, Repository Manager, Designer, Work Flow Manager, EBCEDIC Files, ASCII Files, CSV Files, Mainframe, Teradata-13,14, Windows 7, Unix, Control-M.

ETL Developer

Responsibilities:

• Creating mapping documents and codes per the requirement provided by client and data modellers based on the ARB approved data models and enhancing existing applications.
• Staged data based on data quality standards and integrated various files per the business reports semantic requirements.
• Participated in identifying cross impacted areas and addressed issues with the existing applications along with development of new applications.
• Have created few shell scripts to manage formatting of files, to generate multiple files from single file based on certain criteria after applying compressing and other format requirements.
• Developed many mappings to process data files along with data quality validations for the files to be staged in to tables.
• Created medium to complex PL/SQL stored procedure for Integration with Informatica using Teradata .
• Developed complex mapping also involving SCD Type-II script creation to load the data from various sources
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests. Was part of DEV and L3 support team and helped the L1/L2 Production Support team in resolving tickets from downstream applications.
• Actively involved in debugging and issue fixing for the files datatype, strings, dates, custom transformation issues.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Centre.
• Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.

Environment: Informatica Power Center 8.6, 9.01, Repository Manager, Designer, Work Flow Manager, CSV Files, DB2, Teradata-14, Windows 7, Unix, Abinitio, Tivoli, Control-M.

ETL Developer

Responsibilities:

• Created Reusable Unix shell scripts which were driving entire ETL process where data was extracted, compressed, preprocessed, transmitted and archived through UNIX shell scripts. The scripts are currently being used across 25+ projects.
• Created informatica mappings to integrate with Unix ETL processes for complex scenarios.
• Modified the master unix shell script developed by Chase Reusable component team to have functionality to log and allow to get called through the above scripts.
• Worked with various teams from various projects to resolve issues as the scripts were being reused by 25+ projects across chase.
• Developed complex mappings where data was loaded first then and then got extracted using simple SQL to file which made the process easy to integrate into the Extract process.
• Wrote BTEQ scripts to transform data.
• Extensively used local variables in Expression transformation for solving complex business requirements
• Good experience using mapping parameters and session variables through parameter files
• Developed code to maintain history of UPD tables (User Provided Data) using CDC(SCD type 2)
• Configured and scheduled Pre and Post Session commands with Shell Scripts and in some feasible scenarios used command task in session.
• Utilized Informatica Debugger functionality to troubleshoot data and error conditions.
• Participated in Test case preparation, test scenario execution, ALM ticket management for the defects and UAT testing support to the users.
• Provided support for UNIX reusable scripts that i developed and helped various teams to resolve outstanding issues and in turn making the scripts more generic with enhancements.

Environment: Informatica Power Center 8.6, 9.01, Repository Manager, Designer, Work Flow Manager, CSV Files, DB2, Teradata13/14, Windows 7, Unix, Abinitio, Tivoli, Control-M.

ETL Developer

Responsibilities:

• Analysing requirements, closely working with DBAs and Data modellers to find out best possible solution to the data mart codes and architecture, coding and maintain code tracker, best practices, performance tuning, BAU report SLA related tickets, UAT defect fixing by closely working with Users, BA and data modellers and SMEs.
• Understanding the Requirement specifications for various data marts, creating mappings with surrogate key generation based on Data Model and loading data to Integration layer on which semantic reporting can be done.
• Based on legacy data warehouse reference model, involved with users to understand the requirement from attribute level reporting to identify best possible Change Data Capture (SCD Type-2) solutions for efficient coding to support efficient reporting.
• Developed scripts for creating tables, views, synonyms and materialized views in the data mart.
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Utilized dimensional and star-schema modelling to come up with new structures to support drill down.
• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed mappings to read data from various relational and file source systems such as Teradata, Oracle, flat files and XML files.
• Participated in code migration to QA/UAT/PROD with testing and process documentations while following enterprise defined migration standards and processes.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.

Environment: Informatica Power Center 8.6, 9.01, Repository Manager, Designer, Work Flow Manager, CSV Files, DB2, Teradata-13,14, Windows XP, Unix, Abinitio, Tivoli, Control-M

ETL Developer

Responsibilities:

• Understanding requirement of existing data mart from the end user and modelers and migrate and build, each logical part of existing system and provide thorough and comprehensive view to end user and analysts.
• Detailed Analysis and reverse engineering of SAS codes and prepare mapping specifications with source-target along with transformation logics and filter criteria.
• Participate in discussions with Business Analyst, Data Modellers and Data Review Board to finalize architecture and design of the migration project.
• Active participation in co-ordinating with Central QA team for Integration Testing to ensure quality of the code being delivered.
• Ensured to pre-process data files before staging it to stage layer for unformatted data.
• Created UNIX shell scripts to pre-process data and control files before stage layer load.
• ETL Design and Implementation of migration from SAS-DB2 to Informatica-Teradata and Informatica-Oracle.
• Review and certify the code developed within the team and help in migration of the code.
• Provide estimates of modules to fit into the Scrum method for agile execution.
• Participate and provide in design discussions.
• Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Created Use-Case Documents to explain and outline data behaviour.
• Complete responsibility of a single module for development, Unit/System testing, support for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6/9.1 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Worked on creating Unix Shell scripting solutions for special scenarios where certain specific parameters/values were being reused in informatica mappings.
• Worked on performance improvement of complex views to reduce resource consumption and provide faster results.
• Worked for complete project lifecycle and active participation towards enhancements, break fixes, testing and batch management.

Environment: Informatica Power Center 8.6, 9.01, Repository Manager, Designer, Work Flow Manager, CSV Files, DB2, Teradata 13, Windows XP, Unix, SAS.