Informatica / ETL Developer Resume

\Summary of Qualifications:

Over 7 years of IT experience in Design, Develop, Test and troubleshoot various software and Business Intelligence applications
Experience in various Industry verticals like Retail, Manufacturing, Healthcare, Finance, Telecommunication with appropriate DW/ETL Implementations
5 Years of strong Data Warehousing experience specializing in RDBMS, ETL, data modeling and data warehousing techniques
Expertise in the ETL Tool Informatica which includes components like Power Center, Power Mart, Power Connect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager, Repository Server Administration Console, IDE - Informatica Data Explorer, IDQ - Informatica Data Quality
Experience in working with various Data Sources and targets such as Sybase, Oracle, MS Access, MS Excel, MF COBOL EBCDIC Files, Flat Files, XML Files, DB2, Netezza, SQL Server, Teradata, etc.
Strong knowledge in RDBMS concepts and expertise in creating and maintaining database objects such as tables, indexes, views, materialized views, triggers, synonyms, partitioning techniques at the table and database level, stored Procedures, functions, etc.
Expertise in SQL and PL/SQL programming.
Thorough understanding of configuration, administration and upgradingInformatica.
Proficient in creating entity relational & dimensional relational data models using Kimball Methodology i.e. StarSchema and Snowflake Schema. Experience in Dimension and Fact table loading and data load validations.
Expertise in performance tuning ETL code, mapping, session and Database.
Expertise on integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of Type I, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
Extensive experience using Oracle 11g/10g/9i/8i, DB2 8.0/7.0/6.0,MS SQL Server 2008/2005/2000,Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, Netezza, MS Access 7.0/2000 database clients such as SQL server Management Studio and SQL Developer, SQL navigator, Toad, etc.
Performed Troubleshooting on failures using Informatica Debugger by working on the ETL Transformations step by step as well as fixed maintenance issues.
Individual driven by passion towards learning new things and working hard towards achieving goals

Technical Competencies:

ETL Tool:Informatica Power Center 9.1/8.x/7.x, Power Exchange, Metadata Manager, IDQ, IDE, etc.
RDBMS: Oracle 11g/10g/9i/8i MS SQL Server 2008/2005/2000, Sybase, DB2, Netezza, Teradata, etc.
Operating Systems: UNIX, Windows 7/Vista/XP/2003/2000/98/, Linux, etc.
Languages: SQL, T-SQL, PL/SQL, C, Perl, UNIX Shell Scripting, etc.
Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Visual Basic .Net/6.0/5.0, Java, HTML, DHTML, C, C++, Unix Shell Scripting, PERL Programming

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship