We provide IT Staff Augmentation Services!

Etl Analyst Resume

0/5 (Submit Your Rating)

San Diego, CA

SUMMARY

  • Overall 8+ years of IT experience, in implementing Data Warehouse applications and Business Intelligence applications including EDW/BI testing experience. Excellent knowledge of Data Warehousing / Data Mart designing.
  • Hands on Experience in Data warehousing tools like Informatica 7x, 8.6 and 9.1.0.
  • Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow
  • Good knowledge of RDBMS. Experience of Oracle RDBMS (SQL, PL/SQL), Application Development.
  • Good knowledge of Database Architecture.
  • Thorough understanding of all the phases of SDLC. Extensive knowledge in creating data marts using ETL tools such as Informatica.
  • Implemented slowly changing dimension (SCD) Type 1 and Type 2 mappings for changed data capture.
  • Experience with dimensional modeling using star and snowflake schemas
  • Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations
  • Designed and developed complex Informatica mappings for building a data mart from various data sources into Netezza using Informatica Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor) as ETL tool
  • Expertise in data analysis and validation.
  • Experience in upgrading of Informatica repositories from 7.x/8.x to 9.x versions
  • Experience in administration and configuration of Informatica in Unix using admin console.
  • Highly motivated team player that works with same merit in small as well as large teams. At the same time capable of taking sound decisions, extra responsibility and competent to lead the team as and when need arises.
  • Possess a good understanding of the various business processes in telecom domain.
  • Effective implementation skills of projects based on Onsite - Offshore model.
  • Possess good understanding of Database designing Transactional Database (OLTP) and OLAP Database.

TECHNICAL SKILLS

Primary Skills: Data warehousing (DWH)

Languages: SQL,PL/SQL,C,C++

ETL Tools: Informatica(7x,8x,9x)

Reporting Tools: QlikviewSAP4.0(Business Object)OBIEECognos

Databases: Oracle, Netezza, Composite

Domain Knowledge: Telecom

Version Control Tools: PVCS, Kintana

Project Management Tools: HP PPM, BMC

Quality Control Tool: HP Quality center

Job Monitor Tools: Control M, DAC

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior ETL Developer

Responsibilities:

  • Requirements gathering from users and analyzing feasibility of requirements for data mart
  • Preparing development requirements based on customer requirements and coordinates with client for requirements sign off
  • Analysis of existing ETL mapping, sessions and workflows, DB objects based on requirements
  • Preparing high level and low level design documents based on customer requirements
  • Scheduling meetings with client for any clarifications of requirements
  • Design of ETL mapping, sessions, workflows and DB objects and unit testing.
  • Responsible for design and development of Task Datamart
  • Providing assistance to business users during customer acceptance testing and coordinates for resolving the issues that are identified during testing.
  • Coordinates for production migration of the developed code and responsible for data validation post production.
  • Expertise in data validation
  • Monitoring Prod ETL load
  • Support and fix ETL production issues if any

Environment: Informatica 9.1.0, Netezza, Oracle, SQL, PL/SQL, Control M, Windows 7, Servicenow, Jira, Composite

Confidential, San Diego, CA

ETL Analyst

Responsibilities:

  • Responsible for developing/enhancing the existing ETL/DB objects/QV reports as per business/functional requirements
  • Analyzing the issues at ETL/DB objects and providing optimum solutions to customers
  • Preparing technical spec documents based on functional requirements and uploading to share point and ITGs
  • Modifying the existing ETL/DB Views as per the requirements
  • Uploading the script documents to PVCS for maintaining the versions
  • Documenting the unit test cases and test results and attaching to Quality center and ITGs
  • Creating kintana packages/deployment groups for migrating the code
  • Migrating the code to all non-prod environments
  • Knowledge Transfer of the project functionalities to the offshore team members of the project whenever necessary
  • Coordinating the requirements to offshore
  • Scheduling meetings with offshore whenever necessary
  • Scheduling meetings with client for any clarifications of requirements
  • Reviewing the code done by offshore
  • Responsible for production migration of developed code
  • Responsible for doing QA for few of the projects (SO flow testing/row level security/Item validation)
  • Responsible for uploading QA test cases and test results to quality center

Environment: Informatica 9.1.0, Netezza, Oracle, SQL, PL/SQL, Control M, Windows 7, Quality center, Kintana, Business Objects, Qlikview, PVCS, HP PPM

Confidential

ETL Lead

Responsibilities:

  • Performing gap analysis between OV and MDW systems. Analyzing existing OV BO reports and OBIEE reports. Analyzed new calendar changes as per business requirements
  • Documenting the requirements, technical design, test results as Short form Project Document and uploading into google drive.
  • Modify the existing ETL components and building the new components as per the requirements. Creating transformations like Normalizer, Router, Lookup, Expression, Sequence generator and Update strategy, reusable mapplets and transformations and used them in mappings. Created sessions and workflows required to load the data from ERP applications to staging tables and then to target tables. Executed the workflows through tasks and execution plans in DAC.
  • Responsible for Customer Acceptance Testing and Production Release
  • Maintaining all project related documents to compass/Google Drive

Environment: Informatica 8x/9.1.0, Oracle, SQL, PL/SQL, DAC, Windows 7, OBIEE, Compass Drive, kintana

Confidential

ETL Lead

Responsibilities:

  • Responsible for upgrading various applications like ENGDW, GSMDW, EDW, MDW from PC 8.1/ PC 8.6 to PC 9.1.
  • Responsible for upgrading the applications QMART, WDA from PC 7.1.3/ PC 8.1 to PC 9.5.1 in a sequence i.e, from PC 7.1.3 to 8.1, 8.1 to 9.1.0, 9.1.x to 9.5.x
  • Scheduling the calls with development teams and Confidential management whenever required
  • Preparation of checklist documents for pre upgrade and post upgrade tasks, Installation tasks, design documents with current and To be architectures
  • Validation of server configurations
  • Installation of Informatica 9.5.1 in Linux server and PC 7.1.3/PC 8.1 Repository backup activities
  • Verification & Validation of Informatica Mappings and Workflows which includes testing all the business critical workflows and validating the data post-upgrade.
  • Provide the access/Privileges in PC 9.5.1, in similar to the privileges as in PC 7.1.3/PC 8.1 and changes to the scripts for changing the Informatica Home directory path location.
  • In-Flight Code movement from PC 7.1.3/ PC 8.1 Dev & UAT to PC 9.1/9.5.1 environments.
  • Raising SR’s to Informatica and Oracle whenever required and communicating the risks to management whenever identified.
  • Preparing the checklists, test cases and test results document, KT documents, Implementation plan, Back out plan, Downtime request documents and uploading into google drive.
  • Mail communication to the development team regarding downtime of applications during production upgrade.
  • Post upgrade support
  • Knowledge Transfer of the project functionalities to the new members of the project whenever necessary

Environment: Informatica 7x/8x/9x, Informatica Admin console, Unix, Oracle, SQL, PL/SQL, DAC, Windows 7, Kintana, Compass drive

Confidential

ETL & Cognos/BO Developer

Responsibilities:

  • Performing requirement analysis and developing or modifying the database/ETL or report components
  • Creating mappings, sessions and workflows as per the requirements and loading data to oracle database. Perform unit and system testing of the modified components.
  • Tuning the mappings to achieve better performance
  • Modify BO universe/cognos Framework manager to add the new data elements.
  • Conversion of Impromptu, PHP script based reports to cognos8 reports
  • Creation of new BO reports
  • Monitoring of scheduled jobs in Arcana.
  • Performing KT session on the developed report and universe changes to Support team
  • Knowledge Transfer of the project functionalities to the new members of the project whenever necessary.

Environment: Informatica 8x, Unix, Oracle, SQL, PL/SQL, Windows 7, Kintana, Cognos, Business Objects, BMC Remedy, Arcana

We'd love your feedback!