Dear Recruiter,
please find the below profile of my consultant for Datastage. Let me know if you have any requirements with your clients.
please share the requirements with chandu@idimensio.com
VL
SUMMARY:
· 8 years of career reflecting experience and high performance in Developing, Testing and Maintaining applications in Data Warehouse using ETL tools like Informatica 10.1.0 /9.x/8.x, IBM WebSphere DataStage 11.5/9.1/8.5/8.0.1, Ascential DataStage 7.5/7.0/6.0 and Client-Server application.
· Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
· Excellent knowledge and experience in Data Warehouse development life cycle, dimensional modeling, repository management and administration, implementation of Star, Snowflake schemas and slowly changing dimensions.
· Expertise in designing and developing various DataStage Server jobs using Parallel Extender version as well as Server side and Mainframe side DataStage versions.
· Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
· Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
· Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
· Experienced in UNIX work environment, file transfers, job scheduling and error handling.
· Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
· Involved at all stages of the data warehousing project; setting up the schema and architecture, developing reports and Documents, security and deploying to end users.
· Designed E3 Framework on UNIX environment to utilize reusability of Data stage jobs (sequence/parallel) and integrated the control M scheduling setup using Framework.
· Applied Client-Server database skills (Oracle, DB2-UDB, TERADATA, NETEZZA and Informix) in mixed OS environments (including UNIX).
· Experience in working reporting tools Business Objects, Tableau, Cognos and salesforce.com.
· Expert in working with Autosys, Tivoli and Control M Scheduling applications.
· Expertise in Performance Tuning using best practices of avoiding network connections, distributing session load by using MS SQL servers, optimizing overall session performance.
· Expertise in handling high volumes of data on daily basis and loading millions of data into data warehouse in each load window.
· Expertise in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations in the situation of Oracle 11g/10g/9i/8i.Delivered project needs on time and within the agreed acceptance criteria in a hybrid methodology environment as they attempted to transition to an Agile Methodology.
· Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
· Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
Education:Master of Technology in Computer Science - INDIA
Bachelor of Technology in Computer Science - INDIA
TECHNICAL SKILLS:
ETL Tools: DataStage 11.5/9.1/8.5/8.0.1, Accentual DataStage 7.5/7.0/6.0,Talend,Informatica 10.1.0/9.x/8.x
Reporting Tools: Business Objects, Tableau, COGNOS and salesforce.com
Databases: Oracle 11g/10g/9i/8i/, DB2 UDB v9/ v8, SQL Server
2005/2000, DB2 UDB, NETTEZA, Teradata R12.
Operating Systems: UNIX, IBM-AIX 5.2, Linux, Windows 8/7/XP.
Programming Languages: SQL, PL/SQL, C, C++, C#, Perl, .XML, Net, Java, APEX Code, T-SQL, Shell Scripting.
Scheduling Tools: Tivoli, Control M and Autosys
Chandu A
Desk: 732-913-8428
Mobile: 732-893-0315
iDimensio Inc.,
15 Corporate Place, Suite #103,
Piscataway Township, NJ 08854.
www.linkedin.com/in/sekhar-rao-51a512198
Hangouts: aforakkineni
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sureshotjobs/CA%2BRonb8e2afFM5ZVjJNx9wgxYBdeJTKCT%2BcjS8DRM30o8nxOsg%40mail.gmail.com.
No comments:
Post a Comment