SUMMARY

• 7 years IT experience in Design, Development, Maintenance, Enhancements and Production Support of which includes Data warehousing and Legacy applications using ETL tools like Talend /Informatica. Having hands on experience as ETL Development in Banking, Healthcare and Insurance domain.
• Experience in Talend Enterprise Big Data 7.0.1, Talend Open Studio (6.x/5.x) for Data Integration, Data Quality and Big Data.
• Experience in Talend MDM &Talend Big Data Enterprise version.
• Proficiency in utilizing ETL tool Informatica Power Center 9.x/8.x/7.x for developing the Data warehouse loads with work experience focused in Data Integration as per client requirements.
• Experience working with Data Warehousing Concepts like OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling.
• Experience in adhering software methodologies like waterfall, Agile.
• Experienced in using Talend DI, TalendDQ and TAC.
• Extensively used Talend Big data components like tHDFSInput, tHDFSOutput, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.
• Extensively created mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tJava, tJavarow, tDie, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap etc.
• Experienced in creating DynamicTalend Jobs to inject data into Data Lake using multiple sources systems.
• Experienced in scheduling Talend jobs using Talend Administration Console (TAC).
• Good Understanding of relational database management systems, experience in integrating data from various data source like Oracle, MSSQL Server, MySQL and Flatfiles.
• Performed Data validation, Integration Testing and Unit Testing.
• Capable of processing large sets of structured, semi - structured and unstructured data and supporting systems application architecture.
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modelling and data mining, machine learning and advanced data processing and Experience optimizing ETL workflows.
• Expertise in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
• Good experience in Big Data and Hadoop Ecosystem components like, Pig, Hive, Sqoop, Map Reduce.
• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc.
• Experience in writing database objects like Stored Procedures, Triggers for Oracle, MYSQL databases and good knowledge in PL/SQL, hands on experience in writing SQL queries.

TECHNICAL SKILLS

Data Warehousing: Talend Data Management Platform 6.x, Talend Enterprise Big Data 6.4.1 Informatica Power Center 9.x/8.x/7.x

ETL Tools: ERwin, ER Studio, Visio, Toad, Teradata SQL Assistant, SQL Plus, Data StudioMS Office.Informatice Power Centre 8.X, 9. X,10.X.

Databases: Teradata, Oracle 10g/11g, My SQL 5.0/4.1, SQL Server 2008, MS AccessRedshift, Sybase

Methodologies: SQL Navigator, Toad, Kimball/Inmon Dimensional Data Modeling, Star SchemaSnowflake Schema, Agile, Waterfall.

Data Modeling: ERWIN 4.0, MS Visio

Programming Skills: SQL, PL/SQL, C, C++, UNIX Script, Java

Environment: Windows OS, UNIX, Windows SERVER 2003/08,AWS with s3 & Redshift

PROFESSIONAL EXPERIENCE

Confidential, Pheonix, AZ

SQL Developer

Responsibilities:

• Experienced in Architect, Design, Develop and improve databases and ETL processes in scope of application development.
• Utilized the following Big data technologies for Big Datawarehouse: Hadoop(HDFS, Mapreduce, Talend, Hive, pig, spark and scala).
• Developed logical and physical data flow models for ETL applications. Cleansed large data sets using ETL and Big Data Tools.
• Load the data from AWS S3 to redshift using Talend integration jobs.
• Moving the files from AWS S3 to HDFS using talend bigdata spark jobs.
• Executing the Talend spark jobs on AWS EMR Hadoop cluster.
• Triggering the Talend jobs based on SQS message ques in AWS
• Configuring the EMR Hadoop cluster to run complex Talend spark jobs to handle large set of data.
• Developed Lamdas to trigger the Talend jobs and handle Talend Orchestration process.
• Experienced in Encounter Repository project to develop the file level and Data level controls.
• Hands on experience in Hadoop Ecosystem components such as Hadoop, Spark, HDFS, YARN, HIVE, Sqoop.
• Responsible for deliverables as committed in the sprint planning.
• Having experience in performance tuning techniques.
• Good experience in troubleshooting the issues on talend spark jobs.
• Developed Talend jobs with proper error handling and notifications. Experienced in writing shell scripts to extract the data for multiple vendors on multiple requirements.
• Responsible for modifying the code, debugging and testing the code before deploying on the production cluster. Responsible for programming code independently for intermediate to complex modules following development standards.
• Invovled in story driven agile development methodology and actively participated in daily scrum meetings.
• Responsible for modification of ETL data load scripts, scheduling automated jobs and resolving production issues on time.

Environment: Talend Big Data 7.1.1,AWS S3,AWS EMR,AWS SQS, MapReduce, HDFS, Hive, Hbase, SQL,JAVA.

Confidential, Saint Louis, MO

Responsibilities:

• Designed and Implemented the ETL process using Talend Enterprise Big Data Edition to load the data from Source to Target Database.
• Data ingestion with different data sources and load into Database.
• Worked on Error handling technique's and tuning the ETL flow for better performance.
• Worked closely with Business Analysts to review the business specifications of the project and also to gather the ETL requirements.
• Experienced in Talend Service Oriented Web Services using SOAP, REST and XML/HTTP technologies using Talend ESB components.
• Designed, documented operational problems by following standards and procedures using JIRA.
• Experienced in creating a generic joblet by using tDie, tLogRow, tStatsCatcher to store processing stats into a Database table to the record job history.
• Experienced in fixing errors by using debug mode of Talend.
• Created complex mappings using tHashOutput, tMap, tHashInput, tDenormalize, tUniqueRow. tPivot To Columns Delimited, tNormalize etc.
• Developed joblets that are reused in different processes in the flow.
• Created Context Groups and variables to run jobs in Dev, Test and Production environments and created an utility called Context Loader for secured parameter access.
• Developed error logging module to capture both system errors and logical errors that contains Email notification, updating tables and moving files to error directories.
• Worked on Talend Administrator Console (TAC) for scheduling jobs and adding users.
• Experienced in fixing errors by using debug mode of Talend.
• Created complex mappings using tHashOutput, tMap, tHashInput, tDenormalize, tUniqueRow. tPivot To Columns Delimited, tNormalize etc..
• Involvement in Unit Testing of the mappings including integration testing. Using the best document format and best practice processes for its successful execution.
• Extensively involved in writing SQL queries (sub queries and join conditions) for building and testing ETL processes.
• Created Function specification, High-level design document (ETL design architecture) and Low-level design document and Unit Test Case, deployment and operational document.

Environment: Talend Enterprise Big Data 7.0.1,Talend Administrative Console (TAC), MySQL, GitHub, Oracle, MS SQL Server, Soap UI, Agile Methodology.