OBJECTIVE

• To secure a position that will utilize my analysing and technical skills and gives me enough challenges that will inspire me to give my best.

SUMMARY

• Around 7.5 years of Programmer Analyst experience in data migration, data warehousing, database design.
• Responsible for functional design, technical design, code, testing of Enterprise Information Management, Data Integration and ETL process and applications.
• Generated Data Quality Reports on Source and Target data by using Talend Data Quality Tool.
• Used Jenkins CI to automate the deployment of process of Talend Jobs in Talend Job Server on Cloud.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non - Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklist, Control).
• Installed and Configured DAC (Data Warehouse Administration Console) to manage ETL process.
• Implemented custom procedures to manage indexes, statistics and advanced PLSQL ETL procedures in DAC by creating numerous table actions, index actions and task actions.
• Expertise in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Experience in CDC and daily load strategies of Data warehouse and Data marts, slowly changing Dimensions (Type1, Type2, and Type3) and Surrogate Keys and Data warehouse concepts.
• Hands-on experience in Performance tuning of Informatica ETL Queries.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Experience in writing UNIX shell scripts and handling files with UNIX scripts.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes and Shell scripting.
• Experienced in coding using SQL, PL/SQL stored procedures/functions, triggers and packages.

TECHNICAL SKILLS

Tools: & Utilities: Informatica Power Center 8.x/9.x, DAC, TOAD, HP Quality Center, Putty, PL/ SQL Developer.

Databases: ORACLE 8i/9i/10g,11G, DB2, MS ACCESS, MS SQL Server 2005/ 2000.

Languages: C, C++, SQL, PL/SQL

Methodologies: SDLC, Agile.

Web & Application servers: HTML, XML, IIS.

Operating Systems: Windows 2000/2003/XP/Vista/7/8, UNIX, Linux.

ETL Tools: SAP Business Objects Data services 3.x/4.0, Talend Studio Data Integration 6.1, Informatica Power Center 9.1.0

Scripting Languages: WLST, UNIX Shell Scripting (Bourne, Korn, C and Bash),perl

PROFESSIONAL EXPERIENCE

Lead Engineer

Confidential, Richardson, TX

Responsibilities:

• Responsible for functional design, technical design, code, testing of Enterprise Information Management, Data Integration and ETL process and applications.
• Designed Talend Reference Project for Meta Data and common functionalities to utilize across all Talend Applications as part of Governance Process.
• Governance of application development activities to ensure the compliance with enterprise standards.
• Designed the Talend big data joblets for improving performance of Jobs.
• Used Jenkins CI to automate the deployment of process of Talend Jobs in Talend Job Server on Cloud.
• Written Spark UDF Functions to improving performance of BD batch and Spark Jobs.
• Generated Data Quality Reports on Source and Target data by using Talend Data Quality Tool.
• Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux/Windows for big data resources.
• Data sources are extracted, transformed and loaded to generate CSV data files with Python programming and SQL queries.
• Designed Rest Services using Talend Mediation components for establishing communication between MongoDB and Agent Portal Applications.
• Designed Talend Data Quality Reports on legacy data with custom business rules.
• Extensively used Talend Data Mapper in designing of complex Json objects.
• Provided Production Support existing applications.

Environment: Talend Studio Data Integration 6.1, Talend 7.2.1 DI, Hadoop, Spark, Hive, UNIX, Linux, Shell scripting, SQL, PLSQ

Sr.Talend Developer

Confidential, Somerset, NJ

Responsibilities:

• Interact with Solution Architects and Business Analysts to gather requirements and update
• Solution Architect Document.
• Handled importing of data from various data sources, performed transformations using
• Hive, MapReduce, Spark and loaded data into HDFS.
• Submitted talend jobs for scheduling using Talend scheduler.
• Extensively Worked in Agile software development approach using JIRA
• Leveraged Talend to ingest data into the datalake of datafabric. Unit tested talend workflows for the correctness of the data.
• Developed jobs to expose HDFS files to Hive tables and Views depending up on the schema versions.storing, retrieving and receiving of information about Sybase and Oracle database.
• Supported and produced many web reports which are used for monitoring and maintaining flow of the revenue through processes.
• Responsibilities also include gathering of the requirements, graphical presentations, high level design, implementation and testing of codes.
• Maintain the account of performance issues and developed complex database components.
• Provide on-call support on rotational basis.
• Resolve problems of production by working with the end-users.
• Responsible for the coding of the program before deadline.
• Responsibilities include testing like unit testing, black box testing and system testing.

Environment: Talend Studio Data Integration 6.1, Hadoop, SQL developer, Oracle 11g, Oracle DB, DAC 11g, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, SQL, PLSQL.

Programmer Analyst - ETL

Confidential

Responsibilities:

• Involved in daily meetings to understand the existing issues and gather requirements.
• Understand and discuss the requirements with the Business Unit and functional requirement leads.
• Preparing detailed design document on the business process. Fixed existing internal defects.
• Implementing Slowly Changing Dimension (SCD type II) design for the Data Warehouse.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using the Informatica Power Center.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Migration of code between the Environments and maintaining the code backups.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, Power Center transformations and sessions like re-designing the mappings. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Used debugger in debugging some critical mapping by setting breakpoints and trouble shoot the issues by checking sessions and workflow logs created and maintained various project related documents like high level design documents.
• Creating checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Creating materialized views, tables, views based on the requirements in SQL developer. Creating Stored Procedures for the target MV.
• Created mappings and workflows in Informatica to call procedures and executing them.
• Used Workflow Manager for scheduling the interfaces.
• Unit testing Deploying all the Materialized Views, ETL objects to TEST. Fixing the defects found in System Testing, Debugging Mappings, Transformations, Workflows, Worklets, Sessions using Informatica Power center to fix the defects.

Environment: Informatica Power Center 9.6, SQL developer, Oracle 11g, LINUX, WinSCP, Flat files, Unix Shell Scripting.

Programmer Analyst

Confidential

Responsibilities:

• Analysis, design, development, testing, documentation and implementation of client server applications using state of arts tools like Discoverer, visual basic, Oracle, C/C++ etc. on Unix based platform and window
• Requirement gathering and then develop and design solutions as required.
• Understanding the requirement and Data model to develop the mappings accordingly.
• Creating High Level Design and Low Level Design documents.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets) with various transformations.
• Writing ETL codes, UNIX scripts, SQL queries to check the desired results.
• Delivering the code on time as per schedule.
• Provided technical leadership to the team in order to produce system designs for the framework and code that are scalable, robust, reusable and flexible.
• Involved with the Data Modelling team and provided suggestions in creating the data model.
• Responsible for taking end-to-end ownership of the system for all the technical aspects.
• Implementing best practices and taking delivery standards to the next level.
• Owning design and code reviews and proactively improving system scalability, robustness, performance and flexibility.
• Provide inputs to Project Manager for project planning, providing robust estimates for development tasks.
• Mentoring team and ensuring that design, code / technical deliverables are of high quality.
• Ensuring high quality and zero defect deliveries.
• Involved in Coding, testing and preparing jobs as per the requirements specification.
• Performing Unit Testing for the development /enhancement performed.
• Responsible for debugging any defects came across in the developed mappings and providing logical answers to Testing team.

Environment: Informatica Power Center 9.1.0, SQL developer, Oracle 11g, LINUX, WinSCP, Flat files, Unix Shell Scripting.