SUMMARY

• 5+ years of IT experience in data analysis, requirement gathering, development, testing and implementing Data warehousing projects with tools like Informatica and Ab Initio.
• Having over 4 years of experience working in Informatica PowerCenter, IDQ, Informatica Developer, Metadata Manager and B2B Data Transformation/Data Exchange.
• 2+ years of experience working with Ab Initio, GDE and EME.
• Over 4 years of experience working on various databases like Oracle, MS SQL Server and Teradata.
• Experienced in working with Oracle PL/SQL and Teradata BTEQ scripts.
• Experienced in working with JAVA, .NET, C# Programming languages.
• Experienced using Teradata utilities like TPump, Fast Load, Multi Load and Fast Export.
• Knowledgeable in Data Modeling concepts and Data Warehousing concepts.
• Experience integrating multiple sources in addition to databases like XML, CSV and Flat Files.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Experience in Autosys Job scheduling and UNIX Cron jobs.

TECHNICAL SKILLS

ETL Tools: Informatica, Abinitio

DBMS: Oracle, Teradata, SQL Sever

Languages/ Scripting: PL/SQL, BTEQ, Unix Shell Scripts, Perl

Programming Languages: JAVA, .NET, C, C++

Operating Systems: Windows and UNIX Based Operations Systems

Version Control Tools: VSS, GIT Perforce, Subversion, Harvest

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr. Informatica developer

Responsibilities:

• Converted business requirements into technical documents and created Source to Target mappings as needed.
• Extracted data from sources like Oracle, XML files, and Flat files.
• Worked on Informatica Power Center, Power Exchanges, Salesforce Connectors, B2B DT/DX, IDD, Metadata Manager and Informatica Developer.
• Developed workflows, mappings and mapplets to address various business rules/transformation implementations.
• Extensively used SCD’s to handle the Incremental Loading of Dimension and Fact tables.
• Developed B2B DX endpoints for transferring files from various locations to the staging servers.
• Worked on B2B Data Transformation for parsing the PDF’s into XML and validate the responses using Informatica PowerCenter.
• Worked in tuning the existing processes for better performance.
• Modified existing shell script to suite the existing business logic and developed the utility script to archive, move and copy files and also to automate the batch jobs.
• Worked with DBA and infrastructure team to implement the DDLs, refresh data, create DB links, setup environment and delete the log files from the UNIX boxes.
• Responsible in writing SQL queries for Unit Test scenarios.
• Responsible in migrating code from Dev to QA and Prod environments using PTS Integrity tool.

Environment: Informatica Power Center 9.6, Informatica Metadata Manager, IDQ, Informatica Developer, B2B Data Exchange/ Data Transformation, SQL Developer, Oracle 11g, SQL Server, PDF files, XML Files, CSV Files, SQL/PLSQL, LINUX, Windows

Confidential

Informatica developer

Responsibilities:

• Interacted with the Business Analysts to understand the Dodd Frank Act and other business requirements.
• Performed the overall analysis of the application to identify the impacted sources.
• Co - ordinated with the downstream to accompany the sources.
• Modified all the graphs and transformations as required to support the new indicator.
• Developed the views and modified table structures to introduce the new field.
• Unit tested the application with the test data in dev and test environment.
• Worked with the QA team closely for the testing in the UAT environment.
• Monitored the first run in the production environment.
• Worked with the internal team to understand the features of the application.
• Participated in the high level ETL design and developed low level ETL design.
• Performed the overall analysis of the file watchers to gather the source inputs.
• Monitored the dependency analysis to find the flow of the data.
• Developed the required graphs and psets to support the design.
• Developed different tables and views to capture the data.
• Implemented various autosys jils for file watching, transformations and archiving.
• Developed various UNIX scripts to check the files and automate the internal processes.
• Migrated and deployed code in different environments using Harvest and Anthill.
• Handled different types of data including databases, flat and csv files to gather the source data.

Environment: Ab Initio 3.0.1, UNIX Shell Scripting, UNIX, Windows XP, Teradata, SQL server 2008/2008R2, Oracle10G, SQL/PLSQL, Java/J2EE, Harvest, Anthill.

Confidential

Data Warehouse Support

Responsibilities:

• Worked with the business users in understanding of requirements and profile the data.
• Developed source target mappings based on business requirements and the data model.
• Participated in the high level ETL design and developed low level ETL design.
• Created parameter files that are subsequently used by the ETL projects.
• Responsible for developing ETL process to load facts and dimensions.
• Performed unit testing of the ETL processes.
• Developed UNIX shell scripts for file transfer and file watchers.
• Assisted QA in code migration and testing of the application.
• Supported prod environment on round Robbin basis.
• Developed front end of the application using Java SWING framework.
• Supported the .Net code of the application.

Environment: Informatica 9.1, Ab Initio 3.0.1, UNIX Shell Scripting, UNIX, Windows XP, SQL server 2008/2008R2, Oracle10G