ETL Lead/Architect _ Datastage -Teradata (Consultant Available on c2c)
Greetings of the day
Kindly find the details of my consultant available for your direct client requirement, on c2c. Kindly share the complete Job description at sadath@mutexsystems.com
Consultant"s info:-
Name: Prajwal Chandrashekar
Total exp: 13+ years
Current location: NJ
Relocation: Open (But Prefer NY/NJ/FL/TX/IL)
Visa: H1b (W2 Consultant)
Availability: 2 week notice
Resume Summary
· 13 years of experience working with Datastage 7.5.2, 8.0.1,8.1,8.5,11.5 Teradata R6, R12 and Oracle v11, v12. Used Datastage 7.x, 8.x, 11.x in various data warehousing applications involving complete Software Development Lifecycle model from analysis, design, development, testing, maintenance and enhancement requests of large data warehouse projects.
· 13 years of experience in Telecom, Retail and Logistics domain with providing Business Intelligence design solution to Customer Relationship Management, Campaign data, Advertisement data, Point of Sale, Inventory Management, Logistics for various business processes.
· Extensive experience in designing Datastage 7.x, 8.x, 11.x jobs to effectively meet business needs and deliver best performing design solutions.
· Highly experienced in SQL performance tuning and debugging of existing SQLs in ETL process.
· 8 years of experience using Teradata R6, R12 SQL Assistant and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and 5 years of experience using Oracle 11g, 12c
· Well versed in creating UNIX wrapper scripts for executing Datastage jobs and implementing run control functionalities like recording input/output record counts, processing times, sending email notifications for job status etc.
· Well versed in creating Mainframe jobs using Job Control Language (JCL).
· Extensively used ETL, ELT methodologies for supporting data extraction, transformation and load processing, using Datastage , Oracle and Teradata.
· Extensive experience on various Database Stages, File Stages, Webservices Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Transformer, Lookup, Filter, Sort, Sequential File, Dataset, Remove Duplicate Stages etc to develop Server, Parallel and Sequence jobs.
· Experienced in extracting, transforming and loading (ETL) data from databases and text files.
· Excellent skills in retrieving the data by writing complex SQL Queries.
· Worked under different phases of code promotion from development, user acceptance testing environment to production.
· Provided analysis, resolutions to UAT defects and production issues under stringent timelines.
· Involved in Functional review, Design Review, and Code review, Peer reviews, Deployment plan reviews
· Involved in training the team on Datastage.
Awards and Recognitions:
· Awarded with "Certificate of Recognition" in UPS by CIO Juan R. Perez for 2017 SEAS Release 17.
· Awarded with "Certificate of Recognition" from Telstra for Early Termination Charges Calculator project.
· Rated as STAR Performer for successive years in Mahindra Satyam.
Skills/Tools:
ETL Tools: | Datastage 7.5.2, 8.0.1, 8.1,8.7, 11.5 |
Databases : | Teradata R6, R12, Oracle 11g, 12c |
Version Controls: | Tortoise SVN, Virtual Source Safe (VSS), Team Foundation Server (TFS) |
Operating Systems: | Unix, Linux and Windows |
Programming Languages: | Unix/Linux Shell scripting, PL/SQL, C, C++, |
Modeling Tools: | Microsoft Visio |
Query Tools: | Teradata SQL Assistant, Oracle SQL Developer, Toad |
Auxiliary Skills: | ESP, Cntrl-M, SoapUI and Big Data |
Thanks,
Sadath Khan
MuTex Systems Inc
Ph: 908-777-8045 / 908-822-8515 Ex 20| F: 732-909-2191
E : sadath@mutexsystems.com / gmail: srecruiter.no1@gmail.com
Linked in id: https://in.linkedin.com/in/sadath-khan-a0510a81
DISCLAIMER:
Note: This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th USACongress this email cannot be considered as spam as long as we include our contact information and an option to be removed from our emailing list. If you have received this message in error or, are not interested in receiving our emails, please accept our apologies.To be removed from our mailing list, please reply with the subject line. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused to you. Powered by Vultus
Comments
Post a Comment
Thanks