Sr. Informatica Developer Resume
Columbus, OH
SUMMARY:
- SDLC: Over 7 years of IT experience in F ull life cycle of Software Development (SDLC) including Business Requirement s Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance, Support and Documentation
- ETL: 7 +years of Data Warehousing experience using Informatica Power Center 9.5/9.1/ 8.6.1/ 8.5/ 8.1.1/8.0/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository M anager), PowerConnect, Power Exchange 8.6, ControlM 6.4, Autosys 3.4.4, TIDAL, SQL, PL/SQL, S tored Procedures, Triggers, etc.,
- Vast experience working on the various transformations - Aggregator, Expression, Sorter, Joiner, Rank, Filter, Router, Lookup, U pdate S trategy, etc.Excellent understanding of Data warehousing Concepts - SCD Type1/Type2, CDC, Surrogate Keys, Normalization/De-Normalization, Dimension & Fact tables.
- Data Modeling: 3 years of Dimensional Data Modeling experience using ER win 7.2/4.5, ER/Studio v7. Sound knowledge on Dimensional Modeling, Ralph Kimball and Bill Inmon Methodologies, Star/Snowflake schemas, Data Marts, Facts & Dimensions, Logical & Physical data modeling.
- Business Intelligence: 3 years of Business Intelligence experience using Cognos, Cognos Impromptu Web Reports (IWR), Cognos Report Net 1.01/1.1(Report Studio & Query Studio, Cognos Frame Work manager, Adhoc, Business Objects XIR2/XI/6.5/6.0/5.1, (Web-Intelligence 2.5, Designer 5.1, BO Developer Suite, Broadcast Agent, Supervisor, Designer, Info View, BO Universe Developer, BO Supervisor, BO Set Analyzer 2.0), Crystal Reports 6.x/5.x/4.x/3.x
- Databases: 7+ years of experience using Oracle 11g/10g/9i/8i, DB 2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0, Teradata V2R6/V2R5, Teradata SQL Assistant, MLoad, Fastload, BTEQ, Fastexport, TPump, Sybase 12.x/11.x, SAP R/3, MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer
TECHNICAL SKILLS:
Data Warehousing: Informatica Power Center 9.5/9.1/8.6.1/8.5/ 8.1.1/8.0/7.1 (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Admin Console). PowerConnect, ControlM, Autosys, Cobol, Data Mining, Data mart, OLAP, OLTP, SQL* Plus, SQL*Loader, TIDAL
BI Tools: Microstrategy 8.1.2/9.1, Cognos Impromptu Web Reports (IWR), Business Objects XIR2/XI/6.5/6.0/5.1, Crystal reports 10x.
Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos.
Databases: Teradata 12/13.0/14,Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, TOAD, SQL*Plus, SQL*Loader, MS SQL Server 2005/2000/7.0 /6.0,Teradata V2R6/V2R5/R4.1/R4/R3, Teradata SQL Assistant, MLoad, Fload, BTEQ, Fexport, TPump, Sybase 12.x/11.x, MS Access.
Data Modeling: Dimensional Data Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.2/4.5, Oracle Designer, Visio and Sybase Power Designer.
Programming: C, C++,.NET,C#,SQL, PL/SQL, sql*plus, T-SQL, ANSI SQL, SQL Scripting, HTML, DHTML, Unix Shell Scripting, Kernel Programming, Mainframes VSAM, PERL Programming.
PROFESSIONAL EXPERIENCE:
Confidential,Columbus,OH
Sr. Informatica Developer
Responsibilities:- Successfully migrated and decommissioned 15 tables to help the reporting team to use a single source of truth.
- Created data models and updated the Meta data for future references.
Environment: Used: Informatica 9.5, Oracle 11g, Teradata 14.10, Linux, Erwin 9.2,Toad Data point, Microsoft Office 2010, Teradata Viewpoint, Salesforce.
Confidential,Phoenix,AZ
Sr. Informatica Developer
Responsibilities:
- Involved directly with the Business and Business Analyst to create DMD’s and handling the BRD’s. Developed the ETL processes using Informatica Power Center to load data into the oracle database from Flat Files.
- Developed shell scripts to handle file watcher, file transfer using (SCP, SFTP), trigger the process and sending email task based on file availability.
- Worked as an ETL Admin and production support on rotation basis during the implementation of project.
- Developed mapplets and reusable transformations to reduce the redundancy of transformation usage.
- Successfully implemented Credit Data Mart, by creating a new design altogether which made the project to go live successfully on time.
- Worked on performance improvements of old ETL objects to decrease the production load time.
Environment: Used: Informatica 9.0.1, Oracle 11g, SVM, Unix, Visio, Microsoft Office 2010, Toad, Autosys, Clear quest .
Confidential,Bentonville,AR
Sr. Informatica Developer
Responsibilities:- Converting logical data model to Physical data model in RSA and script generation for DBA’s.
- Created mapping document (TSD) from high level design.
- Implemented Change Data Capture using Informatica Power Exchange 9.1.
- Managing development team in offshore and provide status to senior management.
- Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using PowerCenter and PowerExchange.
- Developed mappings, workflows to pull data from Informix.
- Deployment of ETL and DB changes to higher environments.
- Used TOAD and MS SQL Server to run SQL queries and validate the data in warehouse and mart.
- Performed Unit Testing and Component Integration testing before handing over the code to QA
- Supported QA and UAT phases.
- Design and Development of UNIX Shell Scripts.
- Debugging and Defect fixing of Mappings.
- Review of mappings and workflows developed by Peers and report the defects.
- Created documents to hand over the project to support team.
Environment: Used:Informatica 9.1, Oracle11g, Informix, OBIEE, UNIX, RSA, Teradata SQL Assistant. SQL Server, Windows, Toad 10.0, SQL Developer 3.0, WinScp, Putty Confidential,San Jose,CA
ETL Developer
Responsibilities:
- Lead a team of 5 members to do the ETL Design and Development.
- Designed ETL process to handle intraday transactions from the source and building an SCD in Teradata.
- Interact with Data Modelers to understand and finalize the conversion strategies.
- Interaction with the Business Partners to understand the business of the application, gather requirements analyzed and put into technical design documents.
- Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql queries.
- Worked on performance improvement for weblogs project. Redesigning the existing ETL’s to use pushdown optimization and use TPT instead of regular Teradata utilities.
- Came up with new design templates to create the ETL components.
- Managed the account to grow from 2 onsite, 5 offshore to 5 onsite and 34 offshore developers.
Environment: Used: Power Center 8.6.1, UNIX Shell, Flat Files,Agile, SQL Server, Teradata, ESP, Remedy, TFS, Salesforce.
Confidential
Developer
Responsibilities:- Involved in creation of Bill of Material (BOM) Module for Component Information System.
- Monitored a central / secure CIS Repository, Advanced Component Search Capability which provides central repository of components used in projects.
- Developed complete Module and coded for Shristi Web poll application.
- Designed process flow for Shriti’s as per the flow charts provided by the TL and PL.
- Involved in creation of complete Module and coded for signal integrity effort estimation tool.
- Was able to restore the CIS application up and running which was not used for few years.
Environment: Java/J2EE- Servlets, Struts, Tomcat Web Server,Oracle, Win Runner, Test Director, Windows 2000