We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

NJ

PROFESSIONAL SUMMARY:

  • Around 6 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data Warehousing and experienced using Informatica Power center 9.x/8.x/ 7.x., Informatica IDQ 9.X, MDM.
  • Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • Experience in installation and configuration of core Informatica MDM hub components such as Hub console,Hub Store, Hub Server, Cleanse Match Server and Cleanse adapter in Windows.
  • Expertise in SDLC including requirement gathering, analysis, designing, testing, integration, quality assurance, maintenance, and support.
  • Experienced in domains like Financial, Insurance, and Retail.
  • Experience in Production Support. Extensively worked on production support issues and resolved them using session logs, workflow logs and used e - mail task for capturing issues.
  • Experience in using Informatica Powercenter Transformations such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and XML files.
  • Expertise in Teradata
  • Experienced in storing data to Data Lake
  • Experienced in ETL testing
  • Used unix scripts to schedule sessions, tasks and to automate the deployment group.
  • Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type 3.
  • Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings, and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
  • Used Debugger in Informatica Power Center Designer to check the errors in mapping
  • Experience in writing complex SQL queries.
  • Interacting with Business Analyst and users to get new requirements and enhancements.
  • Excellent skills in fine tuning the ETL mappings in Informatica.
  • Extensive experience using database tools such as SQL *Plus, SQL *Developer, and PostgreSQL
  • Good verbal & communication skills, clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Informatica Data Quality (IDQ), Data Quality/IDE.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i, PostgreSQL, Teradata, DB2

Tools: Toad, SQL* Developer, PGadmin.

Operating Systems: Windows Server, NT/2008/2003/XP/Vista/7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior ETL Developer

Responsibilities:

  • Involved in the design, development, and implementation of the Enterprise Data Warehousing (EDW) process.
  • Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
  • Involved in implementing the Land Process of loading the Data Set into Informatica MDM from various source systems.
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
  • Created Unit Test Case document.
  • Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design, and development.
  • Hands-on Experience in working with Source Analyzer, Mapping Designer, Mapplets to extract, transform and load data.
  • Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
  • Handled versioning and dependencies in Informatica.
  • Developed schedules to automate the update processes, Informatica sessions, and batches
  • Developed data transformation processes, maintain and update loading processes
  • Developed and tested all the mappings, sessions and workflows.
  • Used Informatica Powercenter Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
  • Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
  • Developed PL/SQL code at the database level for the new object.
  • Used shell Scripting to run the workflows, Scheduling the session, to automate the deployment group.

Environment: Informatica 9.5.1,Informatica Multidomain MDM 9.5.0, Oracle11g, SQL Server 2008, Teradata TOAD, SQL Navigator, Windows Server 2008, UNIX.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

  • Gathered User Requirements and designed Source to Target data load specifications based on business rules.
  • Used Informatica Powercenter 9.0.1.for extraction, loading, and transformation (ETL) of data in the DataMart.
  • Designed and developed ETL Mappings to extract data from Flat files and Oracle and to load the data into the target database.
  • Developing several complex mappings in Informatica a variety of Power enter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
  • Built complex reports using SQL scripts.
  • Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
  • Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence Generator transformations.
  • Interacting with Business Analyst and users to get new requirements and enhancements.
  • Design roles and groups for users and resources using AWS Identity Access Management (IAM).
  • Ran the workflows on a daily and weekly basis using workflow monitor.

Environment: Informatica 9.0.1, PL/SQL, AWS, Framework Manager, Transformer, Teradata, Oracle 11g, TOAD, Windows Server 2008, UNIX

Confidential

Informatica/ Database Developer

Responsibilities:

  • Gathered User Requirements and designed Source to Target data load specifications based on business rules.
  • Used Informatica Power Center 8.6.1.for extraction, loading, and transformation (ETL) of data in the DataMart.
  • Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
  • Developed several complex mappings in Informatica using a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
  • Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence Generator transformations.
  • Ran the workflows on a daily and weekly basis using workflow monitor.
  • Maintained the target database in the production and testing environments.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/9i, PL/SQL, Flat files, XML, MS Access, Web services, Unix, Toad, Business Objects

Confidential

Informatica Developer

Responsibilities:

  • Based on the requirements, created Functional design documents and Technical design specification documents for ETL Process.
  • Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.
  • Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.
  • Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator, and Normalizer in the mappings and applied surrogate keys on the target table.
  • Used the Informatica Server Manager to register and monitor the server, create and run the sessions/batches for loading the data using the earlier created mappings.
  • Created mapplets and reusable transformations.
  • Created Workflow, Worklets, and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Powercenter 8.x, Repository Manager, Designer, Oracle 8i, SQL, UNIX, Win 2000/NT

Hire Now