We provide IT Staff Augmentation Services!

Sr.etl Informatica Developer Resume

4.00/5 (Submit Your Rating)

Austin, TX

Hire Now

PROFESSIONAL SUMMARY

  • Around 7+Years of IT Experience in Development and Implementation of Data Warehouses using ETL Tool Informatica Power Center 9.5.1/9.0/8.x/7.x/6.0, Oracle 11g/10g/9i, SQL, PL/SQL.
  • worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
  • Experience in Requirement Analysis, Gap Analysis, Data Cleansing, Data Relationships, Source Systems Analysis and Reporting.
  • Good knowledge on Dimensional Modeling using Star schema and Snow Flake schema for faster, effective query processing and Business Analysis Requirements.
  • Experience in development and design of ETL methodology for supporting data transformations and processing in corporate wide ETL Solutions using Informatica Power Center 9.x/8.x/7.x.
  • Strong technical exposure with good degree of competence in business systems like HealthCare, Insurance, Retail Sales andBanking.
  • Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
  • Experience in performance tuning of sources, mappings, targets and sessions.
  • Worked on Parameter file to initialize the mapping variables and workflow variables.
  • In depth knowledge of Oracle Database.
  • Well versed with complete SDLC i.e. System study, Requirement gathering, Analysis, Design, Development, Testing, Implementation and Application support.
  • Experience with multiple data sources and targets including Oracle, DB2, SQL Server, and flat files.
  • Good Exposure on Web Services SOAP, REST Full architectures.
  • Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
  • Good knowledge and Experience on web development frame works Ruby on Rails and their data models
  • Extensive design and development of transformations; Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner, and Union.
  • Design and development of re - usable mappings, and mapping specifications.
  • Expertise in configuration, performance tuning, installation of Informatica, and in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
  • Proficient in using Workflow Manager Tools like Task Developer, Workflow, Designer and Worklet Designer.
  • Excellent team player with good organizational, communication, interpersonal & analytical skills. Possess strong ability to quickly adapt to new applications requirements, processes, platforms and languages.
  • Quick learner with the ability to work in a fast-paced environment.

TECHNICAL SKILLS:

ETL Tools: InformaticaPower Center 9.5/9.0/8.6.1/7.1(Designer, Manager, Workflow Manager), Power Exchange, Informatica Data Quality 9.1 (IDQ).

Database: Oracle 11g/10g/9i, Teradata, DB2, SQL Server 2000, MS Access, MySQL

Operating Systems: Unix, Windows 2000/NT 4.0 Server

BI & Reporting Tools: Business Objects 6.5/5.x (Designer, Supervisor)

GUI: Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

Web Technologies: C,SQL,PL/SQL, PHP, HTML

Testing Tools: Win Runner, Load Runner, QTP 8.2

Web/App servers: Internet Information Server, JWS, Apache Web server, Web Logic

Additional Tools: Erwin, Toad, SQL Navigator, ControlM, Autosys, Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

PROFESSIONAL EXPERIENCE:

Confidential, AUSTIN, TX

Sr.ETL Informatica Developer

Responsibilities:

  • The goal of the project is to provide an enhanced data load process and adhoc reporting capabilities for the selected Business Users for the Provider Data group repository.
  • It also includes a redesign in the existing schema for the new business requirement.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship