11+ years of Experience in all phases of Data Warehouse life cycle including Requirement Analysis,Design, Coding, Testing and Deployment. Strong knowledge in building ETL components in accordance with the technical ETL specifications. Experience in Development of various business applications using different platforms such asInformatica and Oracle. Performing quality checks on data using tools such as Informatica Developer. Worked with different data sources like Flat Files and Relational Databases. Good Functional knowledge in Banking with appropriate DW/ETL Implementations
-
Data EngineerSellaChennai, Tn, In -
Data EngineerSella May 2017 - PresentChennai, Tamil Nadu, IndiaDesign and develop ETLs with reliable error/exception handling and rollback framework. Interaction with Onsite Coordinators on daily basis to update the current queue status. Preparing implementation plans for deployment of code into production environment. Creating and executing unit tests on all solutions to ensure product and validate integration tests. Performing data quality checks and ensuring quality data based on business standards andrequirements by interacting with Business users. As a part of innovation, proposed and implemented Informatica to Python Automation forreusable ETLs which cut down the redundant works performed.Key Projects:Data from various business units like Accounts, Payments, Cards, Credits, Loans, Trading, etc., afterapplying necessary business logics, are loaded into DBU tables. Data quality checks and validation ofstandards are performed on the loaded data, which will be available for statistical analysis to theBusiness users. DBU acts as centralized Datawarehouse which is used by other business units. The dataflows are split up based on the downstream systems, so that independent business units can acquirethe data for their next process. -
Etl DeveloperAntillo Consulting May 2013 - May 2017Chennai, Tamil Nadu, IndiaImported the source and target definitions into the Source Analyzer and Warehouse designer. Analyzed and Developed the mappings as per the mapping specification document. Developed mappings involving constraint based load ordering. Developed complex mappings by handling complex logic. Extensively used look up transformations in handling slowly changing dimensions. Performance tuned the mappings. Implemented file list file concept while loading data from similar flat file structures. Prepared and executed Unit test scripts for the developed mappings.Key Projects:ConAgra Foods is a leading chain of restaurants with more than 500 branches in USA. The datawarehouse is developed to analyze Sales and financial data for entire the organization on a periodicalbasis. Data for analysis was received in flat files and then converted to tables in Oracle database usingInformatica tool. Data extracted from flat files are stored in staging area first and then appropriatetransformation logic is applied and loaded into the datamart. In the process of loading the data intothe datamart various transformations like Filter’s, Joiner’s, Look up’s, Update strategy’s, Expression’swere used. Information was provided to the client by generating reports using Business Objectstools.
Dinesh Kumar M Education Details
-
Electrical And Electronics Engineering
Frequently Asked Questions about Dinesh Kumar M
What company does Dinesh Kumar M work for?
Dinesh Kumar M works for Sella
What is Dinesh Kumar M's role at the current company?
Dinesh Kumar M's current role is Data Engineer.
What schools did Dinesh Kumar M attend?
Dinesh Kumar M attended Anna University.
Not the Dinesh Kumar M you were looking for?
-
Dinesh Kumar M
Bengaluru -
-
Dinesh Kumar M
Chennai -
Dinesh Kumar M
Hyderabad -
Dinesh Kumar M
Chennai
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial