Sign in

Data Developer

Winston-Salem, NC
January 13, 2020

Contact this candidate


Manojkumar Magarajan


Winston Salem, NC


9.5+ Years of hands-on experience in ETL Software Development; analysis, design and development of data warehousing business systems with expertise in BFSI, Telecom and Insurance domains.

Expertise in various dimensional modeling and enterprise data warehousing best practices.

Ability to breakdown the business requirements from Business Analysts/Users to functional requirements and technical components. Holding good conceptual and technical knowledge with respect to data management, data acquisition, data integration and data quality architecture.

Extensive knowledge in performance tuning and maintenance. Worked in Informatica upgrades

Lead the ETL team of various projects involves multiple technologies and tools such as Informatica Powercenter, Developer, BDM, Datastage, PlSql, etc., Worked as BI and report developer using various tools like Micro strategy, Business objects, etc.,

Designing the data warehouse solution for industries like Banking, Telecom and Insurance companies.

Expertise in ETL tools, technologies and databases: Netezza, Oracle, PL/SQL, Unix Shell scripting, Perl scripting, Postgres, BTEQ and MLOAD scripts.

Designed ETL framework with reusable components and flexible design that span multiple projects

Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

Training knowledge on BIG DATA – Hadoop, MapReduce.

Strong experience managing team, estimation, AGILE, SCRUM process, escalation handling and handling onsite-offsite model.


Informatica - Powercenter 10.x, BDM, Developer, Netezza, Teradata, Hadoop, PLSQL, Perl Shell Scripting, Windows Batch Scripting, Oracle 10g, DB2 9.7.7,, ESP Scheduler Tools like ESP, Ctrl-M, Appworx, Business Intelligence / Business objects tools like Microstrategy


Project Title Commercial Lending Improvement Program (CLIP)

Client BB&T (Branch Banking and Trust)

Duration 05/2015 to Present

The objective of this project is to build an enterprise data warehouse and data marts from AFS sources and incorporating the legacy Commercial lending system (CLS) into it.

Roles and Responsibilities - Tech lead

-Involved in analyzing the business requirements, designing the solution and driving the deliverables.

-End to end responsibility of deliverables.

-Leading the ETL team and co-coordinating with Data Analysts, Data modelers and Quality assurance team on the project progress to ensure smooth delivery on-time.

-Built and configure the end-end setup for Enterprise DW systems comprises of sources from various source layers by configuring necessary interfaces.

-Created mapping specification documents based on Business requirements and implemented the solution by developing Informatica ETL mappings, workflows as defined in the mapping specification documents.

-Validated the design and coding standards and optimized the performance of mappings, sessions and workflows to improve the efficiency of ETL system.

-Mentored team members, reviewed the artifacts developed by team and addressed performance bottlenecks, deviations from coding standards and quality if any in order to rectify them in the development phase.

-Prepared and reviewed documents such as Unit Testing Documents, Unit Test cases, Unit Test Results for all the developments and deliverables handled to make sure the business requirements are achieved.

-Actively participated during the environment preparedness for production implementation and migration.

-Involved in scheduling jobs using ESP scheduler tool and defined dependencies for effective load processing.

Project Title Enterprise Data Warehouse(FSLDM-EDW)

Client Sainsbury’s Bank

Duration 09/2014 to 05/2014

The primary objective of this project is to develop an enterprise data warehouse for Sainsbury’s bank by implementing FSDM (Financial Services Data Model). FSDM is a proprietary data model from Teradata for financial institutions supports retail and commercial banking.

Roles and Responsibilities - ETL Lead

-Involved in gathering the requirements from Business, Business Analysts and Data modelers.

-With the collected inputs, worked on designing the solution by transforming the business requirements to EDW requirements.

-Prepared High level design and Low level design documents based on the developed design.

-Participated in various brainstorming sessions with Architects, DAs and DMs to discuss on the feasibility of implementing the EDW data model in better competent way.

-Created the Data quality framework to implement across warehouse.

-Prepared mapping specification documents based on the Design and Business needs.

-Developed ETL Mappings, Workflows with mapping documents.

-Developed reusable utilities to improve the delivery process.

-Created ETL framework jobs and built EDW audit tables for scheduling and capturing the process metadata.

-Validated design standards, coding standards and optimized mappings, sessions and workflows to improve the performance.

-Prepared various documents such as Unit Testing Documents, Unit Test cases, Unit Test Results for all the developments and deliverables for validating the business logics implemented.

-Mentored team and provided weekly training for the trainees to improve the team’s performance and delivery benchmark.

Project Title Annuities Information Factory(AIF)

Client The Prudential Insurance Company of America

Duration 02/2014 to 09/2014

Objective is to build a hybrid Enterprise Data Warehouse (EDW) for Prudential Insurance Company’s Annuities data and provide BI Strategy Solution which will also allow Management and Business team to analyze changing business conditions and facilitate strategic planning.

Roles and Responsibilities - ETL Lead

-Involved in the analysis of Business requirement and worked on developing the solutions with the inputs shared from onshore team and Data Modelers.

-Had actively participated in the design and Data modeling discussions with Data modelers and Data Analysts.

-Prepared the ETL mapping documents from the requirements provided.

-Implemented the ETL solution from the mapping documents.

-Proposed and executed several enhancements to improve the performance of system and had coordinated with Business to improve the system’s proficiency with respect to needs by studying their requirements.

-Involved in the brainstorming sessions with cross functional system architects to design the outbound feeds from AIF system.

-Implemented various outbound feeds from AIF system which involves complex logics based on custom requirements.

-Built ODS and POS for the AIF system users.

Project Title Quality and Margin Enterprise Data Warehouse(TCS)

Client Teleglobe/Tata Communications Limited

Duration 10/2010 to 02/2014

Objective is to build a typical Data Warehouse (EDW) for the Telecom organization. It involves building a system that should be capable of processing the humungous amount of data at real-time into warehouse with SLA of less than 4 hours.

Roles and Responsibilities - Senior Developer

-Involved in the analysis of Business requirements, provided the design and solutions for the identified requirements.

-Involved in the effort estimation, scheduling and Project planning for each phase of the project and managed resources of the team.

-Developed complex UNIX and Perl scripts for real time file handling jobs.

-Developed complex mapping solutions for user requirements.

-Had identified the performance bottlenecks after developing the code and rectified it to ensure real time data load in production systems.

-Involved in the environment migration and Informatica repository migration.

-Had developed multiple reconciliation reports with respect to the Business requirements to validate the data between Quality and Margin systems.

-Built reporting system using Business intelligence tool with scheduled reports.

-Automated the user activities of uploading the UDD data with utilities.

-Co-ordinated with Architects, Onshore team and Modelers on regular basis to ensure deliverables without any defects and timeline issues.

-Proposed and implemented multiple several initiatives to improve the Business benefits.

-Had worked with Production support team to identify the cause of error processing records and providing the fix which benefited the Business to achieve minimal error rate which helped reconciliation with better accurate results.

-Had mentored, lead the team.

-Had coordinated with Networking and Infrastructure team (IS) while setting up the new server environment for Production and Development.


Tata consultancy Services (Aug 2010 - Feb - 2014)

Cognizant Technology Solutions US (Feb 2014 - Present)


Highest Degree : Bachelor of Engineering

College/University: Government College of Technology, Coimbatore (Anna University)

Year of Passing: 2010

Contact this candidate