Senior Informatica Developer Resume Samples

Description :

1. Involved in design, development and maintenance of database for Data warehouse project.
2. Involved in Business Users Meetings to understand their requirements.
3. Converted business requirements into technical documents- BRD, explained business requirements in terms of technology to the developers.
4. Used of iPaaS and dPaaS Cloud Services enable to customers to develop, execute and govern integration flows.
5. Used of Kettle for data integration delivers powerful extraction , transformation and loading (ETL) capabilities.
6. Created IBM DB2 that contain database server and support the relational model and used object-relational features and non-relational structures like JSON and XML.
7. Used of Business Object to provide common services for deploymrnt and management tools of BI tools.

Experience

2-5 Years

Level

Executive

Education

Master Of Science In Northridge

Description :

1. Implemented a new claims platform, including a new Claims system, Epic Tapestry AP Claims, to process claims.
2. Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets in corresponds to project coordination.
3. Worked directly with Senior Architect and other team members to create ETL design specifications and support the implementation.
4. Created the Mappings and Mapplets Workflows for loading the data in stage tables and loading them to the EOP Info main tables through the Informatica power center 9.5 .1 Involved in creating the mappings and workflows for pulling the 835 files using B2B data studio to load the unstructured data into KPCC database to stage tables.
5. Involved in the Analysis of Sales business knowledge in Customer Service and Ordering subject areas Design, create and tune physical database objects.
6. BO is used for integration of data from Business Intelligence Used of Snap Logic tool for the Big Data Integration and Cloud Integration Snap logic provide visibility inti integration including performance, reliability, and utilization.
7. Controled and monitored performance of SnapLogic orchestrations and administers the lifecycle of data and process flows.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Worked with Business Analyst to gather business and technical requirements.
2. Involved in design and development of the Data Model for the data warehouse.
3. Experienced in doing design reviews, code reviews for ETL mappings.
4. Involved in Dimensional Data Modeling and populating the Business rules into the repository for metadata management.
5. Generated Surrogate key by using Key Management functionality for newly inserted rows in Data Warehouse and defined reference lookups and update transformations.
6. Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
7. Decomposed requirements in detail in order to initiate development.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Collectively implemented an end-to-end global financial solution to strengthen and integrate internal controls and reporting, reduce overall costs of financial systems, create operational efficiencies and global standards for Finance and Human Resources.
2. Project was executed in phases building up from extraction, computation logic, dimension models and populating data using Informatica.
3. Reported were generated using Business Objects for analysis.
4. Responsible for Business Analysis and Requirements Collection.
5. Translated requirements into business rules & made recommendations for innovative IT solution Involved in analyzing scope of application, defining relationship within & between groups of data, star schema, etc.
6. Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
7. Documented data conversion, integration, load and verification specifications.

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Gathered Business requirements from the end users and reporting team.
2. Participated in the entire life cycle of the project, which involved understanding scope of the project, functionality, Data modeling, technical Architecture document, technical design and complete development.
3. Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files.
4. Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
5. Designed and developed Operational Data Store, Slowly Changing Dimension, Staging areas etc.
6. Involved in analyzing the Data to confirm Requirement for project.
7. Involved in design for strategic solution of Trade Reconciliation System 2.0 (which includes more performance, less deployment component, less Autosys jobs & all config derived entity, more reusable components).

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
2. Reviewed the requirements with business, doing regular follow ups and obtaining sign offs.
3. Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
4. Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
5. Moved the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions (SCD) type 2 and type 1.
6. Used Debugger to test the mappings and fixed the bugs.
7. Used various transformations like Filter, Expression, Sequence Generator, Source Qualifier, Lookup, Router, Rank, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Technology

Description :

1. Interacted with the technical team and business users to perform analysis of business requirements and interpreted transformation rules for all target data objects and develop the software components to support the transformation.
2. Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
3. Created and modified the host DB2 and Datacom tables according to the business requirements that needed changes in the COBOL copy books.
4. Created Informix schemas (target tables) for the Cobol source files as per the business documentation.
5. Created mappings to load the daily delta files reading the cobol files containing header and trailer records to staging area.
6. Provided technical support to customers for assigned sales region.

Experience

2-5 Years

Level

Executive

Education

M.S In Computer Science

Description :

1. Used Informatica Designer to create, Load, Update mappings using different transformations to move data to different data marts in Data Warehouse.
2. Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, ODS, SQL Server etc.
3. DevelopedPL/SQL stored procedures and triggers for various data cleansing activities.
4. Developed Mapping by using various transformations to suit the business user requirements and business rules to load and eliminate unrequired data from Oracle and other data sources into Teradata target.
5. Extensively used Teradata SQL Assistant to extract data from Data warehouse.
6. Experienced in setting up the Java class path in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and also in Java SDK Custom transformation.
7. Successfully converted leads to sales based on MKS benchmarks.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Science

Description :

1. Acted as liaison to director with all levels of staff
2. Able to judge the relative importance of issues and act independently to address them
3. Advanced communication and organization skills, including drafting response emails, communication plan for staff after a key event
4. Enhanced productivity of executive by assuming responsibility for key outcomes and deliverables
5. Proactively managed all domestic and international travel arrangements, including air, hotel & ground transportation, visa assistance, and detailed itineraries. Work with local and international teams to ensure trip objectives, outcomes, and presentation expectations are identified, communicated and agreed to in advance of departure
6. Developed Mapping by using various transformations to suit the business user requirements and business rules to load and eliminate unrequired data from Oracle and other data sources into Teradata target.
7. Project involved development of bteq scripts to load from bcr system (universal global system) instead of mars system (legacy). 

Experience

5-7 Years

Level

Management

Education

Bachelor Of Science

Description :

1. Prepared the technical design documents.
2. Estimated the efforts (in terms of hours) based on the tasks assigned to team and guide them accordingly.
3. Designed and developed new workflows wherein the functionality was not incorporated in existing code.
4. Purged a part of the existing code that is not required anymoreand enhanced where needed.
5. Used Informatica Cloud to extract the data from Salesforce to Oracle database.
6. Worked on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
7. Worked mostly on Lookup, Aggregator, and Expression Transformations to implement complex logics while coding a Mapping.

Experience

7-10 Years

Level

Management

Education

Bachelors Of Engineering