Sr Informatica Developer / Etl Developer Resume
Irvine, CA
SUMMARY
- Around 8+ years of experience in IT industry with a strong background in Analyzing, Developing, Testing and Implementing of Data Warehouse applications and BI applications in various domains such as Banking, Financial, Telecom and Insurance using Informatica Power Center.
- Extensive experience in Informatica Power Center 9.x/8.x with strong business understanding and knowledge of ETL from heterogeneous source systems like Flat files, Excel, XML, Oracle, Hive and Teradata to target systems like Oracle, Teradata.
- Worked on all phases of data warehouse development lifecycle, from analyzing requirements, ETL developmentand implementation and supported new and existing applications.
- Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
- Good technology and business experience in the areas of manufacturing, process and health care industry.
- High - level analysis of healthcare data and understanding of use cases to write test plans.
- Designed Reusable Transformations and Mapplets for better usability and performance.
- Expertise in Performance Tuning of sources, targets, transformations and sessions and Query Optimization.
- Healthcare data experience across Medicaid, Medicare, Exchange or commercial payer environments
- Experience in writing SQL Queries and creating stored procedures, PL/SQL Packages, Triggers and Functions.
- Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3).
- Extensive experience in UNIX shells scripting and Job scheduling like Maestro and Informatica Scheduler.
- Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
- Troubleshooting and problem-solving applications with Informatica Debugger and performed code migration from Dev to Test.
- Worked in Agile methodology, participated in stand-up meetings, task out user stories using Jira& implement them.
- Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
- Excellent written and verbal communication skills including experience in proposal and presentation creation.
TECHNICAL SKILLS
ETL Tools: Informatica 9.6.1, 9.5.1 (Power Center)
Databases: Oracle 11g/10g, Teradata, DB2
Languages: SQL, Unix
Tools: Oracle SQL Developer, Teradata SQL Assistant 13.0
Environment: MS Windows 10/8/7/XP, LINUX, UNIX
Job Scheduling: Tivoli, Maestro
PROFESSIONAL EXPERIENCE
Confidential - Irvine CA
Sr Informatica Developer / ETL Developer
Responsibilities:
- Involved in the requirement definition and analysis in support of Data Warehouse efforts.
- Developed ETL mappings, transformations using Informatica Power Center
- Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
- Extensively used ETL to load data from Flat Files to Oracle
- Performed data loading from source to target using Informatica Cloud.
- Worked as a part of AWS build team.
- Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
- Developed data Mappings between source systems and warehouse components using Mapping Designer
- Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
- Implemented Type 1 & Type 2 Slowly changing dimensions.
- Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
- Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
- Documentation to describe program development, logic, coding, testing, changes and corrections.
- Created and scheduled jobs in Autosys.
- Production support Written 24/6.
Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 11g, Erwin, Autosys, SQL Server 2005, AWS, Toad 9.0.
Confidential - Irving, TX
Sr ETL / Informatica Developer
Responsibilities:
- Used Informatica Power Center v9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
- Productively used Informatica tools - Informatica Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
- Using the concept of Slowly Changing Dimensions, complex mappings were created. Involved implementation of Business logic and capturing the deleted rows in the source origination.
- Worked extensively with the connected lookup transformations with the dynamic cache enabled.
- Developed several reusable transformations and Mapplets, which were used in other mappings.
- Created sessions and extracted data from various sources.
- Transformed the data according to the requirement and loading into the data warehouse.
- Involved in creating various mappings in the Informatica power center designer.
- Used Informatica Power Center for extractions, transformation, and loading data from heterogeneous sources into the target databases.
- Worked extensively on different complex mappings using transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer, joiner, Aggregator, Update strategy.
- Extracted Data from different Source Systems like Oracle, Teradata and Flat files.
- Experienced in optimizing the SQL queries to improve the performance.
- Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas and ER modeling.
- Responsible for Unit testing, System and Integration testing.
- Extensively Used debugger in identifying bugs in existing mappings by analyzing data
- Identified and fixed performance bottlenecks and tuned the Informatica mappings for better Performance.
- Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
- Analyzed Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
Environment: Informatica Power 9.6 (Workflow Manager, Workflow Monitor, Mapplets), Oracle, Teradata, SQL.
Confidential - Grand Rapids, MI
ETL / Informatica Developer
Responsibilities:
- Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
- Created mapping documents to outline data flow from sources to targets.
- Developed mappings to load into staging tables and then to Dimensions and Facts.
- Used existing ETL standards to develop these mappings.
- Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command,
- Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design, Documents, Data modeling and design of data warehouse.
- Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
- Created the repository manager, users, user groups and their access profiles.
- Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
- Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
- Extensively performed Data Masking for preserving the referential integrity of the user data.
- Involved in the development of Informatica mappings and also performed tuning for better performance.
- Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
- Developed ETL's for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various ETL scripts.
- Automated the entire processes using UNIX shell scripts.
Environment: Informatica Power 9.6, ETL, SQL, RDBMS, PL/SQL, UNIX
Confidential - IrvingTX
Informatica Developer
Responsibilities:
- Involved in gathering and analyzing the business requirements.
- Designed and developed mappings by using Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, Joiner transformations to implement the mapping.
- Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
- Extracted data from Hive files and transformed it in accordance with the Business logic and loaded data into Oracle tables using ETL tool.
- Involved in creating Oracle staging table structures and modifying existing tables as per the design specifications.
- Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica PowerCenter.
- Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
- Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions and Target Data.
- Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
- Created Unix shell scripts to execute the Informatica Workflows.
- Involved in Performance Tuning of mappings in Informatica.
- Performed unit testing at various levels of the ETL and actively involved in team code reviews.
- Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
Environment: Informatica PowerCenter 9.6.1, Oracle 11g, SQL, SQL Developer, UNIX, Maestro, Putty.
Confidential
Informatica Developer
Responsibilities:
- Involved in business analysis and technical design sessions with business and technical staff to develop
- Requirements document and ETL specifications.
- Involved in designing dimensional modeling and data modeling using Erwin tool.
- Created high-level Technical Design Document and Unit Test Plans.
- Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
- Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
- Responsible for creating workflows. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager
- Prepared user requirement documentation for mapping and additional functionality.
- Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.
- Analyzed current system and programs and prepared gap analysis documents
- Experience in Performance tuning & Optimization of SQL statements using SQL trace
- Involved in Unit, System integration, User Acceptance Testing of Mapping.
- Supported the process steps under development, test and production environment
Environment: Informatica Power Center 8.1.4/7.1.4 , Oracle 10g/9i, TOAD, Business Objects 6.5/XIR2, UNIX, clear case
Confidential
Informatica Developer
Responsibilities:
- Followed Agile-Scrum methodology to design, develop, test and deliver the code.
- Modify existing business logic in Informatica ETL flows.
- Design new ETL flows as per the mapping sheets.
- Involved in designing, creating equivalent Teradata datamarts to load the required staging data.
- Involved in ETL developing, creating required mappings for the data flow using Informatica.
- Used transformations like Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.
- Involved in designing the mapplet and reusable transformations according to the data flow requirements.
- Validated the output according to the specifications.
- Enhancements in existing mappings according to the business logic.
- Attended daily scrum calls to post the required status update.
- Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.
- Gathering reporting requirements and making enhancements to any existing logic if required.
Environment: Informatica PowerCenter 9.5.1, Teradata SQL Assistant, SQL, JCL, Oracle 10g, Teradata, UNIX, SQL Plus, DB2.