SUMMARY

• I have 7+ years of versatile experience in the software industry, dynamic and skilled IT professional with proven success in software project development with 4+ Years as SQL BI Developer (SSIS, SSRS & SSAS) and 3 Years of 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.
• Very good Experience in IT applications development, with primary focus on ETL tools (Data Warehousing) and Oracle Database.
• Extensive experience in implementing the Batch and Real - time Data Integration jobs by using Talend tools (Data Integration, Data Quality and Master Data Management) and Informatica IDQ.
• Responsible for all phases of the System Development Life Cycle (SDLC) from Requirement Gathering, Analysis, Design, Development, Testing, Documentation, Production in various industries.
• Sound experience in designing Talend Data Integration solutions with expertise in Data Migration Project Platforms.
• Expertise in Talend Cloud Data Migration using Talend and AWS S3.
• Having good hands on Creating new WSDL, XSDs and enhancing existing WSDL for Real-time services developed in Talend MDM.
• Implemented end-to-end solution for Talend MDM Frameworks for generating of Golden Customer record across organizational level.
• Good at processing data from heterogeneous Source & Confidential Systems like Relational Databases, Flat Files (.csv, .txt, EXCEL, XML, JSON and Positional).
• Designed reusable jobs in Talend using Joblets for Cleansing like Customer Name, Address, Email/Telephone and Job Restart ability, Job Audit information.
• Hands on Experience to use Talend Cloud Management Console (TMC), Talend Administration Center (TAC) and Code migration.
• Expert in Designing and Testing of Data Quality rules using Informatica Data Analyst and Implementing Services /Mappings using IDQ Developer.
• Experience on Data Cleansing and Standardizations of Data.
• Good working Knowledge on Data warehousing concepts like Schemas, Dimensions and Fact tables.
• Performed Unit Testing based on multiple test cases (Positive and Negative Scenarios) and prepared release notes to the framework Joblets.
• Having a strong knowledge on generating Profiling Reports for creating of Business Rules.
• Support the offshore team members on technical discussions and work hand shaking between onshore and offshore.
• Provided wider support in code building and migration activities like Updating Code release notes and participate in meetings related to Project releases and technical decisions and code reviews.
• Have good knowledge on Azure Cloud services.

TECHNICAL SKILLS

• Talend Cloud Big Data 7.3/6.5/6.2/6.1
• Talend Management Console
• Oracle DB 9i/10g/11g/12c
• DataStage
• SQL Developer 18.1
• Control-M
• UNIX Shell commands
• JMeter2.5.1(Performance Testing)
• Amazon Web Services (AWS)
• Putty
• Tableau
• GitHub
• ETL
• SQL
• JIRA
• Azure cloud services

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Talend Cloud Developer

Responsibilities:

• Responsible for design and develop a scalable data integration solution based on the business requirement.
• Responsible for Data Integrations from multiple sources.
• Developed complexETL jobs to migrate the data from flat files to database.
• Developed complex SnowSQL queries using joins, sub queries and correlated sub queries.
• Developed Talend Bigdata jobs to load heavy volume of data into AWS S3 data lake and then into Redshift using bulk load components.
• Experience in integration of various data sources like SQL Server, Oracle, DB2, XML and Flat Files.
• Experienced in creating Generic schemas, creating Context Groups and context Variables to run jobs against different environments like Dev, Test, and Prod.
• Created complex mappings by using different transformations like Filter, Router, lookups, Stored procedure, Joiner, Update Strategy, Expressions and Aggregator transformations.
• Redesigned the views in snowflake to increase the performance.
• Built and maintain complex data platforms and large-scale CI/CD data pipelines utilizing a variety of technologies (REST APIs, TeamCity, Jenkins) and cloud databases (Snowflake)
• Used tRest components to call GET, PUT and POST services on RestAPI.
• Created and managed Source to Confidential mapping documents for all Facts and Dimension tables
• Worked on Talend Management Console (TMC) for scheduling jobs and adding users.
• Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation, and loading using Talend and designed data conversions from wide variety of source systems.
• Extensively created mappings in Talend using components t-Map, t-Join, t-Replicate, t-Parallelize, t-Java, t-Java row, t-Die, t-Aggregate Row, t-Warn, t-Log Catcher, t-MysqlScd, t-Filter, t-Global map etc.

Environment: Talend Big Data 7.3/6.3 platform, CI/CD, SVN, GIT, FileZilla, Putty, Confluence, JIRA, TAC, TMC, Linux, MySQL, Snowflake, AWS, S3 bucket, UNIX Scripting, AWS EC2, Tableau

Confidential, Emeryville, CA

Talend Data Engineer

Responsibilities:

• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations.
• Developed Talend jobs to populate the claims data to data warehouse - star schema, snowflake schema, Hybrid Schema.
• Hands on experience in developing data pipelines using Talend and Python including the processing of NoSQL and JSON, XML formats using Agile development process Advanced working experience in SQL/PL-SQL, Snowflake, API.
• Develop the ETL mappings for XML, CSV, TXT sources and loading the data from these sources into relational tables with Talend ETL Developed Joblets for reusability and to improve performance.
• Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
• Developed complex ETL jobs from various sources such as SQL server, Postgres sql and other files and loaded into Confidential databases using Talend OS ETL tool.
• Implemented File Transfer Protocol operations using Talend Studio to transfer files in between network folders.
• Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and Confidential .
• Developing UNIX shell scripts for automating and enhancing streamlining existing manual procedures.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.

Environment: Talend 7.3/6.3, Snowflake, Unix, Jira, Agile, SQL Server, Postgres, Windows, Linux, Oracle 11g, DB2, MS Excel, MS Access, TOAD, Putty, Github

Confidential, San Francisco, CA

Talend Developer

Responsibilities:

• Participated in all phases of development lifecycle with involvement in the definition and design meetings, functional and technical walkthroughs.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components
• Created and managed Source to Confidential mapping documents for all Facts and Dimension tables
• Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
• Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
• Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as Confidential databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Created Implicit, local and global Context variables in the job. Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.
• Developed stored procedure to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on tables.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Experience in CI/CD using Jenkins to deploy jobs and rancher to monitor logs.

Environment: Talend 7.0/6.5, ETL, SCD’s, Oracle, Talend Administration Center (TAC), Putty, Jira, MS Access, Salesforce, Informatica, Mainframes, SQL Server.

Confidential, Raleigh, NC

Senior SQL Server ETL/SSIS/SSRS Developer

Responsibilities:

• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Experience in CI/CD using Jenkins to deploy jobs and rancher to monitor logs.
• Data warehouse design using Top-down and bottom-up and Data Mart design using Star Schema and Snow-Flake schema.
• Responsible for making weekly backup databases by using SQL Server 2012 and restore these databases in different server.
• Responsible for data analysis, data designing, data mapping, data quality, business and MDR (Minimum data requirements) gathering, Technical Specification writing, project management.
• Created and refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor (DTA).
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used C#.Net to write Script in SSIS tasks like Script Task and Script Component.
• Written Code in C#.Net to make Web Application and connect with Backend (SQL Server).
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Designed and implemented Tabular model using SSDT 2012 and enrich the model by adding relationships, calculated columns, measures, KPIs, and hierarchies.
• Created tabular models and reports that retrieve data and aggregates directly from a relational database system, usingDirect Query mode.
• Partitioned the Tabular models for optimized processing and secured to the row-level by using role based security.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed them in SharePoint integrated mode.
• Used Power View and created various analytical reports andDashboards from Tabular Models tohelp managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.

Environment: ER-Win, SQL Server 2008R2/2012, SQL Server Agent, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SharePoint, TFS, Power Pivot, Windows Server, Tableau (Desktop, Server).

Confidential, Rolling Meadows, IL

Senior SQL Server ETL/SSIS/SSRS Developer

Responsibilities:

• Actively participated in SDLC processes including requirement gathering, analysis, development, implementation, testing and maintenance.
• Created SQL queries for data retrieval and optimized queries for maximum efficiency using SQL profiler.
• Involved in the development of SQL server maintenance plan, scheduling jobs, alerts, trouble shooting.
• Migrated data from Oracle, Excel, flat files, MS Access to MS SQL server using DTS and SSIS.
• Used FTP task, ETL Script task, lookup transformation and Data flow task to load staging databases in SSIS.
• Created cubes in star and snowflake schemas, applied partitions, aggregations on it, used MDX to retrieve data using SSAS.
• Worked in Agile/Scrum Methodology with daily standup meetings and great knowledge in TFS (Team Foundation Server)
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and created SSIS packages to extract, transform and load data from various data sources like Excel and flat file to SQL Server destination using various transformations like conditional split, look up, derived column, data conversion and slowly changing dimensions
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Generated and consolidated monthly reports to drive forecast production plan with SQL report services (SSRS).
• Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.
• Designed and implemented fact and dimension tables and OLAP cubes using dimensional modeling in SQL server analysis services (SSAS).
• Created sub report, On-demand, custom Ad-hoc reports using SSRS. Designed and developed report layout including parameterized report, drill down, and drill through reports.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Environment: MS SQL Server, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Windows 10, Team Foundation Server (TFS).