Vijay Veeramaneni

• Overall 8+ years of IT experience in Analysis, Design, Developing and Testing and Implementation of business application systems. Proficient in designing, developing, validating, and deploying ETL processes for data collection, data staging, data movement, data quality, and archiving strategies. Expertise in designing ETL jobs using various Talend components, creating context variables, joblets, routines, and utilizing them in project-level jobs. Strong experience in sourcing data from S3 buckets and loading it into Redshift in an AWS environment. Skilled in scaling and performance tuning of Talend jobs for optimal efficiency. Familiar with Talend Administration Center (TAC) for job publication and scheduling using Job Conductor & Execution Plans. Experience in error handling and debugging Talend jobs to quickly identify and resolve issues. Conduct ETL unit and development tests, monitor results, and take corrective actions as needed. Prepare detailed system documentation, including requirements, design specifications, test plans, and user manuals/run books. Experiences on developing & leading the end-to-end implementation of Big Data projects by using Talend BIGDATA, comprehensive experience as a in Hadoop Ecosystem like Map Reduce, Hadoop Distributed File System (HDFS), Hive. Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems including Oracle, DB2, SQL server, Teradata, Hive, Hana, and flat files, XML and Mainframe files and Active MQ. Good Experiences on relational database management systems, experience in integrating data from various data source like Oracle, MSSQL Server, MySQL and Flat files too. Hands on experience on Hadoop technology stack (HDFS, Map-Reduce, Hive, HBase and Spark). Excellent knowledge in deployment process from DEV to QA, UAT and PROD with both Deployment group and Import/Exports method. Excellent working experience in Waterfall, Agile methodologies. Familiar with design and implementation of the Data Warehouse life cycle and excellent knowledge on entity-relationship/multidimensional modeling (star schema, snowflake schema), Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3). Debugging ETL jobs errors, ETL Sanity and production Deployment in TAC-Talend Administrator Console using SVN. Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping Session and System in ETL Process. Experience in converting the Store Procedures logic into ETL requirements. Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment. Experience in Big Data technologies like Hadoop/Map Reduce, HBASE, Hive, Sqoop, Hbase, Dynamodb, Elastic Search and Spark SQL. Experienced in ETL methodology for performing Data Migration, Data Profiling, Extraction, Transformation and Loading using Talend and designed data conversions from large variety of source systems including Oracle […] DB2, Netezza, SQL server, Teradata, Hive, Hana and non-relational sources like flat files, XML and Mainframe files. Experiences on Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL
• Loader. Experience in AWS S3, EC2, EMR, Lambda, RDS (MySQL) and Redshift cluster configuration. Knowledge on Data Warehousing ETL experience of using Informatica 9.x/8.x/7.x Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager. Experience in SQL Plus and TOAD as an interface to databases, to analyze, view and alter data. Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support. Experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions. Utilized AWS services (S3, EC2, EMR, Amazon Redshift). Experience in implementing Azure data solutions, provisioning storage account, Azure Data Factory, SQL server, SQL Databases, SQL Data warehouse, Azure Data Bricks and Azure Cosmos DB. Implementation of data movements from on-premises to cloud in Azure. Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL. Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting, and also used Netezza Utilities to load and execute SQL scripts using Unix. Created interactive and visually compelling dashboards and reports using Power BI, enabling stakeholders to gain actionable insights from data. Designed and optimized data models in Power BI for efficient data visualization and analysis. Implemented row-level security and data-level security in Power BI to ensure data confidentiality and compliance with regulatory requirements. Conducted data analysis and performance tuning to optimize ETL processes and Power BI reports for performance and scalability.

Title: Data Engineer