Mounika
Summary
Results-oriented IT professional with 9 years of experience across all phases of the Software Development Life Cycle, specializing in data warehousing and data lake implementations. Expertise in ETL processes using Talend and Snowflake, data modeling, and database management across Oracle, Teradata, and SQL environments. Proficient in developing complex ETL workflows, data visualizations, and utilizing CI/CD tools for streamlined deployment. IT professional with extensive experience in designing robust data warehouse architectures and executing complex data migrations. Demonstrates expertise in ETL processes and data integration across multiple platforms, enhancing performance and streamlining operations. Strong background in utilizing Talend, Snowflake, and SQL in high-impact data environments.
Overview
11
11
years of professional experience
Work History
Sr Talend Developer
HCSC
Richardson, TX
06.2021 - Current
- Designed data warehouse architecture, including data mapping and data transfer processes.
- Building and managing data pipelines using Talend, Snowflake and SQL server to efficiently load and process data
- Gathered requirements in meetings to define high-level business needs for the project.
- Implement One time Data Migration of Multistate level data from SQL server to Snowflake by SnowSQL
- Migrated on premise database structure to Confidential Redshift data warehouse.
- Worked on Dimensional Data modelling in Star and Snowflake schemas and Slowly Changing Dimensions(SCD)
- Executed migration of applications to higher environments and conducted version upgrades to ensure system compatibility.
- Performed end- to-end Architecture & implementation assessment of various AWS services like Redshift, S3.
- Wrote various data normalization jobs for new data ingested into Redshift.
- Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
- Created and managed Source to Target mapping documents for all Facts and Dimension tables.
- Utilized Big Data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreResult, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.
- Extensively used tMap component which does lookup & Joiner Functions, tjava, tOracle, txml, tdelimtedfiles, tlogrow, tlogback components etc. in many of my Jobs Created and worked on over 100+components to use in my jobs.
- Used Talend components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more).
- Created Implicit, local, and global Context variables in the job. Worked on Talend Administration Console (TAC) for scheduling jobs and adding users.
- Built Auditing Jobs and Retry mechanism jobs that run as wrapper on all the Talend jobs.
- Worked Extensively on Talend Admin Console and Schedule Jobs in Job Conductor.
- Code migration from Talend V7.3 to Talend V8, Patches applied to be in sync with the Talend latest releases.
- Designed and developed high-quality integration solutions by using Denodo virtualization tool (read data from multiple sources including Oracle, Hadoop, MySQL).
- Developed complex views in Denodo to integrate multiple data sources and automated scheduling for data transfers.
- Created scheduled jobs for data extracts and report reloads by Denodo Scheduler.
- Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
- Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
- Created many complex ADF jobs for data exchange from and to Database Server and various other systems including, XML, CSV, and Flat file structures.
- Successfully Loaded Data into different targets from various source systems like Oracle Database, DB2, Flat files, XML files etc. into the Staging table and then to the target database.
- Wrote many HQL (Hive query language) and SQL queries and used as part of the ETL jobs for the transformations.
- Archived the huge volumes of data files after certain range into HDFS.
- Developed stored procedure to automate the testing process to ease QA efforts and reduced the test timelines for data comparison on tables.
- Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.
- Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
- Built Assure Infogix controls to monitor the source and destination results and send out alerts in case of non-matching results to business.
- Built jobs to Check & monitor the logs and errors using Dyna trace monitors.
- Automated SFTP process by exchanging SSH keys between UNIX servers.
- Hands on experience in SQL/Snow SQL of Oracle/SQL Server/Snowflake.
- Contributed to production and deployment activities, created deployment guides for code migration, and prepared production run books.
- Troubleshoot long running jobs and fixing the issues.
- Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment. Performed Unit testing and System testing to validate data loads in the target.
- Environment: Talend Bigdata cloud (7.3.1), TMC, Snowflake, Hive, RedShift, MS SQL server, DB2, Jenkins, UCD, Unix, Denodo, Zena, control M, Teradata, SQL MI, Azure SQL, Dyna trace, Assure, Infogix
Sr. Talend Developer
CSS
Bethesda, MD
06.2019 - 05.2021
- Participated in requirement gathering meetings to define high level business requirements for the project.
- Designed and developed the Talend jobs with many stages to Extract, Transform and load the data into target database.
- Documented the mapping to help personnel understand the process and incorporate changes.
- Scheduled jobs using Autosys to automate task execution.
- Coordinate with Configuration management team in code deployments.
- Optimized and tuned Teradata views and SQLs, enhancing performance of batch processing and reducing response time for users.
- Development of high-level data dictionary of ETL data mappings and transformations from a series of complex Talend data integration jobs.
- Implemented UNIX shell scripts and tuning of SQL queries for better performance to improve Talend functionalities.
- Developed error handling and auditing jobs, enabling identification of job failures and storage of ETL job statistics.
- Migrated code from Talend V6.4 to Talend V7.3 for improved functionality.
- Implemented notification email alerts for job success, failure, and data audits, improving communication and responsiveness to data issues.
- Developed mappings for load data from S3 to Cassandra.
- Developed APIs in Talend Management Console, importing definitions to studio for implementation.
- Worked on different kinds of Transformations in SSIS like Audit, Lookup, Multicast, Conditional Split, Derived column, Union all etc. to create ETL packages.
- Developed SSIS Packages to migrate data from OLTP, Access, flat files, and Excel into Repository for further Data Analysis and Reporting using multiple transformations.
- Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
- Created Database objects including Tables, Views, Stored Procedures and UDF.
- Developed User defined functions, stored procedures, indexes, Triggers.
- Environment: Talend 5.0.2, Teradata, SQL Server, Oracle 11g, Snowflake, GIT, Hive, Hadoop, spark, linux
Talend Developer
Chevron
Houston, TX
01.2018 - 11.2018
- Designed and Developed ETL process using Talend Open Studio (Data Integration).
- Developed ETL jobs to extract data from various sources, including flat files and Oracle tables, and load into Oracle and HAWQ databases.
- Designed and developed ETL processes to load data from Oracle, MS SQL, flat files, and XML files into staging database and subsequently into target data warehouse.
- Developed ETL mappings for Staging, Dimensions, Facts, Data mart load and different format of source files.
- Engaged in development using Talend Open Studio with Java as backend programming language, enhancing integration capabilities.
- Assisted with data extraction from multiple databases and files utilizing Talend Open Studio.
- Extensively Used tamp component which does lookup & Joiner Functions, tjava, treplace, tlogrow, tlogback components in many of my jobs created.
- Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
- Implemented dimensional model (logical and physical) in the existing architecture using Erwin. Studied the PL/SQL code developed to relate the source and target mappings. Helped in preparing the mapping document for source to target.
- Developed mappings between operational sources to Operational target tables.
- Developed Common Generic Jobs which can be reusable.
- Created UNIX shell scripts to automate program execution.
- Modified existing codes PL/SQL packages to perform Certain Specialized functions and enhancements.
- Contributed to development of a new generation data warehouse solution using web technologies.
- Environment: Talend Integration Suite Version 5.0.2, Teradata, DB2, Oracle 11g Tortoise SVN, and UNIX
- Interacted with Business Users to gather business requirements and designed user.
ETL Developer
Quickr
01.2015 - 12.2016
- Developed ETL mappings for Staging, Dimensions, Facts Data mart load and different format of source files.
- Developed parameter-driven ETL processes to map source systems to target data warehouse, ensuring comprehensive source system profiling using Data Stage.
- Implemented Type II changes for Slowly Changing Dimension Tables to enhance data accuracy.
- Developed and implemented strategies for slowly changing dimensions, surrogate key generation and for incremental data loading.
- Designed and Developed PL/SQL Procedures, functions, and packages for creating Summary tables.
- Developed database functions, procedures, triggers, and packages in TOAD for efficient data access, insertion, modification, and deletion.
- Experienced in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
- Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
- Involved in designing lookup strategies using Hash file stage for data extraction from the source systems.
- Utilized Accentual Data Stage 8.1, SQL Server, Oracle 11g, DB2, and Erwin Data Modeler 4.1.4 in data management tasks.
- Collaborated with business users to gather requirements and designed templates for effectively communicating necessary enhancements.
Education
Master’s - computer science
Rivier University
NHBachelors - Electronics and Communication Engineering
JNTUH
Hyderabad, INDIASkills
- ETL development
- Data integration
- Data migration
- Data mapping
- Data warehousing
- Big data processing
- Performance tuning
Timeline
Sr Talend Developer
HCSC
06.2021 - Current
Sr. Talend Developer
CSS
06.2019 - 05.2021
Talend Developer
Chevron
01.2018 - 11.2018
ETL Developer
Quickr
01.2015 - 12.2016
Master’s - computer science
Rivier University
Bachelors - Electronics and Communication Engineering
JNTUH