Informatica Developer Resume

SUMMARY:

Over 14 years of solid professional and diversified experience (Healthcare, Financial, Mortgage, Risk management and products) in architecture, designing, development, support, integrating ETL solutions for Enterprise Datawarehouses. Extensive hands - on experience in ETL, Data design, Data modeling and SDLC methodologies, analyzing complex sources, data cleansing, mapping datasets to appropriate business models, transforming and loading the data into complex high-volume UNIX environments.
Extensive programming skills in Informatica, Informatica MDM 9.6 (Data Quality, Data Integration and BPM), Ab initio, SQL, PL/SQL, SAS, SAS Basics, SAS 9/SAS Enterprise, SAS Procs, Proc compares, Qlikview, and AIX/UNIX.
Hands on experience with ETL tools, data warehousing, data modeling and methodologies
Working knowledge and Hands on experience of Big Data, Hadoop file systems, HIVE and PIG.
Good understanding about various Dashboard reports, scorecards and SAS scripts.
Worked with several databases - ORACLE, DB2, TERADATA and SQL SERVER
Worked different scheduling tools like Autosys, CA7 and Control M.
Strong technical experience in designing large data warehouse, ETL application development and enhancement projects on Agile methodology.
Worked several assignments on multiple financial services divisions (cards and banking).
Worked on Federal funded MATRIX, Watercrafts, Corps, UCC, DEA Registrations and SEC Brokers & Dealers projects.

TECHNICAL SKILLS:

TOOLS: Informatica Power Center 9.X.X, Informatica Powercenter 7.1.2, Informatica Powercenter 8.1, Informatica Powercenter 8.5, Informatica Powercenter 8.6, Informatica Designer, Informatica workflow, Informatica monitor, Infortmatica Repository, Ab initio, SQL Server, SSIS, SSAS, SSRS, Oracle, Teradata, DB2, Teradata SQL Assistant, Fastload, Multiload, BTEQ, JTNM, Microsoft office Visio 2003, SAS scripts, SAS, SAS 9.0.2, SAS Enterprise

Hardware: HP UNIX NCR 5100, Alpha 4/233, SUN OS 5.8

O/S: UNIX, AIX, Linux Servers, Open VMS, Windows NT 4.0

Languages: ECL, COBOL, JAVA, C, C++, SQL and PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

Hands on experience with ETL tools, data warehousing, data modeling and methodologies
Working knowledge and Hands on experience of Big Data, Hadoop file systems, HIVE and PIG.
Good understanding about various Dashboard reports, scorecards and SAS scripts.
Worked with several databases - ORACLE, DB2, TERADATA and SQL SERVER
Worked different scheduling tools like Autosys, CA7 and Control M.
Strong technical experience in designing large data warehouse, ETL application development and enhancement projects on Agile methodology.
Worked several assignments on multiple financial services divisions (cards and banking).

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship