Sr Informatica Developer Resume
Lincolnshire, IL
SUMMARY
- 9+ years of IT experience with in depth noledge in design, development, enhancement of Data Warehouse and Business Intelligence applications for Financial, banking, insurance, Retail and manufacturing industries.
- Strong development skills and ability to work through entire software development life cycle (SDLC) methodologies.
- Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from different sources like Oracle, DB2, SQL Server, Flat files, XML data with various data formats.
- Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
- Expertise in using Informatica Power center / Power Mart for data extraction, transformation and loading (ETL) from desperate data sources like oracle, SQL server, flat files, MS Access, JMS and XML files and load teh data into different targets.
- Expertise in extracting teh data from xml files and loaded into ODS, EDW using XML Source Qualifier, XML Parser Transformations.
- Extensively worked on ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator and created complex mappings.
- Extensively worked on slowly changing dimensions like SCD type-1, type-2 and type-3 to maintain teh transactional data and historical data for teh need of business process and change data capture (CDC) using Informatica applications.
- Solid Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs.
- Experienced in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schemas in implementing Decision Support Systems, followed Ralph Kimball and Bill Inmon methodologies extensively.
- Strong database experience with SQL, PL/SQL Programming skills like creating indexes, joins, functions, stored procedures, triggers and cursors using Toad and SQL*Plus.
- Hands on experience onTeradataV2R6, 12.0, 13.0,TeradataSQL Assistant
- Experience in using scheduling toolsTWS(Tivoli Job Scheduler),AutoSysand Control M to automate running of Informatica Workflows on a daily Batch Jobs.
- Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.1/8.6.1/8.5/8.1.1/8.0/ , Power Mart 6.2/6.1/5.1. x/4.7, Power Exchange, Power Connector,ErWIN
Reporting Tools: Cognos 10.x, 8.x, Report Net, Power Play, Cognos Query, Power Play Web reports, Crystal Reports, Meta Manager,Business Objects (BOBJ)
Databases: Oracle 11g/10g /9i/8i, SQL Server 2000/2005, MS SQL, MS-Access, IBM DB2 v9.5/9.1, UDB, Tera Data(14.1)
Other Tools: TOAD, SQL*Loader, Microsoft Office and Visio
PROFESSIONAL EXPERIENCE
Confidential, Lincolnshire, IL
Sr Informatica Developer
Responsibilities:
- Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).
- Used SSRS to develop different kinds of reports like canned, ad-hoc reports for teh State and Local Agency users.
- Prepared teh complete data mapping and Report Definitionsfor teh project which involved around 33 reports.
- Involved in creating multiple parameterized stored procedures which were used by teh reports to get teh data.
- Worked on formatting SSRSreports using teh Global variables and expressions.
- Createdparameterized reports, Drill downandDrill throughreports using SSRS.
- Deployedanduploaded teh SSRS reportstoSharePoint Serverfor teh end users and involved in enhancements and modifications.
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Involved in teh Migration of Databases from SQL Server 2005 to SQL Server 2008.
- Prepared teh completedata mappingfor all teh migrated jobs using SSIS.
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
- Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
- Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance teh performance of databases.
Environment: SQL Integration Services(SSIS), SSRS,Workflow Manager, Workflow Monitor, Informatic Power Connect / Power Exchange Toad,SQL,DB2,Control M, Business Objects XI R2
Confidential - Pittsburgh,PA
Sr Informatica Developer/Teradata Developer
Responsibilities:
- Worked with Business Analysis team in gathering teh requirements and created Functional and ETL specification documents.
- Analyzed teh Business Requirement Documents (BRD) and laid out teh steps for teh data extraction, business logic implementation & loading into targets.
- Involved in gathering information for various scenario for Change Data Capture.
- Worked with DBA to set up teh DEV and QA environment and various users and roles
- Involved in Developing Unix script to load data to Teradata using FLOAD, TPUMP, MLOAD, BTEQ, etc.
- Created, optimized, reviewed, and executed Teradata SQL test queries to validate
- Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
- Developed mappings, sessions and workflows (ETL) for SCD types me, II and III to meet teh above requirements
- Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
- Creating tasks, sessions, events, timers etc in teh workflow manager and monitoring them in teh workflow monitor.
Environment: Informatica Power Center 9.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Power Analyzer, PL/SQL, Oracle 10g/9i,Teradata Sql Assistant (fastload, multiload, tpump),Toad,SQL,DB2,Control M, Cognos 10.2
Confidential - Titusville, NJ
Sr Informatica Developer (L3 Support)/Teradata Developer
Responsibilities:
- Analyzed teh functional specs provided by teh data architect and created technical specs documents for all teh mappings.
- Extensively used Erwin tool in Forward and reverse engineering, following teh Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
- Designed and developed Informatica Mappings to load data from Source systems to ODS and tan to Data Mart
- Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
- Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in teh Informatica Designer
- Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner
- Created Mapplet and used them in different Mappings
- Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.
- Performance tuning of teh Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
- Performance tuning using round robin, hash auto key, Key range partitioning
- Adhoc data requests and investigations
- Tier 3 support of EDW production processes including, but not limited to Issue investigation, root cause analysis, and defect resolution
- Design, develop and implementation of quality assurance and quality control processes
Environment: Informatica Power Center 8.6.1/9.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Power Analyzer, IMS Data, Maestro, PL/SQL, Oracle, Teradata(fastload, multiload, tpump),10g/9i,Toad Tivoli Workload Scheduler 8.4,Tidal
Confidential - Waukegan, IL
Sr. Informatica Developer
Responsibilities:
- Design and develop teh semantic layer for teh reporting purpose so that teh end user reporting may not be effected.
- Captured teh changes in teh data field and analyzed teh impacts on different systems with teh introduction of Oracle’s off shelf product.
- Extract data from Oracle and upload to oracle tables using Sql Loader
- Derived teh data mappings that could load all teh information from sources to teh targets.
- Designed teh informatica source from mainframe system to target mappings to perform teh initial load into teh production server.
- Devised strategies of extracting data from UNIX to Staging and tan from Staging to ORACLE RDBMS.
- Efficiently utilized Transformations including Expression, Router, Joiner, and Connected and Unconnected lookups, Filter, Aggregator, Rank, Sorter and Sequence Generator in teh mappings.
- Implemented and extensively worked on slowly changing dimensions Type1, Type2 and Type3 for accessing transaction history of accounts and transaction information using Change Data Capture (CDC) corresponding to business requirements.
- Designed and Developed Relational and Dimensional Data Models in Framework Manager based on client’s reporting requirements.
- Designed and Developed List Reports, Crosstab Reports, Charts by using Cognos 10 Report Studio and Query Studio.
Environment: - Informatica Power Center 9.1,Cognos 10(Framework manager, Report Studio, Query Studio, Cognos Connection), Autosys, Oracle 11g, Sybase, PL/SQL, SQL*Plus, flat files, web services, UNIX, Windows NT, Erwin 7.x, Toad 10, Oracle.
Confidential, Madison, WI
Sr. ETL Developer
Responsibilities:
- Held sessions with business user and data analysts to gather requirements and associated different source systems for data integration process.
- Identified documented data sources and transformation logic required to populate data and maintain targets.
- Played key role in determining data feed extraction process, data analysis, and testing and project coordination.
- Designed conceptual design model to understand teh base architecture of data integration process includes sources, transformations rules and target.
- Transformations logic implemented to support ETL (extract, transform, load) processes to load data into staging database using Informatica power center.
- Applied transformation logics by implementing transformations such as XML transformation, lookup transformations, Update strategy transformation, expression transformation, joiner transformation etc to extract, transform and load data into target.
- Designed re-useable transformations to quickly add new data sources and transformations related to business needs.
- Implemented change data capture mechanism using slowly changing dimensions type-II.
- Event wait, event raise, command task utilized to handle teh execution of workflow sessions using Informatica workflow manager.
- Develop store procedure, packages to utilize in mappings using store procedure transformation..
Environment: Informatica Power Center 8.1.1, DB2, Oracle 10g, SQLSERVER 2005, UNIX, TOAD, SQL*Plus, Core FTP & Windows XP
Confidential, CA
Sr. Informatica Developer
Responsibilities:
- Gatheird Business requirements by conducting meetings with business analyst, stake holders, development teams and data analysts on a scheduled basis.
- Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
- Developed various Mappings with teh collection of all Sources, Targets, and Transformations.
- Created Mapplets using Mapplets Designer.
- Used Type2 mapping to update a slowly changing dimension table to keep full history.
- Captured source file/table definitions, target data, and data mart table definitions.
- Create and maintain metadata and ETL documentation that support business roles and detailed source to target data mappings.
- Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
- Created and Scheduled Sessions and Batch Processes based on run on demand, run on time, run once, and run continuously.
- Interacted with business users, analysts for requirements, developed conceptual and logical data models.
- Wrote PL/SQL Packages, procedures, functions in oracle for business rules conformity.
- Utilized SQL loader, export/import utilities for data load and transformation.
Environment: Informatica Power Center 8.1.1, DB2, Oracle 10g, SQLSERVER 2005, UNIX, TOAD, Visio 2000, SQL*Plus, Core FTP & Windows XP.
Confidential
Data Base Developer
Responsibilities:
- Worked with business users to define and analyze problems and business needs by involving in sessions with teh analysts.
- Created a bridge table for teh numerous dimension groups and related them accordingly.
- Applied reusable tasks and work lets in informatica that can be halped for easier design of workflows to implement teh transformations that halp movement of data from diversified sources to teh target.
- Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
- Performed Unit testing during teh mapping phase to ensure proper and efficient implementation of teh transformations
- Written UNIX Shell Scripts and Pmcmd command line utility to interact with Informatica Server from command mode.
Environment: - SQL Server 2005, Oracle 8i, Erwin, UNIX and Shell Scripting