We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

3.00/5 (Submit Your Rating)

Cincinnati, OH

SUMMARY

  • Seven Plus (7+) years of total IT experience in teh Business Requirements Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Designing, Coding, Development, Testing and Implementation of Business applications wif RDBMS, Data Warehouse/Datamarts, ETL, OLAP, Client/Server environment applications for Insurance ( Confidential capitol and All State Insurance), Pharmaceutical ( Confidential and Sankyo Pharmaceuticals), Financial and hospitability (Whyndham World Wide, Confidential, Common Wealth and Confidential Aviation ) Verticals.
  • Seven Plus (7+) years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 8.6/8.0/7.1.1/7.1.3/7.0/6.2/5.1, Informatica PowerMart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server), PowerConnect, PowerPlug, Power Analyzer, PowerExchange, SuperGlue, ETL, ETI, Datamart, OLAP, OLTP
  • Four Plus (4+) years of Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT & Dimensions tables, Physical & logical data modeling, ERwin 4.5/4.x/3.0.
  • Five Plus (5+) years of experience working on Business Intelligence tools like Business Objects 6.5/6.0/5.1/5.0 (Web - Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Cognos Series 7.0/6.0/8.0.
  • Four plus (4+) of unix shell scripting experience, worked on korn, bourn and c shell .
  • Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
  • Three Plus (3+) years of Hands on Experience working wif scheduling tools like Autosys, Control M, Maestro, UC4 Cleansing tools like Trillium 7.0, Firstlogic.
  • Seven Plus (7+) years of Database experience using Oracle 10g/9i/8i/8.x/7.x, DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2005/2000/7.0/6.5, Sybase 12.x/11.x, MS Access 7.0/2000, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x. Strong Experience to databases SQL, PL/SQL, SQL*PLUS, SQL*Loader, DBMS Packages, TOAD & ODBC interfaces to Oracle

TECHNICAL SKILLS

Dimensional Data Modeling: Dimensional Data Modelling using Star & Snow Flake schema. Extensive Experience wif Ralph Kimball and Bill Inman Methodologies. Designed Data models using Erwin 4.5/4.0/3.5, Oracle Designer 2000 and Visio

Data Warehousing: Informatica Power Center 8.6/8.0/7.1/6.2/6.0/5.1 (Workflow Manager, Workflow Monitor, Worklets, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations,), Informatica Power Mart 6.2/6.0/5.1, Informatica Power Analyzer, Power Exchange, Metadata Managaer, ETL, PowerConnect, ETL, OLTP, OLAP, Autosys, Control M, Maestro

Data Profiling: Trillium, Firstlogic

Business Intelligence: Cognos Series 7.0/6.0 (Impromptu & PowerPlay), Business Objects 6.5/6.0/5.0

Programming: SQL, PL/SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, C, C++, Unix Shell Scripting.

Data Bases: Oracle 10g/9i/8i/8.0/7.0, Oracle Report Writer, SQL, PL/SQL, SQL*Plus, SQL*Loader, Teradata V2R5/V2R4/V2R3, IBM DB2 8.0/7.0, MS SQL Server 2005/2000/7.0/6.5, MS Access 7.0/2000

Environment: MS DOS 6.22, Win 3.x/95/98, Win NT 4.0, 2003/2000/XP, SCO Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, CINCINNATI,OH

SENIOR INFORMATICA DEVELOPER

Responsibilities:

  • Had to create pre map to update duplicate indicator column in teh item stage table
  • Had to write shell scripts
  • Had to place teh sessions inside teh worklets
  • Had to create separate workflow for each session
  • Loaded teh data in QA
  • Tested teh data in QA database after loading
  • Tested shell scripts and maps by running teh PDW workflow
  • Had to delete unused sessions and maps in QA
  • Encripted item, line replaceable unit and product structure files and placed them in dev library
  • Had to catch duplicate part numbers and send them back to sites
  • Figured out why teh rows and files are rejected
  • Created score card and error report.
  • Created test case documents
  • Attended everyday PDW test meeting wif offshore team
  • I ran teh workflow in prod and I should not see errors in teh sesson log .
  • Zipped teh session logs and created load statistics.
  • Had to schedule meetings wif off shore team

Environment: Microsoft Windows XP professional 2002, Informatica Power Center 8.6.1, Oracle 11g,SQL developer v1.5.5,MS Office Professional Plus 2010

Confidential, CAMPHILL, PA

SENIOR INFORMATICA DEVELOPER

Responsibilities:

  • Attended meetings and got requirements and updates.
  • Created and updated maps, sessions and workflows.
  • Updated in teh Erwin model.
  • Did some data modeling in provider qualification subject area.
  • Did integration testing and UAT testing.
  • Created update maps as a part of integration testing .
  • Did documentation and placed it in teh common folder
  • Created stored procedures and imported into informatica.
  • Created and altered stage tables and temporary tables.
  • Copied maps from TFP into DEV and updated them.
  • Created new sessions and made it reusable.
  • Multitasked between 6 PCR’s.
  • Did testing by comparing -
  • Front end application wif cognos generated reports,
  • Datawarehouse tables wif application database tables
  • During testing loaded teh stage, temporary, dimension,halper and fact tables.
  • Had to communicate wif application team since there was no documentation.
  • In teh front end application there was no data so created query wif joins on application database.
  • Resolved teh issues during development along wif our team members.

Environment: Windows XP professional 2002, Informatica Power Center 8.6.1, Oracle 11g, Erwin 7.3.4, Benthic Software Gloden 32,Cognos 8

Confidential, NYC,NY

SENIOR DW INFORMATICA DEVELOPER

Responsibilities:

  • Migrated from oracle database to teradata database.
  • Created folders, groups and giving permissions.
  • Verified teh workflow in development according to CIF standards
  • Deployed teh workflow from development to testing and production.
  • Validated teh workflow in testing and production.
  • Started teh integration service for a folder.
  • Created, updated and deleted teh autosys jobs in development, testing and production using jil files.
  • Moved teh parameter files,shell scripts,environment files and dat files from development to testing and from testing to production.
  • Created teh inbound and outbound directories in teh testing and production for dat informatica folder.
  • Ran teh autosys jobs in production.
  • Marked teh autosys jobs as hold or success or fail or inactive or active in production.
  • Created relational connections in teh workflow manager for teh teradata database.
  • Created TNS names in tnsnames.ora.
  • Inserted teh records into ctl infa param and ctl interface tables in QA and production.
  • Executed SQL scripts in teradata database and oracle database.
  • Took teh DMR and CCB ticket requests from teh off-shore team and worked wif them to complete teh tickets
  • Worked wif off-shore team and communicated wif sametime chat software

Environment: Informatica Power Center 8.6.1,oracle 11g,linux - Red Hat 53,Autosys - R11 SP2,Toad 9,Edit Plus,Teradata V2R6,Lotus Sametime

Confidential, WHITE PLAINS,NY

SENIOR DW INFORMATICA DEVELOPER

Responsibilities:

  • Attended meetings and got teh business requirements.
  • Created and updated maps, sessions and workflows.
  • Tested teh maps moved them to production.
  • Did performance tuning of maps.
  • Wrote unix Korn Shell scripts for various purposes.
  • Installed filezilla software and sent teh files manually to WPS.
  • Created FTP scripts which automates file to and from WPS.
  • Replaced FTP scripts wif SSL scripts.
  • Scheduled teh workflows in teh workflow manager
  • Used informatica features to implement type II changes in slowly changing dimension tables
  • Called stored procedures in oracle as pre sql sesssion.
  • Created reusable failure and success email tasks.
  • Created dependencies between workflows using event wait task and OK files.
  • Sent files to WPS using filezilla software.
  • Supported all starcom and aeroplan jobs in production.
  • Wrote sql queries to patch teh records which were missing for jan 22nd and march 09th into teh base and fact table.
  • Catched ups of all informatica jobs along wif my team.
  • Created job status report in excel sheet during weekends.
  • Downloaded informatica power center 7.1 client.
  • Downloaded oracle 10g client and toad 9.0.
  • Upgraded from informatica power center 7.1 to informatica power center 8.1.1.

Environment: Informatica PowerCenter 8.1.1,Informatica PowerConnect 8.6 (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), Power Exchange CDC,PowerAnalyzer, ETL, Erwin 4.5, Flat files, Toad 9.0, oracle 10g, PL/SQL, unix commands,Excel and shell scripting, HP-UX 5.8, MS Windows XP professional 2002

Confidential, PARSIPANNY,NJ

SENIOR DW INFORMATICA DEVELOPER

Responsibilities:

  • Attended meeting and got business requirements from team lead.
  • Created parameter files for daily loads or monthly loads.
  • Wrote unix shell scripts to send success email as post session command.
  • Due to memory space issues, replaced look up transformations wif stored procedures and bridge tables.
  • When source table was altered, modified maps in teh downstream applications containing dat table.
  • Loaded teh data from source flat file into oracle table using oracle external loader in staged mode.
  • Fixed teh bugs using debugger in informatica.
  • Created maps of SCD type 2
  • Cleansed teh data present in site reporting level table wif a query.
  • Created cursors on smaller tables to improve teh performance.
  • Copied teh workflow from production to development using import and export.
  • Did unit testing by writing sql queries.
  • Maps were tested by teh off-shore team.
  • Created reconciliation reports using cognos.
  • Improved teh performance by performing calculations on chunks of data as it dealth wif 1 billion records present in DB2 tables.
  • Tuned teh maps by placing sorter before aggregator and checked sorted inputs.
  • Dropped teh indexes before loading teh table and recreated teh indexes after loading.

Environment: Informatica PowerCenter 7.1.1,Informatica PowerConnect, (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), oracle 10g,PowerExchange,PowerAnalyzer, ETL, Erwin 4.5, Flat files, Toad 7.4,Quest Central for db2 version 3.1.0, PL/SQL, unix commands, Excel and shell scripting, Unix SunOS 5.8, MS Windows XP professional 2002,Cognos 7

Confidential, STAMFORD, CT

SENIOR DW INFORMATICA DEVELOPER

Responsibilities:

  • Attended meetings and gathered business requirements.
  • Wrote PL/SQL procedures in MS sql server to get current and previous batch dates.
  • Fixed teh bugs using teh debugger.
  • Tuned informatica Map and Sessions for optimum performance.
  • Created autosys jobs and scheduled teh workflows.
  • Did unit testing and signed off unit test document.
  • Wrote a technical specification document.
  • Loaded teh data from WINS stage into WINS ODS.
  • Views were created on WINS ODS wif semantic column names and semantic table names.
  • Used changed data capture to get only updated and new records from policy and claims tables.
  • Supported teh WINS ODS jobs.
  • Before extracting procede data from ceded claim transaction detail, deleted procede data from ceded claim accounting month summary table by calling as pre sql session.
  • Loaded different types of financial data (WINS and PROCEDE data) from ceded claim transaction detail table into ceded claim accounting month summary table.

Environment: Informatica PowerCenter 7.1,Informatica PowerConnect, (Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager), PowerExchange, ETL, Erwin 4.5, Flat files, MS SQL Server 2005/2000, PL/SQL, Reporting Services 2005, Autosys, DOS commands, Excel and batch scripting, Perl scripting, DOS, MS Windows 2000

Confidential, PARSIPANNY,NJ

DW INFORMATICA DEVELOPER

Responsibilities:

  • Attended meetings and gathered business requirements.
  • Created logical and physical data models using Erwin 4.5 extensively.
  • Designed, developed and implemented of teh SSRDM.
  • Developed and documented data mappings/transformations, and informatica sessions as per teh business requirement.
  • Used debugger to test teh mapping and fixed teh bugs.
  • Developed mapplets using corresponding source, targets and transformations.
  • Tune informatica Mappings and Sessions for optimum performance.
  • Analyzed IMS Rx Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling.
  • Solely responsible for IMS Data and converting those to require structure using informatica.
  • Developed and tuned all teh Affiliations received from IMS and other data sources using informatica and tested wif high volume of data.
  • Resolved teh performance issues for IMS huge volume of data and increased teh performance significantly.
  • Teh employee table is a cobol source which had two columns first name and last name containing duplicate rows which are deleted using aggregator.
  • I has CDC power exchange to capture only teh changed data from teh customer sources and loaded customer dimesion.
  • I had IMS database source tables registered for CDC in power Xchange now using power center I has to create a map to load tables.
  • Worked wif offshore team and communicated wif yahoo chat software
  • Captured completed history in teh dimension tables
  • Also did production support.
  • In a map I had to load department table and employee table .Under constraint based loading first it loads employee table and then department table as it contains teh foreign key.
  • I has validated teh address of pharmacists and hospitals using trillium.
  • In sales table if we find more employees selling teh same product and I used rank transformation to find teh first 10 employee who is selling more products.
  • Worked on SQL tools like TOAD to run SQL Queries to validate teh data.
  • Designed and developed Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for extracting data to system.
  • Created database triggers for Data Security.
  • Developed Unix Shell scripts to extract and convert data from different legacy systems in databases.
  • Developed canned and ad hoc reports using Business Objects XI/6.5 and also created custom reporting solutions
  • Generated metadata reports using metadata manager
  • Assisted in writing project documentation used Microsoft Visio for different diagrams.
  • Used autosys for scheduling teh jobs.

Environment: Informatica PowerCenter 8.0/7.1, Informatica PowerConnect, (Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager), PowerExchange, Superglue, IMS Data, ETL, Erwin 4.5, Flat files, Oracle 10g/9i, Trillium, MS SQL Server 2005/2000, PL/SQL, Business Objects XI/6.5, Autosys, Shell Programming, SQL * Loader, IBM DB2 8.0, Toad, Excel and Unix scripting, Perl scripting, Sun Solaris, Windows NT

We'd love your feedback!