SUMMARY:

• Extensive experience in developing ETL mappings and scripts using Informatica PowerCenter 10.2/9.5/9.1.1/8. x/7.x (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Experience in Dimensional Data Modeling and Relational Data Modeling, Star Join Schema/ Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Proficient experience in different Databases like Oracle, SQL Server and Teradata.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Expertise in Developing PL SQL Packages, Stored Procedures Functions, triggers.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Proficiency in data warehousing techniques for Slowly Changing dimension phenomenon, Surrogate key assignment and change data capture.
• Experience in Integration of various relational and non - relational sources such as Oracle Tables, SQL Server Tables, Flat files and XML files. Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Application Data warehousing experience in Health, Insurance. Performed Unit, Integration and System Testing. Good analytical and problem-solving skills. Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Knowledge in Hadoop, Good knowledge of database structures, theories, principles, and practices.
• Proven understanding with Hadoop, HBase, Hive, Pig.

TECHNICAL SKILLS:

TOOLS: /METHODS: Informatica 10.2/9.1.1/8. x/7.x (Power Center) Oracle 11g, 10g 9i 8i, MS SQL Server 2005/2008/2012, DB2, Teradatav2r4 v2r3 SQL, PL SQL, UNIX Shell Scripting, VB, C, C++, COBOL, JCL Data Modeling - Dimensional, Star/Snow flake, ETL, OLAP HPQC (Quality Control), SQL Developer, Cognos, Documentum, Erwin, SQL Plus, Toad, Erwin Data Modeler, Control-M, Oracle Designer. Windows 95/98/NT/2000/XP, UNIX, Red Hat Linux 2.1 AS/7.1

PROFESSIONAL EXPERIENCE:

Senior ETL/Database Developer

Confidential, Boston, MA

• Analyzing the current database environment and analyzing the pre-written code and developing the new database objects like designing new table, constraints and indexing the tables.
• Developing new database objects like Stored Procedures, views, Adhoc queries which is being used to pull out various reports.
• Unit testing of code and bug fixes if any.
• Requirement analysis with the business team on One to One basis and coming up with the high-level design documents and preparing detail design documents and finalizing the design documents after taking the approval from the Client and the business.
• Fixing the defect in current queries used in Production environment on ADHOC basis.

Environment: MS SQL Server 2008, SSIS, IBM Rational ClearCase, Informatica 9.0.1

Senior ETL/Data base Developer

Confidential, RTP, NC

• Data analysis for integration and implementation of call data systems (Avaya CMS, Dialers, Syntel ate, IVR and NICE), BKFS, Impact, Western union, IEX, Inbound & outbound data etc.
• Majorly worked on Call center domain projects, call center upgrade projects, Data migration projects - Western union speed pay, Call center data, EDW steady state, Green Field and Compliance projects.
• Created fuzzy logic to integrate all call systems data to identify inbound calls, outbound calls & Manual outbound calls and loaded data and KPI data to call center data marts.
• Creation of Functional specification documents and Technical design documents.
• Created data base tables, views, SQL, Stored procedures’ and Informatica objects- Sources/Targets/Reusable Transformations, Mapplets, Mappings, Sessions, worklets, Workflow and Folders.
• Sensitive data was encrypted and decrypted using sql server certificates.
• Extensively used CTE, temp tables for data analysis in prod environment.
• Creation of ETL’s as per requirements and created static deployment groups to deploy to all environment repositories.
• Scheduling jobs using Autosys by creating necessary schedules, conditions for job flow, self-failure for longer runs and self-restart on failures.
• Created Intraday and daily jobs as per data needs.
• Performance tuning of ETL’s, SQL and Data base objects.
• Designed SSIS Packages to transfer data from flat files/database to SQL Server DB’s using Microsoft visual studio.
• Created release bundles with roll out and rollback scripts for dev, qa, uat, prod and dr environments to ease manual and automated Urban code deploys.
• Created Power shell standardized scripts to handle file copy, file deletions and windows to UNIX file format conversion.
• Worked on Informatica repository DB and Autosys DB queries to feed Informatica metadata manager.
• Performed unit testing as per business requirements and coordinated with SQA, UAT Users.
• Worked on Production support most of the time to resolve Issues quickly, majorly handled issues during nightly EDW batch to meet SLA’s.

Environment: Informatica Power Center 10.2/9.6, Microsoft SQL Server 2008 & 2012, SSMS, SSIS, IBM DB2, IBM Data Studio, Autosys, Urban Code, Maximo, TFS, Visual Studio, Work front, Windows NT, Power shell, file Zilla.

Senior ETL Developer

Confidential, San Jose, CA

• Data analysis, GAP analysis, Impact analysis as per Business review document (BRD) requirements
• Creation of Functional specification documents and Technical design documents.
• Analyzed and Implemented code for different Projects on Customer operations and value chain management - Sales and Operations planning(S&OP), LSS (PAT LT Projects and DISTI Scaling projects.
• Experience on Integration with different teams with respect to schedules, standards, server trusts and data movement.
• Created data base tables, views, SQL, PLSQL and Informatica objects- Sources/Targets/Reusable Transformations, Mapplets, Mappings, Sessions, worklets, Workflow and Folders.
• Creation of ETL’s as per requirements. Deployed ETL Interfaces between Development, Test and Production Repositories.
• Scheduling jobs using Dollar Universe ($U).
• Performance tuning of ETL’s, SQL and Data base objects.
• Experience in Creating Source level dependencies using Dollar universe and Table level dependencies to ensure exact refresh pull.
• Created Kintana Package for code deployment and worked on PVCS tool for version control of code.
• Worked on Operational data source (ODS) to get data and populated in to different Data bases and Flat files.
• Loaded and extracted data for separate set of tools and corresponding DB’s - Business intelligence tools (FINBI, Avalanche, Orion) demand planning tools (Demantra) Supply chain tools (CAN Price).
• Used separate set of data loaders (sql loader, Teradata loaders). Created shell scripts.
• Performed unit testing on Interfaces at ETL level, with Testers as per testing standards and UAT with Users.
• Worked on Production support most of the time to resolve Issues quickly.

Environment: Informatica Power Center 9.5/8.6, Kintana, PVCS, Doppler tool, Dollar Universe ($U) Kinaxis, Oracle 11/R12, Teradata, Windows NT, UNIX, Shell Scripting.

Senior ETL Developer

Confidential, Carlsbad, CA

• Involved completely in SDLC.
• Created Tech specifications based on Business requirements and documented new Implementations.
• Worked with various Sources and Targets which includes Sales Force, JD-Edwards, SIEBEL, AGILE, SAP, Flat Files, SQL Server and Oracle.
• Designed complex mappings, mapplets with all set of Transformations and created Informatica objects (Sessions, Worklets, Workflow). Implemented Slowly changing dimensions of Type-One and Two.
• Created views on Informatica Meta data tables to maintain control flow and summary of the Interface runs.
• Migrated Informatica objects with in Repository (Starting from low level to elevated level, i.e. Sources/Targets/Reusable Transformations, Mapplets, Mappings, Sessions, worklets, Workflow and Folders). And deployed ETL Interfaces between Development, Test and Production Repositories.
• Created data base Tables, views as per business for Interface design and reporting.
• Used Informatica special tools (Informatica developer, Informatica analyser, IDQ,) for data profiling and Data quality. Optimized various Mappings, Sessions, Sources and Target Databases (performance tuning).
• Involved in Upgrade tasks of Informatica from 8.6 to 9.1.1. Creating domains, nodes services (Repository services, Integration services), back up and assigning permissions to developers in team.
• Scheduled Workflows with Informatica scheduler and with automatic scheduler Control-M. Created UNIX shell scripts and Windows batch file to trigger workflows at back end Instead of client tools.
• Performed unit testing on Interfaces at ETL level, with Testers as per testing standards and UAT with Users.
• Working on Production support most of the time to resolve Issues quickly. Used Informatica debugger to trace out Issues in mappings.
• Created documentation to trace out modern design techniques easily. Co-ordinate with offshore team with tasks assigning, requirement sharing.
• Created Parameter files for Interfaces. Used various timer tasks, file watchers, file placers, Event wait, Event rise, Control and command tasks to design Workflows and keeping dependencies on multiple workflows.
• Worked on Aspen supply chain connect tool (third party tool).

Environment: Informatica Power Center 9.1.1/8.6/8.1.1, Informatica Data Quality (IDQ), Informatica Developer, Informatica Analyzer, Informatica Power Connect, Oracle 10g/11g, Windows NT, UNIX, Oracle.

Senior Informatica Developer

Confidential, Hartford, CT

• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Involved in preparation of Mapping Documents like LLD’s.
• Involved in designing, developing and testing of the ETL strategy to populate data from various source systems (Oracle, flat files, SQL Server) feeds using Informatica Created Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Developed staging jobs where in using data from different source formatted, Cleaned, Summarized, aggregated and transformed into Datawarehouse. Involved in ETL design for initial and incremental loads.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented the Slowly Changing Dimension Type 2 methodology to keep track of historical data.
• Created stored procedures for dropping and recreating indexes on target tables.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning. Migrated mappings from Dev to Test and Test to Production repositories.
• Experienced in using Parameter files and mapping parameters, variables in mappings and session variables in workflows.
• Involved in the debugging of the mappings by creating break points to gain trouble shooting information about data and error conditions.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards. Used workflow manager for session management, database connection management and scheduling of jobs. Involved in production support.

Environment: Informatica Power Center 8.6, Informatica B2B data transformation, Oracle10g, PL/SQL, MS SQL Server 2000, SQL * Loader, SQL developer, MS Access, UNIX Shell Scripts, UNIX (Solaris), Windows NT/2000, TOAD 7.0, Erwin, Business Objects

Database Developer

Confidential

• Worked with Business analysts to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Involved in the Design and implementation of Physical and logical Data warehouse models and OLAP solutions. Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Developer.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Involved in preparation of Mapping Documents like LLD’s.
• Involved in designing, developing and testing of the ETL strategy to populate data from various source systems (Oracle, flat files, SQL Server) feeds using Informatica Created Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Developed staging jobs where in using data from different source formatted, Cleaned, Summarized, aggregated and transformed into Datawarehouse. Involved in ETL design for initial and incremental loads.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented the Slowly Changing Dimension Type 2 methodology to keep track of historical data.
• Created various DDL and DML statements using Oracle PL/SQL and SQL.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created scripts to create new tables, views, queries for new enhancement in the application using Toad.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning. Migrated mappings from Dev to Test and Test to Production repositories.
• Experienced in using Parameter files and mapping parameters, variables in mappings and session variables in workflows.
• Involved in the debugging of the mappings by creating break points to gain trouble shooting information about data and error conditions.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards. Used workflow manager for session management, database connection management and scheduling of jobs. Involved in production support.

Environment: Informatica Power Center 8.0/8.6 (Power Center Designer, workflow manager, workflow monitor), Oracle 9i, Erwin, XML, UNIX, Windows 2000, Cubes, OLAP, SQL Developer PL/SQL, MS SQL Server 2000, SQL * Loader, UNIX Shell Scripts, UNIX (Solaris), Windows NT/2000, TOAD 7.0, Erwin, Business Objects