We provide IT Staff Augmentation Services!

Sr Informatica Developer Resume

Weehawken, NJ

PROFESSIONAL SUMMARY:

  • More than 9+ years of proven experience in PL/SQL that includes Cursors, Ref - cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
  • Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing using Informatica Power Center 7.1 and PowerCenter 9.1/8.1.6 (Workflow Manager, Workflow Monitor, Server Manager, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer).
  • Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
  • Good Knowledge on applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
  • Proficient in Teradata Tools and Utilities such as Teradata SQL Assistant, Import/Export.
  • Expertise in designing and developing mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
  • ETL, Data analysis for ODS, online transactional processing (OLTP) and Data Warehouse / Business Intelligence (BI) - logical/physical, relational and multi-dimensional modeling (Star Schema, Snowflake Schema).
  • Design and development of multi-layer Web Based information systems using Web Services Including Java and JSP Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions,
  • Good experience in utilities such as Import/Export, SQL*Loader and SQL*PLUS.
  • Experience in system analysis, design, development and implementation of large to medium scale business applications using Oracle/UNIX technologies in Client-Server and Internet environments.
  • Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
  • Extensive experience in writing data conversion scripts for migrating legacy data into Oracle Applications using SQL*Loader and PL/SQL.
  • Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures
  • Maintained summaries or aggregates on data using Materialized Views.
  • Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.
  • Demonstrated the ability to work as Tech Leadand Developer.
  • Experience as DWH TeamLeadand SuccessfullyLeadmultiple DWH projects. Good experience in Leading both onsite and offshore teams.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, SQL*Plus, Oracle Warehouse Builder, Data Stage. Informatica Power Exchange, Informatica Power Mart, Informatica Data Quality/Informatica Developer, Informatica Data Transformation (B2B), Oracle Data Integrator, OLAP, OLTP, Star schema, Snowflake Schema.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 4/3

Databases: Oracle 8i/9i/10g/11g, SQL Server, DB2, MS Access, Teradata.

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Sr Informatica Developer

Responsibilities:

  • Attended multiple requirement gathering sessions with source system teams and business users.
  • Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
  • Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
  • Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
  • Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
  • Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into Data warehouse using the Mapping Designer.

Environment: Informatica Power Center 9.6/9.1, Informatica PWX CDC, Oracle 11g, Flat Files, Teradata, DB2UDB.

Confidential, Mooresville, NC

Sr Informatica Developer

Responsibilities:

  • Work closely with the Solution Architect, Data Modeler and Business Users.
  • Analyzing the business requirements and providing expert knowledge and solutions on Data warehousing in turn ensuring delivery of business needs in a timely cost-effective manner.
  • Assist in developing project plans, assigning the appropriate technical resources and cost estimations.
  • Evaluate and design data collection, data staging, data movement, analytics delivery, data quality and archiving strategies
  • Lead and guide the ETL developers in data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
  • Provides reviews of deliverables and identifies gaps/areas for improvement
  • Provides/reviews detailed technical specifications and ETL documentations required in each phase of the SDLC.
  • Perform POC activities to capture real-time data using Informatica PWX CDC.

Environment: Informatica Power Center 9.6/9.1, Informatica PWX CDC, Oracle 11g, Flat Files, Teradata, DB2UDB.

Confidential, Boca Raton, FL

Sr Informatica Developer

Responsibilities:

  • Understood the Business point of view to implement coding using Informatica Power Center 9.6/9.1
  • Extensively used Informatica Power Center 9.6/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
  • Involved in design and development of complex ETL coding in an optimized manner.
  • Have created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc using IDE
  • Have created Match, and Merge rules, developed address validations etc and developed address validations to countries like US, and also developed reusable error handling rules using IDQ.
  • Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension Phenomenon’s (SCD) and Change Data Capture (CDC).
  • Worked with Type-I, Type-II and Type-III dimensions and Data warehousing Change Data Capture (CDC).
  • Redesigned some of the existing mappings in the system to meet new functionality.
  • Optimized performance by tuning the Informatica ETL code as well as SQL
  • Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
  • Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
  • Written Queries, procedures, created Indexes, primary keys and data bases testing.
  • Defects were tracked, reviewed and analyzed.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
  • Experience in creating data maps using Power Exchange Navigator version 5.2.2
  • Created mainframe data maps using Power Exchange Navigator for the sources and targets.
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
  • Implemented Error Rejection process to load bad/invalid records into a separate reject table.
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
  • Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
  • Created parameter files to Dev, Test and Prod environments.
  • Created Perl Scripts and called in Pre session and Post session commands.
  • Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
  • Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
  • Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica Power Center 9.6/9.1, Oracle 11g, Flat Files, TOAD, Teradata, Autosys, Perl Scripting, Windows XP, UNIX.

Confidential, Boston, MA

Sr Informatica Developer

Responsibilities:

  • Attended multiple requirement gathering sessions with source system teams and business users.
  • Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
  • Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
  • Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
  • Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
  • Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into Data warehouse using the Mapping Designer.
  • Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Created and modified COBOL copybook to connect source data using Power Exchange Navigator.
  • Used Power Exchange Data Change option (CDC) to capture modified records.
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
  • Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
  • Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
  • Developed unit test plans for each scenario and programmed for data validation and proper error handling to manage the transactions without any data loopholes.
  • Responsible for tuning the Informatica Mappings and Sessions for optimum performance.
  • Enhancing the system with change requests and fault fixes delivery.
  • Responsible for loading the flat files into Oracle database by using SQL* Loader and Informatica.
  • Database performance by optimizing back end queries, Pl/Sql tuning and implementing performance improvements by analyzing indexes, table partition, parallelism etc
  • Documentation of all changes made to enhance the code for new requirements.
  • Used external tables to manipulate data obtained on monthly basis for vehicle information before loading them into the tables.
  • Created different SCD-II mappings using changed data capture (CDC) processes.
  • Utilized Quest tool (Toad 8.0) for database monitoring and tuning.
  • Involved in writing complex report SQL queries, oracle forms and oracle reports solutions.
  • Involved in post production support activities.

Environment: Informatica 8.6, Erwin 7.1, Oracle 11g, Teradata, PL/SQL developer, SQL*PLUS, SQL, SQL*Loader, Toad, ER-Studio, UNIX, CVS, HTML, XML

Confidential, Burlington, VT

Sr.Informatica Developer

Responsibilities:

  • Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
  • Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Used various transformations like Source Qualifier, Joiner, Lookup, Sql, router, Filter, Expression and Update Strategy.
  • Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
  • Documented Informatica mappings in Excel spread sheet.
  • Tuned the Informatica mappings for optimal load performance.
  • Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
  • Analyzed, identified, fixed bad data and imported data fromSales Force - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
  • This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
  • Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
  • Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL Server 2008, MS Access 2010, SQL*Loader, UNIX, Winscp, Informatica Metadata Manager, Putty, SQL, PL/SQL, Autosys 4.5

Confidential, Denver, CO

Informatica Developer

Responsibilities:

  • Data Modeler for the Billing system for Wireless Data mart. This system takes care of existing Qwest customers only.
  • Data Analyst- for analyzing the data for integrity across environments. Maintain Entity Relationships of data models.
  • Data Lead- migration of reference data to Production environment from Dev. Ensuring that only valid data are moved across environments through Release Notes.
  • Extracted data from source systems, transformed as per the business rules specified in the ETL design
  • Loading the data from various data sources (Oracle/DB2 UDB) into data marts for the Informatica data integration.
  • Worked with static and dynamic caches for the better throughput of sessions containing Rank, Lookup, Joiner and aggregator transformations.
  • Developed mappings to load data from Oracle and DB2 using different transformations like Source Qualifier, Expression, Look up, Aggregate, Update Strategy, Joiner, Sorter, xml and Filter into staging area/target tables.
  • Data validation (quality check) for source data (including flat files, csv files, and relational tables) are carried before loading into staging tables/datamart. Invalid data are logged into Error db for business users to analyze. Erred source data are posted into the datamart through a separate mapping once data resolved.
  • Developed ETL and source to target mappings. Created Several Informatica Mappings to populate the data into dimensions and fact tables.
  • Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows
  • Database administration activities like creation of tables, defining index etc. for reference data table changes.
  • Reference Data Migration from development to SIT and to production.
  • Project management, managing releases and communicating with both internal and external stake holders

Environment: Informatica Power Center 7.6, Erwin Data Modeler 4.5, TOAD 9.7.2, Control-M, Windows XP, HP UNIX, Oracle 10G

Confidential

PL/SQL Developer

Responsibilities:

  • Requirements gathering from users designing the database. Functional specs review and created technical specs documents.
  • Created Platform independent schema structure so that the product data can be implemented in any database.
  • Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Developed Ab Initio graphs to manipulate the logs and load the data into the Oracle databases.
  • Developed re-usable graphs for data extraction and scrubbing for various transformation processes

Environment: Unix/Oracle 9i (SQL and PL/SQL), Agile Methodology

Hire Now