PROFESSIONAL SUMMARY:

• 8+ years of strong IT experience in analysis, design, development and testing client server environment with focus on Data Warehousing application using tools like Informatica Power Center9.x/8.x/7.x/6.x, Business Objects with Oracle, SQL Server databases and IDQ.
• Involved in Full Software Development Life Cycle (SDLC) involving Application Development, Data Modeling, Business Data Analysis and ETL/OLAP Processes.
• Strong Data Warehousing ETL experience of using Informatica 9.6.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power center9.x/8.x/7.x/6.x, IDQ and Trillium.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Experience working on Informatica transformations like normalizer, Lookup, Source Qualifier, Expression, Aggregator, Sorter, Rank and Joiner.
• 4+ years Experience on Talend ETL Enterprise Edition for Big data/Data integration/Data Quality.
• Experience in Big Data technologies like Hadoop/Map Reduce, Pig, HBASE, Hive, Sqoop, Hbase, Dynamodb, Elastic Search and Spark SQL.
• Experienced in ETL methodology for performing Data Migration, Data Profiling, Extraction, Transformation and Loading using Talend and designed data conversions from large variety of source systems including Oracle 10g/9i/8i/7.x, DB2, Netezza, SQL server, Teradata, Hive, Hana and non-relational sources like flat files, XML and Mainframe files.
• Involved in code migrations from Dev. to QA and production and providing operational instructions for deployments.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Hands on experience in Pentaho Business Intelligence ServerStudio.
• Expertise in Using transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Java Transformation, Router and Sequence generator.
• Experience in Big Data technologies like Hadoop/Map Reduce, Pig, HBASE, Hive, Sqoop, Hbase, Dynamodb, Elastic Search and Spark SQL.
• Extensive experience in Talend BigData 6.2.1 Enterprise Version.
• Adaptive to AWS Services like S3, Redshift, Step Functions, DynamoDB, CloudWatch, EC2, Lambda, SNS.
• Experienced on designing ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Excellent experience on designing and developing of multi-layer Web Based information systems using Web Services including Java and JSP.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assitant.
• Experienced in integration of various data sources like Oracle SQL, PL/SQL, Netezza, SQL server and MS access into staging area.
• Experienced in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experienced in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing shell scripts and automation of the ETL processes using shell scripting, and also used Netezza Utilities to load and execute SQL scripts using Unix.
• Experienced in using Automation Scheduling tools like Autosys and Control-M.
• Experience in data migration with data from different application into a single application.
• Responsible for Data migration from mySQL Server to Oracle Databases
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix, AWS, Windows 2010/2008/2007/2005/ NT/XP.

ETL Tools: Informatica Power Center 9.x/8.x/7.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), IDQ.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2/UDB, Mongo DB, Teradata.

Data Modelling Tools: Erwin, MS Visio, E/R Studio, Excel, SAS, R language.

Reporting Tools: Reporting services SSRS, SSIS Tableau, and Micro strategy

Languages: Java, JavaScript, HTML, Perl, SQL, PL/SQL, UNIX, Shell scripts, C++, R.

Autosys, Control: M.

Tools: Selenium, QTP, Win Runner, Load Runner, Quality Center, Test Director, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Talend/ETL Developer

Responsibilities:

• Involved in End-End development of the implementation and Roll out.
• Implemented File Transfer Protocol operations using Talend Studio to transfer files in between network folders.
• Work on Data Migration using export/import.
• Created Talend jobs using the dynamic schema feature.
• Created Talend jobs to copy the files from one Database to another and utilized Talend components.
• Used the Custom Components in the Talend
• Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM.
• Spring boot (STS) deployment, configuration and maintenance across a variety of UNIX and Windows platforms.
• Developed data validation rule in the Talend MDM to confirm the golden record.
• Data governance and Clean up old reports everyday generated by a Data base.
• Impact analysis on current system by the new requirement.
• Production Implementation and Creating SQL Queries using Teradata.
• Monitoring the job, checking job status using Bamboo.
• Utilized Big Data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreResult, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.
• Working on POC wrt BigData like loading the data into HDFS and creating Map Reduce Jobs .
• Implemented Error handling in Talend to validate the data Integrity and data completeness for the data from the Flat File.
• Coordinated with the business to gather requirements and preparing Functional Specification document.
• Created Talend Development Standards. This document describes the general guidelines for Talend developers, the naming conventions to be used in the Transformations and development and production environment structures.
• Worked on Talend ETL and used features such as Context variables, Database components like tDBLInput, tdbOutput, file components, ELT components etc.
• Involved in automation of Springboot process in Talend and the Files in UNIX.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Used ESP as a Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)
• Involved in end-to-end testing of jobs.
• Wrote complex SQL queries to take data from various sources and integrated it with Talend.
• Involved in designing Logical/Physical Data Models, reverse engineering for the entire subject across the schema.
• Developed and executed a migration strategy to move Data Warehouse from an Oracle platform to AWS Redshift.
• Load data into Amazon Redshift and use AWS Cloud Watch to collect and monitor AWS RDS instances .
• Developed complex Talend ETL jobs to migrate the data from flat files to database.
• Developed Type-1 and Type-2 mappings for current and historical data.
• Used Parameter Variables and Mapping variables for incremental data feeds.
• Used Shared folders for Source, Targets and Lookups for reusability of the objects.
• Scheduled the Informatica jobs from third party scheduling tool ESP Scheduler.
• Involved/Migrated Informatica from 8.6 to version 9.6
• Performed administrator role in migrating the objects from one environment to the other DEV/QA/PROD.

Environment: Talend open studio (7.0) Informatica Power Center 8.6.1, 9.6.1, Teradata data base, SQL, PL/SQL, Teradata studio, DB Vis, Unix, Spring boot (STS), ESP, Bamboo.

Confidential, Austin, Texas

Talend/ETL Developer

Responsibilities:

• Involved in End-End development of the implementation and Roll out.
• Implemented File Transfer Protocol operations using Talend Studio to transfer files in between network folders.
• Created projects in Talend administration center(TAC)and assigned roles to the users.
• Worked Talend End to End Development which includes all Talend Admin Tasks.
• Handling Talend admin tasks like user creation, job scheduling, execution plan, command line etc.
• Talend Admin tasks like Installation, Configuration, Job Server Configuration, Command line, Project creation, assigned user access, Job Scheduling etc.
• Work on Data Migration using export/import.
• Created Talend jobs using the dynamic schema feature.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Worked on Joblets (reusable code) & Java routines in Talend
• Implemented Error handling in Talend to validate the data Integrity and data completeness for the data from the Flat File.
• Integrated maven with GIT to manage and deploy project related tags.
• Installed and configured GIT and communicating with the repositories in GITHUB
• Performed necessary day to day Subversion/GIT support for different projects.
• Created and maintained Subversion/GIT repositories, branches and tags
• Coordinated with the business to gather requirements and preparing Functional Specification document.
• Created Talend Development Standards. This document describes the general guidelines for Talend developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Worked on Talend ETL and used features such as Context variables,
• A data fabric unifies data management across distributed resources to allow consistency and control of data mobility, security, visibility, protection, and access.
• Involved in automation of FTP process in Talend and also load the data in the salesforce
• Optimized the performance of the mappings by various tests on sources, targets and data fabric.
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)
• Involved in end-to-end testing of jobs.
• Wrote java conditions to take data from various sources and integrated it with Talend.
• Involved in designing Logical/Physical Data Models, reverse engineering for the entire subject across the schema.
• Developed over 90 mappings to support the business logic including the historical data for reporting needs.
• Developed complex Talend ETL jobs to migrate the data from flat files to database.
• Used transformations like Router, Update Strategy, Lookups, Normalizer, Filter, Joiner and Aggregator.
• Developed Type-1 and Type-2 mappings for current and historical data.
• Incorporated business logic for Incremental data loads on a daily basis.
• Used Parameter Variables and Mapping variables for incremental data feeds.
• Used Shared folders for Source, Targets and Lookups for reusability of the objects.
• Performed administrator role in migrating the objects from one environment to the other DEV/QA/PROD.

Environment: Talend Studio 6.0.1/5.5, Oracle 11i, XML files, Flat files, HL7 files, JSON, TWS, Hadoop 2.4.1, HDFS, Hive 0.13, HBase 0.94.21, Talend Administrator Console, IMS, Agile methodology, HPSM.

Confidential, New York

Talend/ETL Developer

Responsibilities:

• Interact with Solution Architects and Business Analysts to gather requirements and update Solution Architect Document.
• Analyze and create low level design document (LLD) and mapping document.
• Performed analysis, design, development, Testing and deployment for Ingestion, Integration, provisioning using Agile Methodology.
• Attended Daily Scrum meetings to provide update on the progress of the user stories Rally and to the Scrum Master and to notify blocker and dependency if any.
• Experienced in creating Generic schemas and creating Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
• Involved in integrating different Database Applications using SSIS packages.
• Creating SSIS packages that involves migration from legacy systems to centralized Database.
• Experienced in Talend Data Integration, Talend Platform Setup on Windows and UNIX systems.
• Created complex mappings in Talend 6.0.1/5.5 using tMap, tJoin, tReplicate, tParallelize, tJava, tjavarow, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
• Created joblets in Talend for the processes which can be used in most of the jobs in a project like to Start job and Commit job.
• Developed jobs to move inbound files to vendor server location based on monthly, weekly and daily frequency.
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages in oracle and hive.
• Assign ICD-9-CM / ICD-10 and/or CPT/HCPCS codes as appropriate along with abstracting pertinent information within records.
• Implemented Change Data Capture technology in Talend in order to load data to a Data Warehouse.
• Created jobs to perform record count validation and schema validation.
• Created contexts to use the values throughout the process to pass from parent to child jobs and child to parent jobs.
• Developed joblets that are reused in different processes in the flow.
• Developed error logging module to capture both system errors and logical errors that contains Email notification and also moving files to error directories.
• Provided the Production Support by running the jobs and fixing the bugs.
• Experienced in using Talend database components, File components and processing components based up on requirements.
• Experienced in creating MFT (Managed File Transfer) Mock jobs for HL7 2.5.1 LAB and ADT transactions in Talend Big Data 6.2.
• Experienced in converting pipe delimited data Ex: HL7V 2.5.1, into JSON structure using Talend Components.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.
• Performed unit testing and also integration testing after the development and got the code reviewed.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
• Used Data Loader to insert, update bulk data to Salesforce.com objects and to read, extract and load data from comma separated values (CSV) files.

Environment: Talend Studio 6.0.1/5.5, Oracle 11i, XML files, Flat files, HL7 files, JSON, TWS, Hadoop 2.4.1, HDFS, Hive 0.13, HBase 0.94.21, Talend Administrator Console, IMS, Agile methodology, HPSM.

Confidential

Informatica/ETL Developer

Responsibilities:

• Actively involved in gathering business requirements and performing GAP analysis.
• Translated Functional requirements into Technical specification documents.
• Developed ETL mapping spreadsheet and Fact-Dimension matrix prior to performing the ETL process.
• Used complex transformations such as Connected and Unconnected Lookups, Joiner, Router, Filter and Stored Procedure transformations for data loads
• Worked with Memory management for the best throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning
• Debugged and implemented the best practices in mappings, sessions and workflows for data extraction and loading into Slowly Changing Dimensions type 1 and type 2
• Created test plan cases and performed Unit, Volume and Performance tests.
• Created and scheduled Informatica workflows using Crontab application.
• Imported physical tables and created the required aliases, views, joins in the Physical layer of Siebel Analytics Admin tool.
• Developed the facts, dimensions, necessary hierarchies and the joins between the logical tables, added aggregates in the BMM layer.
• Implemented various performance tuning mechanisms by performing Query Optimization, Hints, running advice plans and explain queries on indexes and creating Materialized Views to execute the prompts on the Dashboards faster.

Environment: Informatica power center, IDQ, Microsoft Visio 2003, Oracle 8i/9i, PL/SQL, UNIX, Windows NT/2000 and Siebel.

Confidential

SQL - ETL Developer

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005/2008.
• Created and executed several SSIS packages to perform ETL operations of the data from source server to destinations server and OLTP to OLAP.
• Experience in creating complex SSIS packages using proper control and data flow elements with Error Handling.
• Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Transfer Data from Database to Data Warehouse using SSIS ETL packages such as look up, union-all, multicast Transformations.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the reports.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Build, Published and Scheduled SSRS Reports for both Dev and Test Environment.
• Database backups and troubleshooting production databases and cube sync processing issues and SSAS issues.
• Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.

Environment: SQL Server 2008/2005, SSIS, SSRS, T-SQL, Crystal Reports 7/8, Windows 2008 Advance Server, VB.NET, MS Excel, and MS Office.

Confidential

Junior SQL Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Used DDL and DML commands for writing triggers, stored procedures and data manipulation.
• Involved in tuning system stored procedures for better performance.
• Involved in the Data modeling, Physical and Logical Design of Database
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed.
• Worked with the application developers and provide necessary SQL Scripts using SQL and PLSQL.
• Responsible for the management of the database performance, backup, replication, capacity and security.

Environment: MS SQL Server 2008, T-SQL, SQL Server Management Studio (SSMS), SQL Profiler, Visual Source Safe (VSS), Windows XP.