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 SKILLS

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

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