We provide IT Staff Augmentation Services!

Etl Developer Resume

Irvine, CA

PROFESSIONAL SUMMARY:

  • 8 Years of IT experience as a ETL developer(Informatica) & Systems Analyst/Tester in Manual and Database testing applications developed in .NET, Java, and Oracle, SQL Server on Windows.
  • Involved in development of several test plans and test scripts. Experienced in all phases of testing life cycle which is included defect tracking and reporting as well as documentation and execution of test plans, test cases.
  • Experience in Data Integration and ETL expertise using Informatica Power Center
  • Good experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web based applications, Data Warehousing and Business Intelligence solutions
  • Excellent working knowledge of System Development Life Cycle (SDLC), Software Testing Life Cycle (STLC)
  • Have good experience on database query tools such as TOAD, Rapid SQl, SQL Plus and PL/SQL
  • Good knowledge of data warehousing concepts and familiarity with data modeling concepts.
  • Experience in Data Analysis, Data Cleansing(Scrubbing), Data Validation and Verification, Data Conversion, Data Migration
  • Good Knowledge on Erwin modelling with logical and physical schema developing
  • Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Expression, Router, Aggregator, Union Transformation, Update Strategy, Filter, Normalizer, Joiner, Xml transformation (XML parser, XML Generator) Rank, Stored Procedure, Sorter and Sequence Generator.
  • Expert in designing and developing Workflows, Sessions and other tasks using Work flow manager tools Task Developer, Workflow & Worklet Designer to handle different load scenarios.
  • Knowledge in IDQ, Analyst tool and power center including build in rules, name matching and address validation.
  • Experience in debugging the issues using Informatica Workflow manager, Informatica Workflow monitor, Autosys and database.
  • Proficient in working with UNIX shell scripts using PUTTY Environment.
  • Involved in jobs scheduling using Autosys, monitoring
  • Good experience in creating mappings on Power Center Designer, tasks in Workflow manager, workflow monitor
  • Well versed in Black box and DB testing
  • Involved in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, Defect status reports, and Test Summary report
  • Experience in testing Entertainment, manufacturing and financial Applications
  • Experience in Integration, System, Navigational and Unit testing
  • Specialized in testing of both WEB applications and Client/Server applications
  • Specialized in testing on both WINDOWS and UNIX environments
  • Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking, versatile team player and capable of working independently

TECHNICAL SKILLS:

Database: Oracle10/11g and SQL server, INFORMATICA 8.x/9.x,IDQ,Informatica cloud services

Languages: SQL, PL/SQL, Unix Shell Scripting

QA Tools: Manual Testing, QTP(Beginner), HP Quality Center

Documentation: MS Word, MS Excel, MS PowerPoint, MS Projects, Visio, Share Point

Business Intelligence: Tableau

Operating Systems: UNIX, MS - DOS and MS-Windows Family

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

RESPONSIBILITIES:

  • Analyzed source systems and created mappings to the target database schema
  • Implemented the required business transformation rules and logic (ETL Development), developing data naming standards using the Informatica tool
  • Developed LLD and source to target mapping document
  • Worked on Informatica power center designer in developing source to staging and staging to target mappings.
  • Highly used filter, expression, Joiner, look up, router, update strategy transformations in developing business logic
  • Developed Design documents, various deliverables like sql scripts, power center mappings, jil scripts, unit test case document
  • Extensively worked with jil scripts and Autorep browser
  • Thoroughly used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Performed unit testing and conducted test results review meetings
  • Performed the code check-in to perforce
  • Participated in scrum ceremonies daily stand up’s, sprint planning and grooming and retrospective sessions

ENVIRONMENT: Informatica Power Center Designer, Informatica Workflow manager, workflow monitor, Tidal Scheduler, Oracle 11g-Toad, Perforce, HP Quality Center, UNIX

Confidential, Irvine, CA

ETL Developer

RESPONSIBILITIES:

  • Contributed to the project as ETL developer as part of building EDW solution.
  • Reviewed and analyzed business requirement documents, technical requirements and functional specification of various functionalities
  • Developed various artifacts LLD, Source to target mapping document, sql scripts, unit test cases across different phases of SDLC
  • Analyzed source systems and created mappings to the target database schema
  • Implemented the required business transformation rules and logic (ETL Development), developing data naming standards using the Informatica tool
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using ETL(Informatica) and provide technical support and hands-on mentoring in the use of testing
  • Developed workflows following the designed ETL architecture of source to target, target to consolidation and consolidation to target table by meeting the business requirements.
  • Involved in validating the source and target table structure against corresponding Mapping document
  • Thoroughly used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Performed manual testing of the functionality of the application by inserting data on different test runs
  • Active participation in all stages of Scrum Ceremonies: Daily Standups, Story grooming sessions, Retrospectives

ENVIRONMENT: Informatica Power Center Designer, Informatica Workflow manager, workflow monitor, Autosys, Oracle 11g-Toad, MS Access, Manual Testing, HP Quality Center, UNIX

Confidential

Programmer Analyst

RESPONSIBILITIES:

  • Contributed to data conversion project as ETL developer
  • Designed and developed workflows to convert .csv files delivered from mainframe to informatica, created source to target workflows and performed ETL operations to cleanse and consolidate data as per SAP requirements.
  • Developed workflows related to Vendor details, Customer details, Bank details with address, update several flags as per requirements, product specifications etc.
  • Wrote validation rules to perform various checks as per the project to make sure all the data loaded without issues.
  • Wrote SQL programs, Functions to extend new field attributes to the source data as per team requirements. Updated missing information by working BSA’s and coordinating with various teammates across the organization.
  • Worked with team in performing database validations and writing test scenarios to load the data into SAP by working with SAP ABAP developers. Wrote manual test cases to compare between source and target tables in ETL architecture.
  • Developed various artifacts LLD, Source to target mapping document, sql scripts, unit test cases across different phases of SDLC

ENVIRONMENT: Informatica Power Center Designer, Informatica Workflow manager, workflow monitor, Autosys, Oracle 11g-Toad, Db2, Mfg Pro, SQL, PL/SQL, SAP ECC 5.0, SAP MM/AP/AR/FICO, Manual Testing, HP Quality Center, UNIX

Confidential

Programmer Analyst

RESPONSIBILITIES:

  • Contributed to the project as ETL developer
  • Involved in complete project life cycle from requirements gathering to project go-live by delivering the required artifacts
  • Worked with BSA’s is gathering budgets file format to be implanted as part of Plan vs actuals tracking
  • Developed mappings and workflows and performed validations prior to loading to oracle database with versions.
  • Create batch process notifications to automate the jobs to run using autosys scripts
  • Involved in preparing unit test cases and receiving functional acceptance from BSA’s
  • Supported business users with by running workflows periodically in receiving the user acceptance
  • Coordinated with autosys jobs team to perform cutover activates and supported through the premium support period after go-live
  • Worked closed with architect and escalated the data issues and resolved timely to implement the solutions on time
  • Developed various artifacts LLD, Source to target mapping document, sqlscripts, unit test cases across different phases of SDLC
  • Also performed various database tester roles in the project to make sure all the data loaded without any issues.

ENVIRONMENT: Informatica Power Center Designer, Informatica Workflow manager, workflow monitor, Autosys, Oracle 10g, SQL, PL/SQL Toad, Windows Excel. Flat files (.csv), Manual / Database Testing, UNIX, BOBI Web Intelligence 3.1

Confidential

System Analyst

RESPONSIBILITIES:

  • Contributed to the project Database / Front end interface tester
  • Worked with product team, analysts to create list scenarios to perform database unit and functional testing
  • Create several front-end interface tests to validate various screens of the application
  • Developed templates to captures the test scenarios
  • Developed custom test scenarios between email notification workflows between product owners and vendors, customers.
  • Developed and documented the payment processing workflow scenario where the databases payments are captured and notified the payment successful process workflows
  • Performed Smoke, Functional, Regression testing
  • Defect logging and tracking using HP QC
  • Performed data validation and back end testing using SQL
  • Involved as part of the project in weekly status meetings.
  • Worked with performance testing team by providing various technical, functional test scenarios to include as part database to capture performance of the application.

ENVIRONMENT: .net, Oracle, 10g, Database/Manual Testing, SQL, PL/SQL, HP QC

Hire Now