Rajani Maamidi
Dublin,CA
Summary
Over 18 years of experience in IT and consulting, specializing in Data Warehousing, Business Intelligence applications, ETL Data integration (using Talend, IBM Infosphere Datastage, Snowflake, Big Query, Python, Pyspark), Talend Big Data, Hadoop (HDFS, HIVE, PIG), SQL, Microsoft Azure, SAP BW, HANA, Tableau, and Mainframes. Proven expertise in Analysis, Design, Development, Testing, Quality Management, and Implementation across Banking, Healthcare, and Retail sectors. Strong background in Data Warehousing, Dimensional Data Modeling (Star & Snowflake schema), Fact and Dimension table identification, Normalization, Physical, and Logical data modeling. Experience with Azure, Kafka, Prometheus, Grafana, and Big Data solutions like HDFS and Hive. Technical leadership in large-scale projects, guiding teams through all SDLC phases, from data modeling to reporting.
Detail-oriented [Job Title] designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages. Senior engineering professional with deep expertise in data architecture, pipeline development, and big data technologies. Proven track record in optimizing data workflows, enhancing system efficiency, and driving business intelligence initiatives. Strong collaborator, adaptable to evolving project demands, with focus on delivering impactful results through teamwork and innovation. Skilled in SQL, Python, Spark, and cloud platforms, with strategic approach to data management and problem-solving. Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
19
19
years of professional experience
Work History
Senior Data Engineer
Safeway Inc(Albertsons)
Pleasanton, CA
01.2017 - Current
- Led multiple key initiatives like Acupick(Inhouse picking system), PCF to AKS Migration, and MFC setup.
- Developed ETL pipelines for data from Oracle, Cosmos DB, Microsoft SQL server into the Data Warehouse(Snowflake DB,Big Query,Teradara)
- Created high-level ETL designs, performed unit testing, and migrated code using Github.
- Generated Power BI reports, have worked on performance tuning and implemented complex data mappings.
- Technologies: Azure SQL, Kafka, Snowflake, Big Query, MongoDB, AKS, Datastage, Cosmos DB, Unix, Autosys, Stonebranch
- Designed and implemented scalable data pipelines to enhance data accessibility across departments.
- Developed automated reporting solutions using advanced analytics tools, increasing decision-making speed.
- Evaluated new technologies to integrate into existing systems for improved performance and scalability.
- Ensured data quality by implementing rigorous testing protocols and monitoring systems post-deployment.
- Evaluated emerging technologies and tools to identify opportunities for enhancing existing systems or creating new ones.
- Leveraged advanced analytics tools to create interactive dashboards that provided actionable insights into key business metrics.
- Designed robust database architecture that supported seamless integration of new datasets and facilitated rapid analysis capabilities.
- Spearheaded efforts to migrate legacy systems onto cloud-based platforms, resulting in improved scalability and costefficiency.
- Delivered exceptional results under tight deadlines, consistently prioritizing tasks effectively to meet project timelines without compromising quality or accuracy.
- Contributed significantly towards setting up an automated monitoring mechanism using state-of-the-art technologies and tools, which led to proactive issue identification and resolution.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
Senior Data Engineer
First Tech Federal Credit Union (FTFCU)
Mountain View, CA
07.2016 - 01.2017
- Built an Enterprise Data Warehouse by processing data from Salesforce, Oracle, and SQL sources.
- Designed and developed Talend jobs to load data from flat files and SQL sources into Hadoop.
- Developed Tableau reports and scheduled Talend jobs using Autosys.
- Technologies: Talend, Netezza, Hive, HDFS, Autosys
- Designed and implemented scalable data pipelines to enhance data accessibility across departments.
- Optimized ETL processes, reducing data processing time and improving system efficiency.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Optimized data pipelines by implementing advanced ETL processes and streamlining data flow.
Lead Software Developer
McKesson
San Francisco, CA
08.2015 - 06.2016
- Processed SAP data and created Hive tables for ETL operations, integrating data from SAP BW into Hadoop.
- Developed Tableau dashboards and performed ETL using Talend components like tHiveRow, tFileInputXML, etc.
- Technologies: Talend, SAP BW, Oracle, HANA, HDFS
- Collaborated with cross-functional teams to define project requirements and deliver timely updates.
ETL Lead Developer
TJX
Marlborough, MA
04.2014 - 07.2015
- Led ETL development, processing master data into Teradata tables and creating Tableau reports.
- Performed dimensional data modeling using MS Visio and scheduled jobs using Autosys.
- Technologies: Talend, SAP BW, DB2, Teradata, Tableau
Lead Developer (Datastage/Talend)
Bank of America
Charlotte, NC
10.2012 - 03.2014
- Led the development and migration of Datastage jobs to Talend for the Preferred Rewards program.
- Technologies: Datastage, Talend, Oracle, Teradata
Datastage Developer
Bank of America
Hyderabad, India
07.2010 - 09.2012
- Developed ETL pipelines for migrating data from legacy systems and optimized Datastage jobs.
- Technologies: COBOL, JCL, DB2, IMS-DB
Developer
American Express
Bangalore, India
03.2007 - 04.2009
- Developed and managed financial compliance software for international operations.
Education
Bachelor of Technology - Computer Science and Engineering
JNTU University
Skills
- Operating Systems: RED HAT Linux, Windows XP/9X, MVS OS-390
- ETL Tools: Talend ,IBM Infosphere Datastage, Hadoop, Python, Spark
- Databases: DB2, Oracle, Microsoft SQL server, Postgres SQL, Teradata, Netezza, HIVE, Snowflake, Cosmos DB, Mongo DB
- Languages: Unix Shell Programming, Python, PLSQL, COBOL, JCL
- File Systems: Sequential files, Datasets, XML, HDFS, JSON, Parquet
- Scheduling Tools: Autosys, Stonebranch, ESP
- Reporting Tools: Power BI, Tableau
- Application Monitoring tools: Grafana
- Version Control: Github, SVN, PTC Integrity
- Defect Tracking Tools: JIRA, Quality Center
- Data streaming : Message Queues, Kafka
Timeline
Senior Data Engineer
Safeway Inc(Albertsons)
01.2017 - Current
Senior Data Engineer
First Tech Federal Credit Union (FTFCU)
07.2016 - 01.2017
Lead Software Developer
McKesson
08.2015 - 06.2016
ETL Lead Developer
TJX
04.2014 - 07.2015
Lead Developer (Datastage/Talend)
Bank of America
10.2012 - 03.2014
Datastage Developer
Bank of America
07.2010 - 09.2012
Developer
American Express
03.2007 - 04.2009
Bachelor of Technology - Computer Science and Engineering
JNTU University