SUMMARY

• Over 8 years of experience in IT including extensive Functional and Technical expertise in Data Warehousing, Data modelling Business Intelligence, Reports Generation, SQL Development and Business Analysis.
• Worked on multiple ETL projects and involved with the design, development and testing of ETL applications for logistics, procurement, merchandising and sales management.
• Strong expertise in EDW Concepts/Tools. Good understanding of Data Warehouse, Data mart and ODS concepts.
• Experience providing Enterprise Business Intelligence and Data Warehouse solutions from grounds up.
• Good technical knowledge and experience working on Informatica 8.x, 9.x, Oracle 10g, SQL, PL/SQL, UNIX, TERADATA.
• Experience in creating reusable transformations and complex mappings
• Experience in versioning and managing/deployment groups in Informatica environment
• Expertise in working with Teradata and using TPT
• Experience on Teradata utilities fastload, multiload, tpump to load data
• Experience in analyzing business specification documents, developing test plans, defining test cases, developing and executing scripts.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads. proficiency in working with Teradata utilities like (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD).
• Ability to create effective use cases and workflow diagrams using MS Word, Excel, power - point and Visio.
• Excellent knowledge of planning, estimation, project coordination and leadership in managing large scale projects.
• Good interpersonal communicator who effectively interacts with clients and customers
• Decisive, energetic and focused team lead/player who takes ownership and responsibility for requirements and contributes positively to the team.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.

TECHNICAL SKILLS

Programming Languages: SQL,T-SQL, PL/SQL, stored procedures

DBMS: Oracle 9i/10g,11g, SQL-Server 2005, Access, Teradata R12, R13, R14. DB2 UDB, Netezza

Reporting Tools: Webi, DeskI, SAP BOXI, Microstrategy, SAP Business Objects

ETL Tools: Informatica 7.1, 8.1 & 8.6, 9.1, 9.5. SAP BODI, SAP BODS, Talend, SAS

Design/CASE Tools: MS Project, Visio

Operating Systems: Win 2003/XP/2000/NT, MS DOS, UNIX

Miscellaneous: MS VSS, WEBI, universe and ERWIN, TOAD 7.x

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

ETL Informatica Developer

Responsibilities:

• Involved in Supporting BI and ETL Applications production jobs and changing existing code based on business needs.
• Wrote sql queries against the target database to validate the load results based on Business requirements.
• Developed the code using Teradata utilities like Fastload, Multi load, Tpump, BTEQ scripts.
• Automated and improved Business processes using existing technologies.
• Scheduled jobs, created users and provided DW Administration.
• Migrated code across repositories and maintained version control and Deployment groups for code migrations.
• Used transformations such as Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc
• Developed Type2 & Type3 slowly changing dimension mapping for various project requirements.
• Extensively used debugger, analysed log files and loader logs to test the data.
• Developed override SQL statements in Source Qualifier and Lookups to extract desired data from desired region.
• Created mapping parameters and variables in Informatica to handle the incremental date logic using parameter file to connect to various environments.
• Identified bottle neck and fine-tuned Source, Targets, Mappings, Transformations and sessions for better performance
• Supported unit testing and integration testing for the Informatica mappings and Warehouse data and prepared Technical design documents.
• Wrote various UNIX shell scripts to handle File process, validation and ETL controls.

Environment: Informatica Power Center 9.5.1, Teradata 14.0, WLM (workload Management scheduler tool), ServiceNow ticketing system, Cleacase (Migration Tool)

Confidential, Philadelphia, PA

Informatica Developer

Responsibilities:

• ETL Design and development using Informatica transformations like Sorter, Aggregator, Router, Normalizer, sequence, Union, Ranker, Update Strategy, Lookup, Stored Procedure, Source, Target, Transaction Control etc.
• Responsible for enhancing existing mappings and creating new mappings.
• Developed mappings to implement type1, type2, type3 slowly changing dimensions.
• Developed ETL code for Incremental/delta loads.
• Involved in working with project Managers and analysts on estimates, timelines, and resource plans.
• Experience in managing offshore teams for developing and testing various projects.
• Involved in scheduling meetings and co-ordinate with project team during development and testing phases.
• Supported global data convergence strategy through ETL (Using Informatica Power Center releases) process development and minimized failure points within current processes.
• Supported Business projects for successful Go-Live or implementation.
• Maintained multiple SDLC Informatica environments, user creation and group creations across various teams.
• Migrated code across repositories and maintained version control and Deployment groups for code migrations.
• Involved in on call support to resolve production issues during implementations.

Environment: Informatica Power Center 9.1.0,Oracle 10g, Autosys, Remedy

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Understanding the business rules provided to design and develop mapping for the ETL.
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load in Oracle warehouse.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Understanding the business rules provided to design and develop mapping for the ETL.
• Designed Sources to Targets mappings from Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Informatica admin for project coordination.
• Estimated the Database space needed based on the data volume and the data structures.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Datasets.
• Developed complex ETL to dynamically build queries based on the rules provided by the end user.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings coding with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Designed Sources to Targets mappings from Excel/Flat files, Xml Files to Oracle using Informatica Power Center.

Environment: Informatica Power Center 7.1, UNIX shell scripts, Oracle 9i, Windows 7 and Linux.

Confidential

Jr. ETL Informatica Developer

Responsibilities:

• Worked closely with various Application and Business teams to develop Data Model and ETL procedures in designing Data Warehouse with respect to business requirements.
• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server, Excel, and Flat files and load to Oracle database as per business requirements.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Performed unit testing to validate mappings and populate the database.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.1, Linux, Erwin, SQL Server 7.0, Oracle 10g.