Ramya B Email & Phone Number

United States

Florida, United States

Collaborated with the Business Analysis team to gather requirements, create Functional and ETL specification documents, and analyze Business Requirement Documents (BRD) to implement data extraction, transformation, and loading processes.Developed and maintained ETL jobs using Informatica IICS, Talend, and Informatica PowerCenter, automating job scheduling and deployment through tools like Tidel workbook and Nexus repository.Led the end-to-end development and production support process, from dev to prod environments, including extracting, transforming, and loading data from various sources to staging and target systems, ensuring alignment with business requirements.Designed and executed task flows in IICS for data migration from Teradata to BigQuery, and utilized components like tRedshiftUnload and S3 for data ingestion and processing.Demonstrated strong project management skills, including requirement analysis, ETA estimation, and successful management of multiple tasks under tight deadlines.Environment: Talend Enterprise Big Data Edition 5.1, Route53, Talend Administrator Console, Informatica 10.5, MS SQL Server 2015/2018, Oracle 11g, Hive, HDFS, Sqoop, TOAD, Salesforce, UNIX Enterprise Platform for Data integration.

Denver, Colorado, United States

Led ETL processes using Informatica Power Center, utilizing various transformations like Source Qualifier, Mapplet, Router, and Lookup for efficient data extraction, transformation, and loading.Developed and executed Talend big data jobs on Amazon EMR, leveraging components like tHDFSConfiguration, tS3Configuration, and tAmazonEMRManage to process large datasets and load data into S3, Redshift, and Aurora.Gained hands-on experience with Google Cloud Platform (GCP) products such as BigQuery, Cloud DataProc, and Google Cloud Storage, along with Spark SQL for data manipulation and analysis.Implemented and optimized Talend jobs for cloud migrations, including AWS, Teradata, and Azure, using tools like Zeppelin for data analytics and performance-enhancing techniques like tcacheIn/tcacheOut components.Monitored, supported, and deployed Talend jobs across environments using Talend Admin Center (TAC) and Talend Repo Manager (TRM), ensuring smooth production operations and timely issue resolution.Environment: Talend Bigdata 6.3.1/ 7.1.1, Informatica, Power BI, AWS Redshift, S3, Aurora RDS, Spark, Oracle 12c, Pipe delimited / Positional Files/ Parquet, SQL workbench, SQL developer, Putty, WinSCP, FileZilla, Zeppelin, JIRA, SVN, Unix scripting, Agile.

Marlborough, Massachusetts, United States

Collaborated with business teams to gather requirements, designed target tables, and developed ETL processes using Talend, including complex jobs with Hadoop, S3, and AWS Redshift integration.Created technical design documents, Java routines, reusable transformations, and optimized ETL jobs for better performance, including parallel processing, incremental loading, and managing Fact and Dimension tables.Environment: Talend 6.2.1/6.0.1, Talend Open Studio Big Data/DQ/DI, Talend Administrator Console, Oracle 11g, Teradata V 14.0, Hive, HANA, PL/SQL, DB2, XML, JAVA. ERwin 7, UNIX Shell Scripting, Oracle 10g, Oracle, TAC (Admin Center).Developed and executed MapReduce jobs using Hive and Pig, optimized Hadoop processes, and performed data integration using Talend Cloud, ensuring efficient data extraction and loading.Managed the migration of data centers to AWS, created and reviewed scripts for database enhancements, and provided on-call support, including Unix shell scripting and job scheduling in Talend.Led data quality monitoring, metadata management, and enterprise data governance initiatives, collaborating with Voya's Technology Risk and Security Management (TRSM) team to enhance ETL processes and ensure data integrity.Environment: Talend 6.2.1/6.0.1, Talend Open Studio Big Data/DQ/DI, Talend Administrator Console, Oracle 11g, Teradata V 14.0, Hive, HANA, PL/SQL, DB2, XML, JAVA. ERwin 7, UNIX Shell Scripting, Oracle 10g, Oracle, TAC (Admin Center).

India

Developed and optimized ETL processes to load Oracle data into SQL Server using Talend components like tOracleConnection, tOracleInput, and tOracleBulkExec, deploying code on Red Hat Linux.Designed, developed, and tested Informatica mappings and workflows, implementing complex business rules and transformations to load data into dimensions and fact tables from various source systems.Enhanced ETL performance by paginating SQL statements, handling memory issues, resolving deadlock errors in SQL Server, and parameterizing workflows for execution across multiple environments.Created and implemented business rules for data cleansing, validation, and standardization using Informatica Data Quality, developing multiple reusable cleanse components.Led metadata harvesting and management using Collibra Connect in partnership with the Data Service Team, ensuring successful integration and data governance.Environment: Talend Open Studio 5.0.1, Informatica Power center, UNIX, SQL Server

Master'S Degree, Computer Science

Bachelor Of Technology - Btech, Computer Science

Intermediate, Mpc

Tenth