PROFESSIONAL SUMMARY:

• Over 10 + Years of IT Experience in development of Enterprise Data Warehouse applications using Informatica, Oracle and Teradata.
• Experience in all phases of Data warehouse development from Requirements, analysis, design, development, testing and post production support.
• Strong in - depth knowledge in doing data analysis, data quality and source system analysis.
• Experience in Big Data Technologies using Hadoop, Sqoop, Pig and Hive..
• Experience in writing Pre-Sessions and Post-session Unix commands and writing batch sripts for automation (run workflows) using Control-M scheduling tool.
• Strong Knowledge in OBIEE and OBIA

COMPUTER EXPERTISE:

ETL Tools: Informatica, Data Stage, SSIS

Databases: Teradata 12/13/14, Oracle 9i/10g/11g/12c, MySQL, SQL Server 2000/2005, MS Access, DB2, Hadoop (HDFS)

GUI: .Net Custom development, Business Objects, Micro Strategy

Operating Systems: Windows, Unix, Linux

Languages: C#, VB Script, HTML, DHTML, Java Script, SQL, PL/SQL, Unix Shell, Python, Hive, Pig, R

Web Related: ASP.NET, VB Script, HTML, DHTML, JAVA, Java Script

Tools: & Utilities: Teradata Parallel Transporter, Aprimo 6.1/8.X, Bteq, SQL Assistant, Toad, SQL Navigator, SQL*Loader, $U, HP Quality center, PVCS, Data Flux, UC4, Control-M

Domain Knowledge: Banking, Finance, Insurances, Health Care, Energy, Retail

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, Pleasanton, CA

Responsibilities:

• Analysis Design, Development, Testing and Deployment of Informatica workflows, Python and Shell scripts.
• Worked with Confidential and united business users to capture data requirements and transformational rules between source systems with Albertsons EDW.
• Developed Mapping and design documents for Sales, Promotional and Marketing data.
• Performed data profiling, source systems analysis to understand data and quality issues
• Source System Analysis and provide input to data modeling and developing ETL design document as per requirements.
• Developed Mapplets and worklets as a part of standard procedure while developing SAP inbound/outbound mappings.
• Working closely with QA Team, Release Engineering Team, and Operations Team and provide timely responses for Bugs and Issues.

Environment: Informatica Power Center, Power Exchange, Oracle, Control-M, Unix.

ETL Developer

Confidential, Sacramento, CA

Responsibilities:

• Source System Analysis and provide input to data modeling, and developing ETL design document as per business requirements.
• Design, Developing and testing of the various Mappings and Mapplets, worklets and workflows involved in the ETL process.
• Developed and Integrated Data Quality measures into ETL frame work using Informatica Data Quality ( IDQ ).

Environment: SQL Server, PL/SQL, MySQL, Informatica Power Center, Windows XP, UNIX Shell scripting.

ETL developer

Confidential, CA

Responsibilities:

• Developed Mapplets and worklets as a part of standard procedure while developing SAP inbound/outbound mappings.
• Strictly Followed the ETL development standards, i.e. naming conventions, Transformation comments, and documented the ETL code ranging from port level to workflow level.
• Developed and Integrated Data Quality measures into ETL frame work using Informatica Data Quality ( IDQ ).
• Experience in data profiling using IDQ for input into ETL Design and Data Modelling.
• Developed Sqoop Jobs to integrate Data from Oracle and Teradata for application migration.
• Transformed data from STG Tables into Final Tables using Hive Scripts.
• Developed PIG scripts for Analysts to analyze data on HDFS.
• From Hadoop used to refine and analyze clickstream data

Environment: Informatica Power Center, Pig, Hive, Oracle, PL/SQL, Windows, Business Intelligence, HP Quality center, Unix.

ETL and Teradata Developer

Confidential, CA

Responsibilities:

• Analysis, Design, Development, Testing and Deployment of Informatica workflows, BTEQ scripts, Python and shell scripts.
• Source System Analysis and provide input to data modeling, and developing ETL design document as per business requirements.
• Design, Developing and testing of the various Mappings and Mapplets, worklets and workflows involved in the ETL process.
• Developed and Integrated Data Quality measures into ETL frame work using Informatica Data Quality ( IDQ ).

Environment: Teradata, Oracle, PL/SQL, MySQL, Informatica Power Center 8.6/9.1, Power Exchange, IDQ, OCL Tool, UC4, Control-M, ER Viewer, Business Intelligence, Windows, HP Quality center, Unix, Linux.

ETL Developer

Confidential, Annapolis, MD

Responsibilities:

• Developed Mapplets and worklets as a part of standard procedure while developing SAP inbound/outbound mappings.
• Strictly Followed the ETL development standards, i.e. naming conventions, Transformation comments, and documented the ETL code ranging from port level to workflow level.
• Developed Low level mappings for Tables and columns from source to target systems.
• Wrote and optimized Initial data load scripts using Information and Database utilities.
• Using Partitions to extract data from source and load it to Teradata using TPT load with proper load balance on Teradata server.
• Wrote Complex Bteq scripts to in corporate Business functionality in transforming the data from Staging into 3rd normal form.

Environment: Teradata, Oracle, PL/SQL, MySQL, Informatica Power Center, SSIS, SSRS,ER Viewer, Windows XP, HP Quality center, UNIX Shell scripting.

Confidential, Owings Mills, MD

Senior ETL Developer

Responsibilities:

• Conduct source System Analysis and developed ETL design document to meet business requirements.
• Tuned Teradata Sql queries and resolved performance issues due to Data Skew and Spool space issues.
• Developed Flat files from Teradata using fast export, Bteq to disseminate to downstream dependent systems.

Environment: Teradata, Oracle 9i/10g PL/SQL, Informatica Power Center, $U, Business Objects, SSIS, Windows XP, UNIX Shell scripting.

Confidential, Temple, TX

ETL Developer

Responsibilities:

• Documenting functional specifications and other aspects used for the development of ETL mappings
• Design, Developing and testing of the various Mappings and Mapplets, worklets and
• Optimized Performance of existing Informatica workflows.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.

Environment: Oracle 9i, SQL Server, DB2, Informatica Power Center, Erwin, Cognos, XML, Windows NT/2000, Unix

Confidential, Minnesota, MN

ETL Developer

Responsibilities:

• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer
• Extracted data from various sources across the organization (Oracle, SQL Server and Flat files ) and loading into staging area
• Created and scheduled Sessions and Batch Process based on demand, run on time, or run only once using Informatica Workflow Manager and monitoring the data loads using the Workflow Monitor

Environment: Oracle 9i, SQL Server, PL/SQL, Informatica Power Center, Erwin, Cognos, Windows, UNIX