SUMMARY:

• 8+ years of strong experience in analysis Software Development Life Cycle. Design and Development for various software applications in client - server environment and providing Business Intelligence Solutions using ETL tools like Informatica, Datastage, MDM as staging, Teradata, and Talendin .Having hands on experience as a ETL Development in Banking, Healthcare and Insurance domain.
• Having complete domain and development Life Cycle knowledge of Data Warehousing.
• Worked extensively on Informatica PowerCenter for supporting Data Extraction, transformation and loading.
• Experience in preparing and running Sessions/tasks, Work Flows, and Jobs in informatica PowerCenter.
• Experience in Using Designer and Workflow Manger, Workflow Monitor Tools in Informatica.
• Perform unit testing, performance testing and Functional testing at various levels of the ETL.
• Developed and implemented the Informatica Mapping for the different stages like MDM, DB2 and Flat files.
• Fixed the invalid mapping's and troubleshoot the technical problems of the database
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse, MDM and DSS using Informatica Power Center 10.1.1/9.1.0/8.6.1 IDQ(Informatica Data Quality), Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor
• Hands on experience in handling data from various source systems such as MDM,Flat Files, XML Source, Oracle, IBM DB2 and Excel Files
• Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and using PMCMD commands.
• Have a clear understanding of Master Data Management (MDM), Operational Data Store, and DW/BI concepts.
• Having knowledge on how to fetch data from MDM Repository and staging and stored data in MDM database.
• Working on MDM staging and use to perform operation and finally load data in MDM table, DB2 and flat files as per the requirement
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Designed, Developed and Executed Test Cases to ensure that product meets the users business requirements.
• Skilled in coordinating with Project Managers, Business Analysts and System Analysts to setup the pre validation and validation environment to execute the scripts.
• Well versed with to Software Testing Life Cycle (STLC), Bug life Cycle (BLC) and Software Development Life Cycle (SDLC).
• Ability to Understand Functional requirements and interaction with Client meetings.
• Maintaining the Traceability Matrix, Test data Matrix and status report related to project.
• Hands on experience in Black Box testing, White Box Testing, Unit Testing, User acceptance testing, (UAT), Functional, Integration, GUI, System, Usability, Regression, Smoke testing and end to end testing.
• Experience in analyzing test results and submitting bugs using Bug Tracking Tools JIRA and HP Quality Center.
• Experience in Web based testing including Unit Testing, GUI Testing, Regression Testing, Integration Testing, System Testing, Performance Testing and Functional Testing.
• Good Analytical and problem solving skills. Able to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS:

ETL Tools: Informatic aPowerCenter 10.1.1/9.1.0/8.6.0/8.1.1/7.1.1/6.2, PowerMart 6.2/5.1/4.7, Informatica Data Quality 8.5, Power Exchange 9.1

Data Modeling: Erwin 7.2/4.0/3.5

Requirement Management: Rational Requisite Pro V7.0.1

Databases: Oracle 10g/9i/8i, Teradata 12, MDM, MS SQL Server 2010/2008/2005/2000, IBM DB2/UDBLanguages: SQL, PL/SQL, SQL*Plus, HTML, UNIX, DBMS, C, C++

Tools: SQL plus, TOAD, Autosys, CRONTAB, IBM InfoSphere, Apache Velocity Modules, Maven PDK

Operating Systems: UNIX, Wi ndows (XP, NT/95/98/2000),WinNT4.0, MSDOS6.22

Testing Tool: SILK, JIRA, Confluence, HP ALM

Management Tool: HP Quality Centre

Test Approaches: Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle

PROFESSIONAL EXPERIENCE:

HALFAKER AND ASSOCIATE

Confidential, MD

Role & Responsibilities:-

• Worked closely with business team to analyze requirements, design code and develop technical solution. Performs complex data processing, ETL coding and programming using informatica/DB/Spark/Scala/Hadoop
• Designed and development of an efficient, scalable and robust applications handling large data sets and data exchange
• Participated in the full SDLC/Agile cycle engagements, including meetings, iterative development, estimations and design sessions
• Collaborate with Data Engineers, Platform Engineers and other Software Engineering resources in designing and implementing integrated, enterprise solutions
• Understand performance parameters and assess application performance
• Performed and support production jobs and processes
• Developed detailed specifications, design documentation and technical procedures
• Assured quality, security and compliance requirements are met and supported
• Research and identify root cause of complex production issues
• Prepared detailed specifications and ETL design documentation
• Strong understanding of Master Data Management (MDM), Operational Data Store, and DW/BI concepts
• Performed complex development tasks for ETL solutions using legacy and cloud based tools as required and build, deploy, and support all the deliverables
• Support and enhance existing Informatica environment and developing new, complex ETL processes

  to support additional design, development, and deployment of the Enterprise Master Data

  Management system

• Strong Understand of requirements, build the codes, support testing and fix defects, guide junior developers in the course of development activities in order to develop high standard stable codes within the limits of clients processes, standards and guidelines.
• Analyze and evaluating data sources, data volume, and business rules
• Developed, test, and implement new and enhanced reports/tools, define new data aggregation views, working with key stakeholders to develop and enhance the quality and presentation of operational metrics, trend analyses, and statistical models
• Developed and implemented the Informatica Mapping for the different stages like MDM, DB2 and Flat files.
• Fixed the invalid mapping's and troubleshoot the technical problems of the database
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse, MDM and DSS using Informatica Power Center 10.1.1/9.1.0/8.6.1 IDQ(Informatica Data Quality), Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor
• Hands on experience in handling data from various source systems such as MDM,Flat Files, XML Source, Oracle, IBM DB2 and Excel Files
• Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and using PMCMD commands.
• Have a clear understanding of Master Data Management (MDM), Operational Data Store, and DW/BI concepts.
• Having knowledge on how to fetch data from MDM Repository and staging and stored data in MDM database.
• Working on MDM staging and use to perform operation and finally load data in MDM table, DB2 and flat files as per the requirement
• Experience in root cause analysis and defect diagnosis techniques
• Experience working with Oracle database and ERP Systems
• Experience coordinating testing activities and optimizing test cycles working with project team
• Maintain high ethical standard in dealing with sensitive data

Confidential

Role & Responsibilities:-

• Working as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.
• Interacts actively with Data Modelers on Mapping documents and design process for various Sources and Targets and the relationship involved in physical, logical design data models.
• Interaction with business analyst to understand the requirement.
• Estimation and requirement gathering.
• Analyzing the application system and their source databases
• Analyzing business information requirements
• Data Analysis
• Review with business and validate the requirement
• Creating External Table in Oracle database
• Data Extraction from all source application
• Mapping, Sessions & Workflow creation
• Validating the testing strategy to validate the data
• Hands on experience in handling data from various source systems such as Flat Files, XMLSource, Oracle, MS SQLServer, IBM DB2, Teradata and Excel Files
• Expert Developer skills in Teradata RDBMS, initial Teradata DBMS environment setup, development and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.
• Implementing the application in production
• Software Testing including Unit, System and System Integration Testing, Test case/data preparation and execution
• Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Created and tested Informatica mappings and workflows to automate Job scheduling.
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement
• Created sessions, batches for full and incremental load into staging, TDH and EDW tables, and schedule them to run daily/weekly/monthly.
• Developed various Mappings with the collection of Sources, Transformations, and Targets, using designer.
• Extensively worked on Performance tuning to increase the throughput of the data load (like read the data from flat file & write the data into target flat files to identify the bottlenecks).
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Queries, labels and deployment groups to migrate the code from different environments.

Confidential

Role & Responsibilities:-

• Created complex technical solutions and design utilizing ETL tool (Informatica) and other technologies.
• Understanding of the Business requirement.
• Analysis, Designing & Creating of database objects.
• Reading Flat Files, SQL Server Using Informatica Tool.
• Loading multiple dimensions and fact using Informatica mapping
• Used various transformation lookup, joiner, sequence generator, router, filter etc.
• Developed Slowly Changing Dimension (SCD) type 1 for Employee Dim
• Used mapping & session parameter variables
• Unit Testing, performance testing
• Identified the granularity level of the data required to be available for analysis.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Developed ETL processes using the various data warehousing software. Maintained ETL metadata and document all business rules.
• Seek out best practices to find opportunities for improvements in develop processes and makes recommendations for implementation.
• Developed mappings according to the technical documentation and confirming to the business rules
• Created tables, views, indexes, sequences in development and test environment. DBA activities also included altering tables, dropping tables, checking database space and performance tuning.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.

Confidential

Role & Responsibilities:-

• Understand the Agile Methodology, go through the assigned story and description.
• Perform cleansing and integration operation.
• Update Version and story progress with the descriptive information.
• Analysis of Source System & Processes.
• Study the procedures & T-SQL code which is mainly involved in the story.
• Involved in code Migration.
• Involved in the designing and implementation of the mappings for stage to data warehouse data loading.
• Used the Components such as TMap, TFilterRow, TJoin, TFilterColumns, TaggregateRow, TLogRow and TWarn.
• Implement Durby memory connection.
• Create a mapping for handle insertion and updation operation using slowly changing dimension (SCD1).
• Create a mapping for maintain history and versioning using SCD2.
• Restore DB for Upgrade and New scenario as per the story test case.
• Test mapping to assure that data is loaded as per ETL Specification.
• Mainly involved in Manual Testing like Unit Testing as well as Functional Testing.
• Write descriptive test cases for the Functional Testing with the scripts (ORACLE and SQL) as per the story specification.
• Performed Automation Testing using SILK tool.

Confidential

Role & Responsibilities:-

• Responsible for identify & investigate the root cause of Workflow/session failure in both informatica & UNIX environment.
• Handle the most critical SLA workflows like subcount, KPI, make sure to complete within time.
• Investigate the workflows & helped in its performance tune using informatica power center designer.
• Analysis of Source System & Processes.
• Fixing the failure from UNIX environment.
• Managing the informatica repository servers (Dev, Test, Pre Prod, and Prod).
• Solving the Severity tickets opened up in AOTS.
• Scheduling/ unscheduling the jobs via crontab.
• Use of informatica workflow monitor to track the workflow status.
• Documenting the workflow & job flow.

Confidential

Role & Responsibilities:-

• Extract the flat file and database tables from server.
• Perform cleansing and integration operation.
• Create mappings standardize the data.
• Worked as ETL Developer in Data loading Phase from operational system of records into Data Warehouse
• Analysis of Source System & Processes
• Involved in the designing and implementation of the mappings for stage to data warehouse data loading.
• Used the transformations such as Source qualifier, Lookup, Update Strategy, Aggregator, Expression, Filter and joiner.
• Perform Debugging and Tuning of mapping and sessions.
• Scheduling of sessions.
• Create a mapping for handle insertion and updation operation using slowly changing dimension (SCD1).
• Create a mapping for maintain history and versioning using SCD2.
• Test mapping to assure that data is loaded as per ETL Specification.
• Perform Unit Testing and write test cases for the same.

Confidential

Role & Responsibilities:

• Import the project.
• Mapping issue fields.
• Mapping multi value attributes and import issue.
• Study about the database Project by internet.
• Develops the JIRA API Plug-in.
• Worked on SDK 1.6, JIRA issue tracking tool, Apache velocity module, Eclipse IDE, JIRA API, TrakIT Issue Tracking Tool. (Project By Net)
• Transfer TrakIT Bug base to JIRA.
• Manage the Database and access authentication.