SUMMARY:

• 6+ years of experience in IT Industry involving Software Analysis, Design, Implementation, Coding, Development, Testing and Maintenance with focus on Data warehousing applications using ETL tools like Talend open studio and Informatica Power center/IDQ
• Extensive knowledge of business process and functioning of Heath Care, Manufacturing, Mortgage, Financial, Retail and Insurance sectors.
• Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data
• Extensive experience in handling ETL using Informatica PowerCenter9.x/8.x, Talend Integration Suite (7.1/6.4/6.1x) / Talend Open Studio (6.4/6.1) and Talend Admin Console (TAC).
• Extensive experience in using Talend features such as context variables, triggers, connectors for Database and flat files like tMySqlInput, tMySqlConnection, tMSSqlInput, TMSSqlOutput, tMSSqlrow, tFileCopy, tFileInputDelimited, tFileExists.
• Extensive experience in using Talend features such as context variables, triggers, connectors for Database and flat files like tMySqlInput, tMySqlConnection, tOracle, tMSSqlInput, tMSSqlOutput, tMSSqlrow, tFileCopy, tFileInputDelimited, tFileExists.
• Experience in using cloud components and connectors to make API calls for accessing data from cloud storage (Google Drive, Salesforce, Amazon S3, DropBox ) in Talend Open Studio.

TECHNICAL SKILLS:

ETL Tools: Talend Open Studio (TOS) for Data Integration(7.1/6.5/6.0), Informatica Power Center 9.6/9.5/9.1/8.6, Informatica IDQ 9.5.1Security: CA SiteMinder 12.0,12.5, Sun ONE Directory Server 6.3

OLAP/BI: OBIEE 10.1, Cognos 10.5.1

DBMS: 1010,Netezza, Oracle 11g/10g,MYSQL,SQL Server 2008, MS Excel, Flat Files, Teradata v2r12 etc

Languages: C, C++, Java, SQL, PL/SQL, HTML, UNIX

Windows 2008/2003/XP, HP: UnixOthers: MS Office Suite, SQL Developer, Aginity workbench

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park, KS

Software Engineer / Talend / Informatica Developer

Responsibilities:

• Responsible for activities related to the implementation and development of ETL processes for data warehouse using Talend Integration and open studio for data integration 7.x/6.x, Informatica Powercenter 9.1
• Analyzed the requirements and framed the business logic and implemented it using Talend Open Studio
• Worked in the Data Integration Team to perform data and application integration with a goal of moving data more effectively, efficiently and with high performance to assist in business-critical projects coming up with huge data extraction.
• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc
• Used Talend reusable components like routines, context variable,s and global Map variables and used SVN for version control tool for Talend jobs.
• Analyzed the requirements and framed the business logic and implemented it using Talend and involved in ETL design and documentation.
• Responsible for profiling the source systems data using Different DQ Techniques and Worked on the design, development and testing of Talend mappings.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Extracted data from AWS system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
• Investigating and fixing the bugs that occurred in the production environment and providing on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Thoroughly tested the Sql scripts by validating the data and cross comparing the data across five lines of business for adhoc reports
• Parameterize hard-coded values

Environment: Talend Integration studio7.1/6.1/5.6,Informatica Powercenter 9.1 x, SQL,MYSQL, Flat Files, XML, sequel Pro, SQL server 2008, TAC, Amazon S3, MAC OS, MS Excel, Sisense,Jira

Confidential, Thousand Oaks, CA

Informatica / IDQ Developer

Responsibilities:

• Responsible for activities related to the development and implementation of ETL processes for large scale data warehouse using Informatica Power Center
• Worked with Informatica Data Quality (IDQ) 9.5.1 Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks
• Worked with a team in the integration of various data sources definitions like SQL Server, Oracle, Flat Files
• Analyzed the systems, met with end users and business units in order to define the requirements
• Understand the prebuilt mappings and design the new mapping based on the existing standards if required
• Implemented Type 2 Slowly changing dimensions to keep track of current and complete historical data.
• Created sessions and batches and scheduled them on Success tasks like Email to the ETL team and Business Analysts.
• Worked extensively on fixing invalid Mappings and Integration Testing of Informatica Sessions
• Created and scheduled jobs using Control-M
• Responsible for unit testing the developed mappings and involved in UAT sessions.
• Involved in migrating the plans from Development to Production and automating the process
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
• Preparing ETL Mapping Documents For Every Mapping And Data Migration Document For Smooth Transfer Of Project From Development To Testing Environment And Then To Production Environment.
• Created Parameter files and created the shell scripts to update the parameter file for each and every data load
• Extensively used UNIX shell scripts and commands for data loading
• Used Extensively re-usable Mapplet for the audit tables
• Performance Tuning Of Various Mappings And Sessions To Identify And Remove Bottle Necks.

Environment: Informatica Power Center 9.5.1 hf3/9.6.1, IDQ 9.5.1, Teradata SQL Assistant, SQL developer, Flat Files, XML, SQL server 2008, Teradata, Oracle, control-M, Windows XP, MS Excel, Cognos