Lohith N A

Project - Takeda pharmaceuticals

Tools used: Informatica IICS and BDM, AWS S3, Databricks, Python,Tidal.

• Developed and maintained scalable ingestion pipelines for structured and unstructured clinical data, enabling real-time insights for research and trial designs.
• Implemented data profiling and quality monitoring workflows to ensure consistency across stages.
• Automated data extraction, transformation, and loading from Oracle, flat files, and API sources to AWS using Informatica and Python scripting.
• Partnered with architects and product owners to design robust data flows, focusing on operational optimization and reduced data latency.
• Led the redeployment of 70+ standardized data objects into production without business impact as part of a transformational data modernization initiative.
• Worked with DevOps tools like GitLab CI/CD and Tidal for versioning and workflow orchestration.
• Prepared the error handling document to maintain the error handling process.

Project : Law and Public Affairs (Northwestern Mutual )

Tools Used : Informatica Power Center, SQL Developer, Autosys

• Followed Agile Methodology, involved in daily scrum meetings of sprint.
• Responsible for all activities related to development, implementation and support of ETL processes for large scale Customer data warehouse using Informatica Power Center .
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in Informatica Designer.
• Developed complex mappings in Informatica to load data from various sources.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Worked on creating and extracting data into Stage/Landing, Dimensions, Facts tables.
• Created Test cases for mappings developed and then created integration Testing Document.
• Extensively used scheduling tools like Autosys and Control- m to schedule jobs and handle dependency among jobs .
• Automated the Informatica Jobs using unix shell scripting.
• Creating and monitoring batches and sessions using informatica Powercenter server.
• Worked on resolving problem tickets and incidents.

Project : Rationalize the data as a part of data rationalization and deprecating the tables based on their last accessed dates (Allstate).

Tools used : SQL Developer, Shell Scripting, Power BI

• Worked as SQL Developer and completed PII analysis for more than 8 Area of Applications in SQL,Oracle and MongoDB data type.
• Used Shell scripting to identify duplicate data based on user inputs using find pattern.
• Imported Data into Power BI from many sources .
• Created Dashboards and Reports to analyze PII data in meaningful way to get better insights .
• Shared Dashboards to users through Office 365, Content packs.

Project : Claims Backup and Restore ( Allstate)

Tools used : SQL Developer, Informatica Power Center

• Involved in ETL Development and End-to-End testing process for two applications.
• Analyzed business requirements and framed logic for ETL process.
• Worked on data extraction, Transformation and loading data from various sources like Flat files and databases.
• Identified bugs in existing mapping by analyzing data flow.
• Analyzed , documented and maintained test results and test logs.

• Recruited as System Engineer Trainee at infosys Limited wherein i underwent training in Big Data stream .
• I have successfully completed mini project in creating dashboard and report in Power BI

Tool Used : SQL Developer , Hadoop, Hive, Pig ,HBase and Power BI