We provide IT Staff Augmentation Services!

Etl Developer/informatica Resume

Buffalo, NY

SUMMARY

  • Over 9+years of IT experience in analysis, design, development, testing, and implementation of Business Intelligence(BI) solutions using Data Warehousing(DW) concepts/Data mart design, ETL, OLAP client /server applications using Informatica.
  • Strong Data Warehousing ETL experience of using ETL Informatica Power Center 10.4/10.2/10.1/9.6/8.6.1 , IDQ, MDM Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager, other tasks and experience in creating reusable objects..
  • Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLTP, OLAP, MDM, BI, Client/Server applications.
  • Extensively expertise in using various transformations like Joiner, Lookup (Connected and Unconnected), Source Qualifier, Router, Filter, Expression, Rank, Normalizer, Sequence Generator, Union, Aggregator, Update Strategy, XML, Normalizer, Stored procedure transformation.
  • Proficient in all phases of the Software development lifecycle (SDLC), including business requirement analysis, Design, System Implementation, Performance Tuning, Testing and Support and worked in data modeling environments with Agile and waterfall methodology.
  • Worked on both approaches to Datawarehousing - Dr. Ralph Kimball, Bill Inmon Methodologies and agile environment.
  • Implemented ETL solutions in various domains such as Banking, Finance and product based Sales applications using SQL and Informatica.
  • Strong experience in Dimensional Modelling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modelling.
  • Experience in functional performance, system integration testing, regression testing, unit testing, user acceptance testing, Verification, and Validations. .
  • Experience in implementing Slowly Changing Dimension methodology for historical loads, incremental loads and change Data capture for actual and transactional information.
  • Experience in data warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various RDBMS platforms (Oracle, MS SQL Server, DB2, NoSQL, XML, and Flat files) as source and targets.
  • Extensively worked with SQL, PL/SQL procedures, and proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization using SQL, TOAD, and SQL Developer.
  • Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
  • Worked with UNIX Operating system and Created UNIX shell scripts for parsing & modifying data, executing Stored Procedures, data validation, job scheduling, FTP and email notifications.
  • Excellent verbal and communication skills, clear understanding of business requirements and the ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

Databases: Oracle8i/9i/10g/11g/12c, SQL Server, My SQL, DB2, Amazon Redshift, Netezza, MS-Access.

ETL Tools: Informatica Power Center 10.x/9.x/8.x, Informatica Data Quality 9x, MDM.

Operating Systems: UNIX, Linux, Windows 2000, Windows XP/9X/NT/98/2000, MS-DOS.

Languages and Applications: SQL, NoSQL, PL/SQL, C/C++, PERL Scripting, Python, Java.

GUI Tools: Visual Basic, Visual C#.Net, SQL Plus.

Scheduling Tools: UC4, Tidal, Autosys, Redwood.

BI reporting Tools: Business Objects Xi r3.1/r2/6.5.1/5.1, OBIEE.

Modeling Tool: Erwin, Visio, ER Studio, Intelliplex.

Cloud Technologies: AWS, Microsoft Azure.

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

ETL developer/Informatica

Responsibilities:

  • Applied advanced DW techniques and Informatica best practices to load a Financial, HR & Supply Management Data Warehouse, Data Marts and Downstream Systems.
  • Proficiently worked with multiple Informatica repositories, version control, deployment groups, mapping and folder migrations, enhancements to the existing codes, new codes implementation and promote to production.
  • Worked closely with MDM team to identify the data requirements for their landing tables and created Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation as part of Informatica MDM.
  • Worked extensively with business users and business owners by gathering supply management data related business requirements and Data Architects to understand requirements prior to the design of ETL solutions and implemented Slowly Changing Dimensions type I and type II.
  • Experience in preparing Technical diagram and design documents, Mapping specification documents for detail design document for the Source/Target mapping.
  • Collaborated with the DBA team to ensure the optimized performance of all Informatica mappings.
  • Developed a number of complex Informatica mappings, Mapplets, stored procedures, and reusable objects to implement the business logic and to load the data incrementally.
  • Worked with the Reporting/Analysis teams when dealing with testing and modifications to Data Marts.
  • Expertise in UNIX work environment, file transfers, job scheduling and error handling and worked on creating JIL for using Automation Scheduling tool Autosys prior to production implementations.

Environment: Informatica Power Center 10.4/10.2, Microsoft Azure, Informatica MDM PIM, MS project management, Oracle SQL Server 11.2/12c, DB2, TOAD, Autosys, PL/SQL, Windows, Unix, SAP, ERWIN.

Confidential, New York City, New York

BI/Informatica Developer

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Created complex mappings that involved the implementation of Business Logic on financial, CRM and retail-based data to load data into the staging area.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections and stored and executed param variables in the control table.
  • Load data into Amazon Redshift and use AWS Cloud Watch to collect and monitor AWS RDS instances within Confidential.
  • Worked on deploying the code from lower environment to higher environments using deployment groups. Creating repository service and integrating service in Informatica Admin console.
  • Created detailed Unit Test Document with all possible Test cases/Scripts.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Implement the Data Quality solution with the appropriate DQ Rules, Metrics and projects.
  • Used various transformations like Data Profiling, Data Cleansing, Data Standardization, Data De-Duplication, Match / Merge Processes, Parser, Standardizer and Address validator using Informatica Data Quality
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Environment: Informatica Power Center 10.1/9.1/8.6.1 , Informatica data quality (IDQ), Amazon redshift, AWS Cloud, oracle, SQL server, Netezza, TOAD, Redwood, Tidal, Microstrategy, SQL*Plus, PL/SQL, MY SQL, Windows, Unix, Linux, TWS.

Confidential

ETL/Informatica Developer

Responsibilities:

  • Interacted with Business Users to understand the Business requirements and prepare technical documents for implementing the solutions as per business needs.
  • Prepared the Release Notes, Deployment plan, Unit Test document, Validation document, Migration document.
  • Created Staging Database from source as Flat Files, Access, Oracle, My SQL
  • Created different Mapping for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Expressions, Aggregator, and Sequence Generator.
  • Designed and Developed the Informatica workflows/sessions to load the data into target vast DWH.
  • Scheduled Workflows on the Informatica Server using Informatica workflow Manager.
  • Involved in Code migration to different Repositories (Dev/Test/Prod).
  • Interacted with DBA’s, Informatica Admin team to resolve the issues, Configuration of LDAP integration in Informatica domain.
  • Worked on Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data.
  • Used various transformations like Data Profiling, Data Cleansing, Data Standardization, Data De-Duplication, Match / Merge Processes, Parser, Standardizer and Address validator using Informatica Data Quality
  • Implemented Performance Tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Extensively Used Informatica Debugger to analyze/resolve the data issues.
  • Worked with DB2 Software's, reporting team to create email alerts per site, by daily.
  • Production Support & Maintenance.

Environment: Informatica power centre, Information data quality (IDQ), Oracle 10g, SQL Server 2008, DB2, TOAD, SQL*Plus, PL/SQL, UC4, MY SQL, Windows, Unix.

Confidential

ETL/Informatica Developer

Responsibilities:

  • Involved in development phase meetings for Business Analysis and requirements gathering and integrating financial data.
  • Worked with users and developers on requirement issues and gap analysis.
  • Developed and Implemented ETL processes using Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
  • Designed and developed complex aggregate, join, lookup transformation rules to generate consolidated (fact/summary) data.
  • Involved in Change data capture process using Slowly Changing Dimensions.
  • Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of the session.
  • Involved in developing SQL Scripts for extraction and loading of data to the data warehouse.
  • Developed Test Cases for Unit Testing, also involved in Integration, system, and performance tuning and trouble shooting.
  • Create and maintain shell scripts for pre/post session operations.

Environment: Informatica 8.x, Oracle 9i, DB2, PL/SQL, SQL Server 2000, TOAD, Unix, Tidal.

Hire Now