PROFESSIONAL SUMMARY:

• Overall 13+ years of work experience in the field of analysis, design, development, testing and implementation of Data Integration and Data Warehouses projects.
• Extensively worked in Informatica PowerCenter, Talend, Oracle and UNIX. Have also worked on Tableau 10.2 and done few POCs in Big Data, Hadoop.
• Worked Extensively on Informatica PowerCenter 10.X/9.X, Talend, Oracle and UNIX.
• Experience in optimizing Informatica mappings and sessions for performance.
• Experience in developing ETL jobs in Talend.
• Created different PL/SQL objects to efficiently manage the data flow.
• Worked on creating reports and workbooks in Tableau 10.X.
• Extensive hands on experience in ETL designing.
• Worked on different POC’s in Hadoop Ecosystem using HDFS, Hive, Pig, Sqoop and Cloudera. knowledge on Hadoop ecosystems such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node . Knowledge on Hadoop distributions from Cloudera.
• Experience in preparing the ETL Design Documents like High Level and low - level Design documents. Quick learner with ability to plan, organize, prioritize the work to meet deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.X/9.X Talend

Reporting Tools: Tableau Desktop10.2

Language & Scripting: PL/SQL, AWK & Sed, Java

Databases: Oracle 11g, SQL Server

Operating Systems: UNIX, Windows

Scheduling tool: DAC, Informatica Scheduler

Hadoop: HDFS, Hive, Pig, Sqoop

PROFESSIONAL EXPERIENCE:

Confidential

Talend Developer

Responsibilities:

• Build Dimensional Data Model to house data from various sources.
• Design and Develop Talend ETL jobs for loading data to the new Data Mart from existing Everest.
• Leverage existing exception handling, logging framework.
• Help marketing and sales team in getting the required BI reports for their marketing strategies.

Tools: Used: Tableau 10.X, Talend 6.5 Open Studio, Oracle

Confidential

ETL/BI Developer

Responsibilities:

• Translate and refine already developed reports in OBIEE into Tableau workbooks.
• Design, develop, and implement reporting solutions in Tableau while maintaining expected productivity and quality expectations
• Produced attractive visuals/dashboards to convey the story inside the data. Also developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Created lot of custom reports for the Executives.
• Worked on ETL tasks for the ingesting diverse set of files into central repository using Talend Open Studio.
• Responsible for importing, cleansing, transforming, validating and analyzing the data present in different file formats.
• Create different SCD type II mappings for loading of dimension tables.

Tools: Used: Tableau 10.X, Talend 6.5 Open Studio, Oracle

Confidential

Technical Lead

Responsibilities:

• Involved in all phases of SDLC, requirement, design, development, testing, migration and support for production environment.
• Designed and developed different ETL mappings for SCM Module using Informatica 9.x and DAC.
• Created Mappings using Mapping Designer to load the data from various sources.
• Extensively worked with various Lookup caches like, Static cache, Dynamic cache and Persistent cache. Tuned the Informatica mapping and session for long running jobs. Worked on scheduling workflows with DAC.
• Enhancement of existing components in the application and ensure the new component doesn’t affect existing application.
• Simultaneously worked on multiple business units like Lighting, Power and RF, LED, XLamp, HB Lamps. Perform all the administrative tasks related to Informatica and DAC.
• Created different PL/SQL objects to efficiently manage the data flow.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Take a backup of Informatica repository, Managing Roles and Privileges.
• One point of contact for any production issues related to ETL activities.

Tools: Used: Informatica Power Center 9.0.1, OBIEE 11g, SQL developer and Oracle 11g

Confidential

Module Leader

Responsibilities:

• Designed end-to-end ETL framework for the Gateway.
• Prepare the HDL (High level Design) and LLD (Low Level Design)
• Requirement Analysis through business model and functional model.
• Designed processes for the framework, which include processes for Data Cleansing and Quality checks.
• Created low level designs for ETL processes, which are generic in nature and completely metadata driven using Informatica.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder, also take care of the housekeeping scripts
• Executed multiple feeds in the Gateway across various phases of SDLC, from requirement analysis to development, SIT, UAT and Production.
• Onsite coordination, Preparation and deliver Daily/Weekly Status Report
• Created knowledge base and induction framework for new resources coming in the project.

Tools: Used: Informatica Power Center 8.6.1, SQL Developer, Shell Scripts, Oracle 10g

Confidential

Senior Developer /Team Lead

Responsibilities:

• One point of contact for any enhancements or production issues.
• Analyze production issues with Data Stage load and work with DBAs, Unix Administrators and FTP teams to resolve the issue in a timely manner.
• Involve in the creation of DDL and DML scripts for stage and target tables as per the requirements.
• Proactively worked on Bug fixes and automation projects
• Designing the strategy in which makes the data load optimized.
• Resolve the issues related to the production.
• Point of contact for the application related issues.

Tools: Used: Data Stage, DB2, Shell Scripts

Confidential

Senior Developer

Responsibilities:

• Play key role in writing the shell scripts in order to automate the whole application.
• Used Sed and AWK extensively in the shell scripts
• Thoroughly test and debug programs to ensure accurate results and desired output, also Created different INI files to be used by the Wrapper scripts.
• Migrated the code to the production
• Performed the Unit testing and system testing for the automated application scripts.
• Provide support to the project after the implementation.

Tools: Used: AIX, Shell Scripting, DB2, XML