We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

Bloomfield, CT

SUMMARY:

  • Around 7 years of experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 10x/9x/8x
  • Experience in all the phases of the Data Warehouse project life cycle.
  • Interacted with end - users and functional analysts to identify and develop Business Specification Documents and transform it into technical requirements.
  • Worked with Business Analyst in understanding the requirements and Source to Target Mapping document.
  • Worked with Data Modelers for business model review.
  • Experience in Understanding Logical and Physical Data Modeling, Dimensional Data Modeling - Star Schema/Snow Flake modeling, Fact and Dimension Tables.
  • Experience on Informatica components like transformations, reusable transformations, mappings, mapplets, worklets and workflows.
  • Extensive knowledge of various kinds of Informatica Transformations such as Source Qualifier, Aggregate, Lookup (Connected & Un Connected), Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedure, Java, Normalizer and xml Transformations.
  • Experience in Importing the mappings developed in data quality (IDQ) to Informatica designer.
  • Experience working with different Databases like Oracle, Teradata, My Sql, DB2 and SQL Server.
  • Experience In working with Flat Files & XML Files.
  • Experience In working with SFDC and integrating it with Informatica.
  • Manually enter the Data into JIRA and Backup of JIRA databases.
  • Involved in extracting data from legacy systems like Oracle.
  • Hands on experience with Teradata utilities like BTEQ, Fast Export, Fast Load, and Multi Load to export and load data to/from different source systems including flat files.
  • Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III).
  • Good Experience with Change Data Capture for pulling Delta data.
  • Experience in writing efficient SQL queries, PL/SQL Scripts and fine-tuning queries.
  • Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Relational, Flat files, XML Files & Application) to targets.
  • Experience in maintenance and enhancement of existing ETL Process and improving loading process for faster efficiency.
  • Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.
  • Created Workflows with event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
  • Extensive involvement in writing UNIX shell scripts.
  • Involved in Upgrade projects for both Informatica & Database.
  • Strong hold in working both Waterfall & Agile Methodology project implementation.
  • Ability to work in groups as well as independently with minimum supervision and initiative to learn modern technologies and tools quickly.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 10x/9x/8x, IDQ

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual, Physical and Logical Data Modeling, ER Models, OLAP, OLTP concepts.

Databases: Oracle 12C/11g/10g/9i/8i, Teradata 15/14/12, MY SQL, DB2, SQL Server 2012/2008, Sybase.

Reporting: Cognos,SSRS, Dash Board.

Programming: SQL, PL/SQL, Unix Shell Scripting, Java, XML.

Environment: Windows, Unix, Linux.

Other: Agile&Agile(Kanban) & waterfall methodology, MS Office Tools, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, CT

ETL Informatica Developer

Responsibilities:

  • Co-ordinated with Business Analysts and source developers for performing data analysis and gathering business requirements in Agile methodologies.
  • Participating in project planning, daily standup meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings.
  • Developed technical specifications of the ETL process flow.
  • Designed the Source - Target mappings and involved in designing the Selection Criteria document.
  • Responsible for resolving DB2 Database problems and providing solutions and enhancements to the existing SQL queries.
  • Performed SQL Tuning using EXPLAIN plan, tuning database manager configuration parameters for optimal database performance.
  • Created DB2 Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes, Triggers and functions.
  • Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in DB2.
  • Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (DB2, SQL server, Oracle, Oracle Cloud API, Teradata and Flat files).
  • Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, HTTP, Joiner, Stored Procedure, Lookup, Update Strategy and Sequence Generator.
  • Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
  • Used flag enable mappings to update the slowly changing dimensions to keep full history to the target database.
  • Developed Json format data to parse from Oracle Cloud API to Oracle Raw (CLOB) tables.
  • Worked extensively with variables and parameter files in the mapping and in the session to pass the value and to control the environment and source, target information.
  • Developed recursive workflow execution using UNIX scripts and parameter files.
  • Developed Informatica scripts to load historical data (Onetime) and delta loads on daily basis. implemented sending of Post-Session Email once data is loaded.
  • Implemented Data warehouse framework to back track the data load details.
  • Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
  • Used Debugger to test the mappings and fixed the bugs.
  • Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
  • Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
  • Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.

Environment: Informatica Power Center 10.1, Informatica Cloud Data Integration, Microsoft DB2, SQL, PL/SQL, Microsoft SQL Server, Rally, UNIX, Teradata Studio, Oracle Cloud API, Toad for Oracle.

Confidential, Mount Laurel, NJ

ETL Informatica Developer

Responsibilities:

  • Interacted with Business Analyst to understand the business requirements.
  • Involved in Understanding the logical and physical data models with Modelers & Data Architects.
  • Involved in staging the data from external sources and was responsible for moving the data into the Warehouse using ETL Informatica.
  • Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
  • Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
  • Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.
  • The scope of this design includes a generic design for implementing tables whose content will be managed in part by end-users of the Data Warehouse. The content changes can be made via the standard production change request process.
  • Created mappings using flat files and relational databases as sources to build update Mappings.
  • Created reusable transformations and mapplets and used them in mappings.
  • Written SQL override queries in source analyzer to customize mappings.
  • Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
  • As the requirement is to maintain the history of every change for all columns, have implemented the slowly changing dimension type 2 with effective start and end date of the record.
  • Providing periodic update to customer on the coding, unit testing, release and act as Coordinator between development and business team.
  • Handled UNIX system tasks by generating Pre and Post-Session UNIX Shell Scripts.
  • Analyzed source data and formulated the transformations to achieve the customer requested reports.
  • Performed Unit testing and moved the data into QA.
  • Involved in migrating the ETL Code to different environments from Dev to UAT and then to Production with ETL Admins.
  • Analyzed source data and formulated the transformations to achieve the customer requested reports.
  • Performed Unit testing and moved the data into QA.
  • Participated in scheduling workflows, error checking, production support, maintenance as well as in testing of ETL procedures using Informatica session logs.
  • Involved in Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
  • Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: Informatica Power Center 10.1/9.6.1, Oracle 11g, Oracle SQL developer 4.0.3, Informix, Jira, Putty, Informatica Scheduler, UNIX, Windows.

Confidential, Richardson, TX

ETL Informatica Developer

Responsibilities:

  • Worked on the requirements with Business Analyst and business users also involved in working with data modelers.
  • Worked closely with data population developers, multiple business units and data solutions engineer to identify key information for implementing the Data warehouses.
  • Analyzed logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
  • Parsed high-level design spec to simple ETL coding and mapping standards.
  • Used Informatica power center as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
  • Imported mapplets and mappings from Informatica developer (IDQ) to Power Center.
  • Written Teradata BTEQs & as well Informatica mappings using TPT to load data from Staging to base.
  • Fine-tuned Teradata BTEQs as necessary using explain plan and collecting statistics
  • Extensive exposure to data extraction, conversion loading from various sources including flat files, Oracle, SQL Server, DB2, CCR and CCD.
  • Created and used the Normalizer Transformation to normalize the flat files in the source data.
  • Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.
  • Used Evaluate expression options to validate and fix the code using Debugger tool while testing Informatica code.
  • Handled initial (i.e. history) and incremental loads in to target database using mapping variables.
  • Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
  • Worked on performance tuning at both the Informatica level and Database as well by finding the bottlenecks.
  • Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
  • Performed Unit testing and created unit test plan of the code developed and involved in System testing and Integration testing as well. Coordinated with the testers and helped in the process of integration testing.
  • Heavily involved in Production support on rotational basis and supported DWH system using the ticketing tool for the issues raised by Business users.
  • Experience in working with reporting team in building collection layer for reporting purpose

Environment: Informatica Power Center 9.5.1, Oracle, SQLServer2008/2012, Facets, Oracle Sql Developer, Tidal Scheduler, Windows.

Confidential

ETL Informatica Developer

Responsibilities:

  • Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
  • Extensively used Informatica Client tools like Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
  • Used Teradata utilities Fast Load, Multi Load, tpump to load data.
  • Created Sources, Targets in shared folder and developed re-usable transformations, mapplets and user defined function (UDF) to re-use these objects in mappings to save the development time.
  • Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Experience with high volume data sets from various sources like Oracle, Text Files and Teradata Tables
  • Used debugger extensively to identify the bottlenecks in the mappings.
  • Modified PL/SQL stored procedures for Informatica mappings.
  • Created Sessions and Workflows to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
  • Configured the session properties i.e. high value for commit intervals to increase the performance.
  • Involved in unit testing, Integration testing and User acceptance testing of the mappings.
  • Involved in Migrating the Informatica objects using Unix SVN from Dev to QA Repository.
  • Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
  • Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
  • Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Environment: Informatica Power Center 9.1.1/8.6.1, Flat Files, Oracle 11g, Teradata 12/13, SQL, PL/SQL, TOAD, SQL Assistant, Windows XP, Unix, Maestro, SVN.

Confidential

Informatica Developer/SQL Developer

Responsibilities:

  • Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor as a senior Informatica Developer.
  • Extracted data from Oracle, SFDC and Flat files and loaded data into Oracle Data warehouse
  • Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate daily weekly and monthly loading of Data
  • Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, look up and Update Strategy transformations to model various standardized business processes
  • Used Informatica features to implement Type I, II changes in slowly changing dimension tables
  • Participated in reconciling data drawn from multiple systems across the company like Oracle, flat files into Oracle data warehouse
  • Involved in data Transformations between different Informatica folders and Repositories along with DBA team.
  • Generated Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
  • Developed reusable transformations to load data from various data sources to the DW.
  • Participated in Functional Meetings to understand various Source systems to be consolidated and involved in designing the data model for the Warehouse.
  • Designed the procedures for getting data from all systems, like IMS to Data Warehousing system. The data was standardized to store various Business Units in tables.
  • Worked closely with Business Analysts to Design & Develop SQL Statements, Data Conversions, and Data Cleansing, Data Quality Analysis to determine cleansing requirements.
  • Used Oracle, Sql server, DB2 and Flat Files as sources and Sql server 2005 as target.
  • Coding and Debugging, Sorting out their time-to-time technical problems.
  • Written simple and complex SQL-overrides in source qualifier as well as look-up transformations according to the Business Requirements.
  • Developed Informatica mappings and tuned them for Better Performance and validate the data.
  • Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes.
  • Involved in Batch processing & Scheduling Informatica jobs on weekly/monthly basis using Maestro.

Environment: Informatica Power Center 9.1.1/8.6.1 (Informatica Designer, Workflow Manager, Workflow Monitor), Toad, SQL Server 2005, Oracle 9i/10g, UNIX, Shell Scripts, Apex explorer/loader, SQL.

Hire Now