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 requirement solutions using ETL tools like Informatica, Datastage and Talend. Having hands on experience as ETL Development in Healthcare, Banking and Telecom 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 Relational, 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 using Informatica Power Center 10.1.1/9.1.0/8.6.1 . 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.
• 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.
• Having experience to generate a Microstrategy Reports as per the requirement in TEST, QA and PROD Env.
• 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.
• 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.
• Hands on work experience Scrum, Agile and Waterfall methodology.
• Involved in Data Modeling using ERWIN tool.
• Good Understanding on Schema designed like snow flex and star schema.
• Good Analytical and problem solving skills. Able to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS

ETL Tools: InformaticaPowerCenter 10.1.1/9.1.0/8.6.0/8.1.1/7.1.1/6.2 , Informatica Data Quality 8.5

Data Modeling: Erwin 7.2/4.0/3.5

Databases: Oracle10g/9i/8i, MDM, MS SQL Server 2010/2008/2005/2000 , IBM DB2/UDB

Languages: SQL, PL/SQL, SQL*Plus, HTML, UNIX, DBMS, C, C++

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

Operating Systems: UNIX, Windows (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

Confidential, Woodlawn, MD

Sr. Software Engineer (ETL Developer)

Responsibilities:

• Worked closely with business team to analyze requirements, design code and develop technical solution.
• Create Informatica mapping and do Enhancement on old mapping according to the business requirement.
• Create and Send Migration detail form with Workflow details and child count to the Infra Team.
• Update SDD documents for ETL process including workflow, session and mapping details.
• Developed detailed specifications, design documentation and technical procedures
• Prepared detailed specifications and ETL design documentation
• Strong understanding of Operational Data Store, and DW/BI concepts
• Support and enhance existing Informatica environment and developing new, complex ETL processes to support additional design, development, and deployment of the Master Data Management system
• Strong Understand of requirements, build the codes, support testing and fix defects according to client standards and guidelines.
• Analyze and evaluating data sources, data volume, and business rules
• Developed and implemented the Informatica Mapping.
• 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 using Informatica Power Center 10.1.1/9.1.0/8.6.1 , 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, Oracle, DB2 and JSON.
• 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.
• 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 Files.
• Experience coordinating testing activities and optimizing test cycles working with project team.
• Checking data format for JSON and Involved in create test scenarios for JSON file.
• Maintain high ethical standard in dealing with sensitive data

Confidential

Technology: Informatica 9.1, Unix, PL/SQL, Clarity PPM, autosys

Sr. ETL Informatica Developer

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
• 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

Technology: Informatica 9.1, Toad, MS Excel, Putty

ETL Developer (Datastage)

Responsibilities:

• Created complex technical solutions and design utilizing ETL tool (Datastage) 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
• Implementing Industry ETL standards and best practices, performance tuning during designing the Datastage Jobs
• Involved / used several software’s for taking code from source & for deploy process.
• Developed/Modified Parallel jobs using Parallel stages like: Dataset, Sequential file, Funnel, Filter, Modify, Merge, Join, Lookup, Transformer and External Source Stage.
• Implemented data extraction, transformation and load processes in a parallel framework. 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

Technology: Talend(TIS),Oracle10g, T-SQL, Silk(Automation tool),MS Access

ETL Developer and Testing

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

Technology: Informatica 7.1.2, 8.6.1, Oracle 9i, UNIX, crontab, AOTS.

ETL Developer

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

Technology:Informatica 7.1.1, Oracle 9i, BO.

ETL Developer

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.
• Having strong work experience as Business Objects Developer.
• Having experience in creating Adhoc reporting ready universes usingBusiness Objects Universe Designer.
• Extensively used various features likeJoins, Aliasin Universe designer to overcome varioustraps (Chasm, Fan)and Loops.
• Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Experience in building and retrieving data usingUniverses, Personal data files,and creating complexad-hoc Reportsusing theBusiness Objectssuiteapplications.
• 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

Technology: JIRA, TrakIT, Java, SQL Server 2005, Apache Velocity Modules, Maven PDK.

Jr. ETL Informatica Developer

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.