We provide IT Staff Augmentation Services!

Informatica Developer Resume

PROFESSIONAL SUMMARY:

  • Nine years of diversified experience in the field of Information Technology and Data warehousing using Informatica Power Center/PowerExchange/B2B Dx/IDQ 10.1/9.6/8.6/8.1/7.1/6.2 , GDE of Ab Initio 3.2 Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica.
  • Extensive experience in complete Data warehouse project development life cycle and Software Development Life Cycle (SDLC) including System Requirements Analysis, Design, Development, Testing, Maintenance and Enhancement in variety of technological platforms with special emphasis on Data Warehouse and Business Intelligence applications.
  • Complete understanding of Soft Ware Development methodologies like waterfall, Agile etc.
  • Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica PowerCenter 8.6.
  • Extensively worked on Informatica PowerCenter & Ab Initio Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator, Dedup Sorter, Rollup, Filter By Expression, Partition, De-partition etc.
  • Good knowledge in OLAP and OLTP process.
  • Understanding & Working knowledge of Informatica CDC (Change Data Capture).
  • Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
  • Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies
  • Extensively provided end to end 24/7 Production Support by monitoring data into a complex high volume environment using Quick Base ticket logging system.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multi-dimensional modeling.
  • Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
  • Experience in Performance tuning of the Informatica and Oracle.
  • Expertise in implementing complex Business rules by creating complex mappings / mapplets, shortcuts, reusable transformations and Partitioning Sessions.
  • Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
  • Extensively worked on L1 & L2 production support related issues and analyses issue priority and address to L3 team with details and follow up on items.
  • Providing Level 2 support for Tier 0 application with a four hour SLA. Liaison with L3 and DEVOPS when production issues occur and triage resolutions within the SLA window.
  • Responsible for creating conference calls for groups to discuss incidents that are production related, time or scheduled related incidents.
  • Coordinate with DEV teams and work with support teams to move fixes to production and CAB team.
  • Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer and Teradata SQL Assistant.
  • Experience on utilities like BTEQ, FastLoad, MultiLoad, TPump, FastExport, TPT.
  • Experience in working with Informatica Admin team on installing Informatica server, power center client, B2B DX client in Development, QA and Prod machines.
  • Experienced with working on Onshore Offshore Support Model and shifts.
  • Experience in working with production support team and Change management and Incident Management and Deployment Management teams.
  • Experience in using Informatica Data Quality IDQ for Data Profiling, Standardization, Enrichment, Matching, Consolidation transformations.
  • Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
  • Extensively worked on various databases including Oracle 10g, SQL Server, DB2, and Teradata.
  • Experience in Integration of various data sources like Oracle, SQL Server, and Flat Files.
  • Extensively worked with SQL loader for bulk loading into the oracle database.
  • Experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
  • Experienced in designing high level ETL architecture and Framework, created, configured, and fined tuned ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like SQL Server 2000, Oracle Database, Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS utility to SQL server 2005/2008.
  • Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
  • Proficient in understanding business processes / requirements and translating them into technical requirements.
  • Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.
  • Ability to work independently or in a team environment or in a rapid pace environment.
  • Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica PowerCenter 10.x/9.x/ 8.x/7.x/6.x/5.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL,Informatica Data Quality IDQ, IDE, Informatica B2B DX, Repository, Metadata, GDE of Ab Initio 3.2, CA 7 Mainframes, Data Mart, OLAP, OLTP,SAP BODS, DW, ECC, SLT.

SQL Server BI: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MS SQL Enterprise Manager, SQL Query Analyzer, SQL Server Profiler, Database Engine Tuning Advisor, DTS, SSIS, SSRS, SSAS, MS Visual Studio 2008, ODBC, FTP, IIS, MS Office 2000.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERWIN 4.0/3.5.2/2. x.

Databases: Oracle 11g/10g/9i/8.0, Sybase, SSIS, MS SQL Server 7.0/2000/2005/2008 , DB2 8.1, Mainframes, OLTP, Teradata 13.x, Netezza,Sybase,SAP.

Programming: SQL, T-SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, C,Cobol, HTML, Perl

Tools: TOAD,, Toad For Data Analyst, SQL*Plus, SQL Developer, Excel, Word, Autosys Scheduler, DAC, BTEQ, SQL Assistant, TWS, BMC Control-M, Rapid SQL, Aginity for Netezza, PuTTY, WinSCP, Notepad++

Reporting Tools: Oracle Business Intelligence, Cognos, SAP Business Objects.

Environment: UNIX, Windows XP/Vista

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

  • Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies
  • Extensively provided end to end 24/7 Production Support by monitoring data into a complex high volume environment using Quick Base ticket logging system.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multi-dimensional modeling.
  • Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
  • Experience in Performance tuning of the Informatica and Oracle.
  • Expertise in implementing complex Business rules by creating complex mappings / mapplets, shortcuts, reusable transformations and Partitioning Sessions.
  • Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
  • Extensively worked on L1 & L2 production support related issues and analyses issue priority and address to L3 team with details and follow up on items.
  • Providing Level 2 support for Tier 0 application with a four hour SLA. Liaison with L3 and DEVOPS when production issues occur and triage resolutions within the SLA window.
  • Responsible for creating conference calls for groups to discuss incidents that are production related, time or scheduled related incidents.
  • Coordinate with DEV teams and work with support teams to move fixes to production and CAB team.
  • Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer and Teradata SQL Assistant.
  • Experience on utilities like BTEQ, FastLoad, MultiLoad, TPump, FastExport, TPT.
  • Experience in working with Informatica Admin team on installing Informatica server, power center client, B2B DX client in Development, QA and Prod machines.
  • Experienced with working on Onshore Offshore Support Model and shifts.
  • Experience in working with production support team and Change management and Incident Management and Deployment Management teams.
  • Experience in using Informatica Data Quality IDQ for Data Profiling, Standardization, Enrichment, Matching, Consolidation transformations.
  • Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
  • Extensively worked on various databases including Oracle 10g, SQL Server, DB2, and Teradata.
  • Experience in Integration of various data sources like Oracle, SQL Server, and Flat Files.
  • Extensively worked with SQL loader for bulk loading into the oracle database.

Hire Now