We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

0/5 (Submit Your Rating)

Richmond, VA

SUMMARY

  • 9 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Banking, Financial and Manufacturing Sectors.
  • Around 1+ years of experience wif Talend open studio &Talend Enterprise platform for data management (V5.5.1..)
  • Strong analytical and conceptual noledge in database design and development using Oracle 11g/10g/9i/8.x, SQL, Postgres, PL/SQL, Developer/2000 and Unix Shell Scripting.
  • Around 1+ years of experience wif Talend Admin console (TAC).
  • Strong experience in Informatica tools Repository manager, Designer, Workflow manager, Workflow monitor. Ability to Work wif complex mappings using different transformations like Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator
  • Excellent background in implementation of business applications and in using RDBMS and OOPS concepts.
  • Have in - depth noledge in Data analysis, Data warehousing and ETL (Extract Transform and Load) techniques and TOAD.
  • Ability to communicate & present design or support ideas in a team-related environment
  • Extensively worked on developing InformaticaMappings, Mapplets, Sessions, Workletsand Workflows for data loads.
  • Experience in identifying and resolve ETL production root cause issues.
  • Experience in maintenance, enhancements, performance tuning of ETL code.
  • Experience in using Automation Scheduling tools like Autosys and Tivoli job scheduler.
  • Worked extensively wif slowly changing dimensions.
  • Hands-on experience on agile methodology.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
  • Extensive experience in Design, develop and test processes for loading initial data into a data warehouse
  • Strong noledge in Data Warehousing concepts, hands on experience using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, SQL Assistant, Data mover), UNIX
  • Extensively Worked on database objects like tables, indexes, views
  • Strong Experience on RDBMS Concepts.
  • Strong experience in OLAP Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
  • Experience in creating mappings, workflows using Informatica Power Center
  • Experience in developing complex SQL queries using joins, sub queries and correlated sub queries.
  • Experienced in working wif business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
  • Strong analytical and problem solving skills.
  • Excellent communication and interpersonal skills. Ability to work TEMPeffectively while working as a team member as well as individually.

TECHNICAL SKILLS

Data Warehousing/ ETL: InformaticaPower Center 9.6/9.5/9.1/8.6 , InformaticaPowerMart 9/8.x, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository manager), Metadata, talend

Data Modeling: Dimensional Data Modeling, 3NF Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Physical and Logical Data Modeling, Erwin, ER Studio and Sybase Power Designer.

Databases & Tools: Teradata 12/13/13.10/14 , Oracle 11g/10g/9i/8i/8.x, DB2 UDB 8.5, SQL*Server, MS SQL Server 2005/2000/7.0/6.5 , SQL*Plus, SQL*Loader, TOAD, SQL Assistant

Scheduling Tools: Informatica Workflow Manager, Autosys, CTL-M

Programming Languages: Unix Shell Scripting, SQL, PL/SQL, Perl, Teradata Procedure

Environment: UNIX, Win XP/NT 4.0, Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential - Richmond, VA

Responsibilities:

  • Client interaction and business interaction to understand environment and functional aspect of requirements.
  • Design the plan for Upgrade considering the existing architecture and Impact Analysis to the existing Systems.
  • Data Readiness Report Generation and resolving Hub Store issues for Upgrade.
  • Upgrade Master Database and ORS Databases.
  • Upgrade new Version of Hub and Cleanse Server on JBoss.
  • Regression testing of 10.1 for the core functionalities.
  • Upgraded on Development, UAT and Production Environment.
  • Coordinate wif other application areas during integration testing.
  • Generated Step-by-Step Procedure Document, on how the upgrade was done on each Environment.
  • Involved on Configuration, Installation and Integration of Informatica 10.1/IDQ 9.6.1.
  • Work closely wif Informatica Support to resolve the issues identified in Informatica tool.
  • Suggesting client to go for best possible technological solution based on technical expertise and noledge.
  • Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
  • Involved wif Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of data.
  • Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.

Environment: Informatica Developer 9.6, Informatica 9.7.1 and 10.1(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 11g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

ETL Informatica Developer

Confidential, New York, NY

Responsibilities:

  • Involved in analyzing and designing database using Normalization techniques.
  • Developed Forms, Menus, Object Libraries, and the PL/SQL Library using Oracle Form Builder 10g/9i.
  • Created and maintained development environment, resolved Production and validated Environment problems.
  • Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
  • Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
  • Implemented exception handling using autonomous transactions, Pragma Init, Locks, used save points, commits&rollbacks to maintain transactional consistency & database integrity.
  • Developed Front end user interface using Forms 10g.
  • Involved in implementing data migration into Teradata.
  • Maintained and Updated existing applications of Oracle Forms 10g and Reports 10g based on regular basis.
  • Developed custom libraries for the existing applications, used canvases, blocks, and visual attributes in developing front end using forms 10g.
  • Developed and deployed the Reports using Oracle Reports 9i.
  • Involved in various phases of the software development life cycle right from Requirements gathering, Analysis, Design, Development, and Testing to Production.
  • Meeting deadlines to deliver the business value wif in the Sprint Cycle.
  • Analyzed the requirements and framed the business logic for the ETL process.
  • Extensively used ETL to load data using Power Center from source systems like Relational Tables, Flat Files, and Sales Force Objects into staging tables (DB2) and load the data into the target database (DB2).
  • Developed mappings to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner, Normalizer transformations, Filter etc.
  • Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
  • Attending Meetings for Sprint Demos, Retrospectives, Sprint Planning, Grooming Sessions, Stand up Meetings, Collaboration Meetings etc.

ETL Informatica Developer

Confidential - Bethpage, NY

Responsibilities:

  • Worked as part of the development team, along wif the Systems Analysts/Business Analysts to design the CDM data model, and the architecture of the system
  • Created multiple Type 2 mappings in the CDM for Dimensions as well as Fact tables, implementing both date based and flag based versioning logic.
  • Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager. Generated completion messages and status reports using Workflow Manager/Workflow Monitor.
  • Developed mappings for Customer, Product, Premise and Campaign dimensions, implementing the ETL logic provided as part of the Technical Specifications.
  • Created logical dimensional STAR, SNOWFLAKE schemas (Kimball), Entity Relationships diagrams, Normalization, physical schemas.
  • Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor
  • Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
  • Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, and Update Strategy & Sequence Generator.
  • Defined Derived Tables, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins. Resolved Loops (Chasm Traps and Fan Traps) using Aliases and contexts and Verifying Integrity of universes.
  • Used Web Intelligence / Xcelcius for web based query and reporting.
  • Developed reports wif parameters, sub-reports based on Stored Procedures and Queries by using Crystal reports 2008 / XI
  • Upgraded Business Objects Enterprise XI R2 to XI 3.1/SAP BO
  • Used SQL, PL/SQL, TOAD to validate the Data going in to the Data Ware House
  • Extensively worked wif the QA (Quality specialist/analyst) team to get the system and unit testing done successfully

Environment: Informatica Power Center 8.6/8.1, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, SQL Server 2005, SAP BO / BOXIR3, Shell Scripting on UNIX Sun OS 10, WINDOWS.

ETL Informatica Developer

Confidential - Warren, NY

Responsibilities:

  • Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
  • Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression and Aggregator and Sequence generator.
  • Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
  • Worked wif pmcmd to interact wif Informatica Server from command mode and execute the shells scripts.
  • Worked wif different sources such as Oracle, MS SQL Server and flat files.
  • Knowledge of slowly changing dimension tables and fact tables.
  • Writing documentation to describe program development, logic, coding, testing, changes and corrections.
  • Used control-M for Scheduling, Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts
  • Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 8.1 (ETL), Oracle 9i, SQL, PL/SQL, SQL*Loader, SQL Server, Windows, HP-Unix.

ETL Informatica Developer

Confidential

Responsibilities:

  • Involved in design and development ofETLprocess full data warehouse life cycle (SDLC)
  • Coding and testing of various database objects such as views, functions and stored procedures using SQL and PL/SQL
  • Involved in designing the procedures for getting the data from all the source systems to Data Warehousing system.
  • Loaded all membership/Claims data as per the Business requirements by profiling the data, cleansing the raw source data, applying business transformations, massage the data, SQL Optimization and Performance tuning.
  • Developed number of ComplexInformaticaMappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
  • Performance tuning on sources, targets, mappings, sessions and SQL queries in the transformations to improve the daily load performance.
  • Designed and developed complex Aggregate, Join, Router, Look up and Update strategy transformation based on the business rules.
  • Created Dynamic lookup transformation to increase the session performance.
  • Experience in integration of various data sources like Oracle, DB2 UDB, Teradata, SQL server and MS access into staging area.
  • Used Scripting and Scheduled PMCMD to interact wifInformaticaServer from command mode and involved in jobs scheduling, monitoring and production support in a 24/7 environment.
  • Implemented procedures/functions in PL/SQL for stored Procedure Transformations.
  • Used various Oracle Index techniques to improve the query performance.
  • Gained working noledge of ControlM Scheduling Tool for loading/force starting jobs, changing job status and monitoring job progress.
  • Prepared BTEQ scripts to load data from Preserve area to Staging area.
  • Experience working wif Rational ClearCase for Version controlling and ClearQuest for defect tracking tool.

Environment: InformaticaPowerCenter 8.6 (Designer, Server Manager, Repository Manager), ControlM Scheduler, Tidal, SQL Server 2008, DB2 UDB, Erwin, SQL, PL/SQL, Perl Scripting, UNIX, Clear Case, Unix Platform, Perl Scripting, Putty, Windows 2007

ETL Developer

Confidential

Responsibilities:

  • Extensively involved in Gathering requirements by holding meetings wif users.
  • Identify entities and relationships in a business environment using an event-oriented focus.
  • Modeled the business process in the enterprise wide scenario.
  • Constructed context diagrams and data-flow diagrams based on a description of a business process. Analyzing the data model and identification of heterogeneous data sources.
  • Constructed an extended entity relationship diagram based on a narrative description of a business scenario.
  • Performed testing and QA role: developed Test Plan, Test Scenarios and wrote SQL Plus Test Scripts for execution on converted data to ensure consistency.
  • Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies.
  • Worked on Tuning database server, application logic and database objects.
  • Worked on tuning SQL statements using Sybase query plan analyzer
  • Managed the database objects Indexes, Triggers, procedures, functions, packages, cursors.
  • Involved in Maintenance of database, monitoring logs.

Environment: Informatica PowerMart (Designer 5x, Repository Manager 5x, Server Manager 5x), SQL Server 2000, Oracle 8i, UNIX/AI

Oracle Developer

Confidential

Responsibilities:

  • Gathering required data, data analysis and documentation of the plan.
  • Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables using SQL*Loader
  • Responsible for data mapping from legacy system to Oracle
  • Created database objects like tables, synonyms, sequences, views
  • Developed various data exception reports and submitted to the client for data clean up
  • Created materialized views, partitions, tables, views and indexes
  • Checking alert logs on daily basis and resolving problems.
  • Troubleshooting server configuration files such as tnsnames.ora and listener.ora.
  • Transferring logical data using Export/Import and Expdp/Impdp utilities
  • Resolving user issues like long running sessions and locks.
  • Involved in tuning and optimization of SQLstatements
  • Configured RMAN and performing backups regularly using RMAN tool.
  • Implemented Backup strategies (Hot & Cold backup).
  • Proactive monitoring of database health and work as the part of a team member and
  • Created/modified the procedures, functions and packages to support data conversion
  • Used SQL hints and indexes to improve the performance of queries
  • Modified the existing shell scripts to support conversion process
  • Checked explain plan of the SQL queries to improve the performance

Environment: Oracle 8i, TOAD, SQL* Plus, PL/SQL, Import/Export Utility and Windows NT, UNIX.Oracle 9i, SQL, PL/SQL, SQL*Loader, SQL Server, Windows, HP-Unix.

We'd love your feedback!