SUMMARY:

• Sr. ETL/Java Developer with over 13 Years of experience in Software Development Life Cycle(SDLC) within Design, Coding, Testing, Development and implementation of Data Warehouse/DataMart under Unix and windows Environments.
• Extensive SQL, ETL experience with Talend Data Integration and excellent concepts in Development and design of ETL/ Data Warehousing Methodologies to support Data Transformations and Processing ETL Solutions.
• Above 13 Years ’ of professional experience in Information Technology with extensive experience in Design, Development, Maintenance, Enhancements and Production Support the field of Enterprise Data Warehousing (EDW) and Data Integration.
• 8+ Years’ Experience working in an Agile/Scrum environment.
• Extensive design, development and testing experience with Talend Data Integration and Talend with Big Data
• Strong background in Oracle/Netezza/MS SQL Server RDBMS
• Expertise in Data modeling techniques like Data Modeling - entity-relationship, Dimensional/ Star Schema and Snowflake modeling, Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3).
• Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions), Complex SQL Tuning, SQL Server Data Warehousing best practices etc
• Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems including Netezza, Oracle, DB2, SQL server and non - relational sources like flat files, XML and Mainframe files.
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle.
• Knowledge of Data Warehouse/Data Mart design concepts.
• Experience with business requirements gathering, business analysis and documentation.
• Expertise in applying data integration concepts in Retail business verticals, Pre and Post POS Data and in Retail CPG Market Research.
• Experience on migrating applications to Azure Could.
• Good programming skills using Java, J2EE, PL/SQL
• Sound experience in Data Virtualization using Composite Information Server
• Strong analytical skills with a knack for problem solving.
• Expertise in creating mappings in TALEND using tMap, tJoin, tReplicate, tParallelize, tConvertType,, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap, tDie etc.
• Expertise on tHDFSConnection, tHDFSInput, tHDFSOutput, tHDFSCopy, tHDFSDelete, tHDFSGet, THDFSPut, THiveConnection, THiveLoad, tHiveRow, THiveLoad, THiveCreateTable etc.
• Highly skilled, motivated team player with excellent communication and inter-personal skills.
• Ability to work well under pressure and meet deadlines

TECHNICAL SKILLS:

ETL Tool: Talend Data Integration

Databases: Netezza, Oracle 10g & 11i, Teradata, MS SQL Server, DB2, MySQL

DB Tool: Toad, SQL Developer, PL/SQL Developer, WinSQL, Squirrel Client, Golden & SQL Assistant

Language: Java, J2ee, Spring Rest Web Service, Spring Boots

Scheduling Tool: ESB Scheduler, Autosys

Other Tools: Composite Information Server HP QC, BMC-Remedy, Eclipse, Tomcat Server, SVN, Atlassian Tools (Bit Bucket, JIRA, Confluence, Bamboo)

Operating Systems: Window Family, Linux and Solaris

EXPERIENCE:

Confidential, Chicago, IL

Technologies Used: Talend DI, Telend Big Data, Cloudera, Talend MDM, Oracle 11i, Web service Call from Talend Jobs, PL/SQL

Responsibilities:

• Responsible for understanding the Ab Initio Job
• Responsible for understanding & deriving the new requirements which are to be implemented in Talend Job as part of Migration from Business
• Responsible for profiling the source systems data.
• Process very large files(400GB+) files via Spark Big Data Jobs
• Responsible for develop the DI jobs to implement the address validations, cleans and standardization on Talend ETL.
• Responsible for MDM for Merchandise Data Talend MDM Standardizations
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Responsible for inject the data from multiple source systems and multiple Source types
• Responsible for develop the jobs using tRESTClient, tRESTRequest, tRESTResponse to get the service calls
• Responsible for preparing the logical/physical design of tables involved for this new enhancement within EDW.
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages in oracle Database.
• Interacting with Business owners directly and provide the tested solutions for their user sign-off.
• Responsible for accepting ad hoc modifications/new enhancements from Business users for existing & new applications& incorporated the change without effecting the current functionalities.
• Responsible for improving/maximizing the ELT jobs performance by modifying the query/mappings and partitioning the sessions using performance-tuning techniques.

Confidential, Chicago, IL

Technologies Used: Talend, Java, SQL Server, Spring Boots, Spring Web services, Azure Cloud

Responsibilities:

• Transformed the SDLC from Waterfall to Agile.
• Migrated from On-Prem UNIX to Azure Cloud.
• Evaluate design alternatives.
• Make high-level design choices and dictates technical standards.
• Responsible for develop the DI jobs to implement the address validations, cleans and standardization on Talend ETL.
• Extracting the data from the flat files and heterogeneous Relational databases into staging area and populated into data warehouse using SCD logic to maintain the history.
• Developed number of complex Transformations Jobs to implement the business logic and to load the data incrementally ( delta load/full load )
• Worked on optimizing and tuning the Netezza and Oracle SQL’s to improve the performance of batch and response time of data for users.
• Experienced in the performance tuning part in SQL/PLSQL queries
• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Maintained Code standards in warehouse metadata, naming standards and warehouse standards for future application development
• Created & maintained tables, views, synonyms and indexes from Logical database design document.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data Warehouse Environment
• Created and Documented ETL Test Plans, Test Cases, Expected Results, Assumptions and Validations
• Provided technical Support in deployment of workflows, Talend Jobs and maintained the same in Run Book.
• Data corrections - problem finding using custom scripts written in SQL/PLSQL and problem solving using SQL/PLSQL with procedures and functions
• Regular maintenance of billing activities and daily issues resolving using SQL/PLSQL
• Efficient design and construction of the system to extract data from operational systems into the defined physical data model per the business and technical requirement.
• Review the requirement documents with the Client Data Analyst team and the Business teams as Business System analyst.
• We did some POC kind of thing for 1 Year to migrate the project using Talend tool. And to Azure Cloud
• Used SVN for version control tool for Talend jobs.

Confidential, Chicago, IL

Technologies Used: Talend, Java, SQL Server, Spring Boots, Spring Web services, Azure Cloud

Responsibilities:

• Agile Methodology
• Responsible for remodeling the Existing business logic to new Netezza models for EDW
• Understanding the exiting SQL Server Store procedures logic and convert them into ETL Requirements.
• Responsible for understanding & deriving the new requirements from Business
• Efficient design and construction of the system to extract data from operational systems into the defined physical data model per the business and technical requirement.
• Validate the data received & generate the XML files for each client and transferred to require to third parties/downstream systems.
• Migrated from On-Prem UNIX to Azure Cloud.
• Worked on creating Spring Rest Web services and all them in Talend DI Job.
• Unit testing and System Testing
• Ensure adherence to the Standards.

Confidential, Chicago, IL

Technologies Used: Data Virtualization using Composite Information Server, Oracle PL/SQL, Java/ Spring/Rest Web Service/ XML, Oracle/Netezza, Azure Cloud, Atlassian tools (Jira, Bit Bucket, Confluence and Bamboo)

Responsibilities:

• Worked on Very large POS Data
• Transformed the SDLC from Waterfall to Agile.
• Migrated from On-Prem Unix to Azure Cloud.
• Evaluate design alternatives.
• Make high-level design choices and dictates technical standards.
• Standardize architecture, code development processes and use of technology and tools across teams
• Developed a tool which reduces the Manual work by 80%
• Automated a testing tool, which reduced the manual testing by 45%.
• Received of excellence for my contributions multiple times with the client & Star of the Quarter for my contributions
• Lead the team of 20 at onshore.
• Provide insights on solutions and tuned lots of queries for performance.
• Ensure adherence to the architectural design
• Write application code & Unit test
• Design the technical specifications
• Coordination with Offshore team of 50.

Confidential

Technologies Used: Oracle Pl/SQL, Java, J2EE, XML

Responsibilities:

• Responsible for creating PL/SQL procedures to meet the Business/Technical Requirements.
• System integration using eclipse
• Lead a team of 8 for development and Testing activities.
• Responsible for System testing and integration.

Confidential

Pl/SQL Developer

Technologies Used: Oracle Pl/SQL, Oracle Work flows, Oracle 9i, Pl/SQL Developer

Responsibilities:

• Responsible for creating PL/SQL procedures to meet the Business/Technical Requirements.
• Responsible to create Oracle Work Flows.
• Worked as Key team member in Release 15.1, 15.2, 15.3, 15.4, 15.5, 15.6, 15.7 and in R15.8
• Ensured quality delivery of four Complex Change request to the Client.
• Prepared Unit Test Plan and problem resolution documents.
• Interacted with clients and third party interface teams to fix the issues occurring in Production.