Divya Raghu

• Collaborated with other teams to understand their requirements and deliver solutions accordingly.
• Developed data pipelines to ingest and process large datasets.
• Integrated multiple heterogeneous sources into one unified source via ETL processes.
• · Expertise in Informatica PowerCenter, Power BI, SQL, and Teradata – Design, develop ETL jobs.
• · Working as developer to work on regular Backlog business requirements based on their priorities.
• · Working as a Solution Architect to provide Data Lake solutions to Business and make them understand the architecture of it.
• · Handling the production issues, maintaining data availability is essential for the performance and business continuity and keep your team as a best example for Data Availability.
• · Involved in building ETL CICD pipeline.
• Basic knowledge in Python programming.
• Interacting with the client and understanding their business requirements and the change request.
• · Having Experience to build CICD pipelines in Git lab.
• Having good knowledge in AWS, Python, Devops (Git lab) Machine learning and AI models.
• Optimized existing queries in order to improve query performance and reduce the load on the server.
• Managed security protocols and access control policies within the organization's databases and systems.
• Participated in regular meetings with management to assess and address issues and identify and implement improvements.
• Managed performance monitoring and tuning while identifying and repairing issues within database realm.
• Adept in troubleshooting and identifying current issues and providing effective solutions.

• · Developed mappings with different transformations such as expression, aggregator, sorter, lookup and normalizer.
• · Using Informatica Power Connect developed sessions with different sources such as flat file, Oracle and loaded into targets like flat file, Oracle.
• · Created other tasks such as command task & email task.
• · Created worklets required for the workflow.
• · Involved in developing the test cases of smoke, regression and end to end scenarios.
• · Created unit test case documents.
• · Verified column mapping between source and target.
• · Involved in execution of smoke, Regression, and end to end scenarios for each release.
• · Involved in defect tracking, management and reporting activities.
• · Involved in sprint retrospective meeting to prepare sprint retrospective documents.
• · Monitoring daily/weekly/monthly jobs.
• · Involved in On Demand ETL Run.
• · Analyzing the ETL job failure and fixing it as per cardinal SLA norms.
• · Updating daily job status to onsite Team.
• · Interacting with clients in gathering and understanding the requirements.
• · Importing data from RDBMS to HIVE, HDFS and Exporting data from HIVE, HDFS to RDBMS by using SQOOP.
• · Developed and worked with SQOOP incremental loads to populate HIVE external tables
• · Creating HIVE external tables to store the results on top of HDFS
• · Create clone concepts to maintain zero copies in Snowflake.
• · Worked on Task creation for Scheduling/Automate Snowflake jobs.
• · Involved in loading data from Linux file system to HDFS.
• · Writing CLI commands using HDFS.
• · Creating HIVE tables with Partitions and Buckets.
• · Developed Spark SQL queries for processing HIVE tables by using hive context.
• · Import the data from different sources like HDFS/HBase into Spark RDD.

· Experienced in implementing Spark RDD transformations, actions to implement business analysis