We provide IT Staff Augmentation Services!

Sr. Etl/ Informatica Developer Resume

AlabamA

SUMMARY:

  • Over 7years of IT experience with good knowledge in Analysis, Design, Development, Testing and Implementation of Data Warehouse application using Informatica.
  • Good proficiency in design and development of Data Warehousing using Informatica PowerCenter 9.6/9.5/9.1/9.0.1/8.6/8.5/8.1.1.
  • Good experience on Data Warehouse Concepts like Dimension Tables, Fact tables, slowly changing dimensions, Datamarts and dimensional modeling schemas.
  • Expertise in data modeling, development and enhancement.
  • Experience in Relational Databases like Oracle, MS SQL Server, MS Access, SQL, PL/SQL, Linux, UNIX.
  • Strong experience in Data modeling, Dimensional modeling and E - R Modeling and OLTP AND OLAP in Data Analysis. Very familiar with SCD1 and SCD2 in snowflake schema and star schema.
  • Experience in SDLC (Software Development Life Cycle) Requirements, Analysis, Design, Testing, Deployment of Informatica Power Center.
  • Strong expertise in relational database management system like Oracle, DB2, MS Access, Teradata, SQL server.
  • Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations.
  • Having very good knowledge in UNIX commands and shell scripting.
  • Expertise in implementing complex business rules by creating robust Mapplets, Sessions, Mappings, and Workflows using Informatica Power Center.
  • Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like flat files, Excel, XML, Oracle.
  • Applying the business rules to identify the bad records and reporting them to the business.
  • Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations.
  • Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.
  • Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
  • Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
  • Experience in detecting and resolving issues in ETL processes.
  • Design and develop applications using Informatica, UNIX scripting, SQL.
  • Highly proficient in UNIX shell scripting and administering job scheduler using Autosys UNIX machines.
  • In-depth knowledge in dealing with Flat files, Cobol and XML files.
  • Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
  • Efficient team player with excellent communication skills and good interaction.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.x/8.x (Designer, Repository Manager, Workflow manager, Workflow monitor).

Databases: Oracle, MS SQL server, DB2, Teradata.

Tools: PL/SQL developer, TSQL developer, SQL developer, Microsoft Word, Excel, Access, Visio, Tableau.

Languages/web: JavaScript, HTML, UNIX shell scripting, XML.

O perating systems: Windows, Linux, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Alabama

Sr. ETL/ Informatica Developer

Responsibilities:

  • Requirement gathering, validate and review data model, designing (Technical Design) ETL interfaces
  • Involved in reparation of mapping documents based on client requirement specifications.
  • Preparation of ETL Design documents and Functional & Technical specifications.
  • Created Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
  • Participated in all the phases of development life cycle like Requirements, Analysis, Design, Testing, Deployment.
  • Implementing methods to validate that data supplied by external sources were loaded correctly into the awards database.
  • Validating the data were loaded correctly, external data will be examined for signals that indicate the source might be incorrect.
  • Created, Updated and Scheduled Autosys jobs based on user requirements in UAT and Production environments.
  • Ensure that all timelines of loading/validating data are met with comparing host files.
  • Extracted data from Heterogeneous source systems like Oracle, SQL Server and flat files.
  • Design mappings related to complex business logic provided by data modeler, which includes Dimensions and Fact tables.
  • Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modeling which helps in structuring and organizing data in uniform manner where constraints are placed within structure major concept of Data modeling.
  • Involved in the designing of Dimensional Model and created Star Schema using E/R studio.
  • Interacting with the front end users to present the proof of concept and to gather the deliverables of the team.
  • Worked with the quality assurance effort with data analysis and execution of SQL queries for DB2 tables in UNIX environment for data validation.
  • Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
  • Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance.
  • Used Informatica Workflow to create, schedule, monitor and send the messages in case of process failures.
  • Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.

Environment: Oracle 10g/11g, DB2, PL/SQL, Informatica power center.

Confidential, IA

Sr. ETL/ Informatica developer

Responsibilities:

  • Analyzed, Designed and implemented in Informatica, PL/SQL stored procedures to Extract, Transform and Load data from external and Visilogplus internal application systems to GL and ftped to different downstream legacy systems.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Work with Data modeler to understand the architecture of Data warehouse.
  • Transformed business requirements into technical specification and then source-to-target mapping documents.
  • Designed and Developed Complex Informatica Mappings, Mapplets, reusable Transformations, tasks, sessions and Workflows for Daily, Weekly and Monthly process to load heterogeneous data into the Oracle Data warehouse or external vendors and to Data marts and then to downstream systems..
  • Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, Worklets, sessions, tasks etc.
  • Worked with the quality assurance effort with data analysis and execution of SQL queries for DB2 tables in UNIX environment for data validation.
  • Execute and Process (Migration) Informatica change control code from Development to QA and then to Production environments.
  • Re-designed multiple existing Power Center mappings to implement change request (CR) representing the updated business logic.
  • Detected the issues in the ETL processes and also resolved them.
  • Performed Unit Testing and Integration Testing of Mappings and Workflows.
  • Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
  • Validated and fine-tuned the ETL logic coded into existing Power Center Mappings, leading to improved performance.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partition and data/index cache to manage very large volume of data.

Environment: InformaticaPowerCenter8.6.1, Oracle 10g, Windows, SQL server 2005.

Confidential

ETL/ Informatica developer

Responsibilities:

  • Extraction from various Source databases such as Flat Files and Oracle stage tables using Informatica mappings.
  • Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Joiner, Rank, Update Strategy and Lookup.
  • Used Informatica features to implement Type II changes in slowly changing dimension tables.
  • ETL processes using Informatica to load data from heterogeneous sources to target Oracle Data Ware house database.
  • Analyzing the source data coming from various databases and files.
  • Identified data source systems (Oracle Apps, IMS data, Legacy Systems, files) integration issues and proposing feasible integration solutions.
  • Involved in Developing Data Marts for specific Business aspects like Marketing & Finance.
  • Created Oracle PL/SQL Stored Procedures, Packages, Triggers, Cursors and backup-recovery for the various tables.
  • Leveraged Explain Plan to improve the performance of SQL queries and PL/SQL Stored procedures.
  • Identifying and tracking the slowly changing dimensions (SCD), used CDC logic (Change Data Capture) for the SCD tables loading in Oracle.
  • Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modeling which helps in structuring and organizing data in uniform manner where constraints are placed within structure major concept of Data modeling.
  • OLTP and OLAP system will provide source data to data ware house which helps OLAP in data analysis.
  • Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance. And maintain database security and disaster recovery procedures. And performed troubleshooting and maintenance of multiple databases. And resolved many database issues in accurate and timely fashion.
  • Extracting data from Oracle and Flat file, Excel files, XML and COBOL sources and performed complex joiner transformations, Expression, aggregate, lookup, stored procedure, filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
  • Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets, Workflows, and Target Data.
  • Created reusable Tasks, Sessions, reusable Worklets and workflows in Workflow manager.
  • Provided user training and production support.
  • Fine Tuning of the SQL Statements to improve the database Performance.

Environment: Informatica Power Center 8.6.1, Oracle 10g, DB2, SQL*Loader, TOAD.

Confidential, CT

ETL/ Informatica Developer and FACETS Analyst

Responsibilities:

  • Worked with Systems Analyst to review the FRD and got the design approval on the ADS.
  • Attend daily stand up call to discuss on outstanding issues and daily progress.
  • Completed code review with the lead/architect and share the unit test result with SA, QA and DEV team.
  • Worked with fixed width and semicolon delimited flat files as the group and eligibility extracts are written on the flat files.
  • Strong experience in health care claims processing, billings and payments.
  • Used Confidential 's application to setup the group and subscriber data in the FACETS application.
  • Updated SQL overrides in source qualifier according to the business requirements.
  • Performed data manipulations using various Informatica transformations like Expression, Router, Lookup, Aggregator, Filter, Update Strategy, Stored Procedure, etc.
  • Created and used different tasks like Command Task, Event Wait, and E-mail etc.
  • Worked on Performance Bottlenecks to improve the performance of the sessions and workflows by using the HINTS, Pre SQL and Post SQL. I nvolved in data masking.
  • Created Deployment Groups to move the ETL code from RS Dev to RS TST, RS UAT and RS PROD.
  • Created Harvest package ( Confidential 's homegrown tool for Version control) and promoted the DG along with the other objects (PARM file, DDL, DML changes).

Environment: Informatica Power Center 9.1, Oracle 11g, Flat files, Facets 4.51, ESP Scheduler, Visio, SQL, UNIX, Unix Sell Scripting, Windows XP

Confidential

Jr. Informatica Developer

Responsibilities:

  • Working on data warehousing concepts/design with good understanding of the ETL and reporting processes.
  • Troubleshoot and diagnose complex technical work, resolve end User issues.
  • Taking responsibility in fixing the defects.
  • Loading of history data (around 450 million records) and addressing the issues if found.
  • Checking the daily run jobs in Control-M and analyzing the failures.
  • Helping in deploying the code from Development environment to Test and Production environment.
  • Helping team members in resolving their problems and make sure the defects are closed on time.
  • Participated in giving estimates for the project.

Hire Now