Resume

Sign in

Sql Server Data

Location:
Irving, Texas, United States
Posted:
February 25, 2018

Contact this candidate

Sainath Reddy

469-***-**** ac4l0c@r.postjobfree.com

PROFFESIONAL EXPERIENCE

Over 2+ years of experience in information technology industry in the areas of data warehousing and business intelligence: focusing on Talend, Informatica Power Center ETL development, testing and bug fixing

Experience with Talend Open Studio & Talend Enterprise Edition.

Extensively used ETL Methodology for supporting Data Extraction, transformation and loading processing using Talend & Informatica.

Experience in Data Modeling, Star Schema, Snow Flake Schema, Dimensions and Fact tables.

Expertise knowledge on Talend Components.

Proficient knowledge on all Transformations of Informatica.

Experience in full cycle of Software Development including project planning, requirement analysis, design, development, testing, implementation, integration and deployment.

Experience in poc’s(proof of concepts) on Hadoop and, Java.

Experienced on TAC(Talend command line) for scheduling jobs and monitor on production load and CI(continues integration).

Experience in developing back end programs on various databases including Oracle, DB2, Sybase and MS SQL Server.

Expertise in writing, testing and implementation of the triggers, stored procedures, functions and packages at database level using PL/SQL.

Hands on experience to manage Error Handling, Performance Tuning, Error Logging, clustering and High Availability in Talend

Hands on experience in generating source to target mapping, validation, transformations, and business rules.

Hands on experience in using multi format files like XML, .CSV, .TXT and loading data from these files in to relational tables.

Strong work experience on Windows, UNIX, and Linux platforms.

Implementation of ETL engine using Java to handle Incremental Loads

Ability to articulate complex data problems and solutions.

Flexible to work in Agile SCRUM environment.

Team Player as well able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.

SKILLS:

ETL Tools

Talend Enterprise Edition for Big Data 6.2.1/5.6.2, Informatica Power center 8.6/8.1/7.6

DW Tools

Erwin, ER/Studio, MS Visio

RDBMS

Oracle 10G/9i/8.x, MySQL, MS SQL Server, MS Access

Languages

SQL, PL/SQL, C, C++,Java, Hadoop, VB, Shell Scripting, Java and XML.

Operating Systems

Microsoft Windows, MS-DOS, UNIX and Linux

Reporting Tools

Tableau BI

PROFESSIONAL EXPERIENCE.

Amazon Development Centre Pvt Ltd, Telangana, India. Jan 2014 – June 2015

Etl Developer

Effectively working on Business Requirement documents to Map client data fields with Database columns and prepare the Technical document to build Talend Job.

Building and maintaining Talend Job/SQL Programs for member & claims data.

Good understanding on Java and Hadoop consent Rules for healthcare domain.

Creating Talend Components such as tMSSqlInput, trowGenereator, tHashOutput, t-Map, tJava and pulled all data fields from SQL database tables.

Designing Talend component within Job along with Joblet, setting up Database configuration and Project level configuration Contexts, Talend Artifact Repository for Talend Jobs.

Creating Multiple Reports through Talend such as Pipe delimitated file (.txt), Excel (.xlsx), formats.

Publishing Talend job snapshot version each time to keep all Environments (Development, Staging, Prod/UAT, and Production) in Sink.

Creating Test Scripts and Test cases for QA team to load Nexus snapshot version into Talend Administration Center to get test Report output to End User.

Working with QA to drop report output files from Prod/UAT environment into client sFTP server and support any data related issues, File Format issues and solve them before moving into Production Environment.

Processing Inbound/Triage file from End users and pulling from client/End user sFTP server and loading into Talend Repository.

Migrating existing reports from SQL Server data warehouse to the new data warehouse using Talend 6 for Data Integrity on JAVA Platform.

Working on Agile Methodology and Sprint Planning for software development and JIRA system dashboard for issue tracking, Bug tracking and project management principles.

Supporting business users for any productions issues through Incident Tickets from Project Account Manager and End users.

Environment: Talend Enterprise 6.2.1, Sonatype Nexus, TAC (Talend Administration Center), winscp, Microsoft SQL Server 2012/2008r2, JIRA, Service Now, SVN Repository

EDUCATION:

University of Mary Hardin Baylor Anticipated May 2017

GPA 3.01

Academic Project:

Graduate Project Title: Discount Promo Code Issuing.

Language of Implementation: Java

Operating System: Windows 10

Description:

Discount promo code removal system is a web based application. The aim of this application is developed for removing the discount using promo code or update the discount promo codes. Manager can remove or update the promo code details and save the details into data base.

SOFTWARE:

MATLAB, Xilinx, Multisim, Visual Studio, MYSQL, SAP, MS Office, Android SDK, Microsoft Visual Studio, MS Visio.

CERTIFICATION:

CCNA (CISCO CERTIFIED NETWORK ASSOCIATE) Routing and Switching. (Dec 2017)

COURSEWORK:

Completed

oDatabase Development and Administration (BCIS 6320 01), Applied Programming (BCIS 6360 01), Information Systems Security (BCIS 6370 01), IT Infrastructure (BCIS 637525), Decision Support, Analysis Modelling and Design (BCIS 6322 02), Project and Change Management (BCIS 6350 25), Seminar in Information Systems Research (BCIS 6305 04), Business Process Management (BCIS 6330 01),Cloud Architectures (BCIS 6391 25), IT and Supply Chain Management (6380 01), Systems Development and Implementation (6395 01).



Contact this candidate