Muthukumar Manickam Email & Phone Number

Austin, Tx, Us

Cambridge, Massachusetts, Us

Mclean, Va, Us

Chicago, Illinois, Us

 Implemented solutions for ingesting data from various sources into Azure Data lake and processing the Data-at-Rest utilizing Big Data technologies such as Hadoop, Map Reduce Frameworks, Spark, Hive, Bash Scripting, Python. Implementation of Big Data ecosystem (Hortonworks, Microsoft Azure, HDFS, YARN, Spark, Hive, PIG, Oozie, TEZ, Apache Ranger, Sqoop, Zookeeper, Splunk, Ambari) with Cloud Architecture. Created Hive External tables and loaded the data into tables and query data using HQL. Imported millions of structured data to process using Spark and stored the data into HDFS in CSV format. Used Spark SQL to process the huge amount of structured data. Implemented SCD Type 2 logic on Product data using Hive and Spark data frames. Extracted data from multiple APIs using Shell scripts and loaded data into CSV files to perform Data Science activities. Used Python data frames to work with Google Big Query and extracted data tables on daily basis.  Extract files from AWS S3 server using Python Boto3 S3 package and loaded the files into Azure Data Lake. Used Google SDK tools such as gsutil, gcloud and BQ command line tools to extract data from Big Query tables and load into Google Cloud Storage.

 Perform the role of Hadoop Full Stack Development lead which includes guiding the team in converting Informatica ETL components into Python based Scripts hosted in Private Cloud servers.  Performed a full ingestion of data from legacy databases into Hadoop and extracted data from Hive tables, transformed and moved to landing zone in teradata. Hands on experience in Big data tools like Hive, Impala, Sqoop, Scala and Spark. Optimized Teradata BTEQ scripts for better performance. Involved in production issues and performed bug fixes in quick workaround time. Handled the responsibility of Code movement across environments (Development, INT, UAT, PROD). Involved in Continuous Integration and Continuous Deployment using Dev Ops tools. Hands on Experience in Tortoise GIT and Intellij for versioning code. Used Jenkins to build code packages from GIT and promote code to higher environments using Udeploy. Understanding of existing system & technical components in Amazon Web Services.  Manage AWS servers and infrastructure using EC2, S3 & Cloud Formation. Perform the role of Teradata First line support engineer to review peer team code and designs. Interact with Change Control Board and Scheduling team in promoting objects to UAT and Production. Supporting the production team in the warranty period of three months initially after implementation.

 Lead 12-member team performing Application Development & Support, by developing & maintaining complex ICS and ICRT jobs using Informatica Cloud.  Involved in development of Data Synchronization task, Mapping Configuration task, Data Replication tasks. Involved in real time data processing including development of Processes, Guides, Service Connectors, Connections. Includes monitoring of Informatica Cloud Processes. Involved in performance tuning of Informatica Cloud Jobs. Responsible for analysis, design and development of the impacted components in Informatica Cloud & Salesforce. Manage AWS servers and infrastructure using EC2, S3 & Cloud Formation. Perform tuning of ICS & ICRT Jobs for long running task flows. Responsible for understanding Use case development using Salesforce Application and understand data load from/to salesforce using Informatica cloud. Understanding of existing system & technical components in Amazon Web Services.  Leading end to end development of Dev-Ops system using Bit bucket, Jenkins, New Relic and other technologies.

 Worked as Migration Lead & Senior ETL Developer.  Includes interacting with clients and SME's to understand the business requirement and creating functional specification Document. Created Complex reusable Informatica Components & guided the team in rolling out the code at respective stages on time. Handled the responsibility of Code movement across environments (Development, Stage, UAT). Performed Unit testing, System/Integration testing to ensure the functional specifications are met as specified. Created RTM to ensure all the functional specifications were met. Supported after Production Deployment during the guarantee period. Includes handling of resolving Production issues within SLA’s. Guided the team in using Reusable components created in similar previous migration project & Led the team in successfully completing the project on time. Effectively handled client change requests by proposing and supporting the design, development and testing of solutions, including ensuring that change requests entrance criteria and documentation is complete, conducting impact analysis and following through on execution of changes. Responsible for Creation & Execution of Unit Test Cases, System Test Cases to check the functionality of the change requests. Created & maintaining documents like Production Issue tracker, Production Job status tracker & Run book to reduce KT time, tickets resolution time. Ideating Six sigma process helping business to reduce operating costs for support and maintenance of application.

 Played a lead role in requirements understanding & collection processes and translating them into technical requirements. Includes preparation of Technical Design document, ETL Source to Target Mappings. Analyze and estimate the work involved in the gathered requirement, prepare the design documents and get the confirmation from the respective product owners on the same. Involved in the whole SDLC of the data quality management project. Prepared Estimation for Development efforts using Microsoft Project Plan. Responsible for Code movement across environments (Development, Stage, UAT). Manage Resources technically & operation wise.Responsible for project management activities. Attend status meetings with Client’s Project Management team. Manage day to day business operations and work on monitor compliance with Accenture processes. Administering HR policies regarding Performance Management of consultants reporting to me. Have set up and lead the Complete Support & Maintenance team for one of World’s leading Banking Data warehouse application, a critical & strategic project for the current organization gaining client's confidence and appreciation.

 Involved in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area. End to end Implementation of Claim Data for Health Care Clients involving Facts and Dimensions. Have understood PLSQL Stored Procedures and Packages as part of project deliverable. Prepare the test cases for the developed logic to the users and to make sure that the gathered requirement is converted as ETL logic. Perform the comparison of data between the production data and the UAT test data. Experience in handling XML Sources and XML targets. Actively pursued and recommended areas of improvement for data profiling, data loading & Data Cleansing techniques. Experience in Autosys scheduler to schedule Informatica jobs. Experience with UNIX Shell Scripting.