We provide IT Staff Augmentation Services!

Sr. Etl/informatica Developer/production Support Analyst Resume

White Plains, NY

SUMMARY:

  • Result - driven IT Professional with referable 8+ years of expertise in Data Warehousing coupled with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & Testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
  • Effective in interviewing stakeholders, requirements analysis and realization using Use Cases, deriving testable functional / non-functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical project teams from conception through deployment.
  • Expertise in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.
  • Experience in designing complex ETL solutions for Data Warehouse Programs.
  • Experience in both integration and reporting areas of Data Warehouse using Informatica, Cognos, Business Objects, Teradata and Oracle.
  • Erudite in Preparing word documentation and Visio diagrams to depict business processes better.
  • Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica PowerCenter 10.2/9.6/9.1/8.6 Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Mart, Power Connect 6.2, Power Exchange, OLAP and OLTP.
  • Experience with GIT Hub configurations - Data modeling & Data Mappings, Data validation.
  • Experience with Informatica Data Quality for Data Validation.
  • Experience with multiple Data Sources including Legacy Data, SAP and Third Party Data Providers.
  • Experience with healthcare data in HIPAA formats including HL7, NCPDP,837, 834, 835.
  • Experience in developing and implementing Statistical analysis OR Dimension Modeling.
  • Experience Data migration from existing data stores and Developing capacity plans for new and existing systems.
  • Good knowledge with Informatica Metadata Manager.
  • Extensive Experience in developing and performance tuning of Informatica mappings.
  • Erudite in Using Pushdown Optimization feature of Informatica.
  • Experience in Configuration and working on developing maps using Power exchange for SAP& DB2.
  • Extensive knowledge with Teradata SQL Assistant, PUMP, Fast Export, Fast Load, Multiload, BTEQ, coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance.
  • Hands on experience of using MS Office Suite, MS Project, MS Visio, Rational tools, Erwin.
  • Experience in executing C# programs for windows desktop and web-based applications.
  • Experience in coordinating with the configuration and change management groups for Clear Case Version Control and Build Making Process.
  • Versatile team player with excellent analytical, inter-personnel and presentation skill with ability to quickly adapt to new technologies & project environments.

TECHNICAL COMPETENCIES:

ETL Tools: Informatica 10.x/9.x/8.x PowerCenter, Workflow Manager, Workflow Monitor, Designer, Server Manager, Repository Manager, Informatica Data Quality 9.6.1 (IDQ), MDM Informatica

OLAP Tools: Business Objects XIR2/6.x/5i, Designer, Crystal Reports, Web intelligent, Supervisor, SAP R/3, Oracle Discoverer Administrator/Desktop

Databases: Oracle 10g/9i MS-SQL Server 2000, DB2, Teradata

Operating Systems: Windows NT 4.0/2000/XP/98/95, UNIX, OS/390, AS/400

Languages: UNIX Shell Scripts, SQL, Transact-SQL, PL/SQL, XML, JavaScript

Methodologies: Ralph Kimball, Inmon

Web Technologies: HTML/DHTML, JavaScript, JMS

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

Sr. ETL/Informatica Developer/Production Support Analyst

Responsibilities:

  • Effectively worked in Agile environment with bi-weekly iterations to complete various project deliverables.
  • Participate in daily and weekly operational meetings with Business and IT support teams.
  • Manage and own application release process.
  • Support release deliverables into production and perform on demand meetings with BI team supporting issues encountered due to production changes.
  • Perform custom, ad-hoc data analysis and reporting based on stakeholder requests within SLA.
  • Responsible for 24 x 7 production system support, including off hours and weekend 'on call' production support responsibilities.
  • Daily spot check of system health.
  • Analyze business requirements, implementing sound process design, creative and clean code, thorough unit testing and high performing implementations.
  • Designing, coding and unit testing of Data Integration solutions primarily involving Informatica product stack along with other ETL tools.
  • Support weekly and monthly customer report processing
  • Worked on AutoSys jobs automated pipeline for deploying applications to PROD.
  • Post implementation support including application monitoring and on-going issues.
  • Troubleshoot data discrepancy and missing data issues. ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues.
  • Application development enhancement & Quality Assurance testing using Informatica Power Center 10.2, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Mart, Power Connect 6.2, Power Exchange, OLAP, OLTP.
  • Performance tuning of ETL maps and considerably decreased the ETL load timings
  • Design and build Business Objects Universes from different data sources like Oracle/SQL Server.
  • Performance degradations and ongoing maintenance involving ETL toolset, OS, FTP Servers, Network, Database, Job Scheduler and what have Incident (Failures/Missing or Invalid Data, delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug/Break Fixes; Enhancements).
  • Load monitoring and reporting on SLAs and data availability Outages and Scheduled downtime management.

Environment: Informatica Power Center 10.2, SQL Server 2012/2008, T-SQL, Oracle 12g Exadata, SQL Server management Studio, DB2, stored procedures, Shell Scripts, UNIX, TFS, Control-M and AutoSys Scheduling Tool

Confidential, San Francisco, CA

Sr. ETL/Informatica Developer

Responsibilities:

  • Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
  • Responsible for Requirement Gathering Analysis and End User Meetings.
  • Responsible for converting Functional Requirements into Technical Specifications.
  • Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, Sybase, MS Access and Flat Files.
  • Analyze business requirements, implementing sound process design, creative and clean code, thorough unit testing and high performing implementations.
  • Responsible for designing, coding and unit testing of Data Integration solutions primarily involving Informatica product stack along with other ETL tools.
  • Develop, maintain, and support application, data integration, data modeling, and database management resources in Metadata Manager
  • Worked on the Informatica Analyst tool for profiling the data and perform validations.
  • Developed Re-Usable Transformations and Re-Usable Mapplets.
  • Used various transformations like Lookup, Filter, Normalizer, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator and XML Generator Transformations in the mappings.
  • Deploy new versions of the Oracle RDBMS and its tools
  • Work closely with software engineers, and other DBAs, to optimize, tune, and scale our Oracle RDBMS infrastructure
  • Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
  • Responsible for Performance Tuning at the Source, Target, Mapping and Session Level.
  • Created Pre and Post Session Scripts for checking file existence.
  • Responsible for Unit testing and Integration testing of mappings and workflows.
  • Documented existing mappings as per standards and developed template for mapping specification document.
  • Develop, maintain, and support Metadata Security model.
  • Monitor periodic loads of Metadata resources to confirm successful load.
  • Provided excellent customer service to the internal functional team by pro-actively following up with the issues on hand (through detailed emails and by setting up short meetings).
  • Analyze bugs found during testing (root cause analysis) beyond their obvious reason to extrapolate various errors that can occur in future.

Environment: Informatica Power Center 10.2, Rule Point, SQL Server 2012/2008, T-SQL, Oracle 11g Exadata, SQL Server management studio, DB2, stored procedures, Shell Scripts, UNIX, TFS and AutoSys Scheduling Tool

Confidential, Norfolk, VA

Sr. ETL/Informatica Developer

Responsibilities:

  • Prepare and involved in coding for all modules according to require specification and client requirements and prepare all required test plans, implementing, debugging and documenting the complex programs.
  • Evaluate all functional requirements and map documents and perform troubleshoot on all development processes. Creating proper technical documentation in the work assignments and troubleshooting production problems.
  • Understand the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process.
  • Monitor system performance, and other aspects of systems to identify technical problems; monitoring data integrity to identify data quality problems; designing and enhance the data quality improvement process including feedback to system stewards.
  • Worked on database SQL language for user defined database extract or update statements. SQL and database skills are the two great building blocks for ETL work.
  • Implemented Informatica recommendations, methodologies and best practices and performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Wrote documentation to describe program development, logic, coding, testing, changes and corrections. Involved in Unit, Integration, System, and Performance testing levels.
  • Migrated the code into QA (Testing) and supported QA team and UAT (User) and created detailed Unit Test Document with all possible Test cases/Scripts.
  • Creating Session logs and Workflow logs for Error handling and troubleshooting in Dev environment, wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes.
  • Create scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
  • Provide observations of the overall system and suggest automated steps to full-fill the business operations and the requirements, help with the analysis of issues raised during QA/PROD phases and Data Reconciliation.

Environment: Informatica PowerCenter10.2, Power Exchange 9.6, Rapid SQL 8.7.5, DB2, Teradata database, Unix, WinSCP, Putty, Tidal and AutoSys Scheduling Tool

Confidential, Hartford, CT

Sr. ETL/ Informatica Developer

Responsibilities:

  • Extensively worked with PowerCenter 9.6.1 and 10.2 Source Qualifier Transformation to join the homogeneous sources.
  • Worked on Informatica Power Exchange 9.6 for Loading/Retrieving data from mainframe systems.
  • Extensively worked on Joiner Transformation to join the heterogeneous sources.
  • Worked on various Databases for extracting the files and loading them into different databases.
  • Worked on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
  • Coding of optimized Teradata batch processing scripts for data transformation, aggregation.
  • Design the ETLs on PowerCenter and conducting review meets.
  • Loaded the data into the XML and Flat files.
  • Worked on Informatica Data Quality transformations like Address validator, Parser, Match, Exception, Association, Standardizer and other significant transformations.
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • Extensively worked on Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
  • Modified Unix Shell Scripts for executing the Informatica workflows.
  • Extensively worked on Informatica Designer Components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
  • Involved in Unit Testing, Integration Testing and End-End Testing.
  • Provided support to SIT and UAT users and testers.

Environment: Informatica PowerCenter 9.6.1 and 10.2, Power Exchange 9.6, Rapid SQL 8.7.5, DB2, Teradata database, Unix, WinSCP, Putty, Control M and AutoSys Scheduling Tool

Confidential, Irving, TX

ETL/Informatica Developer

Responsibilities:

  • The objective of this project was to build a new Policy database to replace the legacy system which is used by downstream applications.
  • Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica PowerCenter.
  • Responsible for Requirement Gathering Analysis and End User Meetings.
  • Responsible for converting Functional Requirements into Technical Specifications.
  • Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, Sybase, MS Access and Flat Files. Worked on the Informatica Analyst tool for profiling the data and perform validations.
  • Used various transformations like Lookup, Filter, Normalizer, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator and XML Generator Transformations in the mappings.
  • Developed mappings for Slowly Changing Dimensions of Type1, Type2, Facts and Summary tables using all kinds of transformations.
  • Developed Re-Usable Transformations and Re-Usable Mapplets.
  • Involved in gathering information from HL7 clinical documents for the purpose maintaining data exchange between patients and healthcare providers.
  • Dealt withHL7 components and subcomponents.
  • Dealt with several segments and fields withinHL7 message types for both HL7 inbound workflow and HL7 Outbound workflow.
  • Developed Mappings for Type 1 and Type 2 Slowly Changing Dimensions.
  • Extracted HL7 messages from EPIC Systems.
  • Extensively worked on UNIX Shell scripting.
  • Worked on XML Parser transformation to read the XSD file and build the source definition and accordingly to read the XML source file.
  • Used XML spy tool to validate the input source XML files.
  • Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
  • Created Pre and Post Session Scripts for checking file existence.

Environment: Informatica Power Center 9.5.1, SQL Server 2012/2008, T-SQL, Oracle 11g Exadata, SQL Server management Studio, DB2, stored procedures, XML, XML spy, Shell Scripts, UNIX, TFS, HIPAA, Control M and AutoSys scheduling tool

Confidential, Warsaw, IN

ETL/Informatica Developer

Responsibilities:

  • Performed errands in corporate creating and managing projects (It includes create and facilitate preparing; composing framework functionality; testing new advancements; and keeping up project plans, issue logs, and status reports).
  • Lead and participated in the project meetings and workgroups with different, simultaneous tasks.
  • As an ETL Developer, provided suggestions and improvements to adhere to the standards.
  • Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects.
  • Actively involved in creating design specifications and ETL design documents.
  • Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation.
  • Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
  • Extensively worked on UNIX Shell scripting and BTEQs to extract the data from the warehouse.
  • Involved in Performance Tuning (Both Database and Informatica) and there by decreased the load time.
  • Used Push Down Optimization and Partitioning to improve the performance on Informatica.
  • Involved in Design review, code review, Performance analysis.

Environment: Informatica Power Center 9.1, Informatica Power Connect, Oracle 11g, SQL server 2010, PL/SQL Procedures, TOAD, AutoSys Scheduler, Mainframes, UNIX, PUTTY

Confidential, Troy, MI

ETL/ Informatica Developer

Responsibilities:

  • Responsible for ETL design & implementation to source CRM data from Siebel to Business Warehouse.
  • Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into data mart using VSE Connector.
  • Worked closely with analysts and data source systems experts to map requirements to ETL code.
  • Worked on developing UNIX and Perl Scripts for file parsing and job automations.
  • Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
  • Converted functional specifications into technical specifications (design of mapping documents).
  • Used AutoSys, CRON to schedule jobs. Designing, document and configure the Informatica MDM.
  • Worked on administering Informatica 8.6 and 9.5 on windows environment before UNIX migration.
  • Created deployment groups to deploy objects.
  • Responsible for design and implementation needed for loading and updating the warehouse.
  • Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
  • Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
  • Coordinated with DBA’s in resolving the database issues that lead to production job failures.
  • Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes. Hub to support loading, cleansing, matching of MDM data.
  • Efficiently worked on MDM data modelling, data mappings and data integration.
  • Involved in Performance Tuning of existing mappings as well as new ones.
  • Wrote complex SQL scripts to avoid Informatica joiners and Lookups
  • Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
  • Involved extensively in Unit testing, integration testing, system testing and UAT.

Environment: Informatica Power Center 9.1, MDM, Informatica Power Connect SAP R/3, OBIEE 11g, Oracle 11g, SQL server 2010, PL/SQL Procedures, TOAD, Perl scripts, Rational Clear case, AutoSys, MKS Integrity Client, MS Visio, ALM, Mainframes, UNIX, PUTTY, VSE Connector

Confidential

Informatica/Oracle Developer

Responsibilities:

  • Project scope here was to provide an enhanced data load process and Adhoc reporting capabilities for the selected Business Users for the Provider Data group repository, which also includes a redesign in the existing schema for the new business requirement
  • Involved in identifying data ownership/responsibility, requirement gathering, data mapping, mapping design, analysis, validation, and consolidation of source system, defining error and restart logic, and quality assurance and production environment.
  • Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into DataMart.
  • Worked with analysts and data source systems experts to map requirements to ETL code.
  • Documented technical specification, business requirements, and functional specifications for the development of mappings to load data into various target tables.
  • Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
  • Extensively used various oracle utilities like triggers, cursors, PL/SQL procedures and functions.
  • Converted functional specifications into technical specifications (design of mapping documents).
  • Developed complex mappings to load data from multiple source systems like Oracle and flat files.
  • Responsible for design and implementation needed for loading and updating the warehouse.
  • Wrote complex SQL scripts to avoid Informatica joiners and Lookups to improve the performance as the volume of the data was heavy.
  • Review of design and code developed by peers.
  • Coordinated with DBA’s in resolving the database issues that lead to production job failures.
  • Used the Rational ClearCase for versioning the various objects like the mappings, workflows, SL Scripts and Perl scripts. Involved extensively in Unit testing, integration testing, system testing and UAT.
  • Participated in weekly end user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc.

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.x, Oracle 10g, PL/SQL Procedures, TOAD, Perl Scripts, Rational Clear Case, Tivoli Workflow scheduler, MS Visio

Hire Now