Sreejith Bhaskaran
Services provided: ETL , Data analysis , Data Extraction , Data Engineer
About Sreejith Bhaskaran:
Data Warehousing professional having worked in BI DW Platform for 12+ years under diverse domains viz, Automobile Servicing, Banking & Finance Industries
Strong Experience with data Warehousing, Data Integration, Migration and developing business applications using IBM Infosphere Information Server ,Ascential Datastage, IBM Infosphere DataStage Manager, Designer, Director, and Administrator), Oracle, PL/SQL, SQL Server, DB2, SQL and Shell scripts.
Specializes in Data Analysis, Data Mapping, Data Conversion, Data Integration, Business Analysis, Data Quality Analysis, Functional Design, Technical Design, and different aspects of data/information management.
- ETL Tools Used: IBM Infosphere information server 11.7,11.5, 9.1, Ascential DataStage 7.5
- Database Systems: Oracle 9i/10g (10.2.0.4)/11g/12c ,DB2, MySQL
- Languages: SQL, PL/SQL, Shell Scripting, HTML,CSS
- Environments: Windows, HP UX, Linux
- Supportive Tools Used: Postman, Autosys, Salesforce Cloud, Toad, SQL Developer, Erwin Data Modeler, StarTeam, Tortoise SVN, IBM Cognos, CA WORKLOAD Automation, Azure Pipeline, Tidal Automation, Putty, Service Now , WinSCP
Experience
Data Warehousing professional having worked in BI DW Platform for 12+ years under diverse domains viz, Automobile Servicing, Banking & Finance Industries
- Strong Experience with data Warehousing, Data Integration, Migration and developing business applications using IBM Infosphere Information Server ,Ascential Datastage, IBM Infosphere DataStage Manager, Designer, Director, and Administrator), Oracle, PL/SQL, SQL Server, DB2, SQL and Shell scripts.
- Specializes in Data Analysis, Data Mapping, Data Conversion, Data Integration, Business Analysis, Data Quality Analysis, Functional Design, Technical Design, and different aspects of data/information management.
- Design and build common re-usable ETL components to define audit processes and capture DQ exceptions, Job monitoring, and ETL logging processes.
- Create ETL processes to ensure data integrity (error handling) and document appropriate procedures.
- Involved in Administration and Support of ETL Platform.
- Experience in monitoring and administrating IBM InfoSphere DataStage server performance and usage.
- Experience in IBM InfoSphere DataStage jobs specification documentation preparation
SKILLS SUMMARY
- ETL Tools Used: IBM Infosphere information server 11.7,11.5, 9.1, Ascential DataStage 7.5
- Database Systems: Oracle 9i/10g (10.2.0.4)/11g/12c ,DB2, MySQL
- Languages: SQL, PL/SQL, Shell Scripting, HTML,CSS
- Environments: Windows, HP UX, Linux
- Supportive Tools Used: Postman, Autosys, Salesforce Cloud, Toad, SQL Developer, Erwin Data Modeler, StarTeam, Tortoise SVN, IBM Cognos, CA WORKLOAD Automation, Azure Pipeline, Tidal Automation, Putty, Service Now , WinSCP
ETL DATASTAGE DEVELOPER/LEAD
Responsibilities & Achievements
- Involved in the design and development of DataStage Jobs in 25+ Releases so far
- Create high level Designs for the impacted/New jobs
- Create ETL Designs
- Worked with business teams for requirement gathering and create the mapping document for the ETL Development.
- Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing.
- Working on various processing stages like Transformer, Lookup, CDC, Sort, Join, Aggregate, Hierarchical, etc.
- Ability to connect and transform data from various data sources like Flat files, XML Files, JSON Files, Web Services, Oracle DBs etc.
- Extensively used Data Stage Designer, Quality Stage, and Administrator Director for creating and implementing jobs to load the Data Marts/Data Warehouse.
- Extensively used hierarchal data stage to parsing JSON data and Unstructured Data stage to read and write Microsoft Excel files.
- Knowledge on parsing xml and json data from webservice.
- Identifying the facts and dimensions for developing a logical design of the data marts.
- Optimizing low performing queries on a regular basis
- Created ETL jobs to read data from Salesforce and load data into Staging tables.
- DataStage Admin activities control includes environment maintenance.
- Installed and Configured Director, Manager, Administrator and Designer components of IBM InfoSphere DataStage.
- Schedule the jobs in Autosys and Workload automation
- Working with IBM consoles involving administration activities, Information analyzer and Data Governance
- Used IBM IS Web Console for admin areas: Security, Licensing, Logging, and Scheduling.
- Managed Security, Active Sessions, Logs, Unlock Jobs, Datasets, Scratch, Schedules and Assets from Web Console Designing and coding the data transformation interfaces to meet the data transformation needs with optimum performance.
- DataStage Migration activities
- Working on environment Upgrades and patching activites
- Working on IBM Governance catalog and Metadata Workbench
- Developed shell scripts for automated DataStage, database & Unix deployment activity for the application
- Developed Unix script for automated password maintenance management activity for the applications involved in the project.
- Involved for the Migration Activity of Commercial Data Mart from Data stage 9.1 to IBM Infosphere 11.7
- Also been SME for the deployment of CDM (Commercial DataMart) 11.7
- Also involved in the major deployment and sustain activity of Operational Data Store
- Major Involvement in CPU Configuration Change in DataStage Server and Autosys Server Installation
- Complete involvement in installing DataStage Jobs to Autosys Schedular
- Developed Unix scripts for automated deployment for the application
Education
Msc Information Tech
Professionals offering similar services to those of Sreejith Bhaskaran
Professionals in the same Technology / Internet sector as Sreejith Bhaskaran
Professionales offering ETL services
Professionales offering Data analysis services
Professionales offering Data Extraction services
Professionales offering Data Engineer services
Professionals from different sectors near Coimbatore, Coimbatore district
Other users who are called Sreejith
Jobs near Coimbatore, Coimbatore district
-
Renewal Representative
Found in: Talent IN 2A C2 - 4 days ago
Responsive Coimbatore, IndiaAbout Responsive · Responsive, formerly RFPIO, is the market leader in an emerging new category of SaaS solutions called Strategic Response Management. Responsive customers including Google, Microsoft, Blackrock, T.Rowe Price, Adobe, Amazon, Visa and Zoom are using Responsive to ...
-
Python Developer
Found in: Talent IN 2A C2 - 4 days ago
Turbostart Coimbatore, IndiaWho are we: · The world of startups is changing. More importantly, startups are changing the world. At Turbostart Technology Centre (T2C), you have the opportunity to be part of the evolution of cutting edge technology solution development across multiple domains including EdTech ...
-
HR Executive
Found in: Talent IN C2 - 6 days ago
Cotton Concepts (CC) Coimbatore, India Full timeCompany Overview · Cotton Concepts is a certified manufacturer of various sustainable home textile products including Recycle Cotton, Organic Cotton, Bamboo, Linen, and Hemp fibers. The company focuses on design curation, product development, and manufacturing of home textiles. · ...