We provide IT Staff Augmentation Services!

Etl/informati Lead Developer Resume

CA

SUMMARY

  • Over 8+ years of experience in Information Technology wif a strong background in Database development and Data warehousing and ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2. Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
  • Experience working wif Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Proficiency in developing SQL wif various relational databases like Oracle, SQL Server.
  • Knowledge in Full Life Cycle development of Data Warehousing.
  • Strong understanding of OLAP and OLTP Concepts.
  • Understand teh business rules completely based on High Level document specifications and implements teh data transformation methodologies.
  • Created UNIX shell scripts to run theInformatica workflows and controlling teh ETL flow.
  • Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
  • Experience in SQL performance tuning.
  • Experience in maintaining Data Concurrency, Replication of data.
  • Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
  • Performed SAP Data Migration by using Business Objects Data Services as teh ETL tool.
  • Experience in using SQL developer, SQL*Plus, Procedures/Functions and Performance tuning.
  • Extensive experience wif Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer, Union and XML Source Qualifier.
  • Responsible for teh Data Cleansing of Source Data using LTRIM and RTRIM operations of teh Expression Transformation.
  • Expertise in RDBMS concepts, wif hands on exposure in teh development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
  • Experience in working wif Perl Scripts for handling data coming in Flat files.
  • Experience working wif UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
  • Strong wif relational database design concepts.
  • Extracted data from various heterogeneous sources likeOracleandSAP.
  • Used Teradata Utilities like fast load, multi load and fast export.
  • Performed data validation by Unit testing, integration testing and System Testing.
  • Extensive experience in managing teams/On Shore - Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
  • Experience wif managing ODBC connections.
  • Good experience wif InformaticaPerformance Tuning.
  • Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin.
  • Flexible, enthusiastic and project oriented team player wif solid communication and leadership skills to develop creative solution for challenging client needs.
  • Excellent interpersonal and communication skills, and is experienced in working wif senior level managers, business people and developers across multiple disciplines.
  • Able to work independently and collaborate proactively & cross functionally wifin a team.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

TECHNICAL SKILLS

Tools: Informatica Power Center 9.6/9.5/9.1, 8.6.1/8.5/8.1.1 , Power Exchange 9.6/9.5/9.1/8.6 , Informatica IDQ,Informatica Data Replication Console,Talend.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2012, MS Access, DB2, Teradata 14/13/12/V2R6, V2R5, Sybase, Control-M.

Reporting Tools: Business Objects XIR2, SAP BI 7.0, OBIEE 11g/10g

Languages: C, C++, SQL, PL/SQL, HTML, PHP, JAVA, UNIX Scripting

Other Tools: Toad, Harvest, SCM, Putty, Tidal, Autosys, ESP,Informatica MDM Hub Console, Informatica Hierarchy Manager (HM).

Operating Systems: LINUX, SUN Solaris, Windows7/XP/2000/98

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL/Informatica Lead Developer

Responsibilities:

  • Expertise in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments.
  • Used Informatica Power Center 9.5 for Extraction, Transformation and Loading data from heterogeneous source systems into teh target data base.
  • Experience working wif Business users and architects to understand teh requirements and to pace up teh process in meeting teh milestone.
  • Perform impact analysis of teh existing process of RRP-variant and designing teh solution for automating input and output processes to/from RRP.
  • Designed all teh above projects and frameworks and lead teh development teams to reach teh project timelines wifin teh budget.
  • Designed and developed teh Informatica processes to send teh data to retail web services (RWS) and capturing teh response.
  • Working wif global support technology relationship team to setup VDIs wif teh required software packages for ETL development for offshore team. On boarding teh offshore team wif training.
  • Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables teh creation of a single view of customers, halp control costs associated wif mailing lists by preventing multiple pieces of mail.
  • TEMPEffectively communicates wif other technology and product team members.
  • Work on teh performance improved areas. Debug teh issues and coming up wif teh proper solutions which will reduce teh process times.
  • Informatica Data Quality (IDQ 8.6.1) is teh tool used here for data quality measurement.
  • Created mappings by cleansing teh data and populate that intoStagingtables, populating teh staging to Archive and tan to Enterprise Data Warehouseby transforming teh data into business needs & Populating theData Martwif only required information.
  • Extensively used Informatica Power Centre tools and transformations such as Lookups, Aggregator, Joiner, Ranking, Update Strategy,Mapplet, connected and unconnectedstoredprocedures / functions / SQL overrides usage in Lookups / Sourcefilter usage in Sourcequalifiers.
  • Created Pre/Post Session and SQL commands in sessions and mappings on teh target instance.
  • Responsible for Performance tuning Confidential various levels during teh development.
  • Identified performance issues in existing sources, targets and mappings by analyzing teh data flow, evaluating transformations and tuned accordingly for better performance.
  • Extracted/loaded data from/into diverse source/target systems like SQL server, XML and Flat Files.
  • Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into teh targets for better performance.
  • Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
  • Responsible for migrating teh workflows from development to production environment.
  • Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
  • Managed post production issues and delivered all assignments/projects wifin specified time lines.
  • Extensive use of Persistent cache to reduce session processing time.

Environment: Informatica Power center 9.5/8.6.1, Oracle 11/10g, SQL server 2008, LINUXIDQ, LSF (Job scheduling), UNIX shell scripting, SAS Enterprise guide and MS Visual studio (TFS) for version control.

Confidential, CA

ETL/Informatica Lead Developer

Responsibilities:

  • Coordinated wif Business Users for requirement gathering, business analysis to understand teh business requirement and to prepare Technical Specification documents(TSD) to code ETL Mappings for new requirement changes.
  • Involved in Data Analysis.
  • Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL.
  • Involved in designing STAR Schema for teh business processes.
  • Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from teh Database.
  • Designed, developed, implemented and maintainedInformaticaPowerCenter and IDQ 8.6.1 application for matching and merging process.
  • Used Source Analyzer and Warehouse designer to import teh source and target database schemas, teh Mapping Designer to map teh sources to teh target.
  • Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6.1.
  • Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
  • Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.
  • Developed teh transformation logic for both reference as well as transactional data flow from Legacy to New, and New to Legacy systems.
  • Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
  • Set up batches and sessions to schedule teh loads Confidential required frequency using Power Center Workflow manager.
  • Utilized ofInformaticaIDQ 8.6.1to complete initialdataprofiling and matching/removing duplicate data.
  • Extensively worked on Autosys to schedule teh jobs for loading data.
  • Worked on Power Exchange for change data capture (CDC).
  • Set up batches and sessions to schedule teh loads Confidential required frequency using Power CenterWorkflow manager and accessing Mainframe DB2 and AS400 systems.
  • Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
  • Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
  • Involved in InformaticaData Masking & Data Subset Data Mapping.
  • Executed conversion maintenance on existing legacy system.
  • Identified and fixed teh Bottle Necks and tuned teh Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
  • Defined teh program specifications for teh data migration programs, as well as teh necessary test plans used to ensure teh successful execution of teh data loading processes.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Power Exchange 8.6, MS SQL Server 2008, UNIX(Sun Solaris5.8/AIX), SSRS, UltraEdit-32, Data Marts, Erwin Data Modeler 4.1, FTP, MS-Excel, MS-Access, IDQ, DB2, UNIX Shell Scripting, Data Modeling, PL/SQL, Autosys

Confidential, Norwood, MA

Informatica Developer

Responsibilities:

  • Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
  • Experience on working wif complete Software Development Life Cycle of teh application.
  • Involved in monitoring and maintenance of teh Unix Server performance.
  • Involved in creating database tables, views, triggers.
  • Worked wif PL / SQL to create new stored procedures and also modify teh already existing procedures as per teh change requirements from users.
  • Created many PL/ SQL batches and executed them through Unix Shell scripts.
  • Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
  • Extensively worked wif Joiner functions like normal join, full outer join, master outer join and detail outer join in teh Joiner transformation.
  • Worked wif Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
  • Optimized SQL queries for better performance.
  • Created pre SQL and post SQL scripts which need to be run Confidential Informatica level.
  • Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, PL/SQL Developer, MS Access, Data Flux, BPM (Business Process Management), Win CVS, Window XP, DB2, UNIX

Confidential

Application ETL Developer

Responsibilities:

  • Responsible for design and development of Sales Data Warehouse.
  • Worked wif Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
  • Extracted data from heterogeneous sources like Oracle, SQL Server
  • Created detailed Technical specifications for Data Warehouse and ETL processes.
  • Conducted a series of discussions wif team members to convert Business rules into Informatica mappings.
  • Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
  • CreatedMapplets and used them in different Mappings.
  • Involved in doing error handling,debugging and troubleshooting Sessions using teh Session logs, Debugger and Workflow Monitor.
  • Monitoring teh Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
  • Worked wif SAP and Oracle sources to process teh data.
  • Worked on SAP for data migration Human Resources and Finance and converted various objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc., to generate report from SAP BI system.
  • Worked wif Pre and Post Session SQL commands to drop and recreate teh indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
  • Created Unix Shell Scripts to automate sessions and cleansing teh source data.
  • Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
  • Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
  • Worked on teh data masking activities for cloning teh GDW for several buyers

Environment: Informatica Power Center 8.6, Oracle9i,Teradata v2r6, SAP, SAP BI 7.0, SQL Server, Sun Solaris.

Confidential

Data warehouse Developer

Responsibilities:

  • Worked wif advanced PL/SQLconcepts like collections, PL/SQLobjects and records used them in building procedures and functions.
  • Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
  • Worked wif various complex queries, sub queries and joins to check teh validity of loaded and imported data.
  • Worked on data transformation and retrieval from other databases to oracle, usingSQLloader and control files.
  • Worked and developed many procedures and functions according teh requirement and developed brand new packages wif cursors.
  • Good Knowledge in understanding already existed packages, and worked wif them to create updated versions to solve teh issues.
  • Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
  • Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking teh databases.
  • Worked wif Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked wif UNIX shell scripts and PERL scripts to generate daily reports.

Environment: Oracle 9i, Shell Scripting, TOAD for SQL, TOAD, UNIX, Windows NT, Windows 2000.

Hire Now