SUMMARY

• 7+ years of experience in IT Industry and worked on Data Warehousing projects, Data Integration Projects and Data migration projects with development/Enhancement Projects and also have Production Support Experience.
• Strong experience withInformaticaData Quality IDQ 9.6,InformaticaAnalyst andInformaticaPower Center ETL 9X, 10X ETL tools.
• Good experience with developing Data profiling, Scorecards, Mapplets, Rule, Mappings, workflows, Data Cleansing, Data Standardization process, data exceptional handling usingInformaticaData QualityDeveloperIDQ andInformaticaAnalyst tools.
• Good experience with Informatica Analyst and Developer IDQ tools.
• Expertise in identifying performance bottlenecks and optimizing performance with inInformaticamappings, sessions and workflows.
• Expertise in troubleshooting and analyzing issues/errors and providing resolutions accordingly.
• Extensively worked with XML transformations like XML Generator and XML Parser to transform XML files.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Good experience with automatingInformaticaworkflows with third party scheduling tools.
• Expertise in developing reusable transformations, Mapplets, Workflows, worklets and sessions/tasks in Power Center Tool.
• Hands on experience to conduct scrum meetings and sprint planning by using tools like JIRA, Confluence & HP - ALM to track the progress of projects.
• Expertise in working with Business Analysts, Architects/Project members from different areas including technical and non-technical resources.
• Proficiency in developing SQL with various relational databases like Netezza, Oracle, Teradata, Toad and SQL Server.
• Exposure and experience in different methodologies like Agile and Waterfall.
• Used to work with in Sprints and deliver the efficient code.
• Ability to meet deadlines and handle multiple tasks, work under both Agile and Waterfall methodologies
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.x9.5/9.0/8.x/7.x, OLTP.

Databases: Teradata V2R12/V2R6/V2R5, Oracle 11

Languages: SQL, PL/SQL, Java, C, Shell Scripting, Perl, PHP, XML, HTML.

Data Modeling: MS Visio, Erwin.

Big Data: Hadoop, Hive, Pig, Map Reduce, HDFS, Sqoop.

Tools: SQL Developer, Toad, SQL*Plus, Autosys, MS Office.

Environment: Unix, Windows 7/XP/Vista, Linux.

IT Concepts: Data Structures and Algorithms, Software Development Life Cycle.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

ETL INFORMATICA DEVELOPER

Responsibilities:

• Design and develop quality integration workflows between multiple applications utilizingInformaticatools.
• Built mappings usingInformaticaData Quality and export them as Mapplet toInformatica Power Center to read JSON format files.
• Involved in writing shell scripts for file transfers & file attachments and several other database scripts to be executed from UNIX.
• Worked on SQL server, Oracle, Sybase databases.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Excellent knowledge onInformaticaPower Center development.
• Used UNIX scripts for scheduling and executingInformaticaworkflows.
• Worked onInformatica- Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Worked extensively with sources and target like Flat files, SQL Server tables
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Involved in preparing the migration list inventory.
• Involved in requirement gathering for redesign candidates.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Worked with BA in the QA phase of testing.
• Did performance tune ofInformaticacomponents for daily and monthly incremental loading.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Involved in the preparation of High-level design documents and Low-level design documents.
• Designed and developedInformatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

Environment: Informatica Power Exchange, Business Objects, Oracle, UNIX, Shell scripting, Teradata, Toad, Windows.

Confidential -New York, NY

ETL INFORMATICA DEVELOPER

Responsibilities:

• Extensively used Informatica data Quality,InformaticaPower Center to create and manipulate source definitions, target definitions, mappings, Mapplets, transformations, re-usable transformations, etc.
• Extracted data high volume of data sets from SalesForce.com (SFDC) usingInformatica ETL mappings/SQL PLSQL scripts and loaded to Data Warehouse.
• Used UNIX scripts for scheduling and executingInformaticaworkflows.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Worked on Writing and tuning complex SQL queries and shell scripts.
• Worked on SQL server, Oracle, Sybase databases.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Involved in monitoring the workflows and in optimizing the load times.
• Involved in writing procedures, functions in PL/SQL.
• Wrote complex SQL overrides to join heterogenous databases.
• Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Expertise in SQL and Performance tuning on large scale Oracle, Teradata & Microsoft SQL Server.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Built interfaces and automated them withInformaticaETL tool.
• Extensively usedInformaticafor loading the historical data from various tables for different departments and data marts.

Environment: InformaticaPower Center 7.1, ORACLE 9i, SQL Loader, Windows, ERWIN, PL/SQL, windows batch scripting.

Confidential -Atlanta, GA

ETL INFORMATICA DEVELOPER

Responsibilities:

• Translated the business processes into Informatica mappings.
• Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Worked with high volume datasets from various sources like Oracle, Text Files, relational Tables, and xml targets
• Created and configured database for development and production environments in SQL Server.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
• Developed stored procedures and database triggers using SQL Server.
• Expertise in ETL reporting based on the Flat Files data sourced in different platforms.
• Responsible for file archival using Unix Shell Scripting.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Involved in requirement gatherings from users and translated into technical specifications.
• Monitoring SQL Server Logs, Application logs and analyzing the logs.
• Translation of Business Processes intoInformaticamappings for building Data Marts

Environment: SQL Server 2000, Oracle, Teradata, Business Objects, Informatica power center, Crystal Reports, PL/SQ, Windows NT.

Confidential

INFORMATICA DEVELOPER

Responsibilities:

• Involved in analyzing and development of the Data Warehouse.
• Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision making.
• Involved in information gathering from end user and analyzing the data to developed ER diagram, data dictionaries, and flow charts.
• Actively participated in the requirement analysis, database design and modeling.
• Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
• Created and configured database for development and production environments in SQL Server.
• Developed stored procedures and database triggers using SQL Server.
• Database and log backups & restoration, backup strategies, scheduling the backups. Backing up System & User Databases and restoring them when necessary.
• Loaded the SQL Server database using Bulk Export and Import
• Created database for production environment in SQL.
• UsedInformaticareusability at various levels of development.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Developinformaticamappings and workflows for new change requests.
• Preparing Test Results, Unit testing, Defect Fixing
• DevelopingInformaticaETL jobs to extract data from Source and to load into the Oracle.

Environment: InformaticaPower Center, PowerBuilder, Oracle, Oracle SQLDeveloper, Quest-Toad, Shell Scripts, SQL*Loader, UNIX and Windows.