PROFESSIONAL SUMMARY:

• 12 + years of professional experience in IT, and the past 9 + years spent primarily on Data warehouse projects using Informatica Power Center Server, Hadoop EcoSystem, IDQ, Business Objects, Cognos, Teradata, SQL Server and Oracle on UNIX and Windows platforms.
• Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor).
• Experience in Data Load with Informatica CDC (Change Data Capture).
• Experience in Teradata with Fast Load, Multi Load and BTEQ.
• Experience in Hadoop Components using Spark, Python, Sqoop, Oozie, Hive etc.
• Experience in SQL Server Integration Services   (SSIS)  and  SQL Server Reporting Services (SSRS)  with good knowledge on SQL Server Analysis Services   (SSAS) .
• Experience in DataStage implementations, Development and support.
• Experience in Oracle Procedures .
• Experience in file transfer thru SFTP and B2B .
• Experience in UNIX and Windows programming.
• Used Tidal and Tivoli for job scheduling tool.
• Experience in developing Data M odel using Kimball and Agile methodology.
• Experienced in full Software Development Life Cycle (SDLC) process.
• Experience in working on Tableau .
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, Star , Kimball and Snowflake schema database design methodologies.
• Good exposure to D evelopment, Testing, Debugging, Implementation, Documentation & P roduction S upport.
• Good exposure to Excel with Pivots, PivotCharts , Extract data thru Data Connection etc.
• Good understanding on Hadoop components like Hadoop Map Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, and Flume.
• Managed and co - ordinate tasks between multiple teams (Offshore and Onsite) for many projects.
• Ability to work effectively in a supervisory and non supervisory environment as a team member as well as an individual.

TECHNICAL SKILLS:

ETL Tools: Spark 2.0, Informatica(IntegrationService/PowerCenter/PowerMart) 9.6.1/9.5.1/8.6.1/7 , DataStage 8.1/8.0.1

BI Tools: Business Objects 6.5/5.1, Cognos

Databases: Hive 2.0.1, Teradata 9.5.1/9.5, Oracle 11g/10g/9.x,SQL Developer 1.5.5, MS SQL Server 2008, SQL Server 2005

Languages/Others : Python, SQL, PL/SQL, UNIX and Windows

Packages: MS Office (MS Access, MS Excel, MS Visio, MS PowerPoint, MS Word)

OS: Windows 10/95/98/2000/ XP/7/8 Professional/NT, UNIX

Hadoop: HDFS, Hadoop MapReduce, Zookeeper, Hive, Pig, Sqoop, Flume, Oozie, Spark

Data Transfer: Data File thru SFTP and B2B.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Data Analyst/ ETL Developer

Responsibilities:

• Collection and analyzing of Churn Data periodically.
• Load and Build Adhoc Reports using Teradata Utilities and scheduling jobs thru SSIS Packages .
• Sqooping Data from HDFS and ETL Jobs using Spark, Python and loading it in Hive .
• Extensively used Informatica for ETL Development.
• Reports were produced on Tableau and Excel Pivots with Auto refresh ScoreCard.
• Prepared the Deployment documents for C ode M igration.
• Involved in Production Support.
• Performance Tuning of Jobs.
• File transfer thru SFTP .
• Worked closely with DBA’s in performance issues.
• Ensures continuing operational quality by documenting bug fixes and enhancements assigning tasks to developers, testing and updates.

Environment: Teradata 15.10, Informatica Power Center 9.5.1, Spark 2.0, Python, Hive 2.0.1, Tableau 10.2, UNIX, SQL Server etc.

Confidential, Richardson, TX

Sr. Informatica SQL Developer and Data Analyst 

• Design critical part that will be the perquisite of conversion
• Implement the changes from mappers / business analyst on daily basis
• Worked with the Team to validate the data alignment and testing to understand the issues and fix them
• Created databases tables, triggers, views, stored procedures, functions, Packages, joins and hash indexes and collect Statistics.
• Led the end to end system testing
• Responsible for code migration, implementation and monitoring with Operations onshore and offshore teams
• Post production support and data analysis to fix bugs and performance tuning.
• Used SQL Developer to write SQL queries for validating constraints, indexes

Environment: Informatica Power Center 9.5.1, Oracle 11g, UNIX, SQL Server 2008, SQL, PL/SQL, DataStage 8.1/8.0.1.

Confidential, Columbia,MD

Sr. Informatica/ ETL Developer

Responsibilities:

• Export the DataStage to XML file and re-import to Informatica .
• Closely check and add transformation and logics which are missed during importing.
• Developed new the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the new requirements.
• Prepared the Deployment documents for code migration and Data migration.
• Involved in Unit testing of the mappings.
• Performance Tuning of sessions and mappings.
• Experience in file transfer thru SFTP .
• Worked closely with DBA’s in performance issues.
• Used Tivoli for job schedule.
• Experience in developing Agile methodology.
• Worked with Dell Offshore team.

Environment: Informatica Power Center 9.5.1, Oracle 11g,, UNIX, Windows, SQL Server 2008, SQL, PL/SQL, DataStage 8.1/8.0.1.

Confidential, Irving, TX

Sr. Informatica/ ETL Developer

Responsibilities:

• Analysis of the existing mappings.
• Enhancements to the existing mappings and sessions.
• Developed the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the requirements.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Extensively used FLOAD and MLOAD utilities in Teradata through Informatica.
• Extensively used Push down Optimization in Informatica.
• Worked on IDQ.
• Involved in testing of the mappings and matching the data with existing warehouse.
• Converted Unix-Oracle scripts to Unix-BTEQ scripts.
• Prepared the Deployment documents for code migration and Data migration.
• Involved in Production Support.
• Involved in Unit testing of the mappings.
• Performance Tuning of sessions and mappings.
• Experience in file transfer thru SFTP and B2B .
• Experience in DataStage implementations, Development and support.
• Experience in developing Data M odel using Kimball's methodology.
• Worked closely with DBA’s in performance issues.

Environment: Informatica Power Center 9.5.1/9.1.1 , Oracle 11g, Teradata, UNIX, SQL Server, SQL, PL/SQL, DataStage 8.1/8.0.1.

Confidential, Irving, Texas

Sr. Informatica/DW Developer

• Understanding the existing system.
• Involved in preparing the Mapping Document.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations, SQL transformation, Union transformation.
• Preparing Sessions, Workflows, Worklets for Mappings.
• Developed reusable Mapplets using Mapplets Designer.
• Designing of control tables, and data error tables.
• Developed reusable transformations using Transformation Developer.
• Interacting with the testing team to solve the issues.

Environment: Informatica Power Center 8.6.1, Flat files, Oracle 10g, SQL,PL/SQL, Putty, Windows XP, Toad, Tivoli, Business Objects, Unix scripting, Win SCP.

Confidential, Richmond, VA

Sr. Informatica/ DW Developer

• Established Informatica platform at client location.
• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Developed complex mappings with transformations like lookup, router, aggregator, expression and joiner confirming to the business rules.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created session tasks (session, command etc.) and managed database connections and scheduled workflows.
• Designed high performance mappings by using iterative variable logic in Expression Transformation.
• Used DT Studio component "parser" to load HL7 formats.
• Good knowledge about DT Studio components like Mapper, Serilazer and Splitter.
• Used Unstructured Date Transformation to integrate DT Studio components with Informatica
• Used SQL*Loader for loading the stage tables.
• Created SQL scripts for views, synonyms
• Performed unit and integrated testing.
• Prepared documentation for business data flow from source to mart.
• Move the mappings and scripts between various environments like the Development, QA and production.
• Creating /Modifying Batch scripts.
• Attend to day today maintains of the loading process.

Environment: Informatica Power Center 7.1/6.2, Flat files, Oracle 9i/8i, Control M, DB2, UNIX (SunOS 5.8), PL/SQL, SQL * Loader, MS SQL Server 2000, SQL Navigator, Windows NT 4.0 Erwin 4.0, Micro Strategy 8.0.2, Mainframes, Toad 8.6, Tera Term Pro, Win SCP

Confidential, Harrisburg, PA

Sr. Informatica Developer

• Understand the existing business system, business exchanges information and Dimensional Data Model of the eCIS.
• Prepare the conversion document plans, synchronization documents plans and design appropriate mappings for conversion and synchronization.
• Test synchronization mappings and compare results with SAP outcome results to verify both results are in sync.
• Schedule mappings using OPCONS scheduler.
• Error Out invalid data and analyze the root cause for errors.
• Maintain Envelope tables to identify the data loads.
• Written DOS scripts to Copy/ Delete the flat files in appropriate folders and initiate scripts from Informatica sessions.
• Data cleansing, Validations, data transformations and calculations in Data flows/ Work flows.
• Created complex Data Flows to load the data mart and monitored them.

Environment: Informatica PowerMart /Power Center 7.2, ETL, Business Objects 5.0, Oracle 9i, DB2 (UDB), Autosys, Teradata V2R5/V2R4, UNIX Shell Scripting, ERWIN 3.5.2, Windows NT 4.0

Confidential

ETL Developer

• Involved in System study, Analysis, and Project Planning.
• Involved in Database Designing and Application programming.
• Writing Database Packages, Stored Procedures & Triggers.
• Tuning of SQL-Statements, stored procedures
• Involved Unit testing and deployment of the application.
• Training the users, support and maintenance of the application.
• Discussions with client for bug fixing and customization of application.
• Analyze data processing requirements to create an ETL packages/Mappings
• Prepare and develop a document specification for designing the mappings/Packages.
• Design the mappings to Extract, Transform and load the data from source to the target system.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Worked with heterogeneous sources to extract data from different sources.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Data cleansing, Validations, data transformations and calculations in mappings.
• Responsible for creating business solutions for Incremental and Full loads.
• Monitors and executes performance tuning of initial and incremental loads.
• Responsible for processing Cubes and Dimensions.
• Cubes/Reports created for HP Global Sales and Marketing using Analysis services.
• Generating scripts for table definition for both dimension and fact tables.

Environment: Informatica 6.2/5.1.2/4.7 , Oracle 8i, SSIS 2005, Business Objects, UNIX, Windows NT

Confidential

ETL Developer

• Developed Conceptual and logical ETL applications to populate data from source to target database by Informatica tool.
• Implemented slowly changing dimensions Type2.
• Create Mapplets for Reuse Transformation logic in Mappings.
• Responsible for generating Reports from Central Confidential Server, using Business Objects Tool.
• Create Mappings in Mapping Designer for transforming Source Data into Target Database by Informatica Tool.
• Create Reusable Transformations in Transformations Developer.
• Responsible for generating Reports from Central Confidential Server, using Business Objects Tool.
• Design and develop application to solve business functional requirements.
• Creating oracle objects like Object Types, Object Views, Packages, Stored Procedures, Functions and Sequences in Oracle8.1.
• Generating Reports against the application data model using Business Objects Tool.
• Performed testing the application.

Environment: Informatica Power Center 7.1.1, Flat files, Oracle 8i, UNIX, SQL, PL/SQL, TOAD

Confidential

Oracle Developer

• Understanding the requirements for Recruitment, Training and Appraisal modules.
• Involved in System study, Analysis, and Project Planning.
• Writing Database Packages, Stored Procedures & Triggers.
• Designing forms to navigate from main screen to different module screens.
• Responsible for creating stored procedures, triggers, functions etc in the backend.
• Participate in Unit testing.

Environment: Windows, UNIX, SQL, PL/SQL, Oracle 7.1.1